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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).