RE: Standard SQLNET.ORA with multiple O_HOME's

Hi Stephen,

        I configure all our SQLNET stuff in a directory
        called ora_net under the oracle users unix home 
        directory. I then create links from the various
        ORACLE_HOME/network directories into the /home/oracle/ora_net
        directory. Works like a charm.

        Advantages are it removes your listener logs from your
        binary disk and you have a single directory to backup
        to save all the listener configurations.

HTH
DAve

Stephen wrote:

> Greetings fellow listers,=20
>
> We are starting to make the changes to sqlnet.ora files, I discovered that =
> we have 9 separate files on one particular. Most of the file is identical =
> with the only variance appearing to be in the SQLNET.EXPIRE_TIME value =
> which ranges from 10 to 300. =20
>
> I'm thinking that we could have a single file (maybe in /etc/) and create =
> OS links from the various $ORACLE_HOME/network/admin/sqlnet.ora files. =
> Has anyone tried this or know of any reason why this wouldn't be a good =
> idea?
>
> We also have quite a number of hosts and have a standard tnsnames.ora that =
> we ftp from a master location on a nightly basis and would like to do the =
> same with a standard sqlnet.ora. Any thoughts?
>

-- 
Dave Morgan
DBA, Cybersurf
Office: 403 777 2000 ext 284
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dave Morgan
  INET: dave.morgan_at_cybersurf.net

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