Tech by KJ

This guide covers the essential steps for taking RMAN backups and performing restorations, including handling archivelog modes and restoring to different locations. Part 1: Taking an RMAN Backup 1. Preparation First, create a directory to store the backups and generate a parameter file (pfile) from your current server parameter file (spfile). Create the backup directory: mkdir /u01/RMAN_BACKUP Create the pfile backup: Connect to SQL*Plus and create the pfile in your new directory. sqlplus / as sysdba CREATE pfile='/u01/RMAN_BACKUP/init<db_name>.ora' FROM spfile; 2. Configure Archivelog Mode To take a full online backup while the database is running, the database must be in Archivelog Mode. Note: If you cannot change the mode, you can take an offline backup by mounting the database (where logs stop generating) and backing up just the database. However, the steps below assume we are switching to archivelog mode to capture both the database and archive logs. Steps to enable ...

Below is the specs of the source and target I used for this demonstration: Source: OL 7.9 / DB 11.2.0.2 / GoldenGate 12.3 / Classic Extract Target: OL 8 / DB 19c / GoldenGate 19.1 / Integrated Replicat (The reason I used GoldenGate 12.3 in the source server is since GoldenGate 19c does not support Oracle Database 11.2.0.2 The source DB server use the classic extract method to extract the trail files since integrated extract method is not supported.) Ports to be opened: 7809               Source --> Target -- Manager Port 7810-7820     Source --> Target -- Collector Ports 1521               Source --> Target -- Listener Port (Strictly not necessary but better to have opened) 22                    Bidirectional -- SSH Port Make sure the tns entries are clearly specified in the tnsnames.ora file. Phase 0: OS Setup & Installation ...

Step 1 - Execure the wlst.sh script [weblogic@testserver-k app]$ cd /u01/app/oracle/product/12.2.1/oracle_common/common/bin/ [weblogic@testserver-k bin]$ ./wlst.sh Step 2 - Connect using the correct credentials and execute the following commands. wls:/offline> connect ("weblogic","<weblogic_pwd>","<hostname>:7001") wls:/frsdomain/serverConfig/> createReportsServerInstance(instanceName='repserver1',machine='AdminServerMachine') Step 3 - Configure the reports server instance created. [weblogic@testserver-k app]$ vi $DOMAIN_HOME/config/fmwconfig/servers/WLS_REPORTS/applications/reports_12.2.1/configuration/rwservlet.properties <?xml version="1.0" encoding="UTF-8"?> <rwservlet xmlns="http://xmlns.oracle.com/reports/rwservlet/" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <server>repserver1</server> #Instance name you used above <singlesignon>no</sing...

To configure WebUtil we have to configure a data source with the target database (in this case the target database is not the database we used for the RCU configuration) Step 1 - Add the correct tns entries of the target database into the tnsnames.ora file of your app server. [oracle@testserver-k ~]$ vi $ORACLE_HOME network/admin/tnsnames.ora <tns-alias> =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = <ip-of-target>)(PORT = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = <service-name-of-target-database>)     )   ) [oracle@testserver-k ~]$ tnsping <tns-alias> Step 2 - Connect to the weblogic console to configure a jdbc data source. http://<ip-address>:7001/console Navigate to: Services > Data Sources Select Lock & Edit and create a new Generic Data Source You can select the necessary components that you need the data source to be conf...

Step 1 - Take a backup of the sign_webutil.sh script. [weblogic@testserver-k bin]$ cp sign_webutil.sh sign_webutil.sh_OG Step 2 - Find the java installation location in your server. [weblogic@testserver-k bin]$ which java path/to/your/java/bin Step 3 - Edit the hardcoded keytool and jarsigner paths as follows: FROM: error_text=` /u01/app/oracle/product/12.2.1/wlserver/../jdk/bin/keytool -genkey -dname "CN=$DN_CN, OU=$DN_OU, O=$DN_O, C=$DN_C" \         -alias $JAR_KEY -keypass $JAR_KEY_PASSWORD -keystore $KEYSTORE \         -storepass $KEYSTORE_PASSWORD -validity $VALIDDAYS` TO: error_text=` path/to/your/java/bin/keytool -genkey -dname "CN=$DN_CN, OU=$DN_OU, O=$DN_O, C=$DN_C" \         -alias $JAR_KEY -keypass $JAR_KEY_PASSWORD -keystore $KEYSTORE \         -storepass $KEYSTORE_PASSWORD -validity $VALIDDAYS` AND FROM: error_text=` /u01/app/oracle/product/12.2.1/wlserver/../jdk/bin/jar...

Step 1 - Launch the Configuration Wizard. [weblogic@testserver-k ~]$ $ORACLE_HOME/oracle_common/common/bin/config.sh ( If GUI doesn't work check this troubleshooting guide ) Select the following Templates: Oracle Forms [Forms] Oracle Reports Application [reports] Oracle Enterprise Manager [em] Oracle HTTP Server (Collocated) [ohs] Oracle Reports Tools [ReportsToolsComponent] Oracle Reports Bridge [ReportsBridgeComponent] Oracle Reports Server [ReportsServerComponent] Step 2 - Add ' boot.properties ' file. Export the correct DOMAIN_HOME path. [weblogic@testserver-k ~]$ export DOMAIN_HOME=$ORACLE_HOME/user_projects/domains/base_domain [weblogic@testserver-k ~]$ mkdir -p $DOMAIN_HOME/servers/AdminServer/security Add the following entries to the boot.properties file. [weblogic@testserver-k ~]$ vi  $DOMAIN_HOME/servers/AdminServer/security/boot.properties username=weblogic password=<your_weblogic_password> [weblogic@testserver-k ~]$ mkdir -p $DOMAIN_HOME/servers/WLS_FO...