ORA-12541: TNS:no listener - help plz
I installed oracle 10.2.0.1.0 in windows xp machine.
using sql*plus I am able to connect using scott/tiger.
if give scott/tiger@local ( local is the tnsname i have given in tnsnames)
it is showing the above error ORA-12541: TNS:no listener.
If I try to start the listner from command prompt
using lsnrctl start --- it is showing
" TNS-12560 : PROTOCAL ADAPTER ERROR" FAILED TO START THE SERVICE.
PLZ GIVE SUGGESTION. FOLLOWING ARE THE DETAILED INFO.
# tnsnames.ora Network Configuration File:
D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = madhu)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = madhu)(PORT = 1521))
)
)
ORA-012541-listener problem - reply
I checked the environment variables in the path
my compuer - properties - advanced - environment variables - system variables.
in that regarding oracle only path variable is available its values is
D:\oracle\product\10.2.0\db_1\bin;E:\DevSuiteHome_1\jdk\jre\bin\classic;E:\DevSuiteHome_1\jdk\jre\bi n;E:\DevSuiteHome_1\jdk\jre\bin\client;E:\DevSuiteHome_1\jlib;E:\DevSuiteHome_1\bin;E:\DevSuiteHome_ 1\jre\1.4.2\bin\client;E:\DevSuiteHome_1\jre\1.4.2\bin;C:\orant\bin;%SystemRoot%\system32;%SystemRoo t%;%SystemRoot%\System32\Wbem;C:\orant\jdk\bin;C:\Program Files\Samsung\Samsung PC Studio 5\
there are no ORACLE _HOME,ORACLE_SID,TNS_ADMIN etc..
in either user variables or system variables.
But i found one thing in
administrative tools - services - Oracleoradbg10_home1TnsListener
- path to executable is still the old path.
d:\oracle\product\10.1.0\db_1\BIN\TNSLSNR - here 10.1.0 is older version
which was available before. I dont know how to change this path.
with thanks
by madhu
with thanks