Karan Rajpoot Oracle DBA Blog's

                                      Steps to Install Oracle SQL Developer  Step 1) You need to download the SQL developer rpm and java development kit rpm of the version as per your requirement. Links to download rpm's: - Java development kit: -  https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html SQL developer: -  https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html Step 2) Login to your Linux Machine and install both the rpm's. [root@dr sf_Oracle_DBA_Softwares]# rpm -ivh sqldeveloper-18.4.0-376.1900.noarch.rpm Preparing...                ########################################### [100%]    1:sqldeveloper           ########################################### [100%] [root@dr sf_Oracle_DBA_Softwares]#  [root@dr sf_Oracle_DBA_Softwares]# rpm -ivh jdk-8u201-linux-x64.rpm warning: jdk-8u201-linux-x64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY Preparing.

Introduction: RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server with the same file structure, a remote server will a different file structure or the local server with a different file structure.  In this demonstration , I am using the "prod" as a Source database and "clone" as an Auxiliary database. Prerequisites: RMAN must be connected as AUXILIARY to the instance of the duplicate database. The instance of the duplicate database is called the auxiliary instance. The auxiliary instance must be started with the NOMOUNT option. High-Level steps of  RMAN backup based cloning in Oracle 11g Source Server: - 1) The database should be in Archive log mode. 2) Set the recovery parameters. 3) Set the datafile and logfile convert parameter. 4) Create Parameter file (pfile). 5) Take a fresh backup. 6) Create Password fi

                                 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