Re: Manuell deleted Datafile

"Mario Koch" <m.koch_at_md-netz.de> wrote in message news:ccc4rj$fl5$00$1_at_news.t-online.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
>
>

ok, so on linux,

su - oracle
sqlplus "/ as sysdba"

wjat does that produce, what group is the oracle user in? Received on Mon Jul 05 2004 - 15:36:34 CDT