Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating sqlnet.ora file

raulk89Feb 22 2017 — edited Feb 23 2017

Hi

Oracle db 11.2, RAC

When creating sqlnet.ora file into $ORACLE_HOME/network/admin directory, what is needed to make use of these settings..?

Do I need to restart the database instance..?

Or only listener should be restarted..?

And am I right, that sqlnet.ora settings are inherited to all the database instances that are running from that specific $ORACLE_HOME..? If so, is it possible to inherit these settings to only one database..?

Also, I read from here (https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=356860873264164&parent=DOCUMENT&sourceId=1538717.1&id=11… ), that:

"For that reason, we often recommend increasing the values for INBOUND_CONNECT_TIMEOUT at both listener and server side sqlnet.ora file as a preventive measure.  If the problem  is due to connection timeouts, an increase in the following parameters should eliminate or reduce the occurrence of the ORA-609s."

So listener.ora file, that should be modded, is present in $GRID_HOME/network/admin directory..?

Kind regards

Raul

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2017
Added on Feb 22 2017
6 comments
1,186 views