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!

TNS Error

2624807Dec 16 2015 — edited Dec 23 2015

Hi All,

When I am connecting to the server database using sqlplus at the command prompt it's showing the following error:

ERROR:

ORA-12541: TNS:no listener

When I tried to ping the same it's showing error as below:-

C:\Users\admin>tnsping orcl

TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 16-DEC-2015 16:59:26

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

Message 3511 not found; No message file for product=NETWORK, facility=TNSTNS-03505: Message 3505 not found; No message file for product=NETWORK, facility=TNS

C:\Users\admin>

When I tried with listener utility its showing the error as below:-

C:\Users\admin>lsnrctl stat

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 16-DEC-2015 17:29:15

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Message 1053 not found; No message file for product=NETWORK, facility=TNSTNS-12557: Message 12557 not found; No message file for product=NETWORK, facility=TNS

TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS

  TNS-00527: Message 527 not found; No message file for product=NETWORK, facility=TNS

Message 1053 not found; No message file for product=NETWORK, facility=TNSTNS-12557: Message 12557 not found; No message file for product=NETWORK, facility=TNS

TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS

  TNS-00527: Message 527 not found; No message file for product=NETWORK, facility=TNS

C:\Users\admin>

Is it possible to get it resolved or at-least take the backup of the data.

Thanks,

Tarkeshwar.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 20 2016
Added on Dec 16 2015
11 comments
1,759 views