Listener 10g: Failed to start service, error 0 and TNS-12560
631254May 11 2008 — edited Apr 13 2009E:\>set oracle_home
ORACLE_HOME=f:\oracle\product\10.2.0\db_1
E:\>set tns_admin
TNS_ADMIN=f:\oracle\product\10.2.0\db_1\network\admin\PROD_r12db
E:\>tnsping prod
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 11-MAY-2008 10:26:49
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
f:\oracle\product\10.2.0\db_1\network\admin\PROD_r12db\sqlnet_ifile.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=r12db.pasi.om)(PORT=1522)) (CONNECT_DATA= (SID=PROD)))
TNS-12541: TNS:no listener
E:\>lsnrctl
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 11-MAY-2008 10:26:55
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> start
Starting tnslsnr: please wait...
Failed to start service, error 0.
TNS-12560: TNS:protocol adapter error
LSNRCTL> exit
E:\>set hostname
Environment variable hostname not defined
E:\>set computername
COMPUTERNAME=R12DB