topic Re: sqlnet errors/core file in Operating System - HP-UX

sqlnet errors/core file

Rick Bowles — Fri, 24 Aug 2001 12:58:15 GMT

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.

Re: sqlnet errors/core file

Walter Fernandez — Mon, 27 Aug 2001 14:12:40 GMT

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?

Re: sqlnet errors/core file

Rick Bowles — Mon, 27 Aug 2001 16:25:32 GMT

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.

Re: sqlnet errors/core file

Walter Fernandez — Mon, 27 Aug 2001 20:48:50 GMT

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? ..

Re: sqlnet errors/core file

Magdi KAMAL — Wed, 29 Aug 2001 15:19:42 GMT

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

Re: sqlnet errors/core file

T G Manikandan — Sat, 01 Sep 2001 15:58:21 GMT

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