-
hi,
my listener is running on server,tnsping is ok at client node, but sql*plus is not connecting giving the error-
ORA-12545 TNS:name lookup failure
This message occurs when the listener on the remote node cannot be contacted. The ADDRESS in the TNSNAMES.ORA file or the LISTENER.ORA file may be incorrect. This message may also appear if the listener on the remote node has not been started. Check its status with the STATUS command of the Listener Control Utility, and start it with the START command if necessary.
this is the tnsnames.ora-
# E:\ORACLE\ORAHOME81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:E:\oracle\orahome81\network\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant
ORTELAPP.SKYCABLE.NET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = APPSERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORTEL)
)
)
EXTPROC_CONNECTION_DATA.SKYCABLE.NET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLE.SKYCABLE.NET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = database))
)
(CONNECT_DATA =
(SERVICE_NAME = oracle)
)
)
ORACLE1.SKYCABLE.NET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = database)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oracle1)
)
)
this is listener.ora
# E:\ORACLE\ORAHOME81\NETWORK\ADMIN\LISTENER.ORA Configuration File:E:\oracle\orahome81\network\admin\listener.ora
# Generated by Oracle Net8 Assistant
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = database)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\orahome81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = oracle)
(ORACLE_HOME = E:\oracle\orahome81)
(SID_NAME = ORACLE)
)
(SID_DESC =
(GLOBAL_DBNAME = oracle1)
(ORACLE_HOME = E:\oracle\orahome81)
(SID_NAME = ORACLE1)
)
)
I am trying to connect with oracle1.
pl help soon.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|