-
ora-12560 error when connecting from the client
Hi all,
I have problem connecting to the database server from the client; however, I was able to connect on the server fine uding the same connect string, the error I got is:
SQL> connect system/manager@test.tele.com
ERROR:
ORA-12560: TNSrotocol adapter error
below is my tnsnames.ora
Code:
# TNSNAMES.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
INST1_HTTP.TELE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TEST.TELE.COM)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA.TELE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
TEST.TELE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TEST.TELE.COM)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)
below is my sqlnet.ora
Code:
# SQLNET.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin# SQLNET.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = TELE.COM
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
below is my listener.ora
Code:
# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = test.TELE.COM)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = /opt/oracle/product/9.2.0)
(SID_NAME = test)
)
)
thanks
-
Compare tnsnames.ora on client with tnsnames.ora on server.
Compare sqlnet.ora on client with sqlnet.ora on server.
svk
-
Hey, those code tags are pretty cool now, eh?
Jeff Hunter
-
Hi,
I want to be sure so I copy the same sqlnet.ora and tnsnames.ora and I still have the same problem.
any other thoughts????
-
-
c:\>tnsping test
TNS Ping Utility for 32-bit Windows: Version 10.1.0.3.0 - Production on 21-JUN-2
005 13:28:03
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
C:\oracle\Ora101\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 168.172.3.1)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE
_NAME = test)))
TNS-12560: TNSrotocol adapter error
same error when I do the tnsping test.tele.com
-
You may have copied tnsnames.ora into wrong directory. Notice HOST information in tnsping o/p. It isn't test.test.com (the way it should be).
svk
-
how about:
ping 168.172.3.1
ping test.tele.com
nslookup test.tele.com
nslookup 168.172.3.1
Also, on test.tele.com, lets see the output from:
lsnrctl status
Jeff Hunter
-
Originally Posted by svk
You may have copied tnsnames.ora into wrong directory. Notice HOST information in tnsping o/p. It isn't test.test.com (the way it should be).
nah, the default_domain is correct.
Jeff Hunter
-
Oh, wait. Your service name is test. I think you want that to be your SID:
Code:
TEST.TELE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TEST.TELE.COM)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = test)
)
)
Jeff Hunter
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
|