Thank you for your detailed help. It perfect helps to take over this
critical error. Great thanks.
... and best regards
Mario
"David Fitzjarrell" <fitzjarrell_at_cox.net> schrieb im Newsbeitrag
news:9711ade0.0407051134.5803de93_at_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 - 16:14:52 CDT
