Oracle Database Discussions

OS : Solaris 10

Ver : Oracle 10.2.0.1

Plan to use the oracle in a veritas cluster environment.


Have installed Oracle successfully. Listener and database starts normally.

In order to use the Oracle in a Veritas cluster setup, clients should be able to communicate with the listner with a virual ip address.

For this purpose updated :

1) ~/oracle/product/10.2.0/db_1/network/admin/listener.ora as follows:
-------------------------------------------------------------------------------------------------------



ORIGINAL ENTRY
===========

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle10G/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = originalHostName)(PORT = 1521))
)
)


UPDATED AS
========

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle10G/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = virtualHostName)(PORT = 1521))
)
)





2) ~/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora as follows:
----------------------------------------------------------------------------------------------------------

ORIGINAL ENTRY
===========


empDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = originalHostName)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MCDB)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

UPDATED AS
========

empDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = virtualHostName)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MCDB)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


a) After doing above two changes, restarted the listner & also the database.

When I try to connect the oracle server with virutal hostname from a client (Toad on windows), I am getting the error:

"ORA-12505: TNS:listener could not resolve SID given in connect descriptor"

i.e. client is able to connect to the listener but it is not able to find the SID empDB

b) Also, before making the change, lsnrctl status shows empDB. But after the change and restart, lsnrctl status, doesn't contain entries for empDB.

c) Tried changing the hostnames manually and also using the tool netmgr. In both the cases, am facing the same error.


Can someone please help me to address this issue ?