jtittler
asked on
Problems creating a db instance from a template using DBCA in 10G: ORA-01092
I recently installed 10G on my oracle server which runs 9i as well. I made sure they each had separate homes. One of my coworkers from a different location gave me a db template he created with the dbca in 10G so I can replicate the db on my server. It fails every time with the following error: "ORA-01092: ORACLE instance terminated. Disconnection force". I figured it might be the fact that the machine was running both 9i and 10G, (I need to support both types of databases). So, I took my development machine, which is a different machine, removed 9i from it, scrubbed the registry, and installed 10G. Same problem. I had the coworker create a db instance from that template using DBCA on his machine. No problems there. Worked just fine. I tried using the dbca to generate install scripts and ran those instead. Same problem. I checked the file parameters to make sure stuff pointed to existing paths on my machines. That all looks OK.
Does anyone know what might be going on here? I'm really stuck. Attached are my log files. Actually, I don't see a way to attach files to a post. I'll paste the contents below.
Thank you very much,
Julie Tittler
////////////////////////// ////////// ////////// /
FILE: Â cloneDBCreation.log
////////////////////////// ////////// ////////// /
SQL> Create controlfile reuse set database "BDA"
 2  MAXINSTANCES 8
 3  MAXLOGHISTORY 1
 4  MAXLOGFILES 16
 5  MAXLOGMEMBERS 3
 6  MAXDATAFILES 100
 7  Datafile
 8  'C:\oracle\product\10.2.0\ oradata\BD A\SYSTEM01 .DBF',
 9  'C:\oracle\product\10.2.0\ oradata\BD A\UNDOTBS0 1.DBF',
 10  'C:\oracle\product\10.2.0\ oradata\BD A\SYSAUX01 .DBF',
 11  'C:\oracle\product\10.2.0\ oradata\BD A\USERS01. DBF',
 12  'C:\oracle\product\10.2.0\ oradata\BD A\BDA_DB_O RACLE.DBF'
 13  LOGFILE GROUP 1 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO01. LOG') SIZE 10240K,
 14  GROUP 2 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO02. LOG') SIZE 10240K,
 15  GROUP 3 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO03. LOG') SIZE 10240K RESETLOGS;
Control file created.
SQL> exec dbms_backup_restore.zerodb id(0);
PL/SQL procedure successfully completed.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount pfile="C:\oracle\product\1 0.2.0\admi n\BDA\scri pts\initBD ATemp.ora" ;
ORACLE instance started.
Total System Global Area  171966464 bytes                   Â
Fixed Size          1247924 bytes                   Â
Variable Size       142607692 bytes                   Â
Database Buffers      25165824 bytes                   Â
Redo Buffers         2945024 bytes                   Â
SQL> Create controlfile reuse set database "BDA"
 2  MAXINSTANCES 8
 3  MAXLOGHISTORY 1
 4  MAXLOGFILES 16
 5  MAXLOGMEMBERS 3
 6  MAXDATAFILES 100
 7  Datafile
 8  'C:\oracle\product\10.2.0\ oradata\BD A\SYSTEM01 .DBF',
 9  'C:\oracle\product\10.2.0\ oradata\BD A\UNDOTBS0 1.DBF',
 10  'C:\oracle\product\10.2.0\ oradata\BD A\SYSAUX01 .DBF',
 11  'C:\oracle\product\10.2.0\ oradata\BD A\USERS01. DBF',
 12  'C:\oracle\product\10.2.0\ oradata\BD A\BDA_DB_O RACLE.DBF'
 13  LOGFILE GROUP 1 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO01. LOG') SIZE 10240K,
 14  GROUP 2 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO02. LOG') SIZE 10240K,
 15  GROUP 3 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO03. LOG') SIZE 10240K RESETLOGS;
Control file created.
SQL> alter system enable restricted session;
System altered.
SQL> alter database "BDA" open resetlogs;
alter database "BDA" open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> alter database rename global_name to "BDA";
ERROR:
ORA-03114: not connected to ORACLE
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\oracle\product\10.2.0\ oradata\BD A\TEMP01.D BF' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED;
ERROR:
ORA-03114: not connected to ORACLE
SQL> select tablespace_name from dba_tablespaces where tablespace_name='USERS';
ERROR:
ORA-03114: not connected to ORACLE
SQL> select sid, program, serial#, username from v$session;
ERROR:
ORA-03114: not connected to ORACLE
SQL> alter database character set INTERNAL_CONVERT WE8MSWIN1252;
ERROR:
ORA-03114: not connected to ORACLE
SQL> alter database national character set INTERNAL_CONVERT AL16UTF16;
ERROR:
ORA-03114: not connected to ORACLE
SQL> alter user sys identified by "&&sysPassword";
ERROR:
ORA-03114: not connected to ORACLE
SQL> alter user system identified by "&&systemPassword";
ERROR:
ORA-03114: not connected to ORACLE
SQL> alter system disable restricted session;
ERROR:
ORA-03114: not connected to ORACLE
SQL> @C:\oracle\product\10.2.0\ admin\BDA\ scripts\po stScripts. sql
SQL> connect "SYS"/"&&sysPassword" as SYSDBA
Connected to an idle instance.
SQL> set echo on
SQL> spool C:\oracle\product\10.2.0\a dmin\BDA\s cripts\pos tScripts.l og
////////////////////////// ////////// ////////// ////////// ////////// ////////// ///////
////////////////////////// ////////// //
FILE: Â alertBDA.log
////////////////////////// ////////// //
Dump file c:\oracle\product\10.2.0\a dmin\bda\b dump\alert _bda.log
Sun May 21 09:46:01 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU Â Â Â Â Â Â Â Â : 1 - type 586
Process Affinity   : 0x00000000
Memory (Avail/Total): Ph:141M/511M, Ph+PgF:869M/1249M, VA:1941M/2047M
Sun May 21 09:46:01 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
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     = 83886080
 large_pool_size      = 8388608
 java_pool_size      = 50331648
 control_files       = C:\ORACLE\PRODUCT\10.2.0\O RADATA\BDA \CONTROL01 .CTL, C:\ORACLE\PRODUCT\10.2.0\O RADATA\BDA \CONTROL02 .CTL, C:\ORACLE\PRODUCT\10.2.0\O RADATA\BDA \CONTROL03 .CTL
 db_block_size       = 8192
 db_cache_size       = 25165824
 compatible        = 10.1.0.2.0
 db_file_multiblock_read_co unt= 16
 db_recovery_file_dest   = C:\oracle\product\10.2.0\f lash_recov ery_area
 db_recovery_file_dest_size = 2147483648
 undo_management      = AUTO
 undo_tablespace      = UNDOTBS1
 remote_login_passwordfile= EXCLUSIVE
 db_domain         =
 dispatchers        = (PROTOCOL=TCP) (SERVICE=BDAXDB)
 job_queue_processes    = 10
 background_dump_dest   = C:\ORACLE\PRODUCT\10.2.0\A DMIN\BDA\B DUMP
 user_dump_dest      = C:\ORACLE\PRODUCT\10.2.0\A DMIN\BDA\U DUMP
 core_dump_dest      = C:\ORACLE\PRODUCT\10.2.0\A DMIN\BDA\C DUMP
 sort_area_size      = 65536
 db_name          = BDA
 open_cursors       = 300
 pga_aggregate_target   = 25165824
