ORA-01092:instance ORACLE interrompue. DÚconnexion imposÚe
Salut , j'ai un souci lorsque je souhaite me connecté avec le fichier PFILE :
SQL> startup PFILE=C:\oracle\path\pfile(init)\init_maroc.ora
Instance ORACLE lancÚe.
Total System Global Area 155189248 bytes
Fixed Size 1247804 bytes
Variable Size 96470468 bytes
Database Buffers 50331648 bytes
Redo Buffers 7139328 bytes
Base de donnÚes montÚe.
ORA-01092: instance ORACLE interrompue. DÚconnexion imposÚe
C'est quoi exactement le problème et comment puis-je le résoudre ,voici plus d'informations :
Thu Aug 28 01:59:01 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as C:\oracle\product\10.2.0\db_1\RDBMS
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
shared_pool_size = 71303168
control_files = C:\ORACLE\PATH\BASE\CONTROL01_MAROC.ORA
db_block_size = 2048
undo_management = AUTO
background_dump_dest = C:\ORACLE\PATH\TRACE
user_dump_dest = C:\ORACLE\PATH\TRACE
db_name = rabat
PMON started with pid=2, OS id=3328
PSP0 started with pid=3, OS id=3572
MMAN started with pid=4, OS id=3484
DBW0 started with pid=5, OS id=3108
LGWR started with pid=6, OS id=3696
CKPT started with pid=7, OS id=3508
SMON started with pid=8, OS id=3988
RECO started with pid=9, OS id=3440
MMON started with pid=10, OS id=3564
MMNL started with pid=11, OS id=3492
Thu Aug 28 01:59:01 2008
ALTER DATABASE MOUNT
Thu Aug 28 01:59:05 2008
Setting recovery target incarnation to 1
Thu Aug 28 01:59:06 2008
Successful mount of redo thread 1, with mount id 263728485
Thu Aug 28 01:59:06 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Thu Aug 28 01:59:06 2008
ALTER DATABASE OPEN
Thu Aug 28 01:59:06 2008
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Thu Aug 28 01:59:07 2008
Started redo scan
Thu Aug 28 01:59:07 2008
Completed redo scan
1 redo blocks read, 0 data blocks need recovery
Thu Aug 28 01:59:07 2008
Started redo application at
Thread 1: logseq 9, block 2, scn 87027
Thu Aug 28 01:59:07 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 9 Reading mem 0
Mem# 0 errs 0: C:\ORACLE\PATH\BASE\REDO1.LOG
Thu Aug 28 01:59:07 2008
Completed redo application
Thu Aug 28 01:59:07 2008
Completed crash recovery at
Thread 1: logseq 9, block 3, scn 107029
0 data blocks read, 0 data blocks written, 1 redo blocks read
Thu Aug 28 01:59:08 2008
Thread 1 advanced to log sequence 10
Thread 1 opened at log sequence 10
Current log# 2 seq# 10 mem# 0: C:\ORACLE\PATH\BASE\REDO2.LOG
Successful open of redo thread 1
Thu Aug 28 01:59:08 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Aug 28 01:59:08 2008
SMON: enabling cache recovery
Thu Aug 28 01:59:09 2008
Errors in file c:\oracle\path\trace\maroc_ora_3296.trc:
ORA-00704: échec de processus d'amorce
ORA-39700: la base de données doit être ouverte avec l'option UPGRADE
Thu Aug 28 01:59:09 2008
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Thu Aug 28 01:59:09 2008
Errors in file c:\oracle\path\trace\maroc_pmon_3328.trc:
ORA-00704: bootstrap process failure
Thu Aug 28 01:59:10 2008
Errors in file c:\oracle\path\trace\maroc_reco_3440.trc:
ORA-00704: bootstrap process failure
Thu Aug 28 01:59:10 2008
Errors in file c:\oracle\path\trace\maroc_smon_3988.trc:
ORA-00704: bootstrap process failure
Thu Aug 28 01:59:10 2008
Errors in file c:\oracle\path\trace\maroc_ckpt_3508.trc:
ORA-00704: bootstrap process failure
Thu Aug 28 01:59:10 2008
Errors in file c:\oracle\path\trace\maroc_dbw0_3108.trc:
ORA-00704: bootstrap process failure
Thu Aug 28 01:59:10 2008
Errors in file c:\oracle\path\trace\maroc_lgwr_3696.trc:
ORA-00704: bootstrap process failure
Thu Aug 28 01:59:10 2008
Errors in file c:\oracle\path\trace\maroc_mman_3484.trc:
ORA-00704: bootstrap process failure
Thu Aug 28 01:59:10 2008
Errors in file c:\oracle\path\trace\maroc_psp0_3572.trc:
ORA-00704: bootstrap process failure
Instance terminated by USER, pid = 3296
ORA-1092 signalled during: ALTER DATABASE OPEN...
ET MERCI BIEN POUR L'AIDE
