ORA-12541: TNS:no listener
hi,
I am using oracle8i. I had installed software and created the database in windows 2000.Both server and client are running in same machine.
I configured listener and tnsnames while creating database.I am able to connect to any user without host string but when i try to connect using host string it says
ORA-12541: TNS:no listener.
SQL> connect cbt/ksdcbt;
Connected.
SQL> connect cbt/ksdcbt@kesd;
ERROR:
ORA-12541: TNS:no listener
Warning: You are no longer connected to ORACLE.
I even checked listener status,it displays that listener is up.
when i try to ping the service name also i get the same error
ORA-12541: TNS:no listener
C:\Documents and Settings\Administrator>tnsping kesd
TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 05-DEC-20
06 15:40:11
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=kesdee-yjicbiki)(PORT=1521))
TNS-12541: TNS:no listener
I dont know where i am going wrong.can any one help me to resolve this.and correct me where i am going wrong.
here i had given my configured listener and tnsnames.ora files.
# LISTENER.ORA Network Configuration File: D:\oracle\ora81\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 = kesdee-yjicbiki)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = kesdee-yjicbiki)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = kesd)
(ORACLE_HOME = D:\oracle\ora81)
(SID_NAME = kesd)
)
)
tnsnames.ora
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
KESD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kesdee-yjicbiki)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = kesd)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = kesdee-yjicbiki)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = kesd)
(PRESENTATION = http://admin)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
help me plz..........
with regards
Boo