Category: Blog

Case A: Removing a Node that not available for access (Physically not Available) and has been removed and destroyed. Case B: Removing a Node that…

Database Upgrade Problem & Solution List: 1.  Error is related to timezone file (When upgrading 9i to 11g)  2.  ORA-24247: network access denied by access control list…

Section: A (Create first Virtual Machine) 1. Create the windows folders to house the first virtual machines and the shared storage. F:>mkdir RAC1 F:>mkdir SHARED-STORAGE…

Query 1 To determine which databases are currently registered in the recovery catalog: SQL> SELECT * FROM RC_DATABASE; Query 2 To determine which tablespaces are…

When we applying patches in Interactive Mode by using ADPATCH utility, this utility ask basic question like Default APPL_TOP, Log File Name, ORACLE_HOME, apps password,…

How to find patch is applied or not (Except Localization) select A.APPLIED_PATCH_ID, A.PATCH_NAME, A.PATCH_TYPE, B.PATCH_DRIVER_ID, B.DRIVER_FILE_NAME, B.ORIG_PATCH_NAME, B.CREATION_DATE, B.PLATFORM, B.SOURCE_CODE, B.CREATION_DATE, B.FILE_SIZE, B.MERGED_DRIVER_FLAG, B.MERGE_DATE from…

How to Find Oracle Applications version Version of a Oracle Applications Form (fmx) or report strings -a | grep Header alternatively you can also use…

1. Troubleshooting Logical Standby ID: 215020.1 2. ARCHIVE LOGS GETTING DISAPPEARED ON 10.2 LOGICAL STANDBY ID 353748.1

Indian DBA design job-oriented courses meant for people who like to specialize in a definite IT stream. The training programmers include Linux, SUN Solaris, Oracle…