Home » Infrastructure » Windows » Error messages : ORA-12560
Error messages : ORA-12560 [message #100679] Mon, 12 May 2003 20:05 Go to next message
Gito
Messages: 1
Registered: May 2003
Junior Member
hi

I've installed an Oracle Standard 9i (TM) for Win2k Pro
After installing, I try to log in to SQLPLUS. But I get the
error messages : ORA-12560: TNS: protocol adapter error.
Although checking 'listener.ora' and 'tnsnames.ora'
i still get an error.
this script from :

# ========================
# LISTENER.ORA Network Configuration File:
C:oracleora90networkadminlistener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = v7100S)(PORT =1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = v7100S)(PORT = 2481))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = V7100S)
(ORACLE_HOME = C:OracleOra90)
(SID_NAME = v7100s)
)
)

===================
'TNSNAMES.ORA'
# TNSNAMES.ORA Network Configuration files :
C:oracleora90networkadmintnsnames.ora
# Generated by Oracle configuration tools.
v7100s =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = V7100S)(PORT =1521))
)
(CONNECT_DATA =
(SERVICE_NAME = v7100s)
)
)

====================
List dos command for "lsnrctl status"
LSNRCTL for 32-bit Windows: Version 9.0.1.1.1 - Production on 12-MAY-2003
14:22:31

Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=v7100S)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.0.1.1.1 -
Production
Start Date 12-MAY-2003 13:47:35
Uptime 0 days 0 hr. 34 min. 56 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File C:oracleora90networkadminlistener.ora
Listener Log File C:oracleora90networkloglistener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=v7100s)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=v7100s)(PORT=2481)))
Services Summary...
Service "V7100S" has 1 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Would you like to help me, please.

Best regards.
Gito
Re: Error messages : ORA-12560 [message #100681 is a reply to message #100679] Thu, 15 May 2003 03:49 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
why are u using two different ports ?
dump / rename your existng listner.ora and create a new one using net8 config asst.
Previous Topic: Oracle number format in VB
Next Topic: About Windows CE and Visual Studio .NET
Goto Forum:
  


Current Time: Thu Mar 28 12:58:09 CDT 2024