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 […]
RAC

How to Build 18c RAC – 4 of 4 – Creating a RAC Database

Posted on
How to Build 18c RAC – 3 of 4 – Installing Database Software on All Nodes Create a RAC Database Check All Grid Services Make sure everything is ready on grid-level. [grid@primary01 ~]$ crsctl status resource -t ——————————————————————————– Name           Target  State        Server              […]
RAC

How to Build 18c RAC – 3 of 4 – Installing Database Software on All Nodes

Posted on
How to Build 18c RAC – 2 of 4 – Installing Grid Infrastructure Install Database Software Upload and Unzip Source on Node 1 Please note that, you should upload and unzip the software source in ORACLE_HOME because Oracle database starts to use image-based installation since 18c. > cd d:/oracle > sftp oracle@192.168.10.11:/u01/app/oracle/product/18.0.0/db_1 Connected to 192.168.10.11. […]
Linux

How to Build 18c RAC – 1 of 4 – Preparing Two Database Servers

Posted on
Network Design for RAC Let’s see the network design of our cluster database. [root@primary01 ~]# vi /etc/hosts # Public 192.168.10.11 primary01 primary01.example.com 192.168.10.12 primary02 primary02.example.com # Private 192.168.24.11 primary01-priv primary01-priv.example.com 192.168.24.12 primary02-priv primary02-priv.example.com # VIP 192.168.10.111 primary01-vip primary01-vip.example.com 192.168.10.112 primary02-vip primary02-vip.example.com # SCAN # 192.168.10.81 primary-cluster-scan primary-cluster-scan.example.com # 192.168.10.82 primary-cluster-scan primary-cluster-scan.example.com # 192.168.10.83 primary-cluster-scan primary-cluster-scan.example.com […]
ACFS

How to Create Database on ACFS

Posted on
Assuming that you have created a ACFS file system for the database creation. Then you can go on reading this post. Create a Database on ACFS First of all, make sure everything is ready including ACFS mount point which is /u02/oradata1 in this case. [grid@primary01 ~]$ crsctl status resource ora.data.oradata1.acfs -t ——————————————————————————– Name      […]
Installation and Upgrade

How to Build 12c RAC (5/6) – Installing RAC Database

Posted on
How to Build 12c RAC (4/6) – Installing Grid InfrastructureRun Universal Installer as oracle.[oracle@primary01 ~]$ cd /tmp/database/[oracle@primary01 database]$ ./runInstallerStarting Oracle Universal Installer…Checking Temp space: must be greater than 500 MB.   Actual 27489 MB    PassedChecking swap space: must be greater than 150 MB.   Actual 6047 MB    PassedChecking monitor: must be configured to […]