Checking Oracle Client Connectivity

Check the connection to the database from the client on SIOS20-BASTION.

1. Ensure that the Oracle resource hierarchy is active on the active node (SIOS20-NODE1).
   

2. Use the virtual IP address to connect to the database from SIOS20-BASTION and run a simple SQL statement.
   

   C:\> sqlplus sys/<password>@10.0.2.21:1521/orcl as sysdba
   SQL> select instance_name from v$instance ;
   SQL> select sys_context('USERENV','SERVER_HOST') from dual ;
   

   
   

3. Right-click on the ORCL resource for the standby node (SIOS20-NODE2) and select In Service. The ORCL resource will switch over to the standby node.
   

4. Once the switchover is completed the following screen will appear.
   

5. Use the virtual IP address to connect to the database from SIOS20-BASTION.
   

6. You have now verified that the client can connect to the database using the same IP address (virtual IP address) before and after the switchover.