Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Linux Error: 32: Broken Pipe

745105Jan 7 2010 — edited Jan 7 2010

I'm having an issue where the connection fails only on Red Hat 5. We have an installer that configures everything the same way for both Red Hat 4 and Red Hat 5 (configuration files). The bits are for the appropriate version of Red Hat. I'm seeing the problem on Red Hat Enterprise Linux Server release 5.3 (Tikanga). I assume it affects all versions of Red Hat 5.

I've included the listener.log below. You see that it is working fine and then the errors occur. This segment of the log below is taken during our installation of our product.

The confusing part is that after I kill the install, the listener seems to start working again. So some of the connections appear to be working, then it fails, then everything starts working again.

I'm looking for some things to try. Any suggestions would be appreciated.

Oracle versions:
------------------------------------------------------------------------------------------------------------------
Oracle RDBMS 10.2.0.4.0-16
Instantclient 11.1.0.6-0

listener.ora
------------------------------------------------------------------------------------------------------------------
LISTENER =
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=tcp)
(HOST=nc02.example.com)
(PORT=1521)
)
(ADDRESS=
(PROTOCOL=ipc)
(KEY=PNPKEY)
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=cmdb)
(ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)
)
)

LOG_DIRECTORY_LISTENER=/u01/app/oracle/product/10.2.0/db_1/network/log
LOG_FILE_LISTENER=listener.log
TRACE_DIRECTORY_LISTENER=/u01/app/oracle/product/10.2.0/db_1/network/trace
TRACE_FILE_LISTENER=listener.trc
INBOUND_CONNECT_TIMEOUT_LISTENER=120
#LOCAL_OS_AUTHENTICATION_LISTENER=OFF
SAVE_CONFIG_ON_STOP_LISTENER = ON
PASSWORDS_LISTENER = CEE9A6452943F605

tnsnames.ora
------------------------------------------------------------------------------------------------------------------
cmdb=(DESCRIPTION=
(ADDRESS=
(HOST=nc02.example.com)
(PORT=1521)
(PROTOCOL=tcp)
)
(CONNECT_DATA=
(SERVICE_NAME=cmdb.example.com)
)

listener.log
------------------------------------------------------------------------------------------------------------------

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
07-JAN-2010 06:29:12 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=nc02.example.com)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(PASSWORD=xxxxxxxx)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
07-JAN-2010 06:29:15 * service_register * cmdb * 0
07-JAN-2010 06:29:21 * service_update * cmdb * 0
07-JAN-2010 06:29:30 * service_update * cmdb * 0
07-JAN-2010 06:29:33 * service_update * cmdb * 0
07-JAN-2010 06:31:09 * service_update * cmdb * 0
WARNING: Subscription for node down event still pending
07-JAN-2010 06:31:23 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=nc02.example.com)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
07-JAN-2010 06:31:52 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=nc02.example.com)(USER=oracle))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * services * 0
07-JAN-2010 06:35:00 * service_update * cmdb * 0
07-JAN-2010 06:35:51 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
07-JAN-2010 06:36:35 * ping * 0
07-JAN-2010 06:36:35 * version * 0
07-JAN-2010 06:36:36 * service_died * cmdb * 12537
07-JAN-2010 06:36:39 * service_register * cmdb * 0
07-JAN-2010 06:36:45 * service_update * cmdb * 0
07-JAN-2010 06:36:48 * service_update * cmdb * 0
07-JAN-2010 06:37:19 * (CONNECT_DATA=(SID=cmdb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.101.34.4)(PORT=27312)) * establish * cmdb * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
07-JAN-2010 06:37:20 * (CONNECT_DATA=(SID=cmdb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.101.34.4)(PORT=27313)) * establish * cmdb * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
07-JAN-2010 06:37:47 * (CONNECT_DATA=(SID=cmdb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.101.34.4)(PORT=27317)) * establish * cmdb * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
07-JAN-2010 06:37:51 * (CONNECT_DATA=(SID=cmdb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.101.34.4)(PORT=27320)) * establish * cmdb * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
07-JAN-2010 06:37:53 * (CONNECT_DATA=(SID=cmdb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.101.34.4)(PORT=27321)) * establish * cmdb * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
07-JAN-2010 06:37:55 * (CONNECT_DATA=(SID=cmdb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.101.34.4)(PORT=27322)) * establish * cmdb * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
07-JAN-2010 06:37:56 * (CONNECT_DATA=(SID=cmdb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.101.34.4)(PORT=27324)) * establish * cmdb * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
07-JAN-2010 06:37:59 * (CONNECT_DATA=(SID=cmdb)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.101.34.4)(PORT=27326)) * establish * cmdb * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
07-JAN-2010 06:39:36 * service_update * cmdb * 0
07-JAN-2010 06:49:39 * service_update * cmdb * 0
07-JAN-2010 06:59:42 * service_update * cmdb * 0
07-JAN-2010 07:09:45 * service_update * cmdb * 0

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 4 2010

Added on Jan 7 2010

#general-database-discussions

9 comments

9,867 views