No message file for product=NETWORK
I have several Windows 2008 servers with SQL Server DTS packages which connect to oracle instances. Most servers connect ok. One gets these messages with DTS and also with tnsping:
Message 3511 not found; No message file for product=NETWORK,
facility=TNSMessage 3512 not found; No message file for product=NETWORK,
facility=TNSAttempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SERVERNAME.
DOMAINNAME.COM)(PORT = 1528))) (CONNECT_DATA = (SID = MYSID) (SERVER = DEDICATED)))
Message 3509 not found; No message file for product=NETWORK, facility=TNS
I've found lots of threads on various forums referring to problems like this. People want to know
How is your tns entry coded? answer: correctly. same entry works on other servers.
is the environment variable tns_admin set? answer: doesn't seem to matter. works on other servers without it.
Is the environment variable oracle_home set? answer: Yes. It is the same as first entry in PATH environment variable. But works on other servers even if not set.
Is the oracle instance and the listener up? answer: yes
and similar questions. I'd like to start somewhere else.
Can someone explain to me 2 things:
1. What does "product=NETWORK" mean?
2. When the message says "No message file for product=NETWORK" what file is it looking for and where is it looking?
Most discussions on this subject walk all around these questions. Sounds to me that tns is trying to look up
some messages in a file somewhere and isn't finding them because of an incorrect path or a version mismatch.
Hayden