[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Problems creating a db instance from a template using DBCA in 10G: ORA-01092

Posted on 2006-05-22
2
Medium Priority
?
7,899 Views
Last Modified: 2010-01-19
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\BDA\SYSTEM01.DBF',
  9  'C:\oracle\product\10.2.0\oradata\BDA\UNDOTBS01.DBF',
 10  'C:\oracle\product\10.2.0\oradata\BDA\SYSAUX01.DBF',
 11  'C:\oracle\product\10.2.0\oradata\BDA\USERS01.DBF',
 12  'C:\oracle\product\10.2.0\oradata\BDA\BDA_DB_ORACLE.DBF'
 13  LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\BDA\REDO01.LOG') SIZE 10240K,
 14  GROUP 2 ('C:\oracle\product\10.2.0\oradata\BDA\REDO02.LOG') SIZE 10240K,
 15  GROUP 3 ('C:\oracle\product\10.2.0\oradata\BDA\REDO03.LOG') SIZE 10240K RESETLOGS;

Control file created.

SQL> exec dbms_backup_restore.zerodbid(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\10.2.0\admin\BDA\scripts\initBDATemp.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\BDA\SYSTEM01.DBF',
  9  'C:\oracle\product\10.2.0\oradata\BDA\UNDOTBS01.DBF',
 10  'C:\oracle\product\10.2.0\oradata\BDA\SYSAUX01.DBF',
 11  'C:\oracle\product\10.2.0\oradata\BDA\USERS01.DBF',
 12  'C:\oracle\product\10.2.0\oradata\BDA\BDA_DB_ORACLE.DBF'
 13  LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\BDA\REDO01.LOG') SIZE 10240K,
 14  GROUP 2 ('C:\oracle\product\10.2.0\oradata\BDA\REDO02.LOG') SIZE 10240K,
 15  GROUP 3 ('C:\oracle\product\10.2.0\oradata\BDA\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\BDA\TEMP01.DBF' 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\postScripts.sql
SQL> connect "SYS"/"&&sysPassword" as SYSDBA
Connected to an idle instance.
SQL> set echo on
SQL> spool C:\oracle\product\10.2.0\admin\BDA\scripts\postScripts.log
///////////////////////////////////////////////////////////////////////////////////

//////////////////////////////////////
FILE:  alertBDA.log
//////////////////////////////////////
Dump file c:\oracle\product\10.2.0\admin\bda\bdump\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\ORADATA\BDA\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\BDA\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\BDA\CONTROL03.CTL
  db_block_size            = 8192
  db_cache_size            = 25165824
  compatible               = 10.1.0.2.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = C:\oracle\product\10.2.0\flash_recovery_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\ADMIN\BDA\BDUMP
  user_dump_dest           = C:\ORACLE\PRODUCT\10.2.0\ADMIN\BDA\UDUMP
  core_dump_dest           = C:\ORACLE\PRODUCT\10.2.0\ADMIN\BDA\CDUMP
  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)(PROTOCOL=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\DB_1\ASSISTANTS\DBCA\TEMPLATES\BDA_TEMPLATE.DFB is in compressed format.
Full restore complete of datafile 5 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\BDA\BDA_DB_ORACLE.DBF.  Elapsed time: 0:00:03
  checkpoint is 625921
Full restore complete of datafile 4 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\BDA\USERS01.DBF.  Elapsed time: 0:00:05
  checkpoint is 625921
Full restore complete of datafile 2 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\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\ORADATA\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\ORADATA\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\BDA\SYSTEM01.DBF',
'C:\oracle\product\10.2.0\oradata\BDA\UNDOTBS01.DBF',
'C:\oracle\product\10.2.0\oradata\BDA\SYSAUX01.DBF',
'C:\oracle\product\10.2.0\oradata\BDA\USERS01.DBF',
'C:\oracle\product\10.2.0\oradata\BDA\BDA_DB_ORACLE.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\BDA\REDO01.LOG') SIZE 10240K,
GROUP 2 ('C:\oracle\product\10.2.0\oradata\BDA\REDO02.LOG') SIZE 10240K,
GROUP 3 ('C:\oracle\product\10.2.0\oradata\BDA\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\BDA\SYSTEM01.DBF',
'C:\oracle\product\10.2.0\oradata\BDA\UNDOTBS01.DBF',
'C:\oracle\product\10.2.0\oradata\BDA\SYSAUX01.DBF',
'C:\oracle\product\10.2.0\oradata\BDA\USERS01.DBF',
'C:\oracle\product\10.2.0\oradata\BDA\BDA_DB_ORACLE.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\BDA\REDO01.LOG') SIZE 10240K,
GROUP 2 ('C:\oracle\product\10.2.0\oradata\BDA\REDO02.LOG') SIZE 10240K,
GROUP 3 ('C:\oracle\product\10.2.0\oradata\BDA\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\ORADATA\BDA\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\BDA\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\BDA\CONTROL03.CTL
  db_block_size            = 8192
  db_cache_size            = 25165824
  compatible               = 10.1.0.2.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = C:\oracle\product\10.2.0\flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  _no_recovery_through_resetlogs= 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\ADMIN\BDA\BDUMP
  user_dump_dest           = C:\ORACLE\PRODUCT\10.2.0\ADMIN\BDA\UDUMP
  core_dump_dest           = C:\ORACLE\PRODUCT\10.2.0\ADMIN\BDA\CDUMP
  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)(PROTOCOL=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\BDA\SYSTEM01.DBF',
'C:\oracle\product\10.2.0\oradata\BDA\UNDOTBS01.DBF',
'C:\oracle\product\10.2.0\oradata\BDA\SYSAUX01.DBF',
'C:\oracle\product\10.2.0\oradata\BDA\USERS01.DBF',
'C:\oracle\product\10.2.0\oradata\BDA\BDA_DB_ORACLE.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\BDA\REDO01.LOG') SIZE 10240K,
GROUP 2 ('C:\oracle\product\10.2.0\oradata\BDA\REDO02.LOG') SIZE 10240K,
GROUP 3 ('C:\oracle\product\10.2.0\oradata\BDA\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\BDA\SYSTEM01.DBF',
'C:\oracle\product\10.2.0\oradata\BDA\UNDOTBS01.DBF',
'C:\oracle\product\10.2.0\oradata\BDA\SYSAUX01.DBF',
'C:\oracle\product\10.2.0\oradata\BDA\USERS01.DBF',
'C:\oracle\product\10.2.0\oradata\BDA\BDA_DB_ORACLE.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\BDA\REDO01.LOG') SIZE 10240K,
GROUP 2 ('C:\oracle\product\10.2.0\oradata\BDA\REDO02.LOG') SIZE 10240K,
GROUP 3 ('C:\oracle\product\10.2.0\oradata\BDA\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\admin\bda\udump\bda_ora_3416.trc:
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\BDA\REDO01.LOG'
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\admin\bda\udump\bda_ora_3416.trc:
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\BDA\REDO02.LOG'
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\admin\bda\udump\bda_ora_3416.trc:
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\BDA\REDO03.LOG'
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\ORADATA\BDA\REDO03.LOG
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\admin\bda\udump\bda_ora_3416.trc:
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\admin\bda\bdump\bda_lgwr_3584.trc:
ORA-00704: bootstrap process failure

Sun May 21 09:47:54 2006
Errors in file c:\oracle\product\10.2.0\admin\bda\bdump\bda_reco_3512.trc:
ORA-00704: bootstrap process failure

Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\admin\bda\bdump\bda_smon_820.trc:
ORA-00704: bootstrap process failure

Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\admin\bda\bdump\bda_psp0_4044.trc:
ORA-00704: bootstrap process failure

Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\admin\bda\bdump\bda_mman_440.trc:
ORA-00704: bootstrap process failure

Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\admin\bda\bdump\bda_ckpt_1592.trc:
ORA-00704: bootstrap process failure

Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\admin\bda\bdump\bda_dbw0_4024.trc:
ORA-00704: bootstrap process failure

Sun May 21 09:47:55 2006
Errors in file c:\oracle\product\10.2.0\admin\bda\bdump\bda_pmon_3212.trc:
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\ORADATA\BDA\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\BDA\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\BDA\CONTROL03.CTL
  db_block_size            = 8192
  db_cache_size            = 25165824
  compatible               = 10.1.0.2.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = C:\oracle\product\10.2.0\flash_recovery_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\ADMIN\BDA\BDUMP
  user_dump_dest           = C:\ORACLE\PRODUCT\10.2.0\ADMIN\BDA\UDUMP
  core_dump_dest           = C:\ORACLE\PRODUCT\10.2.0\ADMIN\BDA\CDUMP
  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)(PROTOCOL=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\admin\bda\udump\bda_ora_3416.trc
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\BDA\REDO01.LOG'
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\BDA\REDO02.LOG'
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\BDA\REDO03.LOG'
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_count=16
 
###########################################
# Cursors and Library Cache
###########################################
open_cursors=300
 
###########################################
# Database Identification
###########################################
db_domain=""
db_name=BDA
 
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=C:\oracle\product\10.2.0\admin\BDA\bdump
core_dump_dest=C:\oracle\product\10.2.0\admin\BDA\cdump
user_dump_dest=C:\oracle\product\10.2.0\admin\BDA\udump
 
###########################################
# File Configuration
###########################################
control_files=("C:\oracle\product\10.2.0\oradata\BDA\CONTROL01.CTL", "C:\oracle\product\10.2.0\oradata\BDA\CONTROL02.CTL", "C:\oracle\product\10.2.0\oradata\BDA\CONTROL03.CTL")
db_recovery_file_dest=C:\oracle\product\10.2.0\flash_recovery_area
db_recovery_file_dest_size=2147483648
 
###########################################
# 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=25165824
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_count=16
 
###########################################
# Cursors and Library Cache
###########################################
open_cursors=300
 
###########################################
# Database Identification
###########################################
db_domain=""
db_name=BDA
 
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=C:\oracle\product\10.2.0\admin\BDA\bdump
core_dump_dest=C:\oracle\product\10.2.0\admin\BDA\cdump
user_dump_dest=C:\oracle\product\10.2.0\admin\BDA\udump
 
###########################################
# File Configuration
###########################################
control_files=("C:\oracle\product\10.2.0\oradata\BDA\CONTROL01.CTL", "C:\oracle\product\10.2.0\oradata\BDA\CONTROL02.CTL", "C:\oracle\product\10.2.0\oradata\BDA\CONTROL03.CTL")
db_recovery_file_dest=C:\oracle\product\10.2.0\flash_recovery_area
db_recovery_file_dest_size=2147483648
 
###########################################
# 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=25165824
sort_area_size=65536
 
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1
 
_no_recovery_through_resetlogs=true
////////////////////////////////////////////////////
0
Comment
Question by:jtittler
2 Comments
 
LVL 1

Accepted Solution

by:
pcoats earned 1500 total points
ID: 16734949
The one error that keeps sticking out is:

ORA-39700: database must be opened with UPGRADE option.

from there it is complaining that it cannot find files. Try using the upgrade option when opening the database. See more info below from Oracle.

ORA-39700: database must be opened with UPGRADE option.
Cause: The database has not been upgraded, but a standard database open was attempted.
Action: Use the UPGRADE option when opening the database to indicate that the database is being opened for upgrade.
0
 

Author Comment

by:jtittler
ID: 16757400
Your upgrade idea got me to thinking that I had a newer version of Oracle than the person who made the template. It turns out that that's what the problem was. He had 10.1.0.1 and I had 10.2.0.1. I uninstalled Oracle, reinstalled the right version, and the db created just fine. Thanks for the nudge in the right direction.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question