sqlnet.ora missing repercussions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: sqlnet.ora missing repercussions

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586

    Exclamation

    Question. I found a prod box missin sqlnet.ora. What can be the repurcussions of that?
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,015
    Apparently none. SQLNET.ORA tells Oracle how to find the databases when it tries to connect. As with most things in Oracle if you don't specify a value it will default to something. It is probably defaulting to
    NAMES.DIRECTORY_PATH= (TNSNAMES)
    Unless you want to make a change I wouldn't do anything to it. Because it probably works.




  3. #3
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Hi..I get these errrors..in the sqlnet.log


    ***********************************************************************
    Fatal NI connect error 12505, connecting to:
    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=COMTCP)(PROTOCOL=TCP)(HOST=chihp
    dv2)(PORT=1521)))(CONNECT_DATA=(SID=infd)(CID=(PROGRAM=)(HOST=chihpns2)(USER=ora
    cle))))

    VERSION INFORMATION:
    TNS for HPUX: Version 8.0.5.0.0 - Production
    Oracle Bequeath NT Protocol Adapter for HPUX: Version 8.0.5.0.0 - Produc
    tion
    TCP/IP NT Protocol Adapter for HPUX: Version 8.0.5.0.0 - Production
    Time: 11-DEC-01 06:02:25
    Tracing not turned on.
    ~ Tnnt OS err code: 0code: 0n refusedsed from an application
    "High Salaries = Happiness = Project Success."

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,015
    I'm no expert on HPUX. But if this ever worked then you should find out what was changed and if neccessary pull back you listener file from tape. Check the TNSNAMES.ORA, SQLNET.ORA and LISTENER.ORA. and make sure that everything is ok. You might want to compare the entries to another HPUX box.
    Bounce the listener, then if neccessary the box. Also make sure that the user running the database has rights to all of its files. i.e. $ORACLE_HOME/oradata/sid and $ORACLE_HOME/network/admin.

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