Help - customizing RDBMS_ORACLE_HOME sqlnet.ora file

[DriVE_mE_cRazY]

Hi i need a help in customizing RDBMS_ORACLE_HOME sqlnet.ora file

We have a 11i applications (115102) running on top of our 10.1.0.5.0
DB.

We need to preserve the customizations of sqlnet.ora file - so that it
doesnt get regenerated while running autoconfig.

- i have referred to customizing autoconfig environment note in
metalink but im not able to get the idea how to customize it.

I looked for the template file its using by $ORACLE_HOME/appsutil/bin/
adtmplreport.sh but that too resulted in some error like it could not
process the file :(

I grep header information to see if that file is there in $ORACLE_HOME/
appsutil/template but im not able to locate the file ...

$ grep -i header sqlnet.ora => #$Header: NetServiceHandler.java 115.50
2006/07/18 14:57:50 nsugguna ship $

Please help me in customizing this file
---- CUSTOMIZATION i need to make in the sqlnet.ora file -----

tcp.validnode_checking = YES

tcp.excluded_nodes = ( node1, node1.hostname.domainname,IP addr )

---

Please help me ...

Thanks in advance.

:)

[joel garry]

I don't know anything about autoconfig, but generally, you just need
to edit it, creating it if it doesn't exist.

Try:
find $ORACLE_HOME -name sqlnet.ora

If you only see one in a sample directory, create one in $ORACLE_HOME/
network/admin and edit away. The one in the sample directory is just
lots of explanatory comments.

jg
--
@home.com
The three most common expressions (or famous last words) in aviation
are: "Why is it doing that?, Where are we?" and "Oh S...!"

[Frank van Bortel]

joel garry wrote:

>
> I don't know anything about autoconfig, but generally, you just need
> to edit it, creating it if it doesn't exist.

It is an EBS tool, that will (re-)create sqlnet.ora.
As it is adapted *after* autoconfig was run, OP wonders
how to keep these changes over autoconfig runs.
--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up

[Frank van Bortel]

DriVE_mE_cRazY wrote:
> Hi i need a help in customizing RDBMS_ORACLE_HOME sqlnet.ora file
>
> We have a 11i applications (115102) running on top of our 10.1.0.5.0
> DB.
>
> We need to preserve the customizations of sqlnet.ora file - so that it
> doesnt get regenerated while running autoconfig.
>

chmod 400 sqlnet.ora?

[epok...@excite.com]

I feel your pain, sir! Dealing with site dependent customizations on a
system that generates everything it needs is NO fun.

Check under your $ORACLE_HOME/appsutil directory. There should be a
<CONTEXT_NAME>.xml file that hopefully has a SQLNET_IFILE parameter in
it. If you do, it's probably using your $TNS_ADMIN location and using
a name like sqlnet_ifile.ora. Our <CONTEXT_NAME> is OFPR so our file
is named OFPR.xml.

Your customizations would go in the sqlnet_ifile.ora file. There's
nothing you can do about the AutoConfig process recreating the
sqlnet.ora file each time, but AutoConfig will NOT alter the
SQLNET_IFILE file. That SQLNET_IFILE parameter IS important so that
AutoConfig will generate the sqlnet.ora file with an IFILE statement
at the end of it.

In addition, only use the "editcontext" process (should be in
$COMMON_TOP/util/editcontext) to make changes to that XML file. You DO
need to run AutoConfig after "editcontext" to actually implement any
changes you made to that XML file.

Hope this at least gets you pointed in the right direction. I believe
they have "_IFILE" parameters available for the tnsnames.ora and
listener.ora files as well.

Regards,

Eugene Pokopac (Oracle DBA - GSFA - Tucker GA)