| login/connection problem [message #66594] |
Wed, 21 August 2002 10:53  |
Dave Webb
Messages: 1
Registered: August 2002
|
Junior Member |
|
|
All,
We have two HP9000's that connect to a remote Oracle database. One client works, but the other does not - we get an ORA-3113 error. The TNS ping works, and the DBA has checked the TNS file for consistency. The remote side runs 7.x, the client that works runs 8.0x and the client that does not work runs 8.1x
I asked the DBA to verify that the case matched between the ORACLE_SID entry and its corresponding env variable. I took several Sniffer traces and saw that the client that does not work, fails in a consistent manner. The two sides exchange version information, and then they send what seems to be a list of special characters, numbers, and alpha characters. This cuases the client to issue a one byte data packet consisting only of a "!" character. This seems to cause the server to issue the FIN flag in TCP ino order to close the connection. Any ideas? Where might I look to research this further? Thanks!!
DW
|
|
|
|
| Re: login/connection problem [message #66595 is a reply to message #66594] |
Wed, 21 August 2002 11:51  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
what is the exact error u encounter??
becuase we have come across similiar issues before(HP-9000- verion 11).
funniest find was, it is connecting the ORACLE_SID that is listed first in SID list.
workaround was to create connect strings with net 8 easy configuration assisten to create the connect string and tell exactly, whether the target database is 8i or of prior versions.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
