Re: Manuell deleted Datafile

From: David Fitzjarrell <fitzjarrell_at_cox.net>
Date: 5 Jul 2004 12:34:18 -0700
Message-ID: <9711ade0.0407051134.5803de93@posting.google.com>

> I have testet in all variants to get a connection, but there's no connection
> available:
> Error: not enough privilieges. I think there is an property on the database,
> where the rights are managed.
> Can i make an reorganisation of the complete database ?
> Here are the message on the try to connect: (sorry it's a german customer)
> -------------------------------
> rgu:~/OraHome1/bin # su - oracle -c startOracle
> Password:
> -su: /usr/local/lib: is a directory
> Aufruf von StartOracle
>
> SQL*Plus: Release 9.0.1.0.0 - Production on Mo Jul 5 00:57:00 2004
>
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
>
> SQL> Bei einer nicht hochgefahrenen Instanz angemeldet.
> SQL> ORACLE-Instanz hochgefahren.
>
> Total System Global Area 168584160 bytes
> Fixed Size 279520 bytes
> Variable Size 83886080 bytes
> Database Buffers 83886080 bytes
> Redo Buffers 532480 bytes
> Datenbank mit MOUNT angeschlossen.
> ORA-01157: Datendatei 7 kann nicht identifiziert/gesperrt werden - siehe
> DBWR-Trace-Datei
> ORA-01110: Datendatei 7: '/opt/oracle/oradata/db1/data1.dbf'
>
>
> SQL> Verbindung zu Oracle9i Release 9.0.1.0.0 - Production
> JServer Release 9.0.1.0.0 - Production beendet
>
> Database "DB1" warm started.
>
> LSNRCTL for Linux: Version 9.0.1.0.0 - Production on 05-JUL-2004 00:57:16
>
> Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.
>
> /opt/oracle/OraHome1/bin/tnslsnr wird gestartet: Bitte warten...
>
> TNSLSNR for Linux: Version 9.0.1.0.0 - Production
> Die System-Parameterdatei ist
> /opt/oracle/OraHome1/network/admin/listener.ora
> Log-Meldungen wurden geschrieben in:
> /opt/oracle/OraHome1/network/log/listener.log
> Listen auf:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.111.177)(PORT=1521)))
>
> Verbindung mit
> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.111.177)(PORT=1521))) wird
> aufgebaut
> STATUS des LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for Linux: Version 9.0.1.0.0 - Production
>
> Startdatum 05-JUL-2004 00:57:17
> Uptime 0 Tage 0 Std. 0 Min. 0 Sek.
> Trace-Ebene off
> Sicherheit OFF
> SNMP OFF
> Parameterdatei des Listener /opt/oracle/OraHome1/network/admin/listener.ora
> Log-Datei des Listener /opt/oracle/OraHome1/network/log/listener.log
> Zusammenfassung Listening-Endpunkte...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.111.177)(PORT=1521)))
> Services Übersicht...
>
> Der Befehl wurde erfolgreich ausgeführt.
> ------------------------------
> I hope it can help find the wayout.
>
> Greetings Mario
>
>
> "Noel" <tomekb_XXXX__at_softman.pl> schrieb im Newsbeitrag
news:cc94a6$bn4$1_at_inews.gazeta.pl...
> > Dnia 04-07-04 15:26, U¿ytkownik Mario Koch napisa³:
> >
> > > It sounds good, but i can't go to the database with an sql-tool like
> > > "sqlplus". The errors are :
> > > SQL*Plus: Release 9.0.1.0.1 - Production on So Jul 4 15:22:40 2004
> > > (c) Copyright 2001 Oracle Corporation. All rights reserved.
> > > ERROR:
> > > ORA-01033: ORACLE initialization or shutdown in progress
> > >
> > > What now ? I can't connect to the database, but oracle is started with
an
> > > error of the deleted files. (It wasn't system_01.dbf :-) )
> >
> > Connect there using SYS user as SYSDBA.
> > --
> > TomekB

Your first mistake, Mario, is not following the instructions given you. Given your situation you CANNOT, I repeat, CANNOT use a generic database startup script to get this instance running. This is, of course, what you are attempting to do, so there's no wonder why this isn't giving you results.

Let's go back and start this OVER, this time with a BIT more direction:

/usr/bin # su - oracle
$ sqlplus /nolog

SQL*Plus: Release 9.0.1.0.0 - Production on Mo Jul 5 00:57:00 2004

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

SQL> connect / as sysdba
Connected.
SQL> shutdown immediate
Database not open.
Database dismounted.
Oracle shut down.
SQL> startup mount

ORACLE-Instanz hochgefahren.

Total System Global Area 168584160 bytes

Fixed Size                   279520 bytes
Variable Size              83886080 bytes
Database Buffers           83886080 bytes
Redo Buffers                 532480 bytes

Datenbank mit MOUNT angeschlossen.
SQL> alter database datafile '/opt/oracle/oradata/db1/data1.dbf' offline drop;

Database altered.

SQL> alter database open;

Database opened.

SQL> drop tablespace data;

Tablespace dropped.

SQL> alter database backup controlfile to trace;

Database altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
Oracle shut down.
SQL> startup

Total System Global Area 168584160 bytes

Fixed Size                   279520 bytes
Variable Size              83886080 bytes
Database Buffers           83886080 bytes
Redo Buffers                 532480 bytes

Datenbank mit MOUNT angeschlossen.
Datenbank mit OPEN angeschlossen.
SQL> Such are the tasks you need to perform. Do NOT try to run your startOracle script again UNTIL you have completed the steps I, and others, have shown to you. You have created quite a mess and it requires something far more than a simple 'startup' at the SQL> command prompt to fix.

David Fitzjarrell Received on Mon Jul 05 2004 - 14:34:18 CDT