You may hit TNSTNS-03505 Message 3511 error message while you are trying to use tnsping command.Complete error message is:

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

You may hit this error while on database machine or machine which only has client installataion.

I have been face this problem on machine which has 11g client. Also the user is not installation user,so  We have been created one other user and give that user to development team.

My installation user is oracle, development user is oracle1… Both user group are same(dba)

Even I can use tnsping with oracle user i can get response, but wiht oracle 1 I am hitting below error

With Oracle user:
[oracle@client_machine]</oracle11g/app/oracle/product/11.2.0/client_1/bin>tnsping DB_NAME

TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.4.0 – Production on 14-FEB-2014 11:08:13

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

Used parameter files:
/oracle11g/app/oracle/product/11.2.0/client_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1525)) (ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1525)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xxx)))
OK (0 msec)

With Oracle1 user:
[oracle1@client_machine]</oracle11g/app/oracle/product/11.2.0/client_1/bin> tnsping DB_NAME

TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.4.0 – Production on 14-FEB-2014 11:05:05

Copyright (c) 1997, 2013, 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

So issue has been solved by below steps:

At oracle1 user I have been set below parameter to .profile

export ORACLE_BASE=/oracle11g/app/oracle
export ORACLE_HOME=/oracle11g/app/oracle/product/11.2.0/client_1
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

[oracle1@client_machine]</oracle11g/app/oracle/product/11.2.0/client_1/bin> tnsping DB_NAME
TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.4.0 – Production on 14-FEB-2014 11:08:13

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

Used parameter files:
/oracle11g/app/oracle/product/11.2.0/client_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1525)) (ADDRESS = (PROTOCOL = TCP)(HOST = xxx)(PORT = 1525)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = xxx)))
OK (0 msec)

If you are on db server than you also need to set ORACLE_SID.

Advertisements