Listener Startup Problem - Oracle 7.3.2.2 on Unixware 2.1

From: Jonathan Joseph <jon.joseph_at_jbjnet.com>
Date: 1997/09/22
Message-ID: <34271790.6BE2@jbjnet.com>#1/1

CONFIGURATION: Oracle Workgroup Server 7.3.2.2 on Unixware 2.1

PROBLEM: I get the following errors when rebooting my Unixware 2.1 machine, which starts up the Oracle Workgroup Server and its all its related processes:

Tns error Struct:
   nr error code: 12203
   TNS-12203: TNS: unable to connect to destination    ns main err code: 12541
   TNS-12541:TNS: no listener
   no secondary err code: 12560
   nt main err code:511
   TNS-00511: No listener
   nt secondary err code: 146
   nt OS err code: 0

NOTE 1:

I noticed that /etc/rc2.d/S84tcplsnr references the /home/oracle7/network/install/tcppa directory in the starup shell script. But this directory does NOT exist. The tcppa subdirectory exists under the /home/oracle7/network/install directory.

I tried changing /home/oracle7/network/tcppa (in /etc/S84tcplsnr) to /home/oracle7/network/install/tcppa, but I still get the same error message.

NOTE 2:

When I execute su -c "/home/oracle7/bin/lsnrctl start tcp_listener" after startup, the listener seems to start up and STAY UP. The listener process shows up via a 'ps -ef|grep tns' command as:

/home/oracle7/bin/tnslsnr tcp.listener -inherit

This causes the listener related error messages , described above to STOP being displayed. (ie., I manually started up the listener)

MY THOUGHTS:

I see 2 problems: 1) the reference in startup file /etc/rc2.d/S84tnslsnr to a non-existent directory (namely /home/oracle/network/tcppa) and 2) a possible race condition, where the listener needs to be started up at a later stage in the boot process.

Any ideas what's causing this error message ?

Thanks for any help,
Jonathan Joseph

jon.joseph_at_jbjnet.com
jjoseph_at_voicenet.com

215-387-9401 x245 (daytime phone until Sept. 30th) 610-873-2290 (evening phone and fax) Received on Mon Sep 22 1997 - 00:00:00 CDT