OraFAQ Forum: Enterprise Manager » How can I find current values of client SQLNET.ORA?

Home » RDBMS Server » Enterprise Manager » How can I find current values of client SQLNET.ORA? (Oracle client 10.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can I find current values of client SQLNET.ORA? [message #380751]

Tue, 13 January 2009 04:02

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In sqlnet.ora file.

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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

Report message to a moderator

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

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

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

Report message to a moderator

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

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

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

Report message to a moderator

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

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

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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)

Report message to a moderator

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

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

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

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

Report message to a moderator

Previous Topic:	Cannot start OracleDBConsoleorcl
Next Topic:	Unable to start dbconsole

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 17:37:39 CST 2024