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

Leave a reply

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 Windows: 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 Windows: SET ORACLE_SID=ORCL
On Linux: export ORACLE_SID=ORCL

3. Run the tnsping command again
tnsping ORCL

Note: On Linux, you can use the .oraenv command if there’s an entry in oratab. On Windows, set the environment variable permanently through My Computer > Properties > Advanced System Settings > Environment Variables.

Leave a Reply