Skip to main content

19c ORACLE HOME Cloning -Linux/Solaris

 Cloning an Oracle home involves creating a copy of the Oracle home and then configuring it for a new environment.

If you are performing multiple Oracle Database installations, then you may want to use cloning to create each Oracle home, because copying files from an existing Oracle Database installation takes less time than creating a new version of them. This method is also useful if the Oracle home that you are cloning has had patches applied to it. When you clone the Oracle home, the new Oracle home has the patch updates which is already applied on oracle home.

Steps to clone an Oracle home

step 1 : Stop Services
Stop all processes related to the Oracle home.
Step 2 :Create a ZIP or TAR file with the Oracle home (/u01/app/oracle/product/19.0.0/dbhome_1)   
Use ROOT user for ZIP and UNZIP 
# zip -r dbhome_1.zip /u01/app/oracle/product/19.0.0/dbhome_1
TAR option:
# tar -cvf dbhome_1.tar /u01/app/oracle/product/19.0.0/dbhome_1

Step 3: scp zip/tar to target server
 scp dbhome_1.zip root@192.*.*.*:/
Step 4: on Target server extract the ZIP or TAR file
# unzip -d / dbhome_1.zip
# tar -xvf dbhome_1.tar

Step 5:Change the ownership of the Oracle Database home
# chown -R oracle:oinstall /u01/app/oracle/product/19.0.0/dbhome_1


Step 6: run the clone.pl
From the $ORACLE_HOME/clone/bin directory, run the clone.pl file for the unzipped Oracle home.
Example:
[oracle@database server 1~]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/clone/bin/clone.pl ORACLE_BASE="/u01/app/oracle" ORACLE_HOME="/u01/app/oracle/product/19.0.0/dbhome_1" -defaultHomeName
output:

[INFO] [INS-32183] Use of clone.pl is deprecated in this release. Clone operation is equivalent to performing a Software Only installation from the image.
You must use /u01/app/oracle/product/19.0.0/dbhome_1/runInstaller script available to perform the Software Only install. For more details on image based installation, refer to help documentation.

Starting Oracle Universal Installer...

You can find the log of this install session at:
 /u01/app/oraInventory/logs/cloneActions2020-12-06_12-33-20PM.log
..................................................   5% Done.
..................................................   10% Done.
.
..................................................   75% Done.
..................................................   80% Done.
..................................................   85% Done.
..........
Copy files in progress.

Copy files successful.

Link binaries in progress.
..........
Link binaries successful.

Setup files in progress.
..........
Setup files successful.

Setup Inventory in progress.

Setup Inventory successful.
..........
Finish Setup successful.
The cloning of OraHome1 was successful.
Please check '/u01/app/oraInventory/logs/cloneActions2020-12-06_12-33-20PM.log' for more details.

Setup Oracle Base in progress.

Setup Oracle Base successful.
..................................................   95% Done.

As a root user, execute the following script(s):
        1. /u01/app/oracle/product/19.0.0/dbhome_1/root.sh



..................................................   100% Done.


Step 7:  Execute script by ROOT user
/u01/app/oracle/product/19.0.0/dbhome_1/root.sh

Check log files if any error.

Step 8: update .bash profile or export ORACLE_HOME and verify SQLPLUS prompt working.

Comments

Popular posts from this blog

EBS Standby Role Tranistion using standby database and standby application Tier

 Role Transitions A database can operate in either a primary or standby role - these roles are mutually exclusive. Oracle Data Guard enables you to change these roles dynamically by issuing SQL commands, and supports the following transitions: Switchover Allows the primary database to switch roles with one of its standby databases. There is no data loss during a switchover. After a switchover, each database continues to participate in the Oracle Data Guard configuration with its new role. Failover Changes a standby database to the primary role in response to a primary database failure. The following role transitions are discussed: 6.1 Performing a Switchover 6.2 Performing a Failover 6.3 Performing a Switchback to the Primary Following A Switchover/Failover Each of these three transitions requires some application configuration to be performed. Most of the application configuration step...

adgrants issue with 19c PDB database

 adgrant - system.fnd_oracle_userid ORA-06550: line 1094, column 17 SP2-0625: Error printing variable "result_set" adgrants issue with 19c PDB database  Connect to a multitenant 19c database and follow below steps to resolve ORA error 1- source the cdb env file  2-set the  ORACLE_PDB_SID=<PDB_NAME>   3- connect as  sqlplus / as sysdba 4- go to location of adgrant and execute cd /u01/app/oracle/product/19.0.0/dbhome_1/appsutil/sql    SQL>  @adgrants.sql APPS Note: ignore warnings during adgrant session a d.plsql.ad_zd_sys.GIVE_PRIVILEGE