Karan Rajpoot Oracle DBA Blog's

                                 Oracle 12c grid ASM installation Part-2 Till now we have seen the Oracle 12c binary installation, Grid ASM installation till Configure and Create the disks, Now we will see the last step which is to executes the runInstaller command to do the final installation. Step 8)  Now login through respective user and go to the folder where files have been unzipped. [grid@dr ~]$ cd /opt [grid@dr opt]$ ll total 631840 drwxr-xr-x  7 oracle oinstall      4096 Aug 27  2013 database drwxr-xr-x  7 grid   oinstall      4096 Jul  7  2014 grid Now inside grid folder you need executes the  runInstaller command to start the installation. Note: - If you will get below error then do panic just open a new window and execute xhost + command from the root user. Error: - [grid@dr grid]$ ./runInstaller  Starting Oracle Universal Installer... Checking Temp space: must be greater than 415 MB.   Actual 1660 MB    Passed Checking swap

                                         Oracle 12c grid ASM installation Part-1 In my previous blog, I have shown you how to install Oracle 12c grid binary, In this blog, I will show you how to do Oracle 12c ASM installation. In case you are unable to find Oracle 12c grid binary blog  Click Here . High-Level Steps for Oracle 12c grid ASM installation 1) Need to create ASM disks to store data. (Size as per the requirement) 2) Unzip the 12c grid software. 3) Install the necessary RPM's 4) Format all the raw disks. 5) Add the necessary groups. 6) Create or modify the user. 7) Configure and create all the disks. 8) Execute the runInstaller command to do the final installation. Here is the step by step installation of Oracle 12c ASM.  Step 1) We need to create ASM disks to store data. Steps to create ASM disks. 1) Go to Oracle Virtual box, select the Machine Name and click on setting tab. 2) Click on storage an

                                             Oracle 12c Grid binary installation High-Level Steps for Oracle 12c grid binary installation 1) Download the below grid software linuxamd64_12102_grid_1of2 linuxamd64_12102_grid_2of2. 2) Add the necessary groups. eg) asmdba, asmadmin, asmoper. 3) Create or modify a user. eg) Grid or Oracle user. 4) Unzip the grid software from that user. eg) unzip <file name> Note:- Unzip the files in sequential way, first linuxamd64_12102_grid_1of2 then linuxamd64_12102_grid_2of2   Now let's see the above steps with the help of practical  Step 1) First thing that needs to be done after download, Copy the zip files in some other folder to change the ownership from root to respective user (Oracle/Grid). [root@dr sf_Oracle_DBA_Softwares]# cp linuxamd64_12102_grid_1of2.zip linuxamd64_12102_grid_2of2.zip /opt Step 2) Create the necessary groups and user. Group Creation [root@dr sf_Oracle_DBA_Softwares]

                                    Recovery Catalog Database Using RMAN  By default, RMAN connects to the target database in NOCATALOG mode, meaning that it uses the control files in the target database as the sole repository of RMAN metadata. Perhaps the most important decision you make when using RMAN is whether to create a recovery catalog as the RMAN repository for normal production operations. A recovery catalog is a schema created in a separate database that contains metadata obtained from the target control file. With the use of the recovery catalog database, you can put all the backup or pieces information of the multiple databases in a single location. ==> Benefits of Using the Recovery Catalog as the RMAN Repository When you use a recovery catalog, RMAN can perform a wider variety of automated backup and recovery functions than when you use the control file in the target database as the sole repository of metadata. ==>The following features are av

                                               Configure Flash Recovery Area To Configure Flash Recovery Area first there is a need to set below parameters. Parameter 1) db_recovery_file_dest_size Parameter 2) db_recovery_file_dest Now let's start  We can check the current location of Flash Recovery Area through the below query. Query: - select NAME,SPACE_LIMIT,SPACE_USED,NUMBER_OF_FILES from V$RECOVERY_FILE_DEST; Step 1) Now set the db_recovery_file_dest_size parameter  Step 2) Now set the db_recovery_file_dest parameter Step 3) Now we will bounce the database to reflect the changes in the spfile and then will check the status of the parameters through below command Command: - show parameter recover; We can see from the above output both the parameter's has been set as per the requirement. Step 4) Check the database mode, it should be in archive log mode. If it is not set to archive log then need to change t

                                              ORA-12899: value too large for column Error: -  ORA-12899: value too large for column. Cause: - This error occurs when you have given the data type value which is greater than its maximum value. Solution: - Try to give the data type value under its maximum assign value or try to increase the size of the maximum value. let's understand the things with the help of the below example: - Example: - Step 1) SQL> create table employee (emp_id number, emp_name varchar(10), emp_desig varchar(10)); Table created. Step 2) SQL> insert into employee values (1001, 'Paul', 'Project_Engineer'); insert into employee values (1001, 'Paul', 'Project_Engineer')                                            * ERROR at line 1: ORA-12899: value too large for column "SYS"."EMPLOYEE"."EMP_DESIG" (actual: 16, maximum: 10) Note: - At the time of tabl

                                                  ORA-00984: column not allowed here Error: -  ORA-00984: column not allowed here. Cause: - When you try to insert the value in a table and forget to enclose the string value in a single quote, then you will get this error. Solution: - Put the string value under single quotes and re-execute the command again. Example: -  SQL> insert into employee values (1001, Paul, Engineer); insert into employee values (1001, Paul, Engineer)                                          * ERROR at line 1: ORA-00984: column not allowed here Note: - In the above output string value has not enclosed with single quotes, To resolve this, Put the string value under single quotes and re-run the command again like below. SQL> insert into employee values (1001, 'Paul', 'Engineer'); 1 row created. Hope that will resolve your issue.