OraFAQ Forum: Windows

Home » Infrastructure » Windows » ORA-12637 (Ora 9.2.0.1.0 Windows 2003 Srv)

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

ORA-12637 [message #430463]

Tue, 10 November 2009 08:29

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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?

Report message to a moderator

Re: ORA-12637 [message #430477 is a reply to message #430473]

Tue, 10 November 2009 10:07

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

Report message to a moderator

Re: ORA-12637 [message #430478 is a reply to message #430477]

Tue, 10 November 2009 10:12

ThomasG
Messages: 3211
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.

Report message to a moderator

Re: ORA-12637 [message #430481 is a reply to message #430478]

Tue, 10 November 2009 10:45

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

Report message to a moderator

Re: ORA-12637 [message #430507 is a reply to message #430481]

Tue, 10 November 2009 14:30

ThomasG
Messages: 3211
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

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

Report message to a moderator

Re: ORA-12637 [message #430638 is a reply to message #430525]

Wed, 11 November 2009 05:51

ThomasG
Messages: 3211
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.

Report message to a moderator

Re: ORA-12637 [message #430668 is a reply to message #430638]

Wed, 11 November 2009 10:08

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

Report message to a moderator

Re: ORA-12637 [message #430671 is a reply to message #430668]

Wed, 11 November 2009 10:44

ThomasG
Messages: 3211
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.

Report message to a moderator

Previous Topic:	batch file windows environment
Next Topic:	How to disable oracle automatic STARTUP in Windows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 17:37:53 CDT 2024