ORACLE DATABASE INSTALLATION
Module 1: Installing the Oracle Binaries
Cloning Using Oracle Universal Installer(OUI)
ORACLE DATABASE ADMINISTRATION SERIES
S.N STEPHEN N NJOROGE
LinkedIn: www.linkedln.com/in/stephen-njoroge
SENIOR DATABSE ADMINISTRATOR | MSSQL | ORACLE| PostgreSQL |OCI |AWS |
DATABASE ADMINISTRATION SERIES |
Module 1: Installing the Oracle Binaries- Installing Oracle Software
This module focuses on techniques for installing Oracle in an efficient and repeatable manner and which includes silent
installations relying on a response file. I purpose to cover the Following:
Understanding the OFA
Oracle Inventory Directory
Oracle Base Directory
Oracle Home Directory
Oracle Network Files Directory
Automatic Diagnostic Repository
Installing Oracle Software
Step 1. Create the OS Groups and User
Step 2. Ensure That the OS Is Adequately Configured
Step 3. Obtain the Oracle Installation Software
Step 4. Unzip the Files
Step 5: Creating oraInst.loc File
Step 6. Configure the Response File, and Run the Installer
Step 7. Troubleshoot Any Issues
Step 8. Installing Oracle Software
Installing with a Copy of an Existing Installation
Cloning Using Oracle Universal Installer (OUI)
Cloning Using gold image (Database Software Image)
Manual Oracle Home Cloning
Upgrading Oracle Software
Reinstalling After Failed Installation
Applying Interim Patches
Installing Remotely with the Graphical Installer
Step 1. Install X Software and Networking Utilities on the Local PC
Step 2. Start an X Session on the Local Computer
Step 3. Copy the Oracle Installation Media to the Remote Server
Step 4. Run the xhost Command
Step 5. Log In to the Remote Computer from X
Step 6. Ensure that the DISPLAY Variable Is Set Correctly on the Remote Computer
Step 7. Execute the runInstaller Utility
Step 8. Troubleshoot
2
Module 1: Installing the Oracle Binaries- Installing with a Copy of an Existing Installation
Installing with a Copy of an Existing Installation- Oracle Home Cloning
When installing Oracle Database, one can sometimes leverage an existing installation to save time and effort.
The methods - Using an OS Utility and Attach the Oracle Home, refers to techniques for reusing an existing Oracle Home instead
of performing a full installation from scratch a method commonly known as oracle Home Cloning.
There are three main methods to clone an Oracle Home installation in Oracle environments:
1. Cloning Using Oracle Universal Installer (OUI)
Method: We use runInstaller in silent mode with a response file.
Procedure:
o Copy the Oracle Home directory to the target machine.
o Run the runInstaller command with appropriate response file.
./runInstaller -silent -clone ORACLE_HOME="/u01/app/oracle/product/12.2.0/dbhome_1"
ORACLE_HOME_NAME="db12c_home1"
o Run root scripts when prompted.
2. Cloning Using gold image (Database Software Image)
Method: We Create a gold image and use it to deploy Oracle Home.
Steps:
o Create the gold image using:
$ORACLE_HOME/clone/bin/clone.pl ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
o Or:
./runInstaller -createGoldImage -destinationLocation /tmp/gold_image
Deploy this image on the target server.
Configure it with OUI or dbca.
3. Manual Clone Method
Method: It involves manually copying of Oracle Home, fixing symbolic links, reconfiguring inventory and running
configuration scripts.
Steps:
o Tar and copy Oracle Home to target.
o Fix symbolic links .
o Update /etc/oraInst.loc and inventory.
o Run runInstaller with -silent -attachHome
3
Module 1: Installing the Oracle Binaries- Installing with a Copy of an Existing Installation
Demo: Cloning Oracle Home Using Oracle Universal Installer (OUI)
Checklist :
Here is a complete Oracle 12c OUI Home Cloning checklist tailored for a Linux environment.
Step Task
1 Stop Oracle services on the source server
2 Archive Oracle Home on the source server
3 Copy tar file to the target server
4 Extract Oracle Home on the target server
5 Set environment variables on the target
6 Run Oracle Universal Installer in silent clone mode
7 Execute root.sh on the target server
8 Validate the cloned Oracle Home and Inventory
9 Start listener and database
Here's a full step-by-step guide for cloning Oracle 12c Home on Linux using the Oracle Universal Installer (OUI) in silent mode
with a response file.
Prerequisites
Oracle 12c is already installed on a source server.
You have root or sudo access on both source and target machines.
Same OS and environment between source and target.
ORACLE_HOME is: /u01/app/oracle/product/12.2.0/dbhome_1
Step-by-Step Procedure
1. Stop Oracle Services on the Source
$ lsnrctl stop
4
Module 1: Installing the Oracle Binaries- Installing with a Copy of an Existing Installation
$ ps -ef | grep ora_ # Confirm no DB processes are running
In the case above, the database is no running and the listener is since stopped.
2. Copy Oracle Home from Source to Target
Use tar to preserve symbolic links and permissions
On Source Server:
$ cd /u01/app/oracle/product/12.2.0/
$ tar -cvpf dbhome_1.tar dbhome_1
Transfer to Target Location
$ cp dbhome_1.tar /u01/app/oracle/product/19.0.0/
On Target Server:
$ cd /u01/app/oracle/product/19.0.0/
$ tar -xvpf dbhome_1.tar
Set Environment Variables on Target
$ export ORACLE_BASE=/u01/app/oracle
$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
$ export PATH=$ORACLE_HOME/bin:$PATH
5
Module 1: Installing the Oracle Binaries- Installing with a Copy of an Existing Installation
4. Run the Cloning Command with OUI
Navigate to $ORACLE_HOME and run:
cd $ORACLE_HOME
/u01/app/oracle/product/12.2.0/dbhome_1/oui/bin/runInstaller -silent -clone \
ORACLE_HOME="/u01/app/oracle/product/19.0.0/dbhome_1" \
ORACLE_HOME_NAME="db12c2_home1"
5. Run the root.sh Script as Root
Switch to root and run:
# /u01/app/oracle/product/19.0.0/dbhome_1/root.sh
6. Silent create a database:
dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname ORCL -sid ORCL \
-responseFile NO_VALUE \
-characterSet AL32UTF8 \
-memoryPercentage 40 \
-emConfiguration NONE \
-dbsnmpPassword Welcome123 \
-sysPassword Welcome123 \
-systemPassword Welcome123 \
-createAsContainerDatabase false
6
Module 1: Installing the Oracle Binaries- Installing with a Copy of an Existing Installation
7. Validate Clone
Check Oracle Inventory:
$ cat /u01/app/oraInventory/ContentsXML/inventory.xml | grep dbhome_1
Start listener or DB if needed:
$ lsnrctl start
$ sqlplus / as sysdba
SQL> startup
7
Module 1: Installing the Oracle Binaries- Installing with a Copy of an Existing Installation
8
8
Module 1: Installing the Oracle Binaries- Installing with a Copy of an Existing Installation
