Home » Infrastructure » Windows » ORA-12637 (Ora 9.2.0.1.0 Windows 2003 Srv)
ORA-12637 [message #430463] Tue, 10 November 2009 08:29 Go to next message
kidlark
Messages: 5
Registered: November 2009
Location: Germany
Junior Member
Hello Group,

we have several Oracle DB Instances running on this W2k3 Server.

When I try to log in one of these instances, our test-Database rrpt2, I get

ora-16237 PACKET RECEIVE FAILED (or something similiar in German).

sqlnet.log:
Quote:


***********************************************************************
Fatal NI connect error 12637, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rrdb01)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=rrpt2.rrdb01.rroffice)(CID=(PROGRAM=E:\oracl e\ora92\bin\IMP.EXE)(HOST=RRDB01)(USER=administrator))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Time: 10-NOV-2009 14:45:58
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12637
TNS-12637: Datenpaket nicht erhalten
ns secondary err code: 12537
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0



"TNSPING rrpt2" works fine.

Quote:
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 10-NOV-2009 15:25:31

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Parameterdateien benutzt:
E:\oracle\ora92\network\admin\sqlnet.ora


Adapter TNSNAMES zur Auflösung des Alias benutzt
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = rrdb01)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = rrpt2.rrdb01.rroffice)))
OK (10 ms)




I can connect to the other databases on the server.

How can this be solved?

Best Regards
Georg

[Updated on: Tue, 10 November 2009 08:32]

Report message to a moderator

Re: ORA-12637 [message #430473 is a reply to message #430463] Tue, 10 November 2009 09:40 Go to previous messageGo to next message
BlackSwan
Messages: 22839
Registered: January 2009
Senior Member
12637, 00000, "Packet receive failed"
// *Cause:  A process was unable to receive a packet from another process.
//          Possible causes are:
//          1. The other process was terminated.
//          2. The machine on which the other process is running went down.
//          3. Some other communications error occurred.
// *Action: If the cause is not obvious, contact Oracle Customer Support.
bcm@bcm-laptop:~$ oerr tns 12537
12537, 00000, "TNS:connection closed"
// *Cause: "End of file" condition has been reached; partner has disconnected.
// *Action: None needed; this is an information message.


Is any type of virtualization involved here?
Re: ORA-12637 [message #430477 is a reply to message #430473] Tue, 10 November 2009 10:07 Go to previous messageGo to next message
kidlark
Messages: 5
Registered: November 2009
Location: Germany
Junior Member
Hi BlackSwan,

there is no virtualization involved.

The rrpt2-instance used to work!

Greets
Georg
Re: ORA-12637 [message #430478 is a reply to message #430477] Tue, 10 November 2009 10:12 Go to previous messageGo to next message
ThomasG
Messages: 3100
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
What has changed since it worked?

Have a look for additional information in the listener.log file on the server, if any error is showing up there.
Re: ORA-12637 [message #430481 is a reply to message #430478] Tue, 10 November 2009 10:45 Go to previous messageGo to next message
kidlark
Messages: 5
Registered: November 2009
Location: Germany
Junior Member
Hi ThomasG,

as far as I'm concerned, nothing has been changed, or nothing I'm aware of being important.

The listener log doesn't report much. I searched the log for the database in question and found these entries (there are more of course, but they all look the same to me).

Quote:

10-NOV-2009 13:45:52 * (CONNECT_DATA=(SERVICE_NAME=rrpt2.rrdb01.rroffice)(CID=(PROGRAM=C:\Programme\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=RRDB01)(USER=adminis trator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.6)(PORT=2365)) * establish * rrpt2.rrdb01.rroffice * 0
10-NOV-2009 13:51:59 * (CONNECT_DATA=(SERVICE_NAME=rrpt2.rrdb01.rroffice)(CID=(PROGRAM=C:\Programme\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=RRDB01)(USER=adminis trator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.6)(PORT=2384)) * establish * rrpt2.rrdb01.rroffice * 0
10-NOV-2009 13:52:02 * service_update * rrpt2 * 0
10-NOV-2009 13:52:10 * (CONNECT_DATA=(SERVICE_NAME=rrpt2.rrdb01.rroffice)(CID=(PROGRAM=C:\Programme\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=RRDB01)(USER=adminis trator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.6)(PORT=2385)) * establish * rrpt2.rrdb01.rroffice * 0
10-NOV-2009 13:52:13 * (CONNECT_DATA=(SERVICE_NAME=rrpt2.rrdb01.rroffice)(CID=(PROGRAM=C:\Programme\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=RRDB01)(USER=adminis trator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.6)(PORT=2388)) * establish * rrpt2.rrdb01.rroffice * 0
10-NOV-2009 15:25:54 * service_update * rrpt2 * 0


If needed, I can upload a part of the listener.log.

Greets

Georg
Re: ORA-12637 [message #430507 is a reply to message #430481] Tue, 10 November 2009 14:30 Go to previous messageGo to next message
ThomasG
Messages: 3100
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well. none of those connects are from "imp.exe".

So either you are not connecting to the listener/database you are think you are connecting to, or there is a network problem that completely prevents the connection.

Maybe try the standard Windows troubleshooting step "Reboot everything"?

[Updated on: Tue, 10 November 2009 14:31]

Report message to a moderator

Re: ORA-12637 [message #430525 is a reply to message #430507] Tue, 10 November 2009 17:53 Go to previous messageGo to next message
kidlark
Messages: 5
Registered: November 2009
Location: Germany
Junior Member
Hi ThomasG,

the logs wich I posted, are from the oracle managent server-tool.

I tried to connect with "imp system@rrpt2" to the database and got the same error.

I'll try to reboot the server, but are there other ideas?

Greets

Georg
Re: ORA-12637 [message #430638 is a reply to message #430525] Wed, 11 November 2009 05:51 Go to previous messageGo to next message
ThomasG
Messages: 3100
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Not really. There is something wrong on the network level.

You could try experimenting from different machines / client version and to different servers / databases to pin down where the problem is.

Or have a look at the network traffic with wireshark.



Re: ORA-12637 [message #430668 is a reply to message #430638] Wed, 11 November 2009 10:08 Go to previous messageGo to next message
kidlark
Messages: 5
Registered: November 2009
Location: Germany
Junior Member
Hi ThomasG,

I try to connect to the server not from a client, the enterprise manager is started directly on the DB server.

I would throw away the test instance, if i could...

Greets

Georg
Re: ORA-12637 [message #430671 is a reply to message #430668] Wed, 11 November 2009 10:44 Go to previous message
ThomasG
Messages: 3100
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Enterprise Manager is definitely too "High Level" for real troubleshooting.

Try to get the connection working with SQL*Plus first.

This isn't the 64bit Version of Windows by any chance? There were some similar problems in the earlier versions of 9.2. that were fixed in the 9.2.0.7 patch set.
Previous Topic: batch file windows environment
Next Topic: How to disable oracle automatic STARTUP in Windows
Goto Forum:
  


Current Time: Tue Sep 30 15:17:55 CDT 2014

Total time taken to generate the page: 0.26076 seconds