45.1 Configuring OAM Snapshot Tool when the DB is on a Different Infrastructure

The OAM Snapshot Tool assumes that the database binaries are available on the same infrastructure from where the scripts are being run.

If your database binaries are on a different infrastructure, you must also install the database binaries on the source and the target infrastructures where the createSnapShot.sh and the applySnapshot.sh scripts are required to be run. After the DB installation, update the scripts and the properties file to point to the DB_HOME.

Note:

The binaries are required only to invoke the scripts, and has no direct co-relation with the DB Connect String.

The following steps provide instructions for the script files to work correctly:

1. Download the required versions of the database installation files.

   Note:

   If your database version is 12.2 or higher, you can use Instant Clients. If you are on any other database version, use the full client.
   • For Full Client, download the installation files from Oracle Database Software Downloads.
   • For Instant Client, download the Basic, SQL*Plus, and the Tools Instant Client Packages from Instant Client for Linux x86-64 (64-bit) site. For example, download instantclient-basic-linux.x64-12.2.0.1.0.zip, instantclient-sqlplus-linux.x64-12.2.0.2.0.zip, and instantclient-tools-linux.x64-12.2.0.1.0.zip.
2. Install the database binaries on the source and the target Infrastructures where the scripts need to run.
   • For Full Client instructions, navigate to Oracle Database Software Downloads and under Note click See All against the version of the database that you need to install. A new page is displayed containing the link to the Installation guides.

     After installation, skip to Step 5.

   • For Instant Client, unzip the downloaded files to a directory, for example, /usr/local/oracle/dbclient.

     Unzipping the files creates a new folder under the specified directory, for example, /usr/local/oracle/dbclient/instantclient_12_2

3. Create two folders bin and lib under /usr/local/oracle/dbclient/instantclient_12_2
4. From /usr/local/oracle/dbclient/instantclient_12_2 copy all the *.so.* files to the lib folder and the rest of the files to the bin folder.
5. Navigate to $MW_HOME/idm/oam/server/upgrade/script directory on the source infrastructure and open the datapump_exp.sh in your preferred editor.
6. Add export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib line below the existing export ORACLE_HOME=$ORACLE_HOME line.

   
   export ORACLE_HOME=$ORACLE_HOME
   //New line specifying the library path
   export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

7. Similarly, open the datapump_imp.sh on the target infrastructure and add the library path.

   
   export ORACLE_HOME=$ORACLE_HOME
   //New line specifying the library path
   export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

8. Edit the backup.properties file on the source infrastructure and set DB_HOME. For example,

   DB_HOME=/usr/local/oracle/dbclient/instantclient_12_2

9. Similarly, edit the restore.properties file on the target infrastructure and set DB_HOME. For example,

   DB_HOME=/usr/local/oracle/dbclient/instantclient_12_2

The createSnapShot.sh and the applySnapshot.sh scripts run correctly.