can't find sqlnet.log file !!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: can't find sqlnet.log file !!

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    can't find sqlnet.log file !!

    Hello all..

    I installed Oracle 9.0.1 (custom Install) on Sun 5.8. I created the seed database, and started the listener. Everything went great.

    I was able to connect to the database from the client machines...

    But i can't see sqlnet.log file on the server . I looked into $ORACLE_HOME/network/log , and its not there. I did a Find on sqlnet.log and it couldn't find one.


    How is it possible ?....What could have happened to this file ?...


    thanks
    ron

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Look in the directory where you are starting SQL*Plus.

  3. #3
    Join Date
    Oct 2002
    Posts
    284
    I did n't get by "look into directory where you start SQL*Plus "...

    this is what i normally do when i login to the Sun Machine..

    ******************************************************************
    bash-2.05$ sqlplus /nolog

    SQL*Plus: Release 9.0.1.0.0 - Production on Tue Jan 21 13:25:21 2003

    (c) Copyright 2001 Oracle Corporation. All rights reserved.

    SQL> connect / as sysdba
    Connected.
    SQL>
    ***********************************************************

    Is this what you were asming ?...Pardon me for my ignorance.

    Thanks
    Ron

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Start the listener control program (lsnrctl) and:
    Code:
    LSNRCTL> show log_directory
    LSNRCTL> show log_file
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    May 2002
    Posts
    2,645
    Originally posted by vr76413
    I did n't get by "look into directory where you start SQL*Plus "...
    bash-2.05$ ls -la
    bash-2.05$ ls -la *.log
    bash-2.05$ ls -la sql*
    etc

    If you have an error in connecting, you will get a sqlnet.log file in your current working directory.
    Last edited by stecal; 01-21-2003 at 03:26 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width