| URGENT - Fatal NI Connection [message #58685] |
Thu, 25 September 2003 14:23  |
Chris
Messages: 128
Registered: November 1998
|
Senior Member |
|
|
Hi !
We are running through a strange and weird error running our client application. I will show you our sqlnet.log and give you detailed information about our environment.
sqlnet.log
==========
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:CrmWafaber.exe)(HOST=SERV-IFV)(USER=Administrator))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.5.0.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.5.0.0 - Production
Time: 01-SEP-03 23:24:09
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS: protocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 0
nt OS err code: 0
***********************************************************************
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:CrmWafaber.exe)(HOST=SERV-IFV)(USER=Administrator))))
and goes on and on...
Database Version: Oracle 8.1.5 EE for Windows
OS Version: Windows 2000 on a PC
Application technology: Visual FoxPro
Connection type: ODBC using Oracle 8.1.5 driver
The client software (PROGRAM=D:CrmWafaber.exe) is connecting fine in the server, and as long as I keep using it it is ok. Is only after a few minutes of inactivity that it apparently disconnects.
As you can see, the connection arguments are indicating HOST=SERV-IFV (which is MY client machine - the SERV_DB is the real DB server!!!) and USER=Administrator (this is the user I am logged) when this problem occurs.
There isnt a database on SERV-IFV (thats my client machine), neither is there any mention of it in the tnsnames.ora. TNSNAMES.ORA points to SERV_DB. I don't know where it is getting this stuff from, but its not tnsnames.ora.
I need to find out why:
========================
1. The client disconnects from the server if the application is inactive for a couple of time
2. When the client tries to re-connect on the database why it uses wrong parameters for HOST and USER.
We created a new system variable called TNS_ADMIN and set TNS_ADMIN=X:*oracle_location*networkadmin to be sure the right tnsnames.ora is being used.
We are analyzing the firewall to realize if the firewall is terminating the connections or not.
Please, do you have any other suggestions? Where I can find more information about this error?
I tried ALL Oracle searches but could not find anything. I tried Google but did not find any solution for this problem.
Please, is urgent.
Many thanks,
Chris
|
|
|
|
| Re: URGENT - Fatal NI Connection [message #58687 is a reply to message #58685] |
Thu, 25 September 2003 14:57  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Looks like you have set ORACLE_SID on your client environment and thus it is trying to connect using BEQ protocol locally to the database instance ORCL. Remove ORACLE_SID from your registry . Also set
automatic_ipc=off in your sqlnet.ora .
The above behaviour is not fatal,but only delays the connection to the remote database as it tries locally first.
For the client disconnects after inactive time,check if you have assigned any profiles with IDLE_TIME to your database user.Also check for any timeouts specified anywhere( application server,network etc)..
-Thiru
|
|
|
|
| Re: URGENT - Fatal NI Connection [message #58703 is a reply to message #58687] |
Fri, 26 September 2003 06:53 |
Christiano
Messages: 2
Registered: September 2003
|
Junior Member |
|
|
Dear Thiru,
Thank you very much for your contribution, I will follow your recommendations and give you a feed back later.
The strange is this problem happens intermittenly, sometime it will occur after a month, a week or a day - and it also happens in different timing.
Best Regards,
Chris
|
|
|
|
| Re: URGENT - Fatal NI Connection [message #58763 is a reply to message #58685] |
Mon, 29 September 2003 12:51 |
Christiano
Messages: 2
Registered: September 2003
|
Junior Member |
|
|
Hi Thiru and people,
1- The client machine does not have a ORACLE_SID entry in its registry;
2- automatic_ipc=off - The sqlnet.ora did not have this line defined. But its default value was the same you suggested = OFF
3- Every user and profile does not have IDLE_TIME defined. So, the default value is UNLIMITED.
4- The machines does not operate under any firewall.
The error, continues happening. PLEASE, ANY SUGGESTIONS IT IS REALLY URGENT!!!
Thank very much for any reply!
Christiano
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
