<<BACK

 

Screenshots of the RAC Installation for ORACLE_HOME for Database:

 

01

02

03.jpg04

05

06.jpg

07

 

080909

 

10.jpg

 

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))

    )

  )

 

                                                                        <<BACK

 

 

 

HTML Comment Box is loading comments...