Linux.com

Author Message
Joined: Apr 28, 2008
Posts: 1
Other Topics
Posted Apr 28, 2008 at 4:48:52 PM
Subject: SQLNET.ORA file

I have RMAN backups failing, I am receiving the error msg:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04004: error from recovery catalog database: ORA-12170: TNS:Connect timeout occurred
I spoke to Metalink and they stated that we should add the following parameters to our sqlnet.ora file.

Here are the parameters they wanted me to add:
SQLNET.INBOUND_CONNECT_TIMEOUT
SQLNET.SEND_TIMEOUT
SQLNET.RECV_TIMEOUT

Here is the sqlnet.ora file on my linux server:
AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 10
NAMES.DEFAULT_DOMAIN = world
NAME.DEFAULT_ZONE = world

Can someone explain why I would add those parameters and what they think they should be.
I have never used those parameters.

Thanks,
Krystal

Back to top Profile Email Website
Jim
Joined Apr 03, 2008
Posts: 10

Other Topics
Posted: May 02, 2008 7:26:15 PM
Subject: SQLNET.ORA file

Just google them:
SQLNET.INBOUND_CONNECT_TIMEOUT got me:
http://download.oracle.com/docs/cd/B19306_01/network.102/b14213/sqlnet.htm

Use the SQLNET.INBOUND_CONNECT_TIMEOUT parameter to specify the time, in seconds, for a client to connect with the database server and provide the necessary authentication information.

Back to top Profile Email Website
Tableless layout Validate XHTML 1.0 Strict Validate CSS Powered by Xaraya