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

A simple issue that can seem complex. Always check if there are multiple Oracle Homes as well. Remove old ones.

Helios's Blog

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.

View original post 200 more words

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s