ora-12637 packet received failed

[kris123]

Hi friends,

Ora 9.2 on win2000

I'm quite confused by this error, ora-12637 in our server.
When I use the command:

c:\> sqlplus system/manager ( it can connect)

but if i use

C:\> sqlplus system/manager@ora9 (it produce ora-12637)

the above commands is issued on the server itself.

but when I issue the command on the client PC

c:\> sqlplus system/manager@ora9 (it can connect ) I use the same
tnsnames.ora on the server....

Why am i having error on the server and not on the cliemt?


Please help....and thank you all in advance

[ggnanaraj]

Do a tnsping ora9 on the server and see where it is pointing to for the parameter files. It might be pointing to a previous installation directory that does not contain ora9 in the tnsnames.ora

Rectify this and that should solve your problem.

HTH.

[ggnanaraj]

Originally posted by kris123
I'm quite confused by this error, ora-12637 in our server.

TNS-12637 Packet receive failed

Cause: A process was unable to receive a packet from another process. Possible causes include:

The other process was terminated.
The machine on which the other process is running went down.
Some other communications error occurred.
Action: If the cause is not obvious, contact Oracle Support Services.

HTH.

[kris123]

Hi friend,

I did

c:\> tnsping ora9

Used parameter files:
c:\>dbs_home\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

Why is that?....


Thanks agaim

[kris123]

Hi,

Sorry, this is the correct one

c:\> tnsping ora9

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = NTSERV1)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = ora9))) OK (50 msec)


I think no error here?....

Does server domain affect the service name like NTSERV1.DOMAIN.COM
and service name ORA9.DOMAIN.COM.

I'm really confused on what is the right way of naming service name.

[abhaysk]

In Sqlnet.ora add

NAMES.DEFAULT_DOMAIN = DOMAIN.COM

Abhay.