MMAN started with pid=4, OS id=3160
PSP0 started with pid=3, OS id=1788
PMON started with pid=2, OS id=3188
DBW0 started with pid=5, OS id=564
LGWR started with pid=6, OS id=1332
CKPT started with pid=7, OS id=664
SMON started with pid=8, OS id=3788
RECO started with pid=9, OS id=4076
CJQ0 started with pid=10, OS id=3492
MMON started with pid=11, OS id=2896
Sun May 21 09:46:08 2006
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR OTOCOL=TCP ))'...
MMNL started with pid=12, OS id=2900
Sun May 21 09:46:08 2006
starting up 1 shared server(s) ...
Sun May 21 09:46:15 2006
The input backup piece C:\ORACLE\PRODUCT\10.2.0\D B_1\ASSIST ANTS\DBCA\ TEMPLATES\ BDA_TEMPLA TE.DFB is in compressed format.
Full restore complete of datafile 5 to datafile copy C:\ORACLE\PRODUCT\10.2.0\O RADATA\BDA \BDA_DB_OR ACLE.DBF. Â Elapsed time: 0:00:03
 checkpoint is 625921
Full restore complete of datafile 4 to datafile copy C:\ORACLE\PRODUCT\10.2.0\O RADATA\BDA \USERS01.D BF. Â Elapsed time: 0:00:05
 checkpoint is 625921
Full restore complete of datafile 2 to datafile copy C:\ORACLE\PRODUCT\10.2.0\O RADATA\BDA \UNDOTBS01 .DBF. Â Elapsed time: 0:00:08
 checkpoint is 625921
Sun May 21 09:46:59 2006
Full restore complete of datafile 3 to datafile copy C:\ORACLE\PRODUCT\10.2.0\O RADATA\BDA \SYSAUX01. DBF. Â Elapsed time: 0:00:44
 checkpoint is 625921
Sun May 21 09:47:24 2006
Full restore complete of datafile 1 to datafile copy C:\ORACLE\PRODUCT\10.2.0\O RADATA\BDA \SYSTEM01. DBF. Â Elapsed time: 0:01:08
 checkpoint is 625921
Sun May 21 09:47:24 2006
Create controlfile reuse set database "BDA"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\ oradata\BD A\SYSTEM01 .DBF',
'C:\oracle\product\10.2.0\ oradata\BD A\UNDOTBS0 1.DBF',
'C:\oracle\product\10.2.0\ oradata\BD A\SYSAUX01 .DBF',
'C:\oracle\product\10.2.0\ oradata\BD A\USERS01. DBF',
'C:\oracle\product\10.2.0\ oradata\BD A\BDA_DB_O RACLE.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO01. LOG') SIZE 10240K,
GROUP 2 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO02. LOG') SIZE 10240K,
GROUP 3 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO03. LOG') SIZE 10240K RESETLOGS
Sun May 21 09:47:24 2006
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Setting recovery target incarnation to 1
Sun May 21 09:47:28 2006
Successful mount of redo thread 1, with mount id 1469665644
Sun May 21 09:47:28 2006
Completed: Create controlfile reuse set database "BDA"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\ oradata\BD A\SYSTEM01 .DBF',
'C:\oracle\product\10.2.0\ oradata\BD A\UNDOTBS0 1.DBF',
'C:\oracle\product\10.2.0\ oradata\BD A\SYSAUX01 .DBF',
'C:\oracle\product\10.2.0\ oradata\BD A\USERS01. DBF',
'C:\oracle\product\10.2.0\ oradata\BD A\BDA_DB_O RACLE.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO01. LOG') SIZE 10240K,
GROUP 2 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO02. LOG') SIZE 10240K,
GROUP 3 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO03. LOG') SIZE 10240K RESETLOGS
Shutting down instance: further logons disabled
Sun May 21 09:47:29 2006
Stopping background process CJQ0
Sun May 21 09:47:29 2006
Stopping background process MMNL
Sun May 21 09:47:30 2006
Stopping background process MMON
Sun May 21 09:47:30 2006
Shutting down instance (immediate)
License high water mark = 1
Sun May 21 09:47:30 2006
Stopping Job queue slave processes
Sun May 21 09:47:30 2006
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
Waiting for shared server 'S000' to die
All dispatchers and shared servers shutdown
Sun May 21 09:47:31 2006
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Sun May 21 09:47:31 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sun May 21 09:47:33 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
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     = 83886080
 large_pool_size      = 8388608
 java_pool_size      = 50331648
 control_files       = C:\ORACLE\PRODUCT\10.2.0\O RADATA\BDA \CONTROL01 .CTL, C:\ORACLE\PRODUCT\10.2.0\O RADATA\BDA \CONTROL02 .CTL, C:\ORACLE\PRODUCT\10.2.0\O RADATA\BDA \CONTROL03 .CTL
 db_block_size       = 8192
 db_cache_size       = 25165824
 compatible        = 10.1.0.2.0
 db_file_multiblock_read_co unt= 16
 db_recovery_file_dest   = C:\oracle\product\10.2.0\f lash_recov ery_area
 db_recovery_file_dest_size = 2147483648
 _no_recovery_through_reset logs= TRUE
 undo_management      = AUTO
 undo_tablespace      = UNDOTBS1
 remote_login_passwordfile= EXCLUSIVE
 db_domain         =
 dispatchers        = (PROTOCOL=TCP) (SERVICE=BDAXDB)
 background_dump_dest   = C:\ORACLE\PRODUCT\10.2.0\A DMIN\BDA\B DUMP
 user_dump_dest      = C:\ORACLE\PRODUCT\10.2.0\A DMIN\BDA\U DUMP
 core_dump_dest      = C:\ORACLE\PRODUCT\10.2.0\A DMIN\BDA\C DUMP
 sort_area_size      = 65536
 db_name          = BDA
 open_cursors       = 300
 pga_aggregate_target   = 25165824
