8.0.3/Netware 4.11 Install Corrupted

[skibum019]

During a recent power outage we lost power to everything on our network. After restoring power and rebooting servers, our Novell Netware 4.11 server running Oracle 8.0.3 (without any issues for the last 6 years) failed to load the database. I am stuck. The TNS Listener seems to be fine showing 2 services being handled, but when attempting to startup the database we get all kinds of errors.
After loading oracle (ORALOAD), if I run the ORASTART command, Server Manager seems to hang, and the system console states "Unable to open config.ora after 600 tries" over and over and over.
If rather then running ORASTART, I manually load Server Manager, (LOAD SVRMGR30), Server Manager opens and immediately returns "ORA-03113: end-of-file on communication channel" and then goes to the prompt.
Running any kind of connect statement will hang the Server Manager and the system console reports the "unable to open config.ora" message shown above.
If I try to do a "STARTUP PFILE=VOL1:ORANW803\DATABASE\INITORCL.ORA NOMOUNT" command, the Server Manager returns "LCC-00161: Message 161 not found; product=DBMS80; facility=MGR" and then "ORA-03113: end-of-file on communication channel" errors.
If I try to do a "RECOVER DATABASE", Server Manager returns "ORA-03114: not connected to ORACLE".
If I attempt to run Oracle Manager utility (NWDBM80) I can't login to the database.
If I attempt to load "DBSNMP_START" from the Listener Control utility, the following occurs
Loading module DBSNMP80.NLM
OEM Intelligent Agent v8.0.3.0.7
Version 8.00c Novemeber 3, 1998
Copyright blah-blah
Exiting re-entrant call to DBSNMP: no operations run
Then there are two inactive modules (seemingly inactive) loaded (DBSNMP Main & DBSNMP Comm).
The last few messages in the Listener.log file are as follows:

TNSLSNR for NetWare: Version 8.0.3.0.0 - Production on 13-SEP-05 10:35:22

(c) Copyright 1997 Oracle Corporation. All rights reserved.

System parameter file is VOL1:ORANW803\NET80\admin\listener.ora
Log messages written to VOL1:ORANW803\NET80\log\listener.log
Trace information written to VOL1:ORANW803\NET80\trace\listener.trc
Trace level is currently 0

Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=9)(NET=00000000)(NODE=000000000000)(SOCKET=0000))
Listening on: (ADDRESS=(PROTOCOL=spx)(DEV=13)(NET=19800000)(NODE=000000000001)(SOCKET=403a))
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=16)(HOST=192.168.1.253)(PORT=1521))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
13-SEP-05 10:46:12 * (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=)(HOST=Console)(USER=OPERATOR))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.253)(PORT=1027)) * establish * ORCL * 0
13-SEP-05 10:57:18 * (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=)(HOST=Console)(USER=OPERATOR))) * nsevwait_error * 12560
TNS-12560: TNSrotocol adapter error
TNS-00530: Protocol adapter error

13-SEP-05 10:57:18 * (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=)(HOST=Console)(USER=OPERATOR))) * listen_address_removed * 1170
TNS-01170: Event detection broke for address: '(ADDRESS=(PROTOCOL=IPC)(KEY=SATURN_LSNR))'
TNS-12560: TNSrotocol adapter error
TNS-00530: Protocol adapter error

13-SEP-05 10:57:18 * (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=)(HOST=Console)(USER=OPERATOR))) * listen_address_removed * 1170
TNS-01170: Event detection broke for address: '(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.253)(PORT=1521))'
TNS-12560: TNSrotocol adapter error
TNS-00530: Protocol adapter error

13-SEP-05 10:57:18 * (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=)(HOST=Console)(USER=OPERATOR))) * listen_address_removed * 1170
TNS-01170: Event detection broke for address: '(ADDRESS=(PROTOCOL=SPX)(SERVICE=SATURN_LSNR))'
TNS-12560: TNSrotocol adapter error
TNS-00530: Protocol adapter error

13-SEP-05 10:57:18 * (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=)(HOST=Console)(USER=OPERATOR))) * listener_shutdown * 1172
TNS-01172: Listener has shut down since all listen addresses have been deallocated


Any help would be greatly appreciated....

 

[oradba101]

Hi, skibum

In NetWare, you probably should take a look at EASYCFG which is where you configure the listener. The listener may be corrupted and EASYCFG will help to determine that. It is run from the console prompt.

Regards,

PS I run Oracle8i on a NetWare server and would strongly recommend switching to Linux. It runs much better.

William Chadbourne
Oracle DBA

 

[skibum019]

Update:
I have fixed the problem, which seemed to be a combination of issues. How/when/why they changed or started affecting us is still unknown.
1) The <SID>ALRT.LOG file had grown to over 200MB in size, which I believe was causing issues with the database opening properly. I renamed this file and created a new 0-byte file of the same name.
2) The SQLNET.ORA file under %ORACLE_HOME%\NET80\ADMIN has a line in it "SQLNET.AUTHENTICATION_SERVICES=(NDS)"
for some reason this does not work in our situation. I Rem'd this line out.
Once these two items had been addressed, Oracle was able to load as well as the database without any problems. I then found that every time you run the EASYCFG utility, it automatically adds the "SQLNET.AUTHENTICATION_SERVICES=(NDS)" line back in, and we would return to our prior status of problems. A simple REM of the line and the issue would be resolved.
Thanks to all who offered advice.