RAC Intro
Storage: openfiler
OS: Linux 7.5
Database : 12.2.0.1
CPU: 2 core per node
RAM: 8 GB
Hypervisor: Virtual Box
Node1 : racnode1
Node2 : racnode2
[root@racnode1 bin]# ./olsnodes -n -i -s -t
racnode1 1 racnode1-vip.localdomain Active Unpinned
racnode2 2 racnode2-vip.localdomain Active Unpinned
[root@racnode1 bin]#
[oracle@racnode2 ~]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
#public IP
192.168.43.222 racnode1.localdomain racnode1
192.168.43.87 racnode2.localdomain racnode2
#private ip
192.168.10.88 racnode1-priv.localdomain racnode1-priv
192.168.10.89 racnode2-priv.localdomain racnode2-priv
#virtul ip
192.168.43.224 racnode1-vip.localdomain racnode1-vip
192.168.43.225 racnode2-vip.localdomain racnode2-vip
# SCAN
192.168.43.228 racnode-scan.localdomain racnode1-scan
[oracle@racnode2 ~]$
Storage: openfiler
OS: Linux 7.5
Database : 12.2.0.1
CPU: 2 core per node
RAM: 8 GB
Hypervisor: Virtual Box
Node1 : racnode1
Node2 : racnode2
[root@racnode1 bin]# ./olsnodes -n -i -s -t
racnode1 1 racnode1-vip.localdomain Active Unpinned
racnode2 2 racnode2-vip.localdomain Active Unpinned
[root@racnode1 bin]#
[oracle@racnode2 ~]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
#public IP
192.168.43.222 racnode1.localdomain racnode1
192.168.43.87 racnode2.localdomain racnode2
#private ip
192.168.10.88 racnode1-priv.localdomain racnode1-priv
192.168.10.89 racnode2-priv.localdomain racnode2-priv
#virtul ip
192.168.43.224 racnode1-vip.localdomain racnode1-vip
192.168.43.225 racnode2-vip.localdomain racnode2-vip
# SCAN
192.168.43.228 racnode-scan.localdomain racnode1-scan
[oracle@racnode2 ~]$
[root@racnode2 bin]# ./crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[root@racnode2 bin]#
[root@racnode2 bin]# ./crsctl check cluster -all
**************************************************************
racnode1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
racnode2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
[root@racnode2 bin]# date
Sun May 31 12:23:15 IST 2020
[root@racnode2 bin]#
[oracle@racnode1 ~]$ . grid_env
[oracle@racnode1 ~]$
[oracle@racnode1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE racnode1 STABLE
ONLINE ONLINE racnode2 STABLE
ora.DATA.dg
ONLINE ONLINE racnode1 STABLE
ONLINE ONLINE racnode2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE racnode1 STABLE
ONLINE ONLINE racnode2 STABLE
ora.chad
ONLINE ONLINE racnode1 STABLE
ONLINE ONLINE racnode2 STABLE
ora.net1.network
ONLINE ONLINE racnode1 STABLE
ONLINE ONLINE racnode2 STABLE
ora.ons
ONLINE ONLINE racnode1 STABLE
ONLINE ONLINE racnode2 STABLE
ora.proxy_advm
OFFLINE OFFLINE racnode1 STABLE
OFFLINE OFFLINE racnode2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE racnode1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE racnode1 169.254.30.165 192.1
68.10.88,STABLE
ora.asm
1 ONLINE ONLINE racnode1 Started,STABLE
2 ONLINE ONLINE racnode2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE racnode1 STABLE
ora.guggu.db
1 ONLINE ONLINE racnode1 Open,HOME=/u01/app/o
racle/product/12.2.0
.1/db_home,STABLE
2 ONLINE ONLINE racnode2 Open,HOME=/u01/app/o
racle/product/12.2.0
.1/db_home,STABLE
ora.mgmtdb
1 ONLINE ONLINE racnode1 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE racnode1 STABLE
ora.racnode1.vip
1 ONLINE ONLINE racnode1 STABLE
ora.racnode2.vip
1 ONLINE ONLINE racnode2 STABLE
ora.scan1.vip
1 ONLINE ONLINE racnode1 STABLE
--------------------------------------------------------------------------------
[oracle@racnode1 ~]$
SQL> select INST_ID,INSTANCE_NUMBER,INSTANCE_NAME,HOST_NAME,VERSION,STARTUP_TIME,STATUS from gv$instance;
INST_ID INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STARTUP_T STATUS
---------- --------------- ---------------- ---------------------------------------------------------------- ----------------- --------- ------------
1 1 guggu1 racnode1.localdomain 12.2.0.1.0 31-MAY-20 OPEN
2 2 guggu2 racnode2.localdomain 12.2.0.1.0 31-MAY-20 OPEN
SQL>
No comments:
Post a Comment