Home » RDBMS Server » Enterprise Manager » How can I find current values of client SQLNET.ORA? (Oracle client 10.2.0.1)
How can I find current values of client SQLNET.ORA? [message #380751] Tue, 13 January 2009 04:02 Go to next message
dba4bank
Messages: 49
Registered: October 2007
Location: TURKEY
Member
Hi All,

I didn't add any parameter in SQLNET.ORA so How can I find current values of client SQLNET.ORA?

For example

SQLNET.INBOUND_CONNECT_TIMEOUT,
SQLNET.SEND_TIMEOUT,
SQLNET.RECV_TIMEOUT

[Updated on: Tue, 13 January 2009 04:02]

Report message to a moderator

Re: How can I find current values of client SQLNET.ORA? [message #380754 is a reply to message #380751] Tue, 13 January 2009 04:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In sqlnet.ora file.

Regards
Michel
Re: How can I find current values of client SQLNET.ORA? [message #380759 is a reply to message #380751] Tue, 13 January 2009 04:15 Go to previous messageGo to next message
dba4bank
Messages: 49
Registered: October 2007
Location: TURKEY
Member

Thank you for your quick responce.

There is no parameter on the SQLNET.ORA file.
I mean What is the current values of client side?

Best Regards
Re: How can I find current values of client SQLNET.ORA? [message #380762 is a reply to message #380759] Tue, 13 January 2009 04:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If there is no value then tahy are the default values.
There is no way to know them unless you activate a sqlnet trace.

Regards
Michel
Re: How can I find current values of client SQLNET.ORA? [message #380787 is a reply to message #380762] Tue, 13 January 2009 06:05 Go to previous messageGo to next message
dba4bank
Messages: 49
Registered: October 2007
Location: TURKEY
Member
I have been searched all documentation.There is no default value on following parameter.As you say I have to activate sqltrace to get it.

Thx for your help..

Gökhan Dedeler.
Oracle DBA
Re: How can I find current values of client SQLNET.ORA? [message #380792 is a reply to message #380787] Tue, 13 January 2009 06:34 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello,

Actually what's your problem? You want to know SQLNET.ORA default value's OR You want to enable SQLTRACE from SQLNET.ORA??

Babu

[Updated on: Tue, 13 January 2009 06:40]

Report message to a moderator

Re: How can I find current values of client SQLNET.ORA? [message #380793 is a reply to message #380792] Tue, 13 January 2009 06:52 Go to previous messageGo to next message
dba4bank
Messages: 49
Registered: October 2007
Location: TURKEY
Member
Actually I have a problem with Rman backup. Somedays if Backup unit is too busy .it couldn't completed.it is interrupting by following error.
I think that the problem related with sqlnet.ora (timeout)parameters.So I want to know SQLNET.ORA default value's

OS =AIX 5.3
DB VERSION=10.2.0.3.0
DB SIZE=350 GB



RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: ORA-03135: connection lost contact
ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLE

/*
SQLNET.INBOUND_CONNECT_TIMEOUT,
SQLNET.SEND_TIMEOUT,
SQLNET.RECV_TIMEOUT
*/

Gokhan Dedeler
Oracle DBA
Re: How can I find current values of client SQLNET.ORA? [message #380795 is a reply to message #380793] Tue, 13 January 2009 06:59 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

http://download.oracle.com/docs/cd/B19306_01/network.102/b14213/sqlnet.htm#sthref539

Yes. Instead of removing try to increase values Or Why your using this two parameter??

SQLNET.SEND_TIMEOUT, 
SQLNET.RECV_TIMEOUT 


(Please test in your development instance. )


Babu

[Updated on: Tue, 13 January 2009 07:01]

Report message to a moderator

Re: How can I find current values of client SQLNET.ORA? [message #380971 is a reply to message #380795] Wed, 14 January 2009 08:14 Go to previous messageGo to next message
dba4bank
Messages: 49
Registered: October 2007
Location: TURKEY
Member
Hi,

I tried verify problem a sqlplus session.And I didnt do nothing a few hours.

user profile values are unlimited.
If I find out what is the reason of connection lost contact.I believe I will figure out backup problem.


SQL> conn xxx/xxxxxx@RMAN
Connected.
SQL> select sysdate from dual;
select sysdate from dual
*
ERROR at line 1:
ORA-03135: connection lost contact
Re: How can I find current values of client SQLNET.ORA? [message #381040 is a reply to message #380971] Wed, 14 January 2009 23:35 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
ORA-03135: connection lost contact
Cause: 1) Server unexpectedly terminated or was forced to terminate. 2) Server timed out the connection.
Action: 1) Check if the server session was terminated. 2) Check if the timeout parameters are set properly in sqlnet.ora.

[Updated on: Thu, 15 January 2009 00:34] by Moderator

Report message to a moderator

Re: How can I find current values of client SQLNET.ORA? [message #381066 is a reply to message #381040] Thu, 15 January 2009 02:33 Go to previous messageGo to next message
dba4bank
Messages: 49
Registered: October 2007
Location: TURKEY
Member
Hi

1) server was running during the connection. There is no error on the alert.log

2.)

here is client side sqlnet.ora

# sqlnet.ora Network Configuration File: /oracle/ora102/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES)


here is server side sqlnet.ora

sqlnet.ora Network Configuration File: /u01/in/rman/oracle/db/10.2.0/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES)

[Updated on: Thu, 15 January 2009 02:33]

Report message to a moderator

Re: How can I find current values of client SQLNET.ORA? [message #381088 is a reply to message #381066] Thu, 15 January 2009 03:38 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
Hi All,

I didn't add any parameter in SQLNET.ORA so How can I find current values of client SQLNET.ORA?

For example

SQLNET.INBOUND_CONNECT_TIMEOUT,
SQLNET.SEND_TIMEOUT,
SQLNET.RECV_TIMEOUT
[Updated on: Tue, 13 January 2009 15:32]


Quote:
here is server side sqlnet.ora

sqlnet.ora Network Configuration File: /u01/in/rman/oracle/db/10.2.0/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES)


Hello;

There are two different details, actually what's your exact problem?

Are you sure; your SQLNET.ORA details?? If yes; Please post your ORACLE_HOME & TNS_ADMIN details (from your env)

Babu

Re: How can I find current values of client SQLNET.ORA? [message #381131 is a reply to message #381088] Thu, 15 January 2009 06:26 Go to previous messageGo to next message
dba4bank
Messages: 49
Registered: October 2007
Location: TURKEY
Member
Hi,

The problem;
As I mentioned before when I connected with sqlplus from client side.

SQL> conn xxx/xxxxxx@RMAN
Connected.
##AFTER 2 HOURS####
SQL> select sysdate from dual;
select sysdate from dual
*
ERROR at line 1:
ORA-03135: connection lost contact

During the connecting NO Server unexpectedly terminated or NO forced to terminate.
What is the reason of this issue?


On the client side
TNS_ADMIN=/oracle/ora102/network/admin
ORACLE_HOME=/oracle/ora102

Thank you for your interested
Re: How can I find current values of client SQLNET.ORA? [message #381134 is a reply to message #381131] Thu, 15 January 2009 06:38 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


From Client/Server;

1/ Post env. details (for ORACLE_HOME & TNS_ADMIN )

2/ Post SQLNET.ORA Content (Just copy & paste here; from client/server)

3/ Is there any other instance running on your server??

Babu
Re: How can I find current values of client SQLNET.ORA? [message #381139 is a reply to message #381134] Thu, 15 January 2009 06:59 Go to previous messageGo to next message
dba4bank
Messages: 49
Registered: October 2007
Location: TURKEY
Member
Hi,

I have just copy and paste sqlnet.ora
There is no other instance on the server


On the client side
TNS_ADMIN=/oracle/ora102/network/admin
ORACLE_HOME=/oracle/ora102

# sqlnet.ora Network Configuration File: /oracle/ora102/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES)




On the server side
TNS_ADMIN=/u01/in/rman/oracle/db/10.2.0/network/admin
ORACLE_HOME=/u01/in/rman/oracle/db/10.2.0

sqlnet.ora Network Configuration File: /u01/in/rman/oracle/db/10.2.0/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES)
Re: How can I find current values of client SQLNET.ORA? [message #381297 is a reply to message #381139] Fri, 16 January 2009 03:37 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Requesting to you; Try this Document 465572.1

Also; I guess; Try to upgrade your client version to 10.2.0.3

Babu


[Updated on: Fri, 16 January 2009 03:43]

Report message to a moderator

Re: How can I find current values of client SQLNET.ORA? [message #387123 is a reply to message #380787] Wed, 18 February 2009 00:17 Go to previous messageGo to next message
Khan_4u
Messages: 5
Registered: February 2009
Location: UK
Junior Member
Ora-12638 not able me to connect SQL*PLUS so wht I hv to do

[Updated on: Wed, 18 February 2009 00:25]

Report message to a moderator

Re: How can I find current values of client SQLNET.ORA? [message #387131 is a reply to message #387123] Wed, 18 February 2009 00:31 Go to previous message
dba4bank
Messages: 49
Registered: October 2007
Location: TURKEY
Member
Hi

You should verify the Active Directory users .There should not be same name as the database server or client hostname.
if yes delete or rename it.

Gökhan Dedeler
DBA
Previous Topic: Cannot start OracleDBConsoleorcl
Next Topic: Unable to start dbconsole
Goto Forum:
  


Current Time: Thu Mar 28 15:36:15 CDT 2024