PMON started with pid=2, OS id=3212
PSP0 started with pid=3, OS id=4044
MMAN started with pid=4, OS id=440
DBW0 started with pid=5, OS id=4024
LGWR started with pid=6, OS id=3584
CKPT started with pid=7, OS id=1592
SMON started with pid=8, OS id=820
RECO started with pid=9, OS id=3512
MMON started with pid=10, OS id=2412
MMNL started with pid=11, OS id=1568
Sun May 21 09:47:36 2006
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR OTOCOL=TCP ))'...
starting up 1 shared server(s) ...
Sun May 21 09:47:36 2006
Create controlfile reuse set database "BDA"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\ oradata\BD A\SYSTEM01 .DBF',
'C:\oracle\product\10.2.0\ oradata\BD A\UNDOTBS0 1.DBF',
'C:\oracle\product\10.2.0\ oradata\BD A\SYSAUX01 .DBF',
'C:\oracle\product\10.2.0\ oradata\BD A\USERS01. DBF',
'C:\oracle\product\10.2.0\ oradata\BD A\BDA_DB_O RACLE.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO01. LOG') SIZE 10240K,
GROUP 2 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO02. LOG') SIZE 10240K,
GROUP 3 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO03. LOG') SIZE 10240K RESETLOGS
Sun May 21 09:47:36 2006
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Setting recovery target incarnation to 1
Sun May 21 09:47:39 2006
Successful mount of redo thread 1, with mount id 1469634680
Sun May 21 09:47:39 2006
Completed: Create controlfile reuse set database "BDA"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\ oradata\BD A\SYSTEM01 .DBF',
'C:\oracle\product\10.2.0\ oradata\BD A\UNDOTBS0 1.DBF',
'C:\oracle\product\10.2.0\ oradata\BD A\SYSAUX01 .DBF',
'C:\oracle\product\10.2.0\ oradata\BD A\USERS01. DBF',
'C:\oracle\product\10.2.0\ oradata\BD A\BDA_DB_O RACLE.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO01. LOG') SIZE 10240K,
GROUP 2 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO02. LOG') SIZE 10240K,
GROUP 3 ('C:\oracle\product\10.2.0 \oradata\B DA\REDO03. LOG') SIZE 10240K RESETLOGS
Sun May 21 09:47:39 2006
Stopping background process MMNL
Sun May 21 09:47:40 2006
Stopping background process MMON
Sun May 21 09:47:40 2006
db_recovery_file_dest_size of 2048 MB is 0.00% 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.
Sun May 21 09:47:41 2006
Starting background process MMON
MMON started with pid=10, OS id=1692
Sun May 21 09:47:41 2006
Starting background process MMNL
Sun May 21 09:47:41 2006
ALTER SYSTEM enable restricted session;
MMNL started with pid=11, OS id=432
Sun May 21 09:47:41 2006
alter database "BDA" open resetlogs
Sun May 21 09:47:41 2006
RESETLOGS after incomplete recovery UNTIL CHANGE 625921
Sun May 21 09:47:41 2006
Errors in file c:\oracle\product\10.2.0\a dmin\bda\u dump\bda_o ra_3416.tr c:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\ ORADATA\BD A\REDO01.L OG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Sun May 21 09:47:42 2006
Errors in file c:\oracle\product\10.2.0\a dmin\bda\u dump\bda_o ra_3416.tr c:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\ ORADATA\BD A\REDO02.L OG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Sun May 21 09:47:43 2006
Errors in file c:\oracle\product\10.2.0\a dmin\bda\u dump\bda_o ra_3416.tr c:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\ ORADATA\BD A\REDO03.L OG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Sun May 21 09:47:45 2006
Setting recovery target incarnation to 2
Sun May 21 09:47:48 2006
Assigning activation ID 1469634680 (0x5798d878)
Thread 1 opened at log sequence 1
 Current log# 3 seq# 1 mem# 0: C:\ORACLE\PRODUCT\10.2.0\O RADATA\BDA \REDO03.LO G
