OraFAQ Forum: Server Administration » TNS: packet checksum failure

Home » RDBMS Server » Server Administration » TNS: packet checksum failure

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

TNS: packet checksum failure [message #494793]

Thu, 17 February 2011 02:52

muradjuber
Messages: 60
Registered: August 2010

Member

dear all

i installed oracle database 10g

and iconnectthrowsql and it workfine but when i connect from client it give me this error

TNS: packet checksum failure

i try tnsping on the database serverit gives me the same error

Report message to a moderator

Re: TNS: packet checksum failure [message #494795 is a reply to message #494793]

Thu, 17 February 2011 02:53

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You have to give a tnsnames entry to connect from a (remote) client.

Regards
Michel

Report message to a moderator

Re: TNS: packet checksum failure [message #494797 is a reply to message #494795]

Thu, 17 February 2011 03:02

muradjuber
Messages: 60
Registered: August 2010

Member

what do u mean i dont understand

Report message to a moderator

Re: TNS: packet checksum failure [message #494798 is a reply to message #494797]

Thu, 17 February 2011 03:03

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

connect user/psw@tnsnames.entry

Regards
Michel

Report message to a moderator

Re: TNS: packet checksum failure [message #494799 is a reply to message #494798]

Thu, 17 February 2011 03:04

muradjuber
Messages: 60
Registered: August 2010

Member

i connect but it give me the same error

Report message to a moderator

Re: TNS: packet checksum failure [message #494801 is a reply to message #494799]

Thu, 17 February 2011 03:07

knight
Messages: 111
Registered: January 2009

Senior Member

muradjuber wrote on Thu, 17 February 2011 03:04

i connect but it give me the same error

Quote:

i try tnsping on the database serverit gives me the same error

can you post it here

Report message to a moderator

Re: TNS: packet checksum failure [message #494802 is a reply to message #494801]

Thu, 17 February 2011 03:13

muradjuber
Messages: 60
Registered: August 2010

Member

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = testsrv.
takaful.local)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME
= TPICTEST)))
TNS-12569: TNS:Packet checksum failure

Report message to a moderator

Re: TNS: packet checksum failure [message #494804 is a reply to message #494802]

Thu, 17 February 2011 03:30

knight
Messages: 111
Registered: January 2009

Senior Member

do you have any info in listener log

you can enable tracing and check.

Report message to a moderator

Re: TNS: packet checksum failure [message #494805 is a reply to message #494804]

Thu, 17 February 2011 03:31

muradjuber
Messages: 60
Registered: August 2010

Member

i dont have any errors on listener.log

what u mean by enable trace

Report message to a moderator

Re: TNS: packet checksum failure [message #494807 is a reply to message #494802]

Thu, 17 February 2011 03:33

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Did you set ORACLE_HOME?
What is your OS?
What is the Oracle version (4 decimals) for both server and client?

Copy and paste what you do and get.

Regards
Michel

Report message to a moderator