HPUX error 232 Connection reset by peer

[T G Manikandan]

Yes you are right.

There is some problem with resolving the service name using the names services on Oracle.

First we need to narrow down this problem.
We are trying to modify the file only to bring down the problem and understand it.

What you can do is

Take a copy of your sqlnet.ora and listener.ora files

Just modify as

sqlnet.ora
-------------


SQLNET.AUTHENTICATION_SERVICES= (BEQ,NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES)

listener.ora
-----------------
LISTENER =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= TCP)(Host= ta367_1)(Port= 1521))
(ADDRESS= (PROTOCOL= IPC)(KEY= ta367_1))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME= TPEDB01)
(ORACLE_HOME= /oracle/app/product/8.0.6)
(SID_NAME = TPEDB01)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 20
TRACE_LEVEL_LISTENER = ON


//
Increase the timeout value.
taken off the domain entries so that the lookup is local//

Another is to
turned on the listener trace which should log into $ORACLE_HOME/network/listener.log file.
You can find the problems from the log file


Try this and revert


Thanks

[Paul Thomson_2]

ta367_1:/ # hostname
ta367_1
ta367_1:/ # ping ta367_1 -n 3
PING ta367_1: 64 byte packets
64 bytes from 164.39.197.40: icmp_seq=0. time=0. ms
64 bytes from 164.39.197.40: icmp_seq=1. time=0. ms
64 bytes from 164.39.197.40: icmp_seq=2. time=0. ms

----ta367_1 PING Statistics----
3 packets transmitted, 3 packets received, 0% packet loss
round-trip (ms) min/avg/max = 0/0/0

The server is /etc/hosts
164.39.197.40 ta367_1 ta367_1.tnteww.com


Also, the contents of nsswtich.conf

hosts: files [NOTFOUND=continue] dns

nslookup ta367_1 shows
ta367_1:/ # nslookup ta367_1
Server: ta367_1.ta.tnt.com
Address: 164.39.197.40

Name: ta367_1.ta.tnt

[Paul Thomson_2]

Hi all,

Thanks for your posts.

I have set up lsof to monitor the port 1521 to see if anything else is using the port when the listener starts, I am also going to reboot the server when time allows to try and clear the odd entry in the routing tables. A route delete does not work. As for the sqlnet.ora and listener.ora files I may wait to amend these as they have worked for a year so I do not think they are the cause. However, I have made note of the suggestions for changing them and will consider this if the issue re occurs. Also the listener has restarted 3 times this week OK, which mays me think something may have hogged port 1521 when the problem occured.

Many thanks so far for posts.

Paul