Screenshots of the RAC
Installation for ORACLE_HOME for Database:
Created the listener
LAB_LISTENER using netca.
tnsnames.ora
(same on all the RAC nodes)
# tnsnames.ora.node2
Network Configuration File: /u01/app/oracle/db/network/admin/tnsnames.ora.node2
# Generated
by Oracle configuration tools.
LABDB3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node3-vip.hingu.net)(PORT = 1530))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = labdb.hingu.net)
(INSTANCE_NAME = labdb3)
)
)
LABDB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.hingu.net)(PORT = 1530))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = labdb.hingu.net)
(INSTANCE_NAME = labdb2)
)
)
LABDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.hingu.net)(PORT = 1530))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = labdb.hingu.net)
(INSTANCE_NAME = labdb1)
)
)
LISTENER_LABDB3 =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = node3-vip.hingu.net)(PORT = 1530))
)
LISTENER_LABDB2 =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.hingu.net)(PORT = 1530))
)
LISTENER_LABDB1 =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.hingu.net)(PORT = 1530))
)
LABDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.hingu.net)(PORT = 1530))
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.hingu.net)(PORT = 1530))
(ADDRESS = (PROTOCOL = TCP)(HOST = node3-vip.hingu.net)(PORT = 1530))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = labdb.hingu.net)
)
)
OLTP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.hingu.net)(PORT = 1530))
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.hingu.net)(PORT = 1530))
(ADDRESS = (PROTOCOL = TCP)(HOST = node3-vip.hingu.net)(PORT = 1530))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oltp.hingu.net)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
LISTENERS_LABDB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.hingu.net)(PORT = 1530))
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.hingu.net)(PORT = 1530))
(ADDRESS = (PROTOCOL = TCP)(HOST = node3-vip.hingu.net)(PORT = 1530))
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Listener.ora:
[oracle@node2 admin]$ ssh node3 cat /u01/app/oracle/db/network/admin/listener.ora
# listener.ora.node3
Network Configuration File: /u01/app/oracle/db/network/admin/listener.ora.node3
# Generated
by Oracle configuration tools.
SID_LIST_LAB_LISTENER_NODE3 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/db)
(PROGRAM = extproc)
)
)
LAB_LISTENER_NODE3 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node3-vip.hingu.net)(PORT = 1530)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.3)(PORT = 1530)(IP = FIRST))
)
)
[oracle@node2 admin]$ ssh node2 cat /u01/app/oracle/db/network/admin/listener.ora
# listener.ora.node2
Network Configuration File: /u01/app/oracle/db/network/admin/listener.ora.node2
# Generated
by Oracle configuration tools.
SID_LIST_LAB_LISTENER_NODE2 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/db)
(PROGRAM = extproc)
)
)
LAB_LISTENER_NODE2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.hingu.net)(PORT = 1530)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.2)(PORT = 1530)(IP = FIRST))
)
)
[oracle@node2 admin]$ ssh node1 cat /u01/app/oracle/db/network/admin/listener.ora
# listener.ora.node1
Network Configuration File: /u01/app/oracle/db/network/admin/listener.ora.node1
# Generated
by Oracle configuration tools.
SID_LIST_LAB_LISTENER_NODE1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/db)
(PROGRAM = extproc)
)
)
LAB_LISTENER_NODE1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.hingu.net)(PORT = 1530)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.1)(PORT = 1530)(IP = FIRST))
)
)