Oracle 21c RAC Linux 8 Install Tips
Tim had prepared the detail install tips regarding oracle 21c RAC.
Very convenient and efficient!
I changed VM memory size 800MB/5GB/5GB and change the DB’s size to 800MB for my mac’s limited memeory.
Oracle 21c RAC
SQL> set linesize 80
SQL> select banner_full from v$version;
BANNER_FULL
--------------------------------------------------------------------------------
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
SQL> set lines 500 pages 150
SQL> col HOST_NAME for a35
SQL> SELECT INSTANCE_NAME, TO_CHAR(STARTUP_TIME,'YYYY/MM/DD HH24:MI:SS') "STARTUP", DATABASE_ROLE, OPEN_MODE from GV$INSTANCE, V$DATABASE order by 2;
INSTANCE_NAME STARTUP DATABASE_ROLE OPEN_MODE
---------------- ------------------- ---------------- --------------------
cdbrac2 2021/08/31 02:30:13 PRIMARY READ WRITE
cdbrac1 2021/08/31 02:31:15 PRIMARY READ WRITE
SQL>
[oracle@ol8-21-rac1 ~]$ source scripts/setEnv.sh
[oracle@ol8-21-rac1 ~]$ source scripts/db_env
[oracle@ol8-21-rac1 ~]$ srvctl status database -d cdbrac
Instance cdbrac1 is running on node ol8-21-rac1
Instance cdbrac2 is running on node ol8-21-rac2
[oracle@ol8-21-rac1 ~]$ source scripts/grid_env
[oracle@ol8-21-rac1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE ol8-21-rac1 STABLE
ONLINE ONLINE ol8-21-rac2 STABLE
ora.chad
ONLINE ONLINE ol8-21-rac1 STABLE
ONLINE ONLINE ol8-21-rac2 STABLE
ora.net1.network
ONLINE ONLINE ol8-21-rac1 STABLE
ONLINE ONLINE ol8-21-rac2 STABLE
ora.ons
ONLINE ONLINE ol8-21-rac1 STABLE
ONLINE ONLINE ol8-21-rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE ol8-21-rac1 STABLE
2 ONLINE ONLINE ol8-21-rac2 STABLE
ora.CRS.dg(ora.asmgroup)
1 ONLINE ONLINE ol8-21-rac1 STABLE
2 ONLINE ONLINE ol8-21-rac2 STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE ol8-21-rac1 STABLE
2 ONLINE ONLINE ol8-21-rac2 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE ol8-21-rac2 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE ol8-21-rac2 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE ol8-21-rac1 STABLE
ora.RECO.dg(ora.asmgroup)
1 ONLINE ONLINE ol8-21-rac1 STABLE
2 ONLINE ONLINE ol8-21-rac2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE ol8-21-rac1 Started,STABLE
2 ONLINE ONLINE ol8-21-rac2 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE ol8-21-rac1 STABLE
2 ONLINE ONLINE ol8-21-rac2 STABLE
ora.cdbrac.db
1 ONLINE ONLINE ol8-21-rac2 Open,HOME=/u01/app/o
racle/product/21.0.0
/dbhome_1,STABLE
2 ONLINE ONLINE ol8-21-rac1 Open,HOME=/u01/app/o
racle/product/21.0.0
/dbhome_1,STABLE
ora.cdbrac.pdb1.pdb
1 ONLINE ONLINE ol8-21-rac1 STABLE
2 OFFLINE OFFLINE STABLE
ora.cdp1.cdp
1 ONLINE ONLINE ol8-21-rac2 STABLE
ora.cdp2.cdp
1 ONLINE ONLINE ol8-21-rac2 STABLE
ora.cdp3.cdp
1 ONLINE ONLINE ol8-21-rac1 STABLE
ora.cvu
1 ONLINE ONLINE ol8-21-rac2 STABLE
ora.ol8-21-rac1.vip
1 ONLINE ONLINE ol8-21-rac1 STABLE
ora.ol8-21-rac2.vip
1 ONLINE ONLINE ol8-21-rac2 STABLE
ora.qosmserver
1 ONLINE ONLINE ol8-21-rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE ol8-21-rac2 STABLE
ora.scan2.vip
1 ONLINE ONLINE ol8-21-rac2 STABLE
ora.scan3.vip
1 ONLINE ONLINE ol8-21-rac1 STABLE
--------------------------------------------------------------------------------
[oracle@ol8-21-rac1 ~]$
vagrant up start log
lin@lin-mac dns % cd ../node2
lin@lin-mac node2 % vagrant up
Bringing machine 'default' up with 'virtualbox' provider...
==> default: Checking if box 'oraclebase/oracle-8' version '2021.07.29' is up to date...
==> default: Clearing any previously set forwarded ports...
==> default: Fixed port collision for 22 => 2222. Now on port 2200.
==> default: Clearing any previously set network interfaces...
==> default: Preparing network interfaces based on configuration...
default: Adapter 1: nat
default: Adapter 2: hostonly
default: Adapter 3: intnet
==> default: Forwarding ports...
default: 1521 (guest) => 1522 (host) (adapter 1)
default: 5500 (guest) => 5502 (host) (adapter 1)
default: 22 (guest) => 2200 (host) (adapter 1)
==> default: Running 'pre-boot' VM customizations...
==> default: Booting VM...
==> default: Waiting for machine to boot. This may take a few minutes...
default: SSH address: 127.0.0.1:2200
default: SSH username: vagrant
default: SSH auth method: private key
==> default: Machine booted and ready!
==> default: Checking for guest additions in VM...
==> default: Configuring and enabling network interfaces...
==> default: Mounting shared folders...
default: /vagrant => /Users/lin/oracle21c/vagrant/rac/ol8_21/node2
default: /vagrant_config => /Users/lin/oracle21c/vagrant/rac/ol8_21/config
default: /vagrant_scripts => /Users/lin/oracle21c/vagrant/rac/ol8_21/shared_scripts
default: /vagrant_software => /Users/lin/oracle21c/vagrant/rac/ol8_21/software
==> default: Machine already provisioned. Run `vagrant provision` or use the `--provision`
==> default: flag to force provisioning. Provisioners marked to run always will still run.
lin@lin-mac node2 %
lin@lin-mac node2 % cd ../node1
lin@lin-mac node1 % vagrant up
Bringing machine 'default' up with 'virtualbox' provider...
==> default: Checking if box 'oraclebase/oracle-8' version '2021.07.29' is up to date...
==> default: Clearing any previously set forwarded ports...
==> default: Fixed port collision for 22 => 2222. Now on port 2201.
==> default: Clearing any previously set network interfaces...
==> default: Preparing network interfaces based on configuration...
default: Adapter 1: nat
default: Adapter 2: hostonly
default: Adapter 3: intnet
==> default: Forwarding ports...
default: 1521 (guest) => 1521 (host) (adapter 1)
default: 5500 (guest) => 5500 (host) (adapter 1)
default: 22 (guest) => 2201 (host) (adapter 1)
==> default: Running 'pre-boot' VM customizations...
==> default: Booting VM...
==> default: Waiting for machine to boot. This may take a few minutes...
default: SSH address: 127.0.0.1:2201
default: SSH username: vagrant
default: SSH auth method: private key
==> default: Machine booted and ready!
==> default: Checking for guest additions in VM...
==> default: Configuring and enabling network interfaces...
==> default: Mounting shared folders...
default: /vagrant => /Users/lin/oracle21c/vagrant/rac/ol8_21/node1
default: /vagrant_config => /Users/lin/oracle21c/vagrant/rac/ol8_21/config
default: /vagrant_scripts => /Users/lin/oracle21c/vagrant/rac/ol8_21/shared_scripts
default: /vagrant_software => /Users/lin/oracle21c/vagrant/rac/ol8_21/software
==> default: Machine already provisioned. Run `vagrant provision` or use the `--provision`
==> default: flag to force provisioning. Provisioners marked to run always will still run.
lin@lin-mac node1 %
Ref
Oracle Database 21c RAC On Oracle Linux 8 Using VirtualBox and Vagrant
Have a good work&life! 2021/08 via LinHong