3 Replies Latest reply: Oct 1, 2009 12:20 PM by vejpuste RSS

    Instant client don't work trace

    vejpuste
      Hello,
      I try set TRACE in server with Instant client. It's working on another servers and on one no.
      Server CentOS release 5.3, kernel 2.6.18-164.el5 x86_64.
      Instant client from RPM : oracle-instantclient11.1-devel-11.1.0.7.0-1, oracle-instantclient11.1-sqlplus-11.1.0.7.0-1, oracle-instantclient11.1-basic-11.1.0.7.0-1 all x86_64.
      I set export TNS_ADMIN=/etc In /etc are sqlnet.ora and tnsnames.ora
      ::::::::::::::
      /etc/sqlnet.ora
      ::::::::::::::
      NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

      TRACE_LEVEL_CLIENT=16
      TRACE_DIRECTORY_CLIENT=/tmp/trace
      TRACE_FILE_CLIENT=client
      TRACE_UNIQUE_CLIENT=ON
      TRACE_TIMESTAMP_CLIENT=ON

      ls -al /tmp
      drwxrwxrwx 2 apache apache 4096 Sep 29 12:20 trace

      sqlplus -l user@SID
      connect but trace file not created.

      Instant client 11.2 for x86_64 is not available.
      I don't know where problem is.
      Thanks
      Libor