Hi Guru's,
My DB Version: 10.2.0
OS : Solaris
I have 2 Database installed on the server one with the name of orcl and one with the name of mz50. When i am trying to connect from client side using toad to orcl i am able to connect to that db successfully but when i try to connect to mz50 DB i getting above mentioned error.
I check the tnsnames file as well as listener file and when i am trying to do tnsping both DB reply
My tnsname file is
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = blade0)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
mz50 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = blade0)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mz50)
)
)
mz5audit =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = blade0)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mz5audit)
)
)
BSCSPROD =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 192.168.32.42)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = BSCSPROD)
)
)
TSI =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 172.30.70.245)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TSIINDIA)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
listener file is
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /export/home/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = mz50)
(ORACLE_HOME = /export/home/oracle/product/10.2.0/db_1)
(SID_NAME = mz50)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /export/home/oracle/product/10.2.0/db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = blade0)(PORT = 1521))
)
)
my sqlnet file is :
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.AUTHENTICATION_SERVICES = (NONE)
when i do tnsping i get
-bash-3.00$ tnsping orcl
TNS Ping Utility for Solaris: Version 10.2.0.1.0 - Production on 08-AUG-2012 22:00:22
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/export/home/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = blade0)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (1390 msec)
-bash-3.00$ tnsping mz50
TNS Ping Utility for Solaris: Version 10.2.0.1.0 - Production on 08-AUG-2012 22:01:03
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/export/home/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = blade0)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = mz50)))
OK (10 msec)
I done modifications as well as recreate the tnsnames.ora file as well as listner file with giving ip of the machine as well but still not able to connect to mz50 DB .
Please help me over the same due to this problems my application are not connected to db