Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL net help please
I don't think you can reference environment variables in your sqlnet.ora
file. Try replacing the $ORACLE_HOME with a question mark "?".
> -----Original Message-----
> From: Gopal, Umesh [SMTP:ugopal_at_proxicom.com]
> Sent: Monday, June 19, 2000 9:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL net help please
>
> Hi ,
>
> I am trying to test the trace and log file of the tnsnames.ora file on an
> oracle 8 client on a sun solaris box ,
> however I cannot get the client to write to the log or trc files, can
> anyone
> suggest what I can do to make it work
>
> my tnsnames.ora is as follows :
>
>
> DEV01 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = clove))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = dev01)
> )
> )
>
> my sqlnet.ora is as follows :
>
> trace_level_client = 16
> trace_directory_client = $ORACLE_HOME/network/trace
> trace_file_client = $ORACLE_HOME/network/trace/cli.trc
> trace_unique_client = on
> log_directory_client = $ORACLE_HOME/network/log
> log_file_client = $ORACLE_HOME/network/log/sqlnet.log
>
> Any help appreciated .
>
> Thanks
> Umesh
> --
> Author: Gopal, Umesh
> INET: ugopal_at_proxicom.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jun 20 2000 - 09:12:43 CDT