Re: Manuell deleted Datafile

From: Mario Koch <m.koch_at_md-netz.de>
Date: Mon, 5 Jul 2004 19:58:10 +0200
Message-ID: <ccc4rj$fl5$00$1@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

Received on Mon Jul 05 2004 - 12:58:10 CDT