Hi Sashi/Trinath
I am getting a bit confused.....so let me start again
While installing the oracle server, the insatalltaion asks you for
1) SID
2) Global Database Name
so i provided the following values
SID=practice
Global Database Name=axxx.byyy
The tnsoranames conatins the follwing enrty
axxx.byyy.com=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.210.18.39)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = practice)
)
)
AND listener.ore contains the following enrty
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.210.18.39)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\OraHome1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = UKOBA)
(ORACLE_HOME = D:\OraHome1)
(SID_NAME = UKOBA)
)
(SID_DESC =
(GLOBAL_DBNAME = nhsdw1)
(ORACLE_HOME = D:\OraHome1)
(SID_NAME = nhsdw)
)
(SID_DESC =
(GLOBAL_DBNAME = axxx.byyy)
(ORACLE_HOME = D:\OraHome1)
(SID_NAME = practice)
)
)
and entry in the sql.net
NAMES.DEFAULT_DOMAIN = byyy.com
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
I am not able to figure out what is the reason for the error as there are enteries in all the three files.
It would be great help if you could throw some light on this topic
Thanks
