This blog is in continuation with my previous blog on VM RAC DB Creation.
You had created a VM RAC and it was in provisioning state.
In this blog we look into how to see details of the instances and access them.
Wait for the system to become available from provision state - Wait time is about 1 hour for me.
Step 1 - Click on "View DB System Details" to view details of the system.
Step 2 - Note down DB Details such as scan name, IP addresses etc for your usage.
Step 3 - Bottom Left click on Nodes to see Nodes of the database
Step 4 - Note down the Private IP address and DNS name for the instances which have been launched.
You can see as in RAC cluster, there is floating IP (VIP), Scan addresses and Public IPs.
There are obviously Private interfaces, which we will look shortly after logging on to the system.
To Login to system you need to provide the rsa key. I will use the Windows VM which was launched as part of this series and login. To see details on login see my previous blog.
We will use any of the private ip address which was generated - 10.10.11.4 and 10.10.11.5 to login.
ssh -i id_rsa opc@10.10.11.4
[opc@rac1 ~]$ ps -ef | grep pmon
grid 2206 1 0 05:46 ? 00:00:00 asm_pmon_+ASM1
grid 11892 1 0 05:48 ? 00:00:00 apx_pmon_+APX1
oracle 50457 1 0 06:19 ? 00:00:00 ora_pmon_db181
sudo su -
[root@rac1 ~]# /u01/app/18.0/grid/bin/olsnodes -t
rac1 Unpinned
rac2 Unpinned
[root@rac1 ~]# /u01/app/18.0/grid/bin/crsctl stat res -t | less
[root@rac1 ~]# /u01/app/18.0/grid/bin/srvctl config database
db18_iad2rj
[root@rac1 ~]# /u01/app/18.0/grid/bin/srvctl status database -d db18_iad2rj
Instance db181 is running on node rac1
Instance db182 is running on node rac2
You had created a VM RAC and it was in provisioning state.
In this blog we look into how to see details of the instances and access them.
Wait for the system to become available from provision state - Wait time is about 1 hour for me.
Step 1 - Click on "View DB System Details" to view details of the system.
Step 2 - Note down DB Details such as scan name, IP addresses etc for your usage.
Step 3 - Bottom Left click on Nodes to see Nodes of the database
Step 4 - Note down the Private IP address and DNS name for the instances which have been launched.
You can see as in RAC cluster, there is floating IP (VIP), Scan addresses and Public IPs.
There are obviously Private interfaces, which we will look shortly after logging on to the system.
To Login to system you need to provide the rsa key. I will use the Windows VM which was launched as part of this series and login. To see details on login see my previous blog.
We will use any of the private ip address which was generated - 10.10.11.4 and 10.10.11.5 to login.
ssh -i id_rsa opc@10.10.11.4
[opc@rac1 ~]$ ps -ef | grep pmon
grid 2206 1 0 05:46 ? 00:00:00 asm_pmon_+ASM1
grid 11892 1 0 05:48 ? 00:00:00 apx_pmon_+APX1
oracle 50457 1 0 06:19 ? 00:00:00 ora_pmon_db181
sudo su -
[root@rac1 ~]# /u01/app/18.0/grid/bin/olsnodes -t
rac1 Unpinned
rac2 Unpinned
[root@rac1 ~]# /u01/app/18.0/grid/bin/oifcfg getif
eth0 10.10.11.0 global public
eth1 192.168.16.0 global cluster_interconnect,asm
[root@rac1 ~]# /u01/app/18.0/grid/bin/srvctl config database
db18_iad2rj
[root@rac1 ~]# /u01/app/18.0/grid/bin/srvctl status database -d db18_iad2rj
Instance db181 is running on node rac1
Instance db182 is running on node rac2
[root@rac1 ~]# /u01/app/18.0/grid/bin/srvctl config scan
SCAN name: rac-scan.privatesubnet1.dbvcn.oraclevcn.com, Network: 1
Subnet IPv4: 10.10.11.0/255.255.255.0/eth0, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 10.10.11.8
SCAN VIP is enabled.
SCAN VIP is individually enabled on nodes:
SCAN VIP is individually disabled on nodes:
SCAN 2 IPv4 VIP: 10.10.11.9
SCAN VIP is enabled.
SCAN VIP is individually enabled on nodes:
SCAN VIP is individually disabled on nodes:
SCAN 3 IPv4 VIP: 10.10.11.10
SCAN VIP is enabled.
SCAN VIP is individually enabled on nodes:
SCAN VIP is individually disabled on nodes:
ssh -i id_rsa opc@10.10.11.5
[opc@rac2 ~]$ ps -ef | grep pmon
oracle 12376 1 0 06:19 ? 00:00:00 ora_pmon_db182
opc 33405 33365 0 06:55 pts/0 00:00:00 grep pmon
grid 79123 1 0 05:45 ? 00:00:00 asm_pmon_+ASM2
grid 93356 1 0 05:48 ? 00:00:00 apx_pmon_+APX2
No comments:
Write comments