| Error messages : ORA-12560 [message #100679] |
Mon, 12 May 2003 20:05  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
