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

Hank Freeman wrote:
>
> 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
>
> $ Copyright (c) Oracle Corporation 1994. All rights reserved.
>
> $ 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
>
> Copyright (c) Oracle Corporation 1994. All rights reserved.
>
> 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
>
Try adding the following in the ADDRESS_LIST in your listener.ora ... it's adapted from what works on my AT&T That's been running various flavors since 7.1.something ...

        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= Db_SID)
        )

HTH

-- 
Steve Moreland
DBA, LanVision Inc.

Remove "no.spam" from my email
 address to reply