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 […]
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 […]
Data Guard

Connect-Time Failover to Standby Database

Posted on
We’re going to introduce 3 ways that can failover to a standby database at connect-time in this post. Using a Persistent Service Name Using a Dynamic Service Name Using a SRVCTL Configured Service Using a Persistent Service Name Connect-Time Failover is a feature of local naming method, and can be easily set up by adding […]
ACFS

How to Create a ACFS File System on 18c

Posted on
Create ACFS File System First of all, make sure everything is ready on grid-level. [root@primary01 ~]# su – grid [grid@primary01 ~]$ crsctl check crs [grid@primary01 ~]$ crsctl status resource -t Create a Volume In this case, We allocate 80GB for the new volume ORADATA1 from a ASM disk group, DATA. [grid@primary01 ~]$ asmcmd volcreate -G […]
Network

How to Add a Subnet to Grid

Posted on
Servers that have multiple network interfaces may offload the traffic by adding another subnet to grid infra. In this post, I demonstrate how I add another subnet (i.e. 10.0.8/24) from OS to grid infrastructure.Please note that, network resource object is a synonym of subnet from grid infrastructure’s perspective.First of all, we need to configure the […]
SCAN IP

How to Relocating SCAN VIP and Listeners

Posted on
Sometimes, we may find the scan vip and listeners are all located at one node.[grid@primary01 ~]$ ps -ef | grep lsnrgrid      6077     1  0 14:27 ?        00:00:00 /u01/app/12.1.0/grid/bin/tnslsnr MGMTLSNR -no_crs_notify -inheritgrid      6256     1  0 14:27 ?        00:00:00 /u01/app/12.1.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inheritgrid […]
Listener

How to Resolve PRCN-2065 PRCN-2067

Posted on
For preventing port 1521 from mistakenly being assigned by other listener, the clusterware won’t allow port 1521 to be reassigned, no matter what the network is the default one or not.[grid@primary01 ~]$ srvctl add listener -l listener2 -k 2 -p 1521PRCN-2061 : Failed to add listener ora.LISTENER2.lsnrPRCN-2065 : Ports 1521 are not available on the […]