OraFAQ Forum: Networking and Gateways » " Tracing not turned on" SQLNET.ora

Home » RDBMS Server » Networking and Gateways » " Tracing not turned on" SQLNET.ora (11.2.0.3, x86-64, redhat release 5.8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

" Tracing not turned on" SQLNET.ora [message #618967]

Thu, 17 July 2014 00:59

sahadba
Messages: 59
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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post:

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

Report message to a moderator

Re: " Tracing not turned on" SQLNET.ora [message #618972 is a reply to message #618967]

Thu, 17 July 2014 01:11

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Quote:

what am in missing here?

TRACE_FILE_CLIENT=...

Report message to a moderator

Re: " Tracing not turned on" SQLNET.ora [message #618974 is a reply to message #618969]

Thu, 17 July 2014 01:24

sahadba
Messages: 59
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

Report message to a moderator

Re: " Tracing not turned on" SQLNET.ora [message #618977 is a reply to message #618974]

Thu, 17 July 2014 01:36

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator