Roll Forward Physical Standby Database using RMAN incremental backup Current_scn from primary database and standby database. PRIMARY [oracle@ranesh ~]$ cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 192.168.182.130…
Read MoreOracle 12c Physical Standby Database Creation using Rman Prerequisites for standby built for primary side. Ø Configure network files for both side (Primary,standby). Ø Parameter change in primary side. Ø Copy the Password file from primary…
Read MoreROLLBACK [oracle@ranesh 30886680]$ opatch apply Oracle Interim Patch Installer version 12.2.0.1.19 Copyright (c) 2020, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/12.2.0.1/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.2.0.1/db_1/oraInst.loc OPatch version : 12.2.0.1.19 OUI version : 12.2.0.1.4 Log file location : /u01/app/oracle/product/12.2.0.1/db_1/cfgtoollogs/opatch/opatch2021-02-18_15-43-47PM_1.log Verifying…
Read MoreINTRODUCTION: The below steps shows how to decrypt the weblogic password for oracle Apps R12.2 STEP 1: Connect to instance as applmgr and source the ENV. su – applmgr .…
Read MoreEBS Installation 12.1.1 Step- Edit Yum.repository and keep ol6_latest and ol6_addon ebabled=1 cd /etc/yum.repos.d yum install wget.x86_64 wget http://public-yum.oracle.com/public-yum-ol6.repo vi public-yum-ol6.repo ([ol6_latest] name=Oracle Linux $releasever Latest ($basearch) baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/ gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 gpgcheck=1 enabled=1 [ol6_addons] name=Oracle…
Read MoreINTRODUCTION: The below steps shows us how to run a concurrent program in a custom manager, STEP 1: Navigate to System Administrator->Concurrent->Program->Define STEP 2: Create a custom manager as per…
Read More[applmgr@ebs applmgr]$ sqlplus apps/apps—connect to applmgr and apps/apps SQL*Plus: Release 10.1.0.5.0 – Production on Tue Mar 31 22:35:56 2020 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database…
Read MoreFollow these steps to perform an upgrade. 1. Confirm that both the Excel4apps and Excel4apps Reports Wand applications have been registered on you system. a. Log on to the Oracle…
Read MoreSteps For Upgrading Oracle Database To 19c Using DBUA Database preinstall 19c 19c software install Pre-upgrade check Run the pre-upgrade fixup script Run utlrp.sql ( to compile invalid objects) Check database component status To enable restore , in case…
Read Moreset serveroutput on; begin for i in ( select sid, serial# from gv$session where status=’INACTIVE’ and type=’USER’ and program=’APEX Listener’ and last_call_et/60 > 5) loop dbms_output.put_line(‘begin’); dbms_output.put_line(‘rdsadmin.rdsadmin_util.kill(‘); dbms_output.put_line(‘sid =>’||i.sid||’,’); dbms_output.put_line(‘serial…
Read More