RAC

How to Resolve Srvctl Start Database ORA-00304: requested INSTANCE_NUMBER is busy

Posted on
Srvctl Start Database ORA-00304 Saw some errors when I tried to startup a cluster database by srvctl. [oracle@primary01 ~]$ srvctl start database -d compdb PRCR-1079 : Failed to start resource ora.compdb.db CRS-5017: The resource action “ora.compdb.db start” encountered the following error: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: […]
RAC

How to Restore 12c RAC Database by a Backup Set

Posted on
For 10g RAC database restoration, you may check: How to Restore 10g RAC Database by a Backup Set. Suppose we have restored 12c clusterware back. Now we can start to restore 12c cluster database. Our goal in this post is to use a backup set on one of RAC nodes to restore the database. First […]
Database Link

How to Use GLOBAL_NAMES for Database Links

Posted on
GLOBAL_NAMES Normally, we turned off GLOBAL_NAMES to prevent additional check on remote database before connecting to it. This is because we know where we are going to very clearly. But what if we are in a complicated distributed environment, how to prevent connecting to the wrong destination? In such situation, Oracle recommends to turn on […]
Clusterware

How to Restore 12c Clusterware OCR Voting Disk

Posted on
For 10g clusterware, you may check: How to Restore 10g Clusterware. Suppose we have lost all disk groups as well as OCR data, voting disk and management database (MGMTDB) in a disaster, we have to rebuild 12c clusterware nearly from the ground up for later 12c RAC database restoration. The only thing that you must […]
RAC

How to Restore 10g RAC Database by a Backup Set

Posted on
For 12c RAC database restoration, you may check: How to Restore 12c RAC Database by a Backup Set. Suppose we have recovered 10g CRS and ASM from a fatal crash, but the database is still waiting for our saving. Luckily, we have a backup set of the database, which is a full and consistent database […]
ASM

How to Resolve SPFILE in DB_UNKNOWN

Posted on
SPFILE in DB_UNKNOWN When I tried to restore SPFILE to the default location at nomount state, I found that SPFILE was restored to a DB_UNKNOWN in ASM. Is it a bug dedicated to Oracle 10g RAC (Bug 5370663)? No, I saw it too in 12c R1 RAC restoration. Let’s reproduce the problem. First, check what […]
Clusterware

How to Backup Clusterware OCR and Voting Disk

Posted on
In this post, I will introduce some ways to backup Oracle Cluster Registry (OCR) data and voting disk in case of losing all configuration. Backup OCR Data 1. OCR Dumps Oracle provides an utility ocrconfig to export OCR data to a dump file like this: [root@primary01 ~]# . /home/oracle/.bash_profile [root@primary01 ~]# cd /backup/ [root@primary01 backup]# […]
PL/SQL

How to Resolve PLS-00103: Encountered the symbol when expecting one of the

Posted on
PLS-00103 I cannot cover all error patterns of PL-00103 in this post, here is one case that encounter PLS-00103 in anonymous PL/SQL block using EXECUTE IMMEDIATE. SQL> begin   2    execute immediate ‘select nvl(first_name, ‘NO_VALUE’) from employees’;   3  end;   4  /   execute immediate ‘select nvl(first_name, ‘NO_VALUE’) from employees’;       […]