Oracle Database Discussions

Hi,

i am not able to open the database.ASM instance is opened successfully.please help

Database version:10.2.0.1.0
OS:windows

SQL> startup
ORACLE instance started.

Total System Global Area 437219632 bytes
Fixed Size 737584 bytes
Variable Size 369098752 bytes
Database Buffers 67108864 bytes
Redo Buffers 274432 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced

Alert log file:_

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 d:\oracle\product\10.2.0\db_3\RDBMS
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
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:
processes = 150
__shared_pool_size = 75497472
shared_pool_size = 75497472
__large_pool_size = 4194304
large_pool_size = 4194304
__java_pool_size = 4194304
java_pool_size = 4194304
__streams_pool_size = 0
streams_pool_size = 0
sga_target = 167772160
control_files = DATA/test/control01.ctl, DATA/test/control02.ctl, +DATA/test/control03.ctl
db_block_size = 8192
__db_cache_size = 75497472
db_cache_size = 75497472
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 900
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= NONE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\TEST\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\TEST\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\TEST\CDUMP
db_name = test
open_cursors = 300
pga_aggregate_target = 16777216
PMON started with pid=2, OS id=672
PSP0 started with pid=3, OS id=2548
MMAN started with pid=4, OS id=3216
DBW0 started with pid=5, OS id=2776
LGWR started with pid=6, OS id=2884
CKPT started with pid=7, OS id=2104
SMON started with pid=8, OS id=2268
RECO started with pid=9, OS id=2072
CJQ0 started with pid=10, OS id=404
MMON started with pid=11, OS id=3356
Thu Dec 25 20:44:46 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=192
Thu Dec 25 20:44:46 2008
starting up 1 shared server(s) ...
Thu Dec 25 20:44:46 2008
ALTER DATABASE MOUNT
Thu Dec 25 20:44:49 2008
Starting background process ASMB
ASMB started with pid=16, OS id=2516
Starting background process RBAL
RBAL started with pid=17, OS id=700
Thu Dec 25 20:44:59 2008
SUCCESS: diskgroup DATA was mounted
Thu Dec 25 20:45:04 2008
Setting recovery target incarnation to 1
Thu Dec 25 20:45:04 2008
Successful mount of redo thread 1, with mount id 1972534206
Thu Dec 25 20:45:04 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Thu Dec 25 20:45:04 2008
ALTER DATABASE OPEN
Thu Dec 25 20:45:04 2008
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Thu Dec 25 20:45:05 2008
Started redo scan
Thu Dec 25 20:45:05 2008
Completed redo scan
1 redo blocks read, 0 data blocks need recovery
Thu Dec 25 20:45:05 2008
Started redo application at
Thread 1: logseq 136, block 623, scn 317846
Thu Dec 25 20:45:05 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 136 Reading mem 0
Mem# 0 errs 0: +DATA/test/redo02.log
Thu Dec 25 20:45:05 2008
Completed redo application
Thu Dec 25 20:45:05 2008
Completed crash recovery at
Thread 1: logseq 136, block 624, scn 337848
0 data blocks read, 0 data blocks written, 1 redo blocks read
Thu Dec 25 20:45:06 2008
Thread 1 advanced to log sequence 137
Thread 1 opened at log sequence 137
Current log# 1 seq# 137 mem# 0: +DATA/test/redo01.log
Successful open of redo thread 1
Thu Dec 25 20:45:06 2008
SMON: enabling cache recovery
Thu Dec 25 20:45:06 2008
Errors in file d:\oracle\product\10.2.0\admin\test\udump\test_ora_3996.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option

Thu Dec 25 20:45:06 2008
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Thu Dec 25 20:45:06 2008
Errors in file d:\oracle\product\10.2.0\admin\test\bdump\test_o000_3640.trc:
ORA-00704: bootstrap process failure

Thu Dec 25 20:45:07 2008
Errors in file d:\oracle\product\10.2.0\admin\test\bdump\test_rbal_700.trc:
ORA-00704: bootstrap process failure

Thu Dec 25 20:45:07 2008
Errors in file d:\oracle\product\10.2.0\admin\test\bdump\test_lgwr_2884.trc:
ORA-00704: bootstrap process failure

Thu Dec 25 20:45:07 2008
Errors in file d:\oracle\product\10.2.0\admin\test\bdump\test_psp0_2548.trc:
ORA-00704: bootstrap process failure