Successful open of redo thread 1
Sun May 21 09:47:49 2006
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun May 21 09:47:49 2006
SMON: enabling cache recovery
Sun May 21 09:47:53 2006
Errors in file c:\oracle\product\10.2.0\a dmin\bda\u dump\bda_o ra_3416.tr c:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Sun May 21 09:47:53 2006
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Sun May 21 09:47:54 2006
Errors in file c:\oracle\product\10.2.0\a dmin\bda\b dump\bda_l gwr_3584.t rc:
ORA-00704: bootstrap process failure
Sun May 21 09:47:54 2006
Errors in file c:\oracle\product\10.2.0\a dmin\bda\b dump\bda_r eco_3512.t rc:
ORA-00704: bootstrap process failure
Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\a dmin\bda\b dump\bda_s mon_820.tr c:
ORA-00704: bootstrap process failure
Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\a dmin\bda\b dump\bda_p sp0_4044.t rc:
ORA-00704: bootstrap process failure
Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\a dmin\bda\b dump\bda_m man_440.tr c:
ORA-00704: bootstrap process failure
Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\a dmin\bda\b dump\bda_c kpt_1592.t rc:
ORA-00704: bootstrap process failure
Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\a dmin\bda\b dump\bda_d bw0_4024.t rc:
ORA-00704: bootstrap process failure
Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\a dmin\bda\b dump\bda_p mon_3212.t rc:
ORA-00704: bootstrap process failure
Instance terminated by USER, pid = 3416
ORA-1092 signalled during: alter database "BDA" open resetlogs...
Sun May 21 09:47:58 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
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     = 83886080
 large_pool_size      = 8388608
 java_pool_size      = 50331648
 control_files       = C:\ORACLE\PRODUCT\10.2.0\O RADATA\BDA \CONTROL01 .CTL, C:\ORACLE\PRODUCT\10.2.0\O RADATA\BDA \CONTROL02 .CTL, C:\ORACLE\PRODUCT\10.2.0\O RADATA\BDA \CONTROL03 .CTL
 db_block_size       = 8192
 db_cache_size       = 25165824
 compatible        = 10.1.0.2.0
 db_file_multiblock_read_co unt= 16
 db_recovery_file_dest   = C:\oracle\product\10.2.0\f lash_recov ery_area
 db_recovery_file_dest_size = 2147483648
 undo_management      = AUTO
 undo_tablespace      = UNDOTBS1
 remote_login_passwordfile= EXCLUSIVE
 db_domain         =
 dispatchers        = (PROTOCOL=TCP) (SERVICE=BDAXDB)
 job_queue_processes    = 10
 background_dump_dest   = C:\ORACLE\PRODUCT\10.2.0\A DMIN\BDA\B DUMP
 user_dump_dest      = C:\ORACLE\PRODUCT\10.2.0\A DMIN\BDA\U DUMP
 core_dump_dest      = C:\ORACLE\PRODUCT\10.2.0\A DMIN\BDA\C DUMP
 sort_area_size      = 65536
 db_name          = BDA
 open_cursors       = 300
 pga_aggregate_target   = 25165824
