| ORA-01092: ORACLE instance terminated. Disconnection forced [message #285873] |
Wed, 05 December 2007 23:44  |
sudhir1582
Messages: 17
Registered: December 2007
|
Junior Member |
|
|
Hi,
I'm getting the following error while starting the database. My instance get started and database get mounted but it gives the error while opening the database.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1289484 bytes
Variable Size 104858356 bytes
Database Buffers 54525952 bytes
Redo Buffers 7098368 bytes
SQL> alter database mount;
Database altered.
SQL> alter data open;
alter data open
*
ERROR at line 1:
ORA-00940: invalid ALTER command
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL>
When i check the alert log file following error shown
Errors in file e:\oracle\product\admin\test\udump\test_ora_872.trc:
ORA-00604: error occurred at recursive SQL level
Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Thu Dec 06 10:30:37 2007
Errors in file e:\oracle\product\admin\test\bdump\test_pmon_2868.trc:
ORA-00604: error occurred at recursive SQL level
Thu Dec 06 10:30:37 2007
Errors in file e:\oracle\product\admin\test\bdump\test_reco_2264.trc:
ORA-00604: error occurred at recursive SQL level
Thu Dec 06 10:30:37 2007
Errors in file e:\oracle\product\admin\test\bdump\test_ckpt_3288.trc:
ORA-00604: error occurred at recursive SQL level
Thu Dec 06 10:30:38 2007
Errors in file e:\oracle\product\admin\test\bdump\test_lgwr_2628.trc:
ORA-00604: error occurred at recursive SQL level
Thu Dec 06 10:30:39 2007
Errors in file e:\oracle\product\admin\test\bdump\test_dbw0_2512.trc:
ORA-00604: error occurred at recursive SQL level
Thu Dec 06 10:30:39 2007
Errors in file e:\oracle\product\admin\test\bdump\test_mman_1252.trc:
ORA-00604: error occurred at recursive SQL level
Thu Dec 06 10:30:39 2007
Errors in file e:\oracle\product\admin\test\bdump\test_psp0_3296.trc:
ORA-00604: error occurred at recursive SQL level
Instance terminated by USER, pid = 872
ORA-1092 signalled during: alter database open...
When i checked the test_lgwr_2628.trc file following error shown. Rest all trc file show only last 2 line from the following error.
Media recovery not enabled or manual archival only 0x10000
Maximum redo generation record size = 156160 bytes
Maximum redo generation change vector size = 150672 bytes
error 604 detected in background process
ORA-00604: error occurred at recursive SQL level
If anybody know the solution of this issue pls let me know.
Thanks
Regards
Sudhir
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #286014 is a reply to message #285902] |
Thu, 06 December 2007 05:20  |
sudhir1582
Messages: 17
Registered: December 2007
|
Junior Member |
|
|
Hi Michel,
I tried opening the database in Startup force command but that also did not work.I'm getting the same error
But in test_lgwr_1956.trc file i'm getting the following error. What is this error? and why it comes?
Dump file e:\oracle\product\admin\test\bdump\test_lgwr_1956.trc
Thu Dec 06 16:39:14 2007
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:89M/502M, Ph+PgF:307M/1225M, VA:1712M/2047M
Instance name: test
Redo thread mounted by this instance: 1
Oracle process number: 6
Windows thread id: 1956, image: ORACLE.EXE (LGWR)
*** 2007-12-06 16:39:14.468
*** SERVICE NAME:() 2007-12-06 16:39:14.390
*** SESSION ID:(166.1) 2007-12-06 16:39:14.390
Media recovery not enabled or manual archival only 0x10000
Maximum redo generation record size = 156160 bytes
Maximum redo generation change vector size = 150672 bytes
error 604 detected in background process
ORA-00604: error occurred at recursive SQL level
Oracle version is 10.2.0.3
log_archive_start value is FALSE
Database is in noarchive mode
Thanks
Regards
Sudhir
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
