Home » RDBMS Server » Server Administration » TNS: packet checksum failure
TNS: packet checksum failure [message #494793] Thu, 17 February 2011 02:52 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
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

Re: TNS: packet checksum failure [message #494809 is a reply to message #494807] Thu, 17 February 2011 03:35 Go to previous messageGo to next message
muradjuber
Messages: 60
Registered: August 2010
Member
1- yes i set oracle_home on both client and server
2- i have windows 2003 server 64
3- oracle version 9.0.1.4.0 for both

Report message to a moderator

Re: TNS: packet checksum failure [message #494810 is a reply to message #494809] Thu, 17 February 2011 03:39 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
Quote:
dear all

i installed oracle database 10g


Quote:
3- oracle version 9.0.1.4.0 for both

Report message to a moderator

Re: TNS: packet checksum failure [message #494811 is a reply to message #494810] Thu, 17 February 2011 03:40 Go to previous messageGo to next message
muradjuber
Messages: 60
Registered: August 2010
Member
i return this version when i type

select * from v$version

Report message to a moderator

Re: TNS: packet checksum failure [message #494813 is a reply to message #494811] Thu, 17 February 2011 03:42 Go to previous messageGo to next message
cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester
Senior Member
Then you haven't installed 10g or are logging into the wrong database.

Report message to a moderator

Re: TNS: packet checksum failure [message #494814 is a reply to message #494813] Thu, 17 February 2011 03:44 Go to previous messageGo to next message
muradjuber
Messages: 60
Registered: August 2010
Member
i have only one database the 9.0.1.4.0

Report message to a moderator

Re: TNS: packet checksum failure [message #494819 is a reply to message #494793] Thu, 17 February 2011 03:52 Go to previous messageGo to next message
cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester
Senior Member
Then what does this mean:
muradjuber wrote on Thu, 17 February 2011 08:52

i installed oracle database 10g

Report message to a moderator

Re: TNS: packet checksum failure [message #494843 is a reply to message #494814] Thu, 17 February 2011 04:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Copy and paste what you do and get.


Regards
Michel

Report message to a moderator

Re: TNS: packet checksum failure [message #495873 is a reply to message #494814] Tue, 22 February 2011 23:43 Go to previous message
halim
Messages: 100
Registered: September 2008
Senior Member
hi muradjuber,

check

Is your Connection is going via a firewall ?
if yes then stop the firewall.


Regards
Halim

Report message to a moderator

Previous Topic: how to install oracle 8i and 9i databases on same server
Next Topic: Tablespace reaches threshold
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 27 13:12:16 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.