Listener fails to start with TNS-12547 & Broken Pipe on SCO 5.0.4

From: Hank Freeman <hfreeman_at_lodinet.com>
Date: 1997/12/06
Message-ID: <3489AD42.D3BE4B5E@lodinet.com>

Can someone please help with a mystery? I have installed ORACLE7 Server V7.1.4.0.0 on SCO OpenServer V5.0.4 with good reults overall, but one problem that won't resolve. The problem is that SQL*Net V2 Listener will not start. The configuration files are included below. The pertinent software versions are:

 RDBMS           V7.1.4.0.0
        Network Manager V2.1.4.1.0
        SQL*Net         V2.1.4.1.0
        SQL*Net TCP/IP  V2.1.4.1.0
        SQL*Net         V1.2.7.10.1

The problem is shown here, where trying to start the listener elicits a series of errors culminating in "Broken Pipe". The full session text is included here:

$ lsnrctl start

$ LSNRCTL for AT&T System V/386: Version 2.1.4.1.0

$ Starting tnslsnr: please wait...

  $ TNS-12547: TNS:lost contact
  $  TNS-12560: TNS:protocol adapter error
  $   TNS-00517: Lost contact
  $    AT&T System V/386 Error: 32: Broken pipe

In addition, the product never seems to get "started enough" to generate any log or trace files. I am suspicous that there is a file permission/ownership rights issue causing the problem, but can't find any evidence to point to where. I also suspect that perhaps Oracle is trying to use the IPC protocol instead of TCP/IP, but also cannot determine this. Based on documentation that indicates SCO does not support IPC in some cases, I've eliminated the PROTOCOL=IPC section of the configuration, and also tried it with it left in.

I've already tried the following:
Re-link Sql*Net, including de-install/re-install of

                both SQL*Net and the TCP/IP Protocol Adapter.
 Examined OracleSupport Metalink on-line repository,
            and set STARTUP_WAIT_TIME_listener = 50
                    CONNECT_TIMEOUT_listener = 50
        Set environment variable TNS_ADMIN to point to the
            <ORACLE HOME DIR>/network/config/... directory,
            and also just move the *.ora files to /etc/*.ora
        Tried running lsnrctl as both setuid root, and not so

Not one thing I've tried has changed even one character of the output when starting the listener. I know that TCP/IP is working because I can connect via telnet, etc., and also SQL*Net V1x is working just fine. Connects from everywhere. I'm out of ideas, so any and all new ones are _most_ welcome.

These configuration files were all generated using the netmgr tool, and then edited lightly afterward, primarily for elimination of the IPC references.

################


# Filename......: tnsnames.ora

# Name..........: LOCAL_REGION.world
# Date..........: 04-DEC-97 21:48:41

################

Db_SID.DBnet =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS =
          (COMMUNITY = HQ.DBnet)
          (PROTOCOL = TCP)
          (Host = Server.DBnet)
          (Port = 1521)
        )

)
(CONNECT_DATA =

       (SID = Db_SID)
       (GLOBAL_NAME = Db_SID.DBnet)

    )
  )
LocalDb_SID.DBnet =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =
          (COMMUNITY = HQ.DBnet)
          (PROTOCOL = TCP)
          (Host = Server.DBnet)
          (Port = 1521)
        )

)
(CONNECT_DATA =

       (SID = Db_SID)
       (GLOBAL_NAME = Db_SID.DBnet)

)
)

################


# Filename......: sqlnet.ora

# Name..........: Server.DBnet
# Date..........: 04-DEC-97 21:48:41

################

AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 0
NAMES.DEFAULT_DOMAIN = DBnet
NAME.DEFAULT_ZONE = DBnet
SQLNET.CRYPTO_SEED = "<actual seed erased in post>"

################


# Filename......: listener.ora

# Name..........: Server.DBnet
# Date..........: 04-DEC-97 21:48:41

################

listener =
(ADDRESS_LIST =

        (ADDRESS =
          (COMMUNITY = HQ.DBnet)
          (PROTOCOL = TCP)
          (Host = Server.DBnet)
          (Port = 1521)
        )

)
STARTUP_WAIT_TIME_listener = 50
CONNECT_TIMEOUT_listener = 50
LOG_DIRECTORY_listener = <ORACLE HOME DIR>/network/log LOG_FILE_listener = listener.log

TRACE_LEVEL_listener = ADMIN
TRACE_DIRECTORY_listener = <ORACLE HOME DIR>/network/log
TRACE_FILE_listener = listener.trc

SID_LIST_listener =
(SID_LIST =
(SID_DESC =

      (SID_NAME = Db_SID)
      (ORACLE_HOME = <ORACLE HOME DIR>)

)
)

Installed SQL*Net V2 Protocol Adapters are:

   V2 BEQ Protocol Adapter
   V2 IPC Protocol Adapter
   V2 TCP/IP Protocol Adapter

Installed network security products are:

Installed SQL*Net Drivers are:

V1 Pipes
V1 TCP/IP
SQL*Net V2

$ lsnrctl start

LSNRCTL for AT&T System V/386: Version 2.1.4.1.0 - >

Production on 06-DEC-97 18:24:26

Starting tnslsnr: please wait...

TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
AT&T System V/386 Error: 32: Broken pipe

---------------------------------------------<END>-----

Thank you in advance for any and all suggestions. Replies by email are also welcome, if you prefer.

Email replies to hfreeman_at_lodinet.com Received on Sat Dec 06 1997 - 00:00:00 CST