HELP!!!!!!!!

From: Joe Trubisz <trubisz_at_cs.sunysb.edu>
Date: 1996/11/04
Message-ID: <55lgjt$s0q_at_newsserv.cs.sunysb.edu>#1/1


HELP!!!!!!!!!!!!! We have a system which has run for a while here with no problems. Then, students got a hold of it, now we have a problem and don't know what to do.

We do a dbstart and get the following:

SQLDBA> Connected.
SQLDBA> ORACLE instance started.
Database mouinted.
ORA-01157: cannot identify data file 6 - file not found ORA-01110: data file 6: '/databases/bob.test' Attempting to dismount database........Database dismounted. Attempting to shutdown instance........ORACLE instance shut down. SQLDBA>
SQL*DBA complete
Database "INST" warm started.

We want INST running. The file from above was manually deleted with a UNIX rm. We can start the listener and that goes OK, but when we try to sqlplus into the database, we get:

ERROR: ORA-01034: ORACLE not available
ORA-07429: smsgsg: shmget() failed to get segment. SunOS Error: 2: No such file or directory

Enter user-name:

What do we do now??????????????????????????????????

Thanks,
joe Received on Mon Nov 04 1996 - 00:00:00 CET

Original text of this message