Home » RDBMS Server » Networking and Gateways » " Tracing not turned on" SQLNET.ora (11.2.0.3, x86-64, redhat release 5.8)
" Tracing not turned on" SQLNET.ora [message #618967] Thu, 17 July 2014 00:59 Go to next message
sahadba
Messages: 54
Registered: September 2009
Location: Pune
Member

Hello Experts,

I am trying to enable Tracing through sqlnet.ora, below are the parameters that i set;


DIAG_ADR_ENABLED=OFF
TRACE_DIRECTORY_CLIENT=/prd/dvp/ora/tmp
TRACE_LEVEL_CLIENT=16
TRACE_UNIQUE_CLIENT=on


But the tracing is not enabled.

Below is the error show in sqlnet.log

Fatal NI connect error 12650, connecting to:
 (LOCAL=NO)

  VERSION INFORMATION:
        TNS for Linux: Version 11.2.0.3.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
  Time: 17-JUL-2014 07:42:53
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12650
    TNS-12650: No common encryption or data integrity algorithm
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

what am in missing here? please let me know

[Updated on: Thu, 17 July 2014 01:00]

Report message to a moderator

Re: " Tracing not turned on" SQLNET.ora [message #618969 is a reply to message #618967] Thu, 17 July 2014 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 59203
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post:
ls -ld /prd/dvp/ora/tmp
ls -l /prd/dvp/ora/tmp


Re: " Tracing not turned on" SQLNET.ora [message #618972 is a reply to message #618967] Thu, 17 July 2014 01:11 Go to previous messageGo to next message
John Watson
Messages: 4592
Registered: January 2010
Location: Global Village
Senior Member
Quote:
what am in missing here?


TRACE_FILE_CLIENT=...
Re: " Tracing not turned on" SQLNET.ora [message #618974 is a reply to message #618969] Thu, 17 July 2014 01:24 Go to previous messageGo to next message
sahadba
Messages: 54
Registered: September 2009
Location: Pune
Member

Hi Michel,

[oracle@lxx0131:/prd/dvp/ora/tmp]# ls -ld /prd/dvp/ora/tmp
drwxr-xr-x 8 oracle oinstall 126976 Jul 17 08:15 /prd/dvp/ora/tmp

The tracefiles were getting generated;

-rw-rw---- 1 oracle oinstall  181723 Jul 17 07:21 cli_12246.trc
-rw-rw---- 1 oracle oinstall  205450 Jul 17 07:22 cli_13465.trc
-rw-rw---- 1 oracle oinstall  204300 Jul 17 07:22 cli_13459.trc
-rw-rw---- 1 oracle oinstall  202711 Jul 17 07:22 cli_13450.trc
-rw-rw---- 1 oracle oinstall  208199 Jul 17 07:32 cli_26169.trc
-rw-rw---- 1 oracle oinstall  204335 Jul 17 07:32 cli_26164.trc
-rw-rw---- 1 oracle oinstall  200034 Jul 17 07:32 cli_26155.trc
-rw-rw---- 1 oracle oinstall  266859 Jul 17 07:38 cli_32236.trc
-rw-rw---- 1 oracle oinstall  181719 Jul 17 07:41 cli_4300.trc
-rw-rw---- 1 oracle oinstall  208197 Jul 17 07:42 cli_5415.trc
-rw-rw---- 1 oracle oinstall  204333 Jul 17 07:42 cli_5410.trc
-rw-rw---- 1 oracle oinstall  200036 Jul 17 07:42 cli_5401.trc


what could be the reason for the error in sqlnet.log, also alert log was flooded with below error;

opiodr aborting process unknown ospid (5880) as a result of ORA-609


thanks a lot
Re: " Tracing not turned on" SQLNET.ora [message #618977 is a reply to message #618974] Thu, 17 July 2014 01:36 Go to previous messageGo to next message
Michel Cadot
Messages: 59203
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So you have the trace files. Smile

ORA-00609: could not attach to incoming connection
 *Cause:  Oracle process could not answer incoming connection
 *Action: If the situation described in the next error on the stack
         can be corrected, do so; otherwise contact Oracle Support.

Re: " Tracing not turned on" SQLNET.ora [message #618978 is a reply to message #618977] Thu, 17 July 2014 01:50 Go to previous messageGo to next message
sahadba
Messages: 54
Registered: September 2009
Location: Pune
Member

yes, but why does the sqlnet.log shows "Tracing not turned on" Confused
Re: " Tracing not turned on" SQLNET.ora [message #618984 is a reply to message #618978] Thu, 17 July 2014 03:05 Go to previous messageGo to next message
Michel Cadot
Messages: 59203
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This is server file.
Anyway, don't care, you have your trace files, this is the most important point.

Re: " Tracing not turned on" SQLNET.ora [message #618998 is a reply to message #618984] Thu, 17 July 2014 04:18 Go to previous message
sahadba
Messages: 54
Registered: September 2009
Location: Pune
Member

ok

thanks a lot
Previous Topic: Unable to start listener
Next Topic: Fatal NI connect error 12547
Goto Forum:
  


Current Time: Tue Sep 23 23:28:49 CDT 2014

Total time taken to generate the page: 0.09010 seconds