Setup Only One SCAN VIP
Oracle recommends that you allocate 3 or above SCAN VIP to load balance incoming connections. The more SCAN VIP, the more clients and connections they… Read More »Setup Only One SCAN VIP
Cluster
How to Resolve SRVCTL Error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
error while loading shared libraries After installing Oracle 10g RAC, we checked the configuration of the cluster database like this: [oracle@primary01 ~]$ srvctl config database… Read More »How to Resolve SRVCTL Error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
How to Set Server-Side Transparent Application Failover (TAF)
I have talked about how to set client-side Transparent Application Failover (TAF) pretty much. This time, we turn to server-side TAF. There're 2 ways to… Read More »How to Set Server-Side Transparent Application Failover (TAF)
How to Resolve INS-30510: Insuffient number of ASM disks selected
INS-30510 When we choose 2 disks to create a disk group with NORMAL redundancy during Oracle grid infrastructure 19c installation, we got INS-30510: Insuffient number… Read More »How to Resolve INS-30510: Insuffient number of ASM disks selected
How to Resolve ORA-00304: requested INSTANCE_NUMBER is busy
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… Read More »How to Resolve ORA-00304: requested INSTANCE_NUMBER is busy
How to Restore RAC Database from RMAN Backup Set
For 10g RAC database restoration, you may check: How to Restore 10g RAC Database from a Backup Set. Suppose we have restored 12c clusterware back.… Read More »How to Restore RAC Database from RMAN Backup Set
How to Restore 10g RAC Database from a Backup Set
For 12c RAC database restoration, you may check: How to Restore 12c RAC Database from a Backup Set. Suppose we have recovered 10g CRS and… Read More »How to Restore 10g RAC Database from a Backup Set
How to Resolve SPFILE in DB_UNKNOWN
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… Read More »How to Resolve SPFILE in DB_UNKNOWN
How to Build 18c RAC – 4 of 4 – Creating a RAC Database
How to Build 18c RAC - 3 of 4 - Installing Database Software on All Nodes Create a RAC Database Check All Grid Services Make… Read More »How to Build 18c RAC – 4 of 4 – Creating a RAC Database
How to Build 18c RAC - 3 of 4 - Installing Database Software on All Nodes
How to Build 18c RAC - 2 of 4 - Installing Grid Infrastructure Install Database Software Upload and Unzip Source on Node 1 Please note… Read More »How to Build 18c RAC - 3 of 4 - Installing Database Software on All Nodes