Thu Dec 25 20:45:07 2008
Errors in file d:\oracle\product\10.2.0\admin\test\bdump\test_mman_3216.trc:
ORA-00704: bootstrap process failure

Thu Dec 25 20:45:07 2008
Errors in file d:\oracle\product\10.2.0\admin\test\bdump\test_dbw0_2776.trc:
ORA-00704: bootstrap process failure

Thu Dec 25 20:45:07 2008
Errors in file d:\oracle\product\10.2.0\admin\test\bdump\test_pmon_672.trc:
ORA-00704: bootstrap process failure

Thu Dec 25 20:45:08 2008
Errors in file d:\oracle\product\10.2.0\admin\test\bdump\test_ckpt_2104.trc:
ORA-00704: bootstrap process failure

Thu Dec 25 20:45:13 2008
Errors in file d:\oracle\product\10.2.0\admin\test\bdump\test_reco_2072.trc:
ORA-00704: bootstrap process failure

Thu Dec 25 20:45:13 2008
Errors in file d:\oracle\product\10.2.0\admin\test\bdump\test_smon_2268.trc:
ORA-00704: bootstrap process failure

Instance terminated by USER, pid = 3996
ORA-1092 signalled during: ALTER DATABASE OPEN...




Errors in file d:\oracle\product\10.2.0\admin\test\udump\test_ora_3996.trc: contents

Dump file d:\oracle\product\10.2.0\admin\test\udump\test_ora_3188.trc
Sat Dec 20 09:43:47 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.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:114M/501M, Ph+PgF:316M/1226M, VA:1746M/2047M
Instance name: test

Redo thread mounted by this instance: 0 <none>

Oracle process number: 15

Windows thread id: 3188, image: ORACLE.EXE (SHAD)


*** 2008-12-20 09:43:47.406
*** SERVICE NAME:() 2008-12-20 09:43:47.359
*** SESSION ID:(159.1) 2008-12-20 09:43:47.359
2008-12-20 09:43:47.359: [ OCROSD]utgdv:11:could not read reg value ocrmirrorconfig_loc os error= The system could not find the environment option that was entered. 2008-12-20 09:43:47.453: [ OCROSD]utgdv:11:could not read reg value ocrmirrorconfig_loc os error= The system could not find the environment option that was entered. 2008-12-20 09:43:48.734: [ OCROSD]utgdv:11:could not read reg value ocrmirrorconfig_loc os error= The system could not find the environment option that was entered. 2008-12-20 09:43:48.750: [ OCROSD]utgdv:11:could not read reg value ocrmirrorconfig_loc os error= The system could not find the environment option that was entered. *** 2008-12-20 09:43:59.375
kccsga_update_ckpt: num_1 = 16, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
Control file created with size 512 blocks
ORA-00301: error in adding log file '+data/test/redo01.log' - file cannot be created
ORA-17502: ksfdcre:4 Failed to create file +data/test/redo01.log
ORA-15005: name "test/redo01.log" is already used by an existing alias
*** 2008-12-20 09:46:19.015 ssthreadkillsafe: about to forcefully terminate tid=1416, dumping call stack:
------------------- Call Stack Trace ---------------------
calling location entry point arg #1 arg #2 arg #3 arg #4
------------------------------------------- ------------------------------------------- -------- -------- -------- --------
7C90EB94 00000000 00000000 00000000 00000000 00000000
62652C91 00000000 00000000 00000000 00000000 00000000
6265193D 62652B40 00000000 00000000 00000000 00000000
60A08BD8 00000000 07c60e58 07c62b92 07c60fec 00000000
609CCBB8 60A07EF0 07c602cc 07b99bf0 07bce708 00000000
609AF9CD 609CCAF0 07c602cc 07bce708 00000000 00000000
609ACF09 609ACF48 07bce5ec 00000055 07bce708 00000000
6097E2C7 609ACEF4 07bce5ec 07bce708 07b99e80 00000000
_ttcdrv+6065 00000000 07c35720 00000000 07b9cafb 00000001
6098223F 00000000 07b9caec 00000000 00000000 00000000
_xupirtrc+983 00000000 07c35720 00000000 60febfb0 07b9caec
xupirtr+125 xupirtrc+0 07c3567c 0000008f 07b9f2a0 07b9caec
upirtr+28 xupirtr+0 07c3567c 0000008f 07b9f2a0 00000000
kpurcs+31 upirtr+0 07c3567c 0000008f 07b9f2a0 00000000
OCIKDispatch+24 kpurcs+0 04cea268 0000008f 07b9f2a0 00000000
kfnOpExecute+112 OCIKDispatch+0 04cea268 04cea31c 0000008f 07b9f2a0
kfnbRun+1084 kfnOpExecute+0 00000000 00000000 00000000 00000000
_ksbrdp+747 00000000 03c55378 00000000 00000000 00000000
opirip+674 ksbrdp+0 00000000 00000000 00000000 00000000
opidrv+857 opirip+0 00000032 00000004 07b9febc 00000000
sou2o+45 opidrv+0 00000032 00000004 07b9febc 00000000
opimaireal+227 _sou2o+0 07b9feb0 00000032 00000004 07b9febc
opimai+92 opimai_real+0 00000003 07b9fee8 00000000 00000000
BackgroundThreadStart@4+422 opimai+0 00000000 00000000 00000000 00000000
7C80B508 00000000 00000000 00000000 00000000 00000000
---------------- End of Call Stack Trace -----------------
Call stack acquisition performance stats:
setup time (lock acquis., memory alloc.): 0 ms
frame get time (time the target proc was suspended): 0 ms
symbol translation time: 172 ms
total time: 172 ms
Dump file d:\oracle\product\10.2.0\admin\test\udump\test_ora_3188.trc
Thu Dec 25 20:39:17 2008
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.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:81M/501M, Ph+PgF:240M/1226M, VA:1716M/2047M
Instance name: test

Redo thread mounted by this instance: 1

Oracle process number: 15

Windows thread id: 3188, image: ORACLE.EXE (SHAD)


*** SERVICE NAME:(SYS$USERS) 2008-12-25 20:39:17.281
*** SESSION ID:(159.3) 2008-12-25 20:39:17.281
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
*** 2008-12-25 20:39:22.843 ssthreadkillsafe: about to forcefully terminate tid=3808, dumping call stack:
------------------- Call Stack Trace ---------------------
calling location entry point arg #1 arg #2 arg #3 arg #4
------------------------------------------- ------------------------------------------- -------- -------- -------- --------
7C90EB94 00000000 00000000 00000000 00000000 00000000
62652C91 00000000 00000000 00000000 00000000 00000000
6265193D 62652B40 00000000 00000000 00000000 00000000
60A08BD8 00000000 080f0f64 080f2c9e 080f10f8 00000000
609CCBB8 60A07EF0 080f02cc 080e9bf0 079fe708 00000000
609AF9CD 609CCAF0 080f02cc 079fe708 00000000 00000000
609ACF09 609ACF48 079fe5ec 00000055 079fe708 00000000
6097E2C7 609ACEF4 079fe5ec 079fe708 080e9e80 00000000
_ttcdrv+6065 00000000 07735720 00000000 080ecafb 00000001
6098223F 00000000 080ecaec 00000000 00000000 00000000
_xupirtrc+983 00000000 07735720 00000000 60febfb0 080ecaec
xupirtr+125 xupirtrc+0 0773567c 0000008f 080ef2a0 080ecaec
upirtr+28 xupirtr+0 0773567c 0000008f 080ef2a0 00000000
kpurcs+31 upirtr+0 0773567c 0000008f 080ef2a0 00000000
OCIKDispatch+24 kpurcs+0 050ca268 0000008f 080ef2a0 00000000
kfnOpExecute+112 OCIKDispatch+0 050ca268 050ca31c 0000008f 080ef2a0
kfnbRun+1084 kfnOpExecute+0 00000000 00000000 00000000 00000000
_ksbrdp+747 00000000 03c55378 00000000 00000000 00000000
opirip+674 ksbrdp+0 00000000 00000000 00000000 00000000
opidrv+857 opirip+0 00000032 00000004 080efebc 00000000
sou2o+45 opidrv+0 00000032 00000004 080efebc 00000000
opimaireal+227 _sou2o+0 080efeb0 00000032 00000004 080efebc
opimai+92 opimai_real+0 00000003 080efee8 00000000 00000000
BackgroundThreadStart@4+422 opimai+0 00000000 00000000 00000000 00000000
7C80B508 00000000 00000000 00000000 00000000 00000000
---------------- End of Call Stack Trace -----------------
Call stack acquisition performance stats:
setup time (lock acquis., memory alloc.): 0 ms
frame get time (time the target proc was suspended): 0 ms
symbol translation time: 31 ms
total time: 31 ms


Thnaks,