sqlnet errors/core file

[Rick Bowles]

We have a K400 10.20 HP-UX with an off-the-shelf application whose client front end uses 8.0.5 sqlnet to connect to an Oracle database 7.3.4 to retrieve data. The Oracle listner log, nor the HP-UX logs show errors but the client continues to exibit network disconnects in the form of sqlnet error 12547, and 12571. The clients are also reporting ORA:1012, 3114, and 1041. Network sniffers(3)show the request from the client is completed without any errors. We have checked the entire network including firewall and can find nothing.

A core file from the K400 has been attached that reflects NT errors, but we are lost as to what they are trying to tell us. Your thoughts would be greatly appreciated.

[Walter Fernandez]

Hi Rick
It sounds like a sqlnet trouble, for a bad configuration in the client NT. Did you check the SQL net easy configuration? .. are you using ODBC, to connect to oracle?

[Rick Bowles]

Walter, we have had Oracle in to look at the server and the client. By their account the sqlnet easy config is correct. We also are not using ODBC.

Thanks for taking time to review the information. Share it with your buddies because it has Oracle, HP and the locals stumped.

[Walter Fernandez]

yes.. at first time I was thinking in bad configuration.. but them i saw the file joined. I supposed that if you was able to connect with other client, it must be a server problem. I looked a code message as if was a busy address, did you try to stop de listener?
(lsnrctl stop) .. in other case I was looking in this file, some errors such as but address or config (PORT, HOST ..errors) are you trying to connect to oracle using SQLNET V2 & RPC? ..

[Magdi KAMAL]

Hi Rick,

It looks like your tnsnames.ora file is not well configured " missing entries for host".

cd $Oracle_HOME/network/admin
more tnsnames.ora

it should include entry like the following :

InstanceID = ( DESCRIPTION =
(ADDRESS_LIST = ( ADDRESS = ( COMMUNITY = xxx)( PROTOCOL = TCP)(HOST = yyy)(PORT = 1526)))
(CONNECT_DATA = ( SID = InstanceID )(GLOBAL_NAME = InstanceID )))

While :
xxx : Community name
yyy : Host name


Magdi

[T G Manikandan]

Hello,
Check for the proper entries in the listener.ora and tnsnames.ora files in $ORACLE_HOME/network/admin directory.
Also looking at your log file do verify the
shmmax,shmseg,shmmni parameters.

Thanks
G Manikandan