Message 3511 not found; No message file for product=network, facility=TNS-03505

Message 3511 not found; No message file for product=network, facility=TNS-03505

Following error occurred when run the tnsping command without setting the environment variable for Oracle Database:

tnsping databasename

$ tnsping ORCL
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 06-JUL-2010 10:38:30
Copyright (c) 1997, 2009, 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

1. Set the oracle home environment variable

On Window:
SET ORACLE_HOME=C:\app\oracle\db_1
On Linux:
export ORACLE_HOME=/u01/app/oracle/db_1

2. Set the oracle sid environment variable

On Window
SET ORACLE_SID=ORCL
On Linux
export ORACLE_SID=ORCL

3. Then try again the tnsping command

tnsping ORCL

Note:
1. In Linux operating system, you can also use the .oraenv command to set environment variable if entry present in oratab.
2. In Windows you can set environment variable permanent by setting it in windows environment variable through right click on My Computer –> select properties –>.Advance System Setting –> Environment Variable.
 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.