Re: sqlnet.log

Kenneth C Stahl <BluesSax_at_Unforgettable.com> writes:

> 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.
The sqlnet.log is put into the current directory unless specified otherwise.

>
> 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?

Sqlnet.ora is read when the process starts. So, when the database starts, it reads sqlnet.ora. When a client program connects, it reads it.

>
> 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.
It used to be supported, but I'm not sure that it is now.

>
> 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.

Placing sqlnet.log in the root directory is a bad idea, IMO, since some Unix systems will crash if / gets full.

For the server, I would place it under $ORACLE_HOME. For client programs, I would allow it to be created in the current directory as it can contain valuable debugging information.

                                        Rick
                                        Rick Wessman
                                        Security and Directory Technologies
                                        Server Technologies
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com