| tarun |
Posted: Jun 25, 2008 01:41:09 AM |
Total Post: 16
Joined: Jun, 2008
|
Dear All,
PLEASE HELP ME
At the time of start the database .it come in mount state mode.but database not go in open mode.it show the following error :
ORA-01092 Oracle instance terminated Disconnection Forced.
and alert log show the following errors:-
ORA-1092 - signalled during:ALTER DATABASE OPEL
ORA-30012- undo tablespace 'UNDOTABS1' does not exist or of wrong type
LGWR-Primary database is in CLUSTER CONSISTENT MODE
Errors in files /oracle/admin/XGLIV925/bdump/xgliv925_dbw0_405654.trc
ORA-01186:file 254 failed verfication tests
ORA-01157: cannot identify lock data file 254-see DBWR trace file
ORA-01110: DATAFILE 254: /ora9205/rsaarch/temp02.dbf
ORA-27037 unable to obtain file status
PLEASE SEND ME SOLUATION AS SOOS AS POSSIBLE
TO MAILID:tarunkumar_goel@rediffmail.com |
|
|
 Gitesh |
| Posted: Jun 25, 2008 07:22:11 AM |  |
|
Total Post: 322
Joined: May, 2005
|
Undo tablespace UNDOTABS1 doesn't exist. Check your undo_tablespace parameter and create undo tablespace same name in database. Add tempfile in database.
|
|
|
|
|
| positive |
| Posted: Jun 27, 2008 04:29:33 PM | |
|
Total Post: 483
Joined: Jun, 2008
|
If you had created your database using DBCA undotablespace would have been created automatically.
If database had been created manually problem might have occured.
The open clause of STARTUP command reads the control file and locates the appropriate files.There is problem in finding undo datafile.
check if the file exists.If not create a file in the location specified with given name and try opening the database.
|
|
|
|
|
| navya |
| Posted: Jan 05, 2009 05:55:15 AM | |
|
Total Post: 14
Joined: Jan, 2009
|
first check what u have given the undo_tablespace_undotbs in init file and also while creating the database then after if both are same remove comment infront of undo_tablespace in init file and check
navaya
\
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
