OVERVIEW OF SQL Please create the scott schema from the following GITHUB repository https://github.com/oracle/dotnet-db-samples/blob/master/schemas/scott.sql EXECUTING SELECT STATEMENT SQL> SELECT * […]
We faced this error during Oracle12cR2 installation. During our installation of oracle 12.2 in new home on existing Oracle 11g
Today I observed that we were getting following error when we were going to connect using SERVICE_NAME from (DR site)
Error in DR alert log:- FAL[client]: Failed to request gap sequence GAP – thread 2 sequence 9432-9473 DBID 2085418592 branch
1.OPatch installation Copy the opatch binary using root user to $ORACLE_HOME and $GRID_HOME. Then please keep backup of old OPatch
1.Please download latest version of OPatch and install under $ORACLE_HOME and $GRID_HOE Copy the opatch binary using root user to
1.V$LOGSTDBY_PROCESS displays dynamic information about what is happening to the Data Guard log apply services. This view is helpful when
LOGICAL STANDBY DATABASE STEP BY STEP Primary DB: CLRVMS (ip:10.3.248.5 and 10.3.248.8) Logical Standby DB: CLRVMS_B(ip:10.3.248.129) Please check
FLASHBACK FEATURES Purging the Recycle Bin purge table sales.woodscrews; purge index sales.woodscrews_pk_idx; purge tablespace sales; purge recyclebin;
Oracle Network Configuration =========================== In its most basic form, Oracle uses three files (listener.ora, tnsnames.ora & sqlnet.ora) for network configuration.