Re: sqlnet.log

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 30 Jun 1999 19:02:32 +0200
Message-ID: <930762097.28396.0.pluto.d4ee154e@news.demon.nl>

Hi Kenneth,
Sqlnet.ora is mandatory, both on the server and on any client. Of course you could have one set of configuration files on a network drive.

Minimal sqlnet.ora for a client
automatic_ipc = off -- should be on for the server

trace_level_client = off -- should be 16 for debugging purposes
trace_unique_client = true -- one file per session
trace_directory_client = $ORACLE_HOME/network/trace
names.directory_path = (tnsnames, onames)
names.default_domain = world

names.default_zone = world
sqlnet.expire_time = 10 (if you want dead connection detection)

sqlnet.ora is read every time a client connects!! The sequence for finding sqlnet.ora (and other files) is
the current directory
the directory pointed to by TNS_ADMIN
the /etc directory (/var/opt/oracle for Solaris) $ORACLE_HOME/network/admin

Do you already need more detail ....

Hth,

Sybrand Bakker, Oracle DBA

Kenneth C Stahl <BluesSax_at_Unforgettable.com> wrote in message news:377A2081.BF403FE0_at_Unforgettable.com...
> In the absence of a sqlnet.ora file in $ORACLE_HOME/network/admin, how
> does oracle determine where to put the log file? For some reason the
> sqlnet.log files seem to crop up in a variety of places on my system and
> so far I haven't seen a real pattern.
>
> Also, when does sqlnet.ora get read? When oracle starts? When the
> listener starts? When the system reboots? Is there any way of
> controlling the level of information sent to sqlnet.log in a manner
> similar to the say that the level of data to listener.log can be
> controlled?
>
> I've seen some references in the past to a .sqlnet.ora (note the '.' at
> the beginning of the name - it is a hidden file) that is to be placed in
> the home directory of a unix user account. Does anyone know anything
> about this? Supposedly it overrides the system level sqlnet.ora.
>
> The reasons I ask all of this is because one of the systems I work with
> seems to have a habit of placing sqlnet.log in the root directory. The
> root file system on this box is already pretty full and I just don't
> need to have log files being created there. However, I'm also interested
> in learning whatever else anyone knows about all of the things I
> mentioned.
>
> Ken
>
> My os: Unixware 2.1.2
> My rdbms: Oracle V7.3
>
>
>
Received on Wed Jun 30 1999 - 12:02:32 CDT