Home » Developer & Programmer » Precompilers, OCI & OCCI » sqlnet.log: No message file for product=network, facility=TNS (InstantClient, 12.1.0.2.0, AIX, 64bit)
sqlnet.log: No message file for product=network, facility=TNS [message #685632] Mon, 21 February 2022 09:37 Go to next message
NevemTeve
Messages: 15
Registered: November 2017
Junior Member
My question is about file sqlnet.log: why does it contain messages like

TNS-12535: Message 12535 not found; No message file for product=network, facility=TNS
I know this problem does happen with standard client if file $ORACLE_HOME/network/mesg/tnsus.msg is not available, but (as far as I know) with InstantClient its content should exist in $ORACLE_HOME/lib/libociei.so.

At least in other contexts (sql*plus, Pro*C, OCI) I get valid error messages like ORA-12154: TNS:could not resolve the connect identifier specified

Also I would like to know under what conditions is file sqlnet.log written. It's clear not every problem is logged into it, only some of them.

[Updated on: Mon, 21 February 2022 09:39]

Report message to a moderator

Re: sqlnet.log: No message file for product=network, facility=TNS [message #685637 is a reply to message #685632] Tue, 22 February 2022 02:51 Go to previous messageGo to next message
piripicchio
Messages: 18
Registered: April 2018
Location: Rome
Junior Member
A quick look on a strace output confirms that the instant client looks for that file:

open("/tmp/ic/instantclient_19_14/network/mesg/tnsus.msb", O_RDONLY) = -1 ENOENT (File o directory non esistente)
Re: sqlnet.log: No message file for product=network, facility=TNS [message #685684 is a reply to message #685637] Mon, 07 March 2022 00:57 Go to previous message
NevemTeve
Messages: 15
Registered: November 2017
Junior Member
Yes, that's right: InstantClient first looks for actual file, and if the file doesn't exist it uses the file stored in 'Data Shared Library' (i.e. libociei.so)
Previous Topic: OciDescribeAny on procedure in package gives error ORA-04043
Goto Forum:
  


Current Time: Fri Aug 12 03:19:44 CDT 2022