ora-12637 packet received failed

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

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.

Quote:

---

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

---

Quote:

---

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.

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

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.

In Sqlnet.ora add

NAMES.DEFAULT_DOMAIN = DOMAIN.COM

Abhay.