| ORA-12560: TNS:protocol adapter error [message #149823] |
Mon, 05 December 2005 03:28  |
juicyapple
Messages: 92
Registered: October 2005
|
Member |
|
|
Hello, does anybody know why I get this message when I login to sqlplus with sys account?
SQL> conn sys/manager as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
The oracle service is running.
Thanks.
|
|
|
|
| Re: ORA-12560: TNS:protocol adapter error [message #149826 is a reply to message #149823] |
Mon, 05 December 2005 03:38  |
juicyapple
Messages: 92
Registered: October 2005
|
Member |
|
|
Below are the contents of listener.ora and sql.ora
# LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = CCServer1)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
)
---------------------------------------------------------
# SQLNET.ORA Network Configuration File: C:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
|
|
|
|
| Re: ORA-12560: TNS:protocol adapter error [message #149978 is a reply to message #149823] |
Mon, 05 December 2005 20:56 |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
You also need a tnsnames.ora file:
# tnsnames.ora Network Configuration File: C:\Oracle\product\10.1.0\Client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
OS2T =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = solarsystem)(PORT = 1521))
(CONNECT_DATA =
(SID = os2t)
)
)
This shows a service name of OS2T, a port of 1521, and a sid of os2t.
HTH
Neil.
|
|
|
|
|
|
| Re: ORA-12560: TNS:protocol adapter error [message #150037 is a reply to message #149823] |
Tue, 06 December 2005 01:28 |
Rishi Mahajan
Messages: 29
Registered: April 2005
Location: India
|
Junior Member |
|
|
Hi
R u connecting to ur database from client?
If Yes, u have to specify the service name while connecting
SQL> connect sys/manager@service_name as sysdba
The service_name should be specified in tnsnames.ora of client as
service_name
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = google) (PORT=1521))
(CONNECT_DATA =
(SID = mydb)
)
)
Rishi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
