Re: HELP!!!!!!!!

From: Giuseppe Zancanaro <zancanaro.giuseppe_at_lotto.it>
Date: 1996/11/07
Message-ID: <3281F8F2.64C0_at_lotto.it>#1/1

Joe Trubisz wrote:
>
> 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

Hi, Joe
I simulate your situation in my trial personal Oracle. The trouble is the same, except for the file name... If you have a backup copy of the file, simply recover the file and then start Oracle. Otherwise, run the sqldba utility, and try the following to solve your problem.
!!!!!
Of course, in the second case you lose all the data of the file, and probably also of the tablespace related to the file. :-(
!!!!!

A small suggestion: look at the "Oracle7 Server Administrator’s Guide", it is a very useful help for this kind of trouble.

Good Luck

	Giuseppe
	E-mail address: giuseppe.zancanaro_at_lotto.it

(sorry for my bad english, i hop you can understand it)

SQLDBA> 
SQLDBA> 
SQLDBA> connect internal

Connected.

SQLDBA> 
SQLDBA> 
SQLDBA> startup

ORACLE instance started.
Database mounted.
ORA-01157: cannot identify data file 5 - file not found ORA-01110: data file 5: 'C:\APPS\ORAWIN95\DATABASE\prova.ora' Attempting to dismount database........Database dismounted. Attempting to shutdown instance........ORACLE instance shut down.

SQLDBA> 
SQLDBA> 
SQLDBA> startup nomount

ORACLE instance started.
SQLDBA> alter database mount exclusive;
Statement processed.

SQLDBA> 
SQLDBA> 
SQLDBA> alter database create datafile

'C:\APPS\ORAWIN95\DATABASE\prova.ora';
Statement processed.

SQLDBA> 
SQLDBA> 
SQLDBA> shutdown

ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.

SQLDBA> 
SQLDBA> 
SQLDBA> startup open recover

ORACLE instance started.
Database mounted.
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: 'C:\APPS\ORAWIN95\DATABASE\prova.ora' Media recovery required... beginning recovery session. Media recovery complete.
Database opened.

Total System Global Area       4303424 bytes
              Fixed Size         38296 bytes
           Variable Size       3847336 bytes
        Database Buffers        409600 bytes
            Redo Buffers          8192 bytes
SQLDBA> 

SQLDBA>
SQLDBA> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQLDBA> startup
ORACLE instance started.
Database mounted.
Database opened.

Total System Global Area       4303424 bytes
              Fixed Size         38296 bytes
           Variable Size       3847336 bytes
        Database Buffers        409600 bytes
            Redo Buffers          8192 bytes

SQLDBA>
SQLDBA>

=================================== End of file
========================================

Received on Thu Nov 07 1996 - 00:00:00 CET