| TNS:protocol adapter error [message #66998] |
Mon, 19 May 2003 08:35  |
Yan Seiler
Messages: 13
Registered: December 2001
|
Junior Member |
|
|
Hi,
I am facing a very strange problem, if I do not specify the SID when trying to connect to sqlplus, I get a tns problem and no issue if I specify it:
C:Documents and SettingsPosAdmin>set ORACLE_SID=POS
C:Documents and SettingsPosAdmin>sqlplus system/manager
SQL*Plus: Release 8.1.7.0.0 - Production on Mon May 19 16:03:03 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
C:Documents and SettingsPosAdmin>sqlplus system/manager@pos
SQL*Plus: Release 8.1.7.0.0 - Production on Mon May 19 16:03:42 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL>
Does one have a idea ?
Thanks in advance
tnsnames.ora:
# TNSNAMES.ORA Network Configuration File: c:oracleora81NETWORKADMINtnsnames.ora
# Generated by Oracle configuration tools.
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 149.133.75.167)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = POS)
(PRESENTATION = http://admin)
)
)
POS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 149.133.75.167)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = POS)
(SRVR = DEDICATED)
)
)
listener.ora:
# LISTENER.ORA Network Configuration File: c:oracleora81networkadminlistener.ora
# Generated by Oracle configuration tools.
STARTUP_WAIT_TIME_LISTENER = 0
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = POS))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 149.133.75.167)(PORT = 1521))
)
)
)
CONNECT_TIMEOUT_LISTENER = 10
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = POS)
(ORACLE_HOME = c:oracleora81)
(SID_NAME = POS)
)
)
TRACE_LEVEL_LISTENER = OFF
sqlnet.ora:
# SQLNET.ORA Network Configuration File: c:oracleora81networkadminsqlnet.ora
# Generated by Oracle configuration tools.
#NAMES.DEFAULT_DOMAIN = world
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
|
|
|
|
| TNS:protocol adapter error+listening error [message #67654 is a reply to message #66998] |
Sun, 12 December 2004 20:32  |
yogesh bisht
Messages: 1
Registered: December 2004
|
Junior Member |
|
|
sir
i am facing problem in oracle9iAS installation. TNS network protocal adaptor is arising .also when configuring database then ORA-01109 error is listed.ALSO some more error of this ORA-00301,ORA-27038,ORA-01501,ORA 12560 be listing .provide me a solution for this.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
