Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Listener 10g: Failed to start service, error 0 and TNS-12560

631254May 11 2008 — edited Apr 13 2009
E:\>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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 11 2009
Added on May 11 2008
7 comments
19,941 views