| vikhardba |
Posted: Jul 04, 2008 01:04:28 AM |
Total Post: 86
Joined: Apr, 2007
|
Hi to One and All,
Issue:
======
SQL>startup mount
ORACLE instance started.
Total System Global Area 205520896 bytes
Fixed Size 1295824 bytes
Variable Size 67111472 bytes
Database Buffers 130023424 bytes
Redo Buffers 7090176 bytes
Database mounted.
Now when i give alter database open; i get "ORA-01092: ORACLE instance terminated. Disconnection forced"
Troubleshooting:
================
(1)
SQL> recover database;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
(2)
Below given is the init parameter file:
========================================================
orcl.__db_cache_size=24904448
orcl.__java_pool_size=2194304
orcl.__large_pool_size=1194304
orcl.__shared_pool_size=30686720
orcl.__streams_pool_size=0
*.audit_file_dest='c:\oracle\product\10.2.0\admin\orcl\adump'
*.background_dump_dest='c:\oracle\product\10.2.0\admin\orcl\bdump'
*.compatible='10.2.0.1.0'
*.control_files='c:\oradataprod\control1.ctl'
*.core_dump_dest='c:\oracle\product\10.2.0\admin\orcl\cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.db_recovery_file_dest='c:\oracle\product\10.2.0\orcl\flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=202368384
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS01'
*.user_dump_dest='c:\oracle\product\10.2.0\admin\orcl\udump'
== Earlier it was UNDOTBS1 but i changed it to UNDOTBS01 but still no luck.
== Decreased the size of SGA_TARGET, db_cache_size but still no luck.
Then sql>select file#,status from v$datafile;
select file#,status from v$datafile;
FILE# STATUS
------ -------
1 SYSTEM
2 ONLINE
3 ONLINE
4 ONLINE
5 ONLINE
6 ONLINE
6 rows selected.
SQL>alter database datafile 1 online;
Database altered;
SQL>select file#,status from v$datafile;
still see same SYSTEM
I think problem is here. If not, please let me know the complete full fledge solution. I am eager to know the solution.
Cheers to All!!!!
|
|
|
 Gitesh |
| Posted: Jul 04, 2008 02:33:32 AM |  |
|
Total Post: 322
Joined: May, 2005
|
Did you check alert.log? what is the error messages logged in alert.log?
|
|
|
|
|
| vikhardba |
| Posted: Jul 04, 2008 03:11:46 AM | |
|
Total Post: 86
Joined: Apr, 2007
|
Yes, i checked the alert log file. Please find it below.
Fri Jul 04 12:22:45 2008
db_recovery_file_dest_size of 2048 MB is 2.88% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Jul 04 12:22:45 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_5792.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Fri Jul 04 12:22:45 2008
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Fri Jul 04 12:22:46 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_5328.trc:
ORA-00704: bootstrap process failure
Fri Jul 04 12:22:47 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_reco_5704.trc:
ORA-00704: bootstrap process failure
Fri Jul 04 12:22:47 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_860.trc:
ORA-00704: bootstrap process failure
Fri Jul 04 12:22:47 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_ckpt_1984.trc:
ORA-00704: bootstrap process failure
Fri Jul 04 12:22:47 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_lgwr_5456.trc:
ORA-00704: bootstrap process failure
Fri Jul 04 12:22:48 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mman_5672.trc:
ORA-00704: bootstrap process failure
Fri Jul 04 12:22:48 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_5248.trc:
ORA-00704: bootstrap process failure
Fri Jul 04 12:22:48 2008
Errors in file c:\oracle\product\10.2.0\admin\orcl\bdump\orcl_psp0_4968.trc:
ORA-00704: bootstrap process failure
Instance terminated by USER, pid = 5792
ORA-1092 signalled during: alter database open...
I know you will ask start database with upgrade. I did that too but i get same error message. Now??????
|
|
|
|
|
| aliai |
| Posted: Jul 04, 2008 03:50:23 AM | |
|
Total Post: 12
Joined: Apr, 2008
|
check out the names of the datafiles with the name in the pfile might there be a problem or try to start with spfile.
|
|
|
|
|
| vikhardba |
| Posted: Jul 04, 2008 07:33:42 AM | |
|
Total Post: 86
Joined: Apr, 2007
|
Thanks for your response. Yes, i did cross check with .DBF files . . . they all are same and at same path. Also, database is mounted with SPFILE
If i do SQL>recover database; media recovery complete result. But when i say alter database open; I get ORA-01092: ORACLE instance terminated. Disconnection forced
I tried SQL>alter database open upgrade and migrate tooo but no avail.
In order to run catalog, catproc . . .i should have database in open stage but as you see whenever i say alter database open; i get this error.
This isssue is driving me nuts.
Can anybody help me on this issue. Now i am leaving for the day.
|
|
|
|
|
| meraj |
| Posted: Jul 04, 2008 05:20:33 PM | |
|
Total Post: 39
Joined: Sep, 2006
|
I had also received this error.... when i checked the alert log there was block corruption in one of the DBF files.
Please check the .DBF files for any corruption.
|
|
|
|
|
| vikhardba |
| Posted: Jul 06, 2008 04:32:55 AM | |
|
Total Post: 86
Joined: Apr, 2007
|
Thanks for response from all.
I've resolved the issue with the help of my friend/colleague. actually the name on UndoTbs in init.ora was UNDOTBS01 instead of UNDOTBS1.
After changing the that in init file the issue is resolved.
Thanks
|
|
|
|
|
| positive |
| Posted: Jul 09, 2008 11:41:36 AM | |
|
Total Post: 483
Joined: Jun, 2008
|
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