PMON started with pid=2, OS id=3800
PSP0 started with pid=3, OS id=3880
MMAN started with pid=4, OS id=1804
DBW0 started with pid=5, OS id=2480
LGWR started with pid=6, OS id=360
CKPT started with pid=7, OS id=3484
SMON started with pid=8, OS id=3840
RECO started with pid=9, OS id=4072
CJQ0 started with pid=10, OS id=3476
MMON started with pid=11, OS id=2388
MMNL started with pid=12, OS id=1968
Sun May 21 09:47:59 2006
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR OTOCOL=TCP ))'...
starting up 1 shared server(s) ...
Sun May 21 09:47:59 2006
ALTER DATABASE Â MOUNT
Sun May 21 09:48:03 2006
Setting recovery target incarnation to 2
Sun May 21 09:48:04 2006
Successful mount of redo thread 1, with mount id 1469631887
Sun May 21 09:48:04 2006
Database mounted in Exclusive Mode
Completed: ALTER DATABASE Â MOUNT
Sun May 21 09:48:04 2006
ALTER DATABASE OPEN
Sun May 21 09:48:05 2006
ORA-1113 signalled during: ALTER DATABASE OPEN...
Sun May 21 10:03:05 2006
db_recovery_file_dest_size of 2048 MB is 0.00% 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.
////////////////////////// ////////// ////////// ///////
////////////////////////// ///////
FILE: Â bda_ora_3416.trc
////////////////////////// ///////
Dump file c:\oracle\product\10.2.0\a dmin\bda\u dump\bda_o ra_3416.tr c
Sun May 21 09:47:38 2006
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 Â Â Â Â Â Â Â Â : 1 - type 586
Process Affinity   : 0x00000000
Memory (Avail/Total): Ph:84M/511M, Ph+PgF:681M/1249M, VA:1739M/2047M
Instance name: bda
Redo thread mounted by this instance: 0 <none>
Oracle process number: 14
Windows thread id: 3416, image: ORACLE.EXE (SHAD)
*** SERVICE NAME:() 2006-05-21 09:47:38.193
*** SESSION ID:(160.1) 2006-05-21 09:47:38.193
kccsga_update_ckpt: num_1 = 8, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
Control file created with size 424 blocks
Prior to RESETLOGS processing...
ALTER SYSTEM ARCHIVE LOG ALL USING BACKUP CONTROLFILE start
Database is not in archivelog mode
ALTER SYSTEM ARCHIVE LOG ALL USING BACKUP CONTROLFILE complete
*** 2006-05-21 09:47:41.468
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\ ORADATA\BD A\REDO01.L OG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\ ORADATA\BD A\REDO02.L OG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\ ORADATA\BD A\REDO03.L OG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
*** 2006-05-21 09:47:53.855
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
////////////////////////// ////////// //////////
////////////////////////// ////////// //
FILE: Â init.ora
////////////////////////// ////////// //
########################## ########## ########## ########## ########## ########## ##
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
########################## ########## ########## ########## ########## ########## ##
Â
########################## ########## #######
# Cache and I/O
########################## ########## #######
db_block_size=8192
db_cache_size=25165824
db_file_multiblock_read_co unt=16
Â
########################## ########## #######
# Cursors and Library Cache
########################## ########## #######
open_cursors=300
Â
########################## ########## #######
# Database Identification
########################## ########## #######
db_domain=""
db_name=BDA
Â
########################## ########## #######
# Diagnostics and Statistics
########################## ########## #######
background_dump_dest=C:\or acle\produ ct\10.2.0\ admin\BDA\ bdump
core_dump_dest=C:\oracle\p roduct\10. 2.0\admin\ BDA\cdump
user_dump_dest=C:\oracle\p roduct\10. 2.0\admin\ BDA\udump
Â
########################## ########## #######
# File Configuration
########################## ########## #######
control_files=("C:\oracle\ product\10 .2.0\orada ta\BDA\CON TROL01.CTL ", "C:\oracle\product\10.2.0\ oradata\BD A\CONTROL0 2.CTL", "C:\oracle\product\10.2.0\ oradata\BD A\CONTROL0 3.CTL")
db_recovery_file_dest=C:\o racle\prod uct\10.2.0 \flash_rec overy_area
db_recovery_file_dest_size =214748364 8
Â
########################## ########## #######
# Job Queues
########################## ########## #######
job_queue_processes=10
Â
########################## ########## #######
# Miscellaneous
########################## ########## #######
compatible=10.1.0.2.0
Â
########################## ########## #######
# Pools
########################## ########## #######
java_pool_size=50331648
large_pool_size=8388608
shared_pool_size=83886080
Â
########################## ########## #######
# Processes and Sessions
########################## ########## #######
processes=150
Â
########################## ########## #######
# Security and Auditing
########################## ########## #######
remote_login_passwordfile= EXCLUSIVE
Â
########################## ########## #######
# Shared Server
########################## ########## #######
dispatchers="(PROTOCOL=TCP ) (SERVICE=BDAXDB)"
Â
########################## ########## #######
# Sort, Hash Joins, Bitmap Indexes
########################## ########## #######
pga_aggregate_target=25165 824
sort_area_size=65536
Â
########################## ########## #######
# System Managed Undo and Rollback Segments
########################## ########## #######
undo_management=AUTO
undo_tablespace=UNDOTBS1
////////////////////////// ////////// ////////
//////////////////////////
FILE: Â initBDAtemp.ora
//////////////////////////
########################## ########## ########## ########## ########## ########## ##
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
########################## ########## ########## ########## ########## ########## ##
Â
########################## ########## #######
# Cache and I/O
########################## ########## #######
db_block_size=8192
db_cache_size=25165824
db_file_multiblock_read_co unt=16
Â
########################## ########## #######
# Cursors and Library Cache
########################## ########## #######
open_cursors=300
Â
########################## ########## #######
# Database Identification
########################## ########## #######
db_domain=""
db_name=BDA
Â
########################## ########## #######
# Diagnostics and Statistics
########################## ########## #######
background_dump_dest=C:\or acle\produ ct\10.2.0\ admin\BDA\ bdump
core_dump_dest=C:\oracle\p roduct\10. 2.0\admin\ BDA\cdump
user_dump_dest=C:\oracle\p roduct\10. 2.0\admin\ BDA\udump
Â
########################## ########## #######
# File Configuration
########################## ########## #######
control_files=("C:\oracle\ product\10 .2.0\orada ta\BDA\CON TROL01.CTL ", "C:\oracle\product\10.2.0\ oradata\BD A\CONTROL0 2.CTL", "C:\oracle\product\10.2.0\ oradata\BD A\CONTROL0 3.CTL")
db_recovery_file_dest=C:\o racle\prod uct\10.2.0 \flash_rec overy_area
db_recovery_file_dest_size =214748364 8
Â
########################## ########## #######
# Job Queues
########################## ########## #######
Â
########################## ########## #######
# Miscellaneous
########################## ########## #######
compatible=10.1.0.2.0
Â
########################## ########## #######
# Pools
########################## ########## #######
java_pool_size=50331648
large_pool_size=8388608
shared_pool_size=83886080
Â
########################## ########## #######
# Processes and Sessions
########################## ########## #######
processes=150
Â
########################## ########## #######
# Security and Auditing
########################## ########## #######
remote_login_passwordfile= EXCLUSIVE
Â
########################## ########## #######
# Shared Server
########################## ########## #######
dispatchers="(PROTOCOL=TCP ) (SERVICE=BDAXDB)"
Â
########################## ########## #######
# Sort, Hash Joins, Bitmap Indexes
########################## ########## #######
pga_aggregate_target=25165 824
sort_area_size=65536
Â
########################## ########## #######
# System Managed Undo and Rollback Segments
########################## ########## #######
undo_management=AUTO
undo_tablespace=UNDOTBS1
Â
_no_recovery_through_reset logs=true
////////////////////////// ////////// ////////// //////
Does anyone know what might be going on here? I'm really stuck. Attached are my log files. Actually, I don't see a way to attach files to a post. I'll paste the contents below.
Thank you very much,
Julie Tittler
//////////////////////////
FILE: Â cloneDBCreation.log
//////////////////////////
SQL> Create controlfile reuse set database "BDA"
 2  MAXINSTANCES 8
 3  MAXLOGHISTORY 1
 4  MAXLOGFILES 16
 5  MAXLOGMEMBERS 3
 6  MAXDATAFILES 100
 7  Datafile
 8  'C:\oracle\product\10.2.0\
 9  'C:\oracle\product\10.2.0\
 10  'C:\oracle\product\10.2.0\
 11  'C:\oracle\product\10.2.0\
 12  'C:\oracle\product\10.2.0\
 13  LOGFILE GROUP 1 ('C:\oracle\product\10.2.0
 14  GROUP 2 ('C:\oracle\product\10.2.0
 15  GROUP 3 ('C:\oracle\product\10.2.0
Control file created.
SQL> exec dbms_backup_restore.zerodb
PL/SQL procedure successfully completed.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount pfile="C:\oracle\product\1
ORACLE instance started.
Total System Global Area  171966464 bytes                   Â
Fixed Size          1247924 bytes                   Â
Variable Size       142607692 bytes                   Â
Database Buffers      25165824 bytes                   Â
Redo Buffers         2945024 bytes                   Â
SQL> Create controlfile reuse set database "BDA"
 2  MAXINSTANCES 8
 3  MAXLOGHISTORY 1
 4  MAXLOGFILES 16
 5  MAXLOGMEMBERS 3
 6  MAXDATAFILES 100
 7  Datafile
 8  'C:\oracle\product\10.2.0\
 9  'C:\oracle\product\10.2.0\
 10  'C:\oracle\product\10.2.0\
 11  'C:\oracle\product\10.2.0\
 12  'C:\oracle\product\10.2.0\
 13  LOGFILE GROUP 1 ('C:\oracle\product\10.2.0
 14  GROUP 2 ('C:\oracle\product\10.2.0
 15  GROUP 3 ('C:\oracle\product\10.2.0
Control file created.
SQL> alter system enable restricted session;
System altered.
SQL> alter database "BDA" open resetlogs;
alter database "BDA" open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> alter database rename global_name to "BDA";
ERROR:
ORA-03114: not connected to ORACLE
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\oracle\product\10.2.0\
ERROR:
ORA-03114: not connected to ORACLE
SQL> select tablespace_name from dba_tablespaces where tablespace_name='USERS';
ERROR:
ORA-03114: not connected to ORACLE
SQL> select sid, program, serial#, username from v$session;
ERROR:
ORA-03114: not connected to ORACLE
SQL> alter database character set INTERNAL_CONVERT WE8MSWIN1252;
ERROR:
ORA-03114: not connected to ORACLE
SQL> alter database national character set INTERNAL_CONVERT AL16UTF16;
ERROR:
ORA-03114: not connected to ORACLE
SQL> alter user sys identified by "&&sysPassword";
ERROR:
ORA-03114: not connected to ORACLE
SQL> alter user system identified by "&&systemPassword";
ERROR:
ORA-03114: not connected to ORACLE
SQL> alter system disable restricted session;
ERROR:
ORA-03114: not connected to ORACLE
SQL> @C:\oracle\product\10.2.0\
SQL> connect "SYS"/"&&sysPassword" as SYSDBA
Connected to an idle instance.
SQL> set echo on
SQL> spool C:\oracle\product\10.2.0\a
//////////////////////////
//////////////////////////
FILE: Â alertBDA.log
//////////////////////////
Dump file c:\oracle\product\10.2.0\a
Sun May 21 09:46:01 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU Â Â Â Â Â Â Â Â : 1 - type 586
Process Affinity   : 0x00000000
Memory (Avail/Total): Ph:141M/511M, Ph+PgF:869M/1249M, VA:1941M/2047M
Sun May 21 09:46:01 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
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     = 83886080
 large_pool_size      = 8388608
 java_pool_size      = 50331648
 control_files       = C:\ORACLE\PRODUCT\10.2.0\O
 db_block_size       = 8192
 db_cache_size       = 25165824
 compatible        = 10.1.0.2.0
 db_file_multiblock_read_co
 db_recovery_file_dest   = C:\oracle\product\10.2.0\f
 db_recovery_file_dest_size
 undo_management      = AUTO
 undo_tablespace      = UNDOTBS1
 remote_login_passwordfile=
 db_domain         =
 dispatchers        = (PROTOCOL=TCP) (SERVICE=BDAXDB)
 job_queue_processes    = 10
 background_dump_dest   = C:\ORACLE\PRODUCT\10.2.0\A
 user_dump_dest      = C:\ORACLE\PRODUCT\10.2.0\A
 core_dump_dest      = C:\ORACLE\PRODUCT\10.2.0\A
 sort_area_size      = 65536
 db_name          = BDA
 open_cursors       = 300
 pga_aggregate_target   = 25165824
MMAN started with pid=4, OS id=3160
PSP0 started with pid=3, OS id=1788
PMON started with pid=2, OS id=3188
DBW0 started with pid=5, OS id=564
LGWR started with pid=6, OS id=1332
CKPT started with pid=7, OS id=664
SMON started with pid=8, OS id=3788
RECO started with pid=9, OS id=4076
CJQ0 started with pid=10, OS id=3492
MMON started with pid=11, OS id=2896
Sun May 21 09:46:08 2006
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR
MMNL started with pid=12, OS id=2900
Sun May 21 09:46:08 2006
starting up 1 shared server(s) ...
Sun May 21 09:46:15 2006
The input backup piece C:\ORACLE\PRODUCT\10.2.0\D
Full restore complete of datafile 5 to datafile copy C:\ORACLE\PRODUCT\10.2.0\O
 checkpoint is 625921
Full restore complete of datafile 4 to datafile copy C:\ORACLE\PRODUCT\10.2.0\O
 checkpoint is 625921
Full restore complete of datafile 2 to datafile copy C:\ORACLE\PRODUCT\10.2.0\O
 checkpoint is 625921
Sun May 21 09:46:59 2006
Full restore complete of datafile 3 to datafile copy C:\ORACLE\PRODUCT\10.2.0\O
 checkpoint is 625921
Sun May 21 09:47:24 2006
Full restore complete of datafile 1 to datafile copy C:\ORACLE\PRODUCT\10.2.0\O
 checkpoint is 625921
Sun May 21 09:47:24 2006
Create controlfile reuse set database "BDA"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\
'C:\oracle\product\10.2.0\
'C:\oracle\product\10.2.0\
'C:\oracle\product\10.2.0\
'C:\oracle\product\10.2.0\
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0
GROUP 2 ('C:\oracle\product\10.2.0
GROUP 3 ('C:\oracle\product\10.2.0
Sun May 21 09:47:24 2006
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Setting recovery target incarnation to 1
Sun May 21 09:47:28 2006
Successful mount of redo thread 1, with mount id 1469665644
Sun May 21 09:47:28 2006
Completed: Create controlfile reuse set database "BDA"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\
'C:\oracle\product\10.2.0\
'C:\oracle\product\10.2.0\
'C:\oracle\product\10.2.0\
'C:\oracle\product\10.2.0\
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0
GROUP 2 ('C:\oracle\product\10.2.0
GROUP 3 ('C:\oracle\product\10.2.0
Shutting down instance: further logons disabled
Sun May 21 09:47:29 2006
Stopping background process CJQ0
Sun May 21 09:47:29 2006
Stopping background process MMNL
Sun May 21 09:47:30 2006
Stopping background process MMON
Sun May 21 09:47:30 2006
Shutting down instance (immediate)
License high water mark = 1
Sun May 21 09:47:30 2006
Stopping Job queue slave processes
Sun May 21 09:47:30 2006
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
Waiting for shared server 'S000' to die
All dispatchers and shared servers shutdown
Sun May 21 09:47:31 2006
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Sun May 21 09:47:31 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sun May 21 09:47:33 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
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     = 83886080
 large_pool_size      = 8388608
 java_pool_size      = 50331648
 control_files       = C:\ORACLE\PRODUCT\10.2.0\O
 db_block_size       = 8192
 db_cache_size       = 25165824
 compatible        = 10.1.0.2.0
 db_file_multiblock_read_co
 db_recovery_file_dest   = C:\oracle\product\10.2.0\f
 db_recovery_file_dest_size
 _no_recovery_through_reset
 undo_management      = AUTO
 undo_tablespace      = UNDOTBS1
 remote_login_passwordfile=
 db_domain         =
 dispatchers        = (PROTOCOL=TCP) (SERVICE=BDAXDB)
 background_dump_dest   = C:\ORACLE\PRODUCT\10.2.0\A
 user_dump_dest      = C:\ORACLE\PRODUCT\10.2.0\A
 core_dump_dest      = C:\ORACLE\PRODUCT\10.2.0\A
 sort_area_size      = 65536
 db_name          = BDA
 open_cursors       = 300
 pga_aggregate_target   = 25165824
PMON started with pid=2, OS id=3212
PSP0 started with pid=3, OS id=4044
MMAN started with pid=4, OS id=440
DBW0 started with pid=5, OS id=4024
LGWR started with pid=6, OS id=3584
CKPT started with pid=7, OS id=1592
SMON started with pid=8, OS id=820
RECO started with pid=9, OS id=3512
MMON started with pid=10, OS id=2412
MMNL started with pid=11, OS id=1568
Sun May 21 09:47:36 2006
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR
starting up 1 shared server(s) ...
Sun May 21 09:47:36 2006
Create controlfile reuse set database "BDA"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\
'C:\oracle\product\10.2.0\
'C:\oracle\product\10.2.0\
'C:\oracle\product\10.2.0\
'C:\oracle\product\10.2.0\
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0
GROUP 2 ('C:\oracle\product\10.2.0
GROUP 3 ('C:\oracle\product\10.2.0
Sun May 21 09:47:36 2006
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Setting recovery target incarnation to 1
Sun May 21 09:47:39 2006
Successful mount of redo thread 1, with mount id 1469634680
Sun May 21 09:47:39 2006
Completed: Create controlfile reuse set database "BDA"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\
'C:\oracle\product\10.2.0\
'C:\oracle\product\10.2.0\
'C:\oracle\product\10.2.0\
'C:\oracle\product\10.2.0\
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0
GROUP 2 ('C:\oracle\product\10.2.0
GROUP 3 ('C:\oracle\product\10.2.0
Sun May 21 09:47:39 2006
Stopping background process MMNL
Sun May 21 09:47:40 2006
Stopping background process MMON
Sun May 21 09:47:40 2006
db_recovery_file_dest_size
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.
Sun May 21 09:47:41 2006
Starting background process MMON
MMON started with pid=10, OS id=1692
Sun May 21 09:47:41 2006
Starting background process MMNL
Sun May 21 09:47:41 2006
ALTER SYSTEM enable restricted session;
MMNL started with pid=11, OS id=432
Sun May 21 09:47:41 2006
alter database "BDA" open resetlogs
Sun May 21 09:47:41 2006
RESETLOGS after incomplete recovery UNTIL CHANGE 625921
Sun May 21 09:47:41 2006
Errors in file c:\oracle\product\10.2.0\a
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Sun May 21 09:47:42 2006
Errors in file c:\oracle\product\10.2.0\a
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Sun May 21 09:47:43 2006
Errors in file c:\oracle\product\10.2.0\a
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Sun May 21 09:47:45 2006
Setting recovery target incarnation to 2
Sun May 21 09:47:48 2006
Assigning activation ID 1469634680 (0x5798d878)
Thread 1 opened at log sequence 1
 Current log# 3 seq# 1 mem# 0: C:\ORACLE\PRODUCT\10.2.0\O
Successful open of redo thread 1
Sun May 21 09:47:49 2006
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun May 21 09:47:49 2006
SMON: enabling cache recovery
Sun May 21 09:47:53 2006
Errors in file c:\oracle\product\10.2.0\a
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Sun May 21 09:47:53 2006
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Sun May 21 09:47:54 2006
Errors in file c:\oracle\product\10.2.0\a
ORA-00704: bootstrap process failure
Sun May 21 09:47:54 2006
Errors in file c:\oracle\product\10.2.0\a
ORA-00704: bootstrap process failure
Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\a
ORA-00704: bootstrap process failure
Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\a
ORA-00704: bootstrap process failure
Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\a
ORA-00704: bootstrap process failure
Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\a
ORA-00704: bootstrap process failure
Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\a
ORA-00704: bootstrap process failure
Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\a
ORA-00704: bootstrap process failure
Instance terminated by USER, pid = 3416
ORA-1092 signalled during: alter database "BDA" open resetlogs...
Sun May 21 09:47:58 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
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     = 83886080
 large_pool_size      = 8388608
 java_pool_size      = 50331648
 control_files       = C:\ORACLE\PRODUCT\10.2.0\O
 db_block_size       = 8192
 db_cache_size       = 25165824
 compatible        = 10.1.0.2.0
 db_file_multiblock_read_co
 db_recovery_file_dest   = C:\oracle\product\10.2.0\f
 db_recovery_file_dest_size
 undo_management      = AUTO
 undo_tablespace      = UNDOTBS1
 remote_login_passwordfile=
 db_domain         =
 dispatchers        = (PROTOCOL=TCP) (SERVICE=BDAXDB)
 job_queue_processes    = 10
 background_dump_dest   = C:\ORACLE\PRODUCT\10.2.0\A
 user_dump_dest      = C:\ORACLE\PRODUCT\10.2.0\A
 core_dump_dest      = C:\ORACLE\PRODUCT\10.2.0\A
 sort_area_size      = 65536
 db_name          = BDA
 open_cursors       = 300
 pga_aggregate_target   = 25165824
PMON started with pid=2, OS id=3800
PSP0 started with pid=3, OS id=3880
MMAN started with pid=4, OS id=1804
DBW0 started with pid=5, OS id=2480
LGWR started with pid=6, OS id=360
CKPT started with pid=7, OS id=3484
SMON started with pid=8, OS id=3840
RECO started with pid=9, OS id=4072
CJQ0 started with pid=10, OS id=3476
MMON started with pid=11, OS id=2388
MMNL started with pid=12, OS id=1968
Sun May 21 09:47:59 2006
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR
starting up 1 shared server(s) ...
Sun May 21 09:47:59 2006
ALTER DATABASE Â MOUNT
Sun May 21 09:48:03 2006
Setting recovery target incarnation to 2
Sun May 21 09:48:04 2006
Successful mount of redo thread 1, with mount id 1469631887
Sun May 21 09:48:04 2006
Database mounted in Exclusive Mode
Completed: ALTER DATABASE Â MOUNT
Sun May 21 09:48:04 2006
ALTER DATABASE OPEN
Sun May 21 09:48:05 2006
ORA-1113 signalled during: ALTER DATABASE OPEN...
Sun May 21 10:03:05 2006
db_recovery_file_dest_size
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.
//////////////////////////
//////////////////////////
FILE: Â bda_ora_3416.trc
//////////////////////////
Dump file c:\oracle\product\10.2.0\a
Sun May 21 09:47:38 2006
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 Â Â Â Â Â Â Â Â : 1 - type 586
Process Affinity   : 0x00000000
Memory (Avail/Total): Ph:84M/511M, Ph+PgF:681M/1249M, VA:1739M/2047M
Instance name: bda
Redo thread mounted by this instance: 0 <none>
Oracle process number: 14
Windows thread id: 3416, image: ORACLE.EXE (SHAD)
*** SERVICE NAME:() 2006-05-21 09:47:38.193
*** SESSION ID:(160.1) 2006-05-21 09:47:38.193
kccsga_update_ckpt: num_1 = 8, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
Control file created with size 424 blocks
Prior to RESETLOGS processing...
ALTER SYSTEM ARCHIVE LOG ALL USING BACKUP CONTROLFILE start
Database is not in archivelog mode
ALTER SYSTEM ARCHIVE LOG ALL USING BACKUP CONTROLFILE complete
*** 2006-05-21 09:47:41.468
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'C:\ORACLE\PRODUCT\10.2.0\
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
*** 2006-05-21 09:47:53.855
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
//////////////////////////
//////////////////////////
FILE: Â init.ora
//////////////////////////
##########################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##########################
Â
##########################
# Cache and I/O
##########################
db_block_size=8192
db_cache_size=25165824
db_file_multiblock_read_co
Â
##########################
# Cursors and Library Cache
##########################
open_cursors=300
Â
##########################
# Database Identification
##########################
db_domain=""
db_name=BDA
Â
##########################
# Diagnostics and Statistics
##########################
background_dump_dest=C:\or
core_dump_dest=C:\oracle\p
user_dump_dest=C:\oracle\p
Â
##########################
# File Configuration
##########################
control_files=("C:\oracle\
db_recovery_file_dest=C:\o
db_recovery_file_dest_size
Â
##########################
# Job Queues
##########################
job_queue_processes=10
Â
##########################
# Miscellaneous
##########################
compatible=10.1.0.2.0
Â
##########################
# Pools
##########################
java_pool_size=50331648
large_pool_size=8388608
shared_pool_size=83886080
Â
##########################
# Processes and Sessions
##########################
processes=150
Â
##########################
# Security and Auditing
##########################
remote_login_passwordfile=
Â
##########################
# Shared Server
##########################
dispatchers="(PROTOCOL=TCP
Â
##########################
# Sort, Hash Joins, Bitmap Indexes
##########################
pga_aggregate_target=25165
sort_area_size=65536
Â
##########################
# System Managed Undo and Rollback Segments
##########################
undo_management=AUTO
undo_tablespace=UNDOTBS1
//////////////////////////
//////////////////////////
FILE: Â initBDAtemp.ora
//////////////////////////
##########################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##########################
Â
##########################
# Cache and I/O
##########################
db_block_size=8192
db_cache_size=25165824
db_file_multiblock_read_co
Â
##########################
# Cursors and Library Cache
##########################
open_cursors=300
Â
##########################
# Database Identification
##########################
db_domain=""
db_name=BDA
Â
##########################
# Diagnostics and Statistics
##########################
background_dump_dest=C:\or
core_dump_dest=C:\oracle\p
user_dump_dest=C:\oracle\p
Â
##########################
# File Configuration
##########################
control_files=("C:\oracle\
db_recovery_file_dest=C:\o
db_recovery_file_dest_size
Â
##########################
# Job Queues
##########################
Â
##########################
# Miscellaneous
##########################
compatible=10.1.0.2.0
Â
##########################
# Pools
##########################
java_pool_size=50331648
large_pool_size=8388608
shared_pool_size=83886080
Â
##########################
# Processes and Sessions
##########################
processes=150
Â
##########################
# Security and Auditing
##########################
remote_login_passwordfile=
Â
##########################
# Shared Server
##########################
dispatchers="(PROTOCOL=TCP
Â
##########################
# Sort, Hash Joins, Bitmap Indexes
##########################
pga_aggregate_target=25165
sort_area_size=65536
Â
##########################
# System Managed Undo and Rollback Segments
##########################
undo_management=AUTO
undo_tablespace=UNDOTBS1
Â
_no_recovery_through_reset
//////////////////////////
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER