Home » RDBMS Server » Server Administration » ORA-00214: (Windows)
| ORA-00214: [message #465500] |
Wed, 14 July 2010 07:29  |
maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai
|
Member |
|
|
Hi
Please See the below session
=======================================================
SQL> shut immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> conn sys/ace123 as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 150997892 bytes
Database Buffers 452984832 bytes
Redo Buffers 7135232 bytes
ORA-00214: control file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL'
version 1656 inconsistent with file
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL' version 1646
=========================================================
Can anyone tell me the solution.
Thanks & Regards
Manish
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-00214: [message #465603 is a reply to message #465500] |
Thu, 15 July 2010 00:00  |
maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai
|
Member |
|
|
Dump file d:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log
Wed Jun 09 17:19:45 2010
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1669M/3317M, Ph+PgF:4311M/5206M, VA:1942M/2047M
Wed Jun 09 17:19:45 2010
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
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=2344
PSP0 started with pid=3, OS id=1308
MMAN started with pid=4, OS id=1304
DBW0 started with pid=5, OS id=2260
LGWR started with pid=6, OS id=3788
CKPT started with pid=7, OS id=1056
SMON started with pid=8, OS id=576
RECO started with pid=9, OS id=908
CJQ0 started with pid=10, OS id=432
MMON started with pid=11, OS id=4072
Wed Jun 09 17:19:46 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Jun 09 17:19:46 2010
starting up 1 shared server(s) ...
Wed Jun 09 17:19:46 2010
The input backup piece D:\ORACLE\PRODUCT\10.2.0\DB_1\ASSISTANTS\DBCA\TEMPLATES\SEED_DATABASE.DFB is in compressed format.
MMNL started with pid=12, OS id=3176
Full restore complete of datafile 4 to datafile copy D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF. Elapsed time: 0:00:01
checkpoint is 534906
Full restore complete of datafile 2 to datafile copy D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF. Elapsed time: 0:00:03
checkpoint is 534906
Wed Jun 09 17:20:08 2010
Full restore complete of datafile 3 to datafile copy D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF. Elapsed time: 0:00:22
checkpoint is 534906
Wed Jun 09 17:20:27 2010
Full restore complete of datafile 1 to datafile copy D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF. Elapsed time: 0:00:40
checkpoint is 534906
Wed Jun 09 17:20:27 2010
Create controlfile reuse set database "ORCL"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'D:\oracle\product\10.2.0\oradata\ORCL\SYSTEM01.DBF',
'D:\oracle\product\10.2.0\oradata\ORCL\UNDOTBS01.DBF',
'D:\oracle\product\10.2.0\oradata\ORCL\SYSAUX01.DBF',
'D:\oracle\product\10.2.0\oradata\ORCL\USERS01.DBF'
LOGFILE GROUP 1 ('D:\oracle\product\10.2.0/oradata/ORCL/redo01.log') SIZE 51200K,
GROUP 2 ('D:\oracle\product\10.2.0/oradata/ORCL/redo02.log') SIZE 51200K,
GROUP 3 ('D:\oracle\product\10.2.0/oradata/ORCL/redo03.log') SIZE 51200K RESETLOGS
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
Wed Jun 09 17:20:28 2010
Successful mount of redo thread 1, with mount id 1249025243
Wed Jun 09 17:20:28 2010
Completed: Create controlfile reuse set database "ORCL"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'D:\oracle\product\10.2.0\oradata\ORCL\SYSTEM01.DBF',
'D:\oracle\product\10.2.0\oradata\ORCL\UNDOTBS01.DBF',
'D:\oracle\product\10.2.0\oradata\ORCL\SYSAUX01.DBF',
'D:\oracle\product\10.2.0\oradata\ORCL\USERS01.DBF'
LOGFILE GROUP 1 ('D:\oracle\product\10.2.0/oradata/ORCL/redo01.log') SIZE 51200K,
GROUP 2 ('D:\oracle\product\10.2.0/oradata/ORCL/redo02.log') SIZE 51200K,
GROUP 3 ('D:\oracle\product\10.2.0/oradata/ORCL/redo03.log') SIZE 51200K RESETLOGS
Shutting down instance: further logons disabled
Wed Jun 09 17:20:29 2010
Stopping background process CJQ0
Wed Jun 09 17:20:30 2010
Stopping background process MMNL
Wed Jun 09 17:20:31 2010
Stopping background process MMON
Wed Jun 09 17:20:32 2010
Shutting down instance (immediate)
License high water mark = 1
Wed Jun 09 17:20:32 2010
Stopping Job queue slave processes
Wed Jun 09 17:20:32 2010
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jun 09 17:20:34 2010
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Wed Jun 09 17:20:34 2010
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
Wed Jun 09 17:20:36 2010
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
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=276
PSP0 started with pid=3, OS id=1072
MMAN started with pid=4, OS id=2952
DBW0 started with pid=5, OS id=408
LGWR started with pid=6, OS id=3908
CKPT started with pid=7, OS id=3592
SMON started with pid=8, OS id=684
RECO started with pid=9, OS id=3160
MMON started with pid=10, OS id=2584
Wed Jun 09 17:20:37 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=11, OS id=1084
Wed Jun 09 17:20:37 2010
starting up 1 shared server(s) ...
Wed Jun 09 17:20:37 2010
Create controlfile reuse set database "ORCL"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'D:\oracle\product\10.2.0\oradata\ORCL\SYSTEM01.DBF',
'D:\oracle\product\10.2.0\oradata\ORCL\UNDOTBS01.DBF',
'D:\oracle\product\10.2.0\oradata\ORCL\SYSAUX01.DBF',
'D:\oracle\product\10.2.0\oradata\ORCL\USERS01.DBF'
LOGFILE GROUP 1 ('D:\oracle\product\10.2.0/oradata/ORCL/redo01.log') SIZE 51200K,
GROUP 2 ('D:\oracle\product\10.2.0/oradata/ORCL/redo02.log') SIZE 51200K,
GROUP 3 ('D:\oracle\product\10.2.0/oradata/ORCL/redo03.log') SIZE 51200K RESETLOGS
Wed Jun 09 17:20:37 2010
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
Wed Jun 09 17:20:38 2010
Successful mount of redo thread 1, with mount id 1249021157
Wed Jun 09 17:20:38 2010
Completed: Create controlfile reuse set database "ORCL"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'D:\oracle\product\10.2.0\oradata\ORCL\SYSTEM01.DBF',
'D:\oracle\product\10.2.0\oradata\ORCL\UNDOTBS01.DBF',
'D:\oracle\product\10.2.0\oradata\ORCL\SYSAUX01.DBF',
'D:\oracle\product\10.2.0\oradata\ORCL\USERS01.DBF'
LOGFILE GROUP 1 ('D:\oracle\product\10.2.0/oradata/ORCL/redo01.log') SIZE 51200K,
GROUP 2 ('D:\oracle\product\10.2.0/oradata/ORCL/redo02.log') SIZE 51200K,
GROUP 3 ('D:\oracle\product\10.2.0/oradata/ORCL/redo03.log') SIZE 51200K RESETLOGS
Wed Jun 09 17:20:38 2010
Stopping background process MMNL
Wed Jun 09 17:20:39 2010
Stopping background process MMON
Starting background process MMON
Starting background process MMNL
MMON started with pid=10, OS id=2452
Wed Jun 09 17:20:40 2010
ALTER SYSTEM enable restricted session;
Wed Jun 09 17:20:40 2010
alter database "ORCL" open resetlogs
Wed Jun 09 17:20:40 2010
RESETLOGS after incomplete recovery UNTIL CHANGE 534906
Wed Jun 09 17:20:41 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2544.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\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.
MMNL started with pid=11, OS id=3240
Wed Jun 09 17:20:42 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2544.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\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.
Wed Jun 09 17:20:43 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_2544.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\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.
Wed Jun 09 17:20:44 2010
Setting recovery target incarnation to 2
Wed Jun 09 17:20:44 2010
Assigning activation ID 1249021157 (0x4a728ce5)
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
Wed Jun 09 17:20:45 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Jun 09 17:20:45 2010
SMON: enabling cache recovery
Wed Jun 09 17:20:45 2010
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Tablespace 'TEMP' #3 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Dictionary check complete
Wed Jun 09 17:20:45 2010
SMON: enabling tx recovery
Wed Jun 09 17:20:45 2010
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
This condition can occur when a backup controlfile has
been restored. It may be necessary to add files to these
tablespaces. That can be done using the SQL statement:
ALTER TABLESPACE <tablespace_name> ADD TEMPFILE
Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: TEMP
*********************************************************************
Database Characterset is US7ASCII
Threshold validation cannot be done before catproc is loaded.
Threshold validation cannot be done before catproc is loaded.
**********************************************************
WARNING: Files may exists in db_recovery_file_dest
that are not known to the database. Use the RMAN command
CATALOG RECOVERY AREA to re-catalog any such files.
One of the following events caused this:
1. A backup controlfile was restored.
2. A standby controlfile was restored.
3. The controlfile was re-created.
4. db_recovery_file_dest had previously been enabled and
then disabled.
**********************************************************
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=15, OS id=996
Wed Jun 09 17:20:48 2010
LOGSTDBY: Validating controlfile with logical metadata
Wed Jun 09 17:20:49 2010
LOGSTDBY: Validation complete
Global Name changed to ORCL
Completed: alter database "ORCL" open resetlogs
Wed Jun 09 17:20:51 2010
alter database rename global_name to "ORCL"
Completed: alter database rename global_name to "ORCL"
Wed Jun 09 17:20:51 2010
ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\oracle\product\10.2.0\oradata\ORCL\TEMP01.DBF' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\oracle\product\10.2.0\oradata\ORCL\TEMP01.DBF' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Wed Jun 09 17:20:51 2010
ALTER DATABASE DEFAULT TABLESPACE "USERS"
Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
Wed Jun 09 17:20:51 2010
alter database character set INTERNAL_CONVERT WE8MSWIN1252
Wed Jun 09 17:21:02 2010
Updating character set in controlfile to WE8MSWIN1252
Synchronizing connection with database character set information
Refreshing type attributes with new character set information
Completed: alter database character set INTERNAL_CONVERT WE8MSWIN1252
Wed Jun 09 17:21:07 2010
ALTER SYSTEM disable restricted session;
Wed Jun 09 17:21:08 2010
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.
Wed Jun 09 17:21:10 2010
Starting background process CJQ0
CJQ0 started with pid=20, OS id=2844
Wed Jun 09 17:22:07 2010
Starting background process EMN0
EMN0 started with pid=14, OS id=4016
Wed Jun 09 17:22:07 2010
Shutting down instance: further logons disabled
Wed Jun 09 17:22:09 2010
Stopping background process QMNC
Wed Jun 09 17:22:09 2010
Stopping background process CJQ0
Wed Jun 09 17:22:11 2010
Stopping background process MMNL
Wed Jun 09 17:22:12 2010
Stopping background process MMON
Wed Jun 09 17:22:13 2010
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Wed Jun 09 17:22:15 2010
ALTER DATABASE CLOSE NORMAL
Wed Jun 09 17:22:15 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Jun 09 17:22:15 2010
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Wed Jun 09 17:22:16 2010
Completed: ALTER DATABASE CLOSE NORMAL
Wed Jun 09 17:22:16 2010
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
Wed Jun 09 17:22:18 2010
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
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=3228
PSP0 started with pid=3, OS id=1060
MMAN started with pid=4, OS id=1608
DBW0 started with pid=5, OS id=3540
LGWR started with pid=6, OS id=3232
CKPT started with pid=7, OS id=3852
SMON started with pid=8, OS id=2872
RECO started with pid=9, OS id=3840
CJQ0 started with pid=10, OS id=536
MMON started with pid=11, OS id=3352
MMNL started with pid=12, OS id=3128
Wed Jun 09 17:22:19 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Jun 09 17:22:19 2010
ALTER DATABASE MOUNT
Wed Jun 09 17:22:23 2010
Setting recovery target incarnation to 2
Wed Jun 09 17:22:24 2010
Successful mount of redo thread 1, with mount id 1249023051
Wed Jun 09 17:22:24 2010
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Wed Jun 09 17:22:24 2010
ALTER DATABASE OPEN
Wed Jun 09 17:22:24 2010
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
Wed Jun 09 17:22:24 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Jun 09 17:22:24 2010
SMON: enabling cache recovery
Wed Jun 09 17:22:25 2010
Successfully onlined Undo Tablespace 1.
Wed Jun 09 17:22:25 2010
SMON: enabling tx recovery
Wed Jun 09 17:22:26 2010
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=4064
Wed Jun 09 17:22:30 2010
Completed: ALTER DATABASE OPEN
Wed Jun 09 17:22:30 2010
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.
Wed Jun 09 17:37:49 2010
Starting background process EMN0
EMN0 started with pid=15, OS id=1160
Wed Jun 09 17:37:49 2010
Shutting down instance: further logons disabled
Wed Jun 09 17:37:49 2010
Stopping background process QMNC
Wed Jun 09 17:37:50 2010
Stopping background process CJQ0
Wed Jun 09 17:37:51 2010
Stopping background process MMNL
Wed Jun 09 17:37:52 2010
Stopping background process MMON
Wed Jun 09 17:37:53 2010
Shutting down instance (normal)
License high water mark = 11
Wed Jun 09 17:37:53 2010
Stopping Job queue slave processes
Wed Jun 09 17:37:53 2010
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Wed Jun 09 17:37:55 2010
ALTER DATABASE CLOSE NORMAL
Wed Jun 09 17:37:55 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Jun 09 17:37:56 2010
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Wed Jun 09 17:37:56 2010
Completed: ALTER DATABASE CLOSE NORMAL
Wed Jun 09 17:37:56 2010
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Jun 09 17:38:18 2010
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 = 163577856
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 432013312
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=2372
PSP0 started with pid=3, OS id=288
MMAN started with pid=4, OS id=3336
DBW0 started with pid=5, OS id=3228
LGWR started with pid=6, OS id=2020
CKPT started with pid=7, OS id=3172
SMON started with pid=8, OS id=1452
RECO started with pid=9, OS id=3176
CJQ0 started with pid=10, OS id=500
MMON started with pid=11, OS id=3272
Wed Jun 09 17:38:18 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2244
Wed Jun 09 17:38:18 2010
starting up 1 shared server(s) ...
Wed Jun 09 17:38:18 2010
ALTER DATABASE MOUNT
Wed Jun 09 17:38:23 2010
Setting recovery target incarnation to 2
Wed Jun 09 17:38:23 2010
Successful mount of redo thread 1, with mount id 1249065482
Wed Jun 09 17:38:23 2010
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Wed Jun 09 17:38:23 2010
ALTER DATABASE OPEN
Wed Jun 09 17:38:24 2010
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
Wed Jun 09 17:38:24 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Jun 09 17:38:24 2010
SMON: enabling cache recovery
Wed Jun 09 17:38:24 2010
Successfully onlined Undo Tablespace 1.
Wed Jun 09 17:38:24 2010
SMON: enabling tx recovery
Wed Jun 09 17:38:25 2010
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=520
Wed Jun 09 17:38:29 2010
Completed: ALTER DATABASE OPEN
Wed Jun 09 17:38:29 2010
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.
Dump file d:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log
Thu Jun 10 09:30:14 2010
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2922M/3317M, Ph+PgF:4974M/5206M, VA:1941M/2047M
Thu Jun 10 09:30:14 2010
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
Thu Jun 10 09:30:24 2010
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 = 167772160
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 427819008
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=3032
MMAN started with pid=4, OS id=3040
DBW0 started with pid=5, OS id=3052
LGWR started with pid=6, OS id=3056
CKPT started with pid=7, OS id=3060
SMON started with pid=8, OS id=3064
RECO started with pid=9, OS id=3068
CJQ0 started with pid=10, OS id=3072
MMON started with pid=11, OS id=3076
Thu Jun 10 09:30:31 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=3080
Thu Jun 10 09:30:31 2010
starting up 1 shared server(s) ...
PSP0 started with pid=3, OS id=3036
Thu Jun 10 09:30:35 2010
alter database mount exclusive
Thu Jun 10 09:30:39 2010
Setting recovery target incarnation to 2
Thu Jun 10 09:30:40 2010
Successful mount of redo thread 1, with mount id 1249095995
Thu Jun 10 09:30:41 2010
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Thu Jun 10 09:30:41 2010
alter database open
Thu Jun 10 09:30:43 2010
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Thu Jun 10 09:30:48 2010
Started redo scan
Thu Jun 10 09:30:50 2010
Completed redo scan
47 redo blocks read, 27 data blocks need recovery
Thu Jun 10 09:30:52 2010
Started redo application at
Thread 1: logseq 1, block 94309
Thu Jun 10 09:30:53 2010
Recovery of Online Redo Log: Thread 1 Group 3 Seq 1 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Thu Jun 10 09:30:54 2010
Completed redo application
Thu Jun 10 09:30:59 2010
Completed crash recovery at
Thread 1: logseq 1, block 94356, scn 568436
27 data blocks read, 27 data blocks written, 47 redo blocks read
Thu Jun 10 09:31:10 2010
Thread 1 advanced to log sequence 2
Thread 1 opened at log sequence 2
Current log# 1 seq# 2 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1
Thu Jun 10 09:31:11 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Jun 10 09:31:11 2010
SMON: enabling cache recovery
Thu Jun 10 09:31:17 2010
Successfully onlined Undo Tablespace 1.
Thu Jun 10 09:31:17 2010
SMON: enabling tx recovery
Thu Jun 10 09:31:18 2010
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=4064
Thu Jun 10 09:31:29 2010
Completed: alter database open
Thu Jun 10 09:31:31 2010
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.
Thu Jun 10 10:47:35 2010
CREATE TABLESPACE TBS_ACE
DATAFILE 'F:\ORADATA/TBS_ACE.dbf' SIZE 800M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 10:47:59 2010
Completed: CREATE TABLESPACE TBS_ACE
DATAFILE 'F:\ORADATA/TBS_ACE.dbf' SIZE 800M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 10:47:59 2010
CREATE TABLESPACE TBS_ACEINT
DATAFILE 'F:\ORADATA/TBS_ACEINT.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 10:48:04 2010
Completed: CREATE TABLESPACE TBS_ACEINT
DATAFILE 'F:\ORADATA/TBS_ACEINT.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 10:48:05 2010
CREATE TABLESPACE TBS_ACEIND
DATAFILE 'F:\ORADATA/TBS_ACEIND.dbf' SIZE 500M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 10:48:16 2010
Completed: CREATE TABLESPACE TBS_ACEIND
DATAFILE 'F:\ORADATA/TBS_ACEIND.dbf' SIZE 500M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 10:48:16 2010
CREATE TABLESPACE TBS_ACEINTIND
DATAFILE 'F:\ORADATA/TBS_ACEINTIND.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 10:48:22 2010
Completed: CREATE TABLESPACE TBS_ACEINTIND
DATAFILE 'F:\ORADATA/TBS_ACEINTIND.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 13:21:35 2010
drop tablespace TBS_ACE including contents and datafiles
Thu Jun 10 13:21:35 2010
ORA-23515 signalled during: drop tablespace TBS_ACE including contents and datafiles...
Thu Jun 10 13:21:46 2010
drop tablespace TBS_ACE including contents and datafiles
Thu Jun 10 13:21:46 2010
ORA-23515 signalled during: drop tablespace TBS_ACE including contents and datafiles...
Thu Jun 10 13:22:17 2010
drop tablespace TBS_ACE including contents and datafiles
Thu Jun 10 13:22:17 2010
ORA-23515 signalled during: drop tablespace TBS_ACE including contents and datafiles...
Thu Jun 10 13:22:31 2010
drop tablespace TBS_ACE including contents and datafiles
Thu Jun 10 13:22:32 2010
ORA-23515 signalled during: drop tablespace TBS_ACE including contents and datafiles...
Thu Jun 10 13:23:21 2010
Thread 1 advanced to log sequence 3
Current log# 2 seq# 3 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Thu Jun 10 13:23:42 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 2209K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==
Thu Jun 10 13:24:26 2010
drop tablespace TBS_ACE including contents and datafiles
Thu Jun 10 13:24:27 2010
Deleted file F:\ORADATA\TBS_ACE.DBF
Completed: drop tablespace TBS_ACE including contents and datafiles
Thu Jun 10 13:24:38 2010
drop tablespace TBS_ACEINT including contents and datafiles
Thu Jun 10 13:24:38 2010
Deleted file F:\ORADATA\TBS_ACEINT.DBF
Completed: drop tablespace TBS_ACEINT including contents and datafiles
Thu Jun 10 13:24:47 2010
drop tablespace TBS_ACEINTIND including contents and datafiles
Deleted file F:\ORADATA\TBS_ACEINTIND.DBF
Completed: drop tablespace TBS_ACEINTIND including contents and datafiles
Thu Jun 10 13:25:34 2010
drop tablespace TBS_ACEIND including contents and datafiles
Thu Jun 10 13:25:35 2010
Deleted file F:\ORADATA\TBS_ACEIND.DBF
Completed: drop tablespace TBS_ACEIND including contents and datafiles
Thu Jun 10 13:25:57 2010
CREATE TABLESPACE TBS_ACE
DATAFILE 'F:\ORADATA/TBS_ACE.dbf' SIZE 800M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 13:26:17 2010
Completed: CREATE TABLESPACE TBS_ACE
DATAFILE 'F:\ORADATA/TBS_ACE.dbf' SIZE 800M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 13:26:17 2010
CREATE TABLESPACE TBS_ACEINT
DATAFILE 'F:\ORADATA/TBS_ACEINT.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 13:26:22 2010
Completed: CREATE TABLESPACE TBS_ACEINT
DATAFILE 'F:\ORADATA/TBS_ACEINT.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 13:26:23 2010
CREATE TABLESPACE TBS_ACEIND
DATAFILE 'F:\ORADATA/TBS_ACEIND.dbf' SIZE 500M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 13:26:33 2010
Completed: CREATE TABLESPACE TBS_ACEIND
DATAFILE 'F:\ORADATA/TBS_ACEIND.dbf' SIZE 500M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 13:26:34 2010
CREATE TABLESPACE TBS_ACEINTIND
DATAFILE 'F:\ORADATA/TBS_ACEINTIND.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 13:26:39 2010
Completed: CREATE TABLESPACE TBS_ACEINTIND
DATAFILE 'F:\ORADATA/TBS_ACEINTIND.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 13:27:53 2010
Thread 1 advanced to log sequence 4
Current log# 3 seq# 4 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Thu Jun 10 13:29:56 2010
Thread 1 advanced to log sequence 5
Current log# 1 seq# 5 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Thu Jun 10 14:32:26 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j000_4108.trc:
ORA-12012: error on auto execute of job 22
ORA-01435: user does not exist
Thu Jun 10 14:32:31 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j000_4108.trc:
ORA-12012: error on auto execute of job 23
ORA-01435: user does not exist
Thu Jun 10 14:32:41 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j000_4108.trc:
ORA-12012: error on auto execute of job 22
ORA-01435: user does not exist
Thu Jun 10 14:32:41 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_j001_3564.trc:
ORA-12012: error on auto execute of job 23
ORA-01435: user does not exist
Thu Jun 10 14:34:40 2010
drop tablespace DAT_TS01_ACE including contents and datafiles
Thu Jun 10 14:34:40 2010
ORA-959 signalled during: drop tablespace DAT_TS01_ACE including contents and datafiles...
Thu Jun 10 14:34:55 2010
drop tablespace TBS_ACE including contents and datafiles
Thu Jun 10 14:34:56 2010
Deleted file F:\ORADATA\TBS_ACE.DBF
Completed: drop tablespace TBS_ACE including contents and datafiles
Thu Jun 10 14:36:00 2010
drop tablespace TBS_ACEint including contents and datafiles
Thu Jun 10 14:36:01 2010
Deleted file F:\ORADATA\TBS_ACEINT.DBF
Completed: drop tablespace TBS_ACEint including contents and datafiles
Thu Jun 10 14:36:22 2010
drop tablespace TBS_ACEind including contents and datafiles
Thu Jun 10 14:36:22 2010
Deleted file F:\ORADATA\TBS_ACEIND.DBF
Completed: drop tablespace TBS_ACEind including contents and datafiles
Thu Jun 10 14:36:39 2010
drop tablespace TBS_ACEintind including contents and datafiles
Thu Jun 10 14:36:40 2010
Deleted file F:\ORADATA\TBS_ACEINTIND.DBF
Completed: drop tablespace TBS_ACEintind including contents and datafiles
Thu Jun 10 14:37:55 2010
CREATE TABLESPACE TBS_ACE
DATAFILE 'F:\ORADATA/TBS_ACE.dbf' SIZE 800M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 14:38:14 2010
Completed: CREATE TABLESPACE TBS_ACE
DATAFILE 'F:\ORADATA/TBS_ACE.dbf' SIZE 800M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 14:38:14 2010
CREATE TABLESPACE TBS_ACEINT
DATAFILE 'F:\ORADATA/TBS_ACEINT.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 14:38:20 2010
Completed: CREATE TABLESPACE TBS_ACEINT
DATAFILE 'F:\ORADATA/TBS_ACEINT.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 14:38:20 2010
CREATE TABLESPACE TBS_ACEIND
DATAFILE 'F:\ORADATA/TBS_ACEIND.dbf' SIZE 500M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 14:38:31 2010
Completed: CREATE TABLESPACE TBS_ACEIND
DATAFILE 'F:\ORADATA/TBS_ACEIND.dbf' SIZE 500M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 14:38:31 2010
CREATE TABLESPACE TBS_ACEINTIND
DATAFILE 'F:\ORADATA/TBS_ACEINTIND.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 14:38:37 2010
Completed: CREATE TABLESPACE TBS_ACEINTIND
DATAFILE 'F:\ORADATA/TBS_ACEINTIND.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Thu Jun 10 14:38:44 2010
Thread 1 advanced to log sequence 6
Current log# 2 seq# 6 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Thu Jun 10 14:40:42 2010
Thread 1 advanced to log sequence 7
Current log# 3 seq# 7 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Thu Jun 10 17:30:54 2010
Thread 1 advanced to log sequence 8
Current log# 1 seq# 8 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Thu Jun 10 22:29:20 2010
Thread 1 advanced to log sequence 9
Current log# 2 seq# 9 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Fri Jun 11 09:30:31 2010
Thread 1 advanced to log sequence 10
Current log# 3 seq# 10 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Fri Jun 11 18:45:10 2010
WARNING: inbound connection timed out (ORA-3136)
Fri Jun 11 18:45:13 2010
WARNING: inbound connection timed out (ORA-3136)
Fri Jun 11 18:45:19 2010
WARNING: inbound connection timed out (ORA-3136)
Fri Jun 11 22:00:12 2010
Thread 1 advanced to log sequence 11
Current log# 1 seq# 11 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Sat Jun 12 06:05:05 2010
Thread 1 advanced to log sequence 12
Current log# 2 seq# 12 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Sat Jun 12 20:15:08 2010
Thread 1 advanced to log sequence 13
Current log# 3 seq# 13 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Sun Jun 13 10:16:46 2010
Thread 1 advanced to log sequence 14
Current log# 1 seq# 14 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Sun Jun 13 17:10:47 2010
WARNING: inbound connection timed out (ORA-3136)
Mon Jun 14 00:15:13 2010
Thread 1 advanced to log sequence 15
Current log# 2 seq# 15 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Mon Jun 14 14:35:41 2010
Thread 1 advanced to log sequence 16
Current log# 3 seq# 16 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Mon Jun 14 23:30:14 2010
Thread 1 advanced to log sequence 17
Current log# 1 seq# 17 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Tue Jun 15 13:31:34 2010
Thread 1 advanced to log sequence 18
Current log# 2 seq# 18 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Tue Jun 15 19:20:12 2010
CREATE TABLESPACE TBS_ACE1
DATAFILE 'F:\ORADATA/TBS_ACE1.dbf' SIZE 800M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Tue Jun 15 19:20:32 2010
Completed: CREATE TABLESPACE TBS_ACE1
DATAFILE 'F:\ORADATA/TBS_ACE1.dbf' SIZE 800M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Tue Jun 15 19:20:32 2010
CREATE TABLESPACE TBS_ACE1INT
DATAFILE 'F:\ORADATA/TBS_ACE1INT.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Tue Jun 15 19:20:37 2010
Completed: CREATE TABLESPACE TBS_ACE1INT
DATAFILE 'F:\ORADATA/TBS_ACE1INT.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Tue Jun 15 19:20:37 2010
CREATE TABLESPACE TBS_ACE1IND
DATAFILE 'F:\ORADATA/TBS_ACE1IND.dbf' SIZE 500M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Tue Jun 15 19:20:50 2010
Completed: CREATE TABLESPACE TBS_ACE1IND
DATAFILE 'F:\ORADATA/TBS_ACE1IND.dbf' SIZE 500M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Tue Jun 15 19:20:50 2010
CREATE TABLESPACE TBS_ACE1INTIND
DATAFILE 'F:\ORADATA/TBS_ACE1INTIND.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Tue Jun 15 19:20:55 2010
Completed: CREATE TABLESPACE TBS_ACE1INTIND
DATAFILE 'F:\ORADATA/TBS_ACE1INTIND.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Tue Jun 15 19:22:06 2010
Thread 1 advanced to log sequence 19
Current log# 3 seq# 19 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Tue Jun 15 19:23:53 2010
Thread 1 advanced to log sequence 20
Current log# 1 seq# 20 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Tue Jun 15 22:00:31 2010
Thread 1 advanced to log sequence 21
Current log# 2 seq# 21 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Wed Jun 16 05:02:31 2010
Thread 1 advanced to log sequence 22
Current log# 3 seq# 22 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Wed Jun 16 11:14:55 2010
WARNING: inbound connection timed out (ORA-3136)
Wed Jun 16 13:54:27 2010
Thread 1 advanced to log sequence 23
Current log# 1 seq# 23 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Wed Jun 16 22:00:08 2010
Thread 1 advanced to log sequence 24
Current log# 2 seq# 24 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Thu Jun 17 03:30:32 2010
Thread 1 advanced to log sequence 25
Current log# 3 seq# 25 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Thu Jun 17 12:29:30 2010
Thread 1 advanced to log sequence 26
Current log# 1 seq# 26 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Thu Jun 17 21:18:57 2010
Thread 1 advanced to log sequence 27
Current log# 2 seq# 27 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Fri Jun 18 01:06:59 2010
Thread 1 advanced to log sequence 28
Current log# 3 seq# 28 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Fri Jun 18 10:01:39 2010
Thread 1 advanced to log sequence 29
Current log# 1 seq# 29 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Fri Jun 18 11:35:25 2010
WARNING: inbound connection timed out (ORA-3136)
Fri Jun 18 12:21:16 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 2590K exceeds notification threshold (2048K)
KGL object name :select a.object_type, a.object_name,
b.owner, b.object_type, b.object_name, b.object_id, b.status
from ALL_OBJECTS a,
ALL_OBJECTS b,
(select object_id, referenced_object_id
FROM PUBLIC_DEPENDENCY
start with object_id = (select object_id
from ALL_OBJECTS
WHERE owner = :owner
AND object_name = :name
AND object_type = :type)
connect by prior referenced_object_id = object_id) c
where a.object_id = c.object_id
and b.object_id = c.referenced_object_id
and a.owner <> 'SYS'
and
Fri Jun 18 12:21:16 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 3870K exceeds notification threshold (2048K)
Details in trace file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_1140.trc
KGL object name :select a.object_type, a.object_name,
b.owner, b.object_type, b.object_name, b.object_id, b.status
from ALL_OBJECTS a,
ALL_OBJECTS b,
(select object_id, referenced_object_id
FROM PUBLIC_DEPENDENCY
start with object_id = (select object_id
from ALL_OBJECTS
WHERE owner = :owner
AND object_name = :name
AND object_type = :type)
connect by prior referenced_object_id = object_id) c
where a.object_id = c.object_id
and b.object_id = c.referenced_object_id
and a.owner <> 'SYS'
and
Fri Jun 18 13:29:45 2010
WARNING: inbound connection timed out (ORA-3136)
Fri Jun 18 18:16:01 2010
Thread 1 advanced to log sequence 30
Current log# 2 seq# 30 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Fri Jun 18 22:32:39 2010
Thread 1 advanced to log sequence 31
Current log# 3 seq# 31 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Sat Jun 19 06:00:08 2010
Thread 1 advanced to log sequence 32
Current log# 1 seq# 32 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Sat Jun 19 12:28:49 2010
Thread 1 advanced to log sequence 33
Current log# 2 seq# 33 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Sat Jun 19 21:30:35 2010
Thread 1 advanced to log sequence 34
Current log# 3 seq# 34 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Sun Jun 20 04:44:29 2010
Thread 1 advanced to log sequence 35
Current log# 1 seq# 35 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Sun Jun 20 13:52:45 2010
Thread 1 advanced to log sequence 36
Current log# 2 seq# 36 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Sun Jun 20 22:33:30 2010
Thread 1 advanced to log sequence 37
Current log# 3 seq# 37 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Mon Jun 21 06:29:50 2010
Thread 1 advanced to log sequence 38
Current log# 1 seq# 38 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Mon Jun 21 13:14:00 2010
WARNING: inbound connection timed out (ORA-3136)
Mon Jun 21 15:30:22 2010
Thread 1 advanced to log sequence 39
Current log# 2 seq# 39 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Mon Jun 21 22:00:19 2010
Thread 1 advanced to log sequence 40
Current log# 3 seq# 40 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Tue Jun 22 03:30:19 2010
Thread 1 advanced to log sequence 41
Current log# 1 seq# 41 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Tue Jun 22 11:36:13 2010
Starting background process EMN0
EMN0 started with pid=19, OS id=4104
Tue Jun 22 11:36:13 2010
Shutting down instance: further logons disabled
Tue Jun 22 11:36:14 2010
Stopping background process QMNC
Tue Jun 22 11:36:14 2010
Stopping background process CJQ0
Tue Jun 22 11:36:15 2010
Stopping background process MMNL
Tue Jun 22 11:36:16 2010
Stopping background process MMON
Tue Jun 22 11:36:17 2010
Shutting down instance (immediate)
License high water mark = 13
Tue Jun 22 11:36:17 2010
Stopping Job queue slave processes
Tue Jun 22 11:36:17 2010
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Tue Jun 22 11:36:24 2010
ALTER DATABASE CLOSE NORMAL
Tue Jun 22 11:36:24 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Jun 22 11:36:25 2010
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 41
Successful close of redo thread 1
Tue Jun 22 11:36:26 2010
Completed: ALTER DATABASE CLOSE NORMAL
Tue Jun 22 11:36:26 2010
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
Tue Jun 22 11:36:50 2010
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 = 146800640
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 440401920
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=2176
PSP0 started with pid=3, OS id=500
MMAN started with pid=4, OS id=2268
DBW0 started with pid=5, OS id=3612
LGWR started with pid=6, OS id=5320
CKPT started with pid=7, OS id=5372
SMON started with pid=8, OS id=2788
RECO started with pid=9, OS id=1388
CJQ0 started with pid=10, OS id=144
MMON started with pid=11, OS id=2856
MMNL started with pid=12, OS id=1272
Tue Jun 22 11:36:50 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Tue Jun 22 11:36:50 2010
ALTER DATABASE MOUNT
Tue Jun 22 11:36:54 2010
Setting recovery target incarnation to 2
Tue Jun 22 11:36:55 2010
Successful mount of redo thread 1, with mount id 1250158546
Tue Jun 22 11:36:55 2010
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue Jun 22 11:36:55 2010
ALTER DATABASE OPEN
Tue Jun 22 11:36:55 2010
Thread 1 opened at log sequence 41
Current log# 1 seq# 41 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1
Tue Jun 22 11:36:55 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Jun 22 11:36:55 2010
SMON: enabling cache recovery
Tue Jun 22 11:36:57 2010
Successfully onlined Undo Tablespace 1.
Tue Jun 22 11:36:57 2010
SMON: enabling tx recovery
Tue Jun 22 11:36:57 2010
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=4984
Tue Jun 22 11:37:02 2010
Completed: ALTER DATABASE OPEN
Tue Jun 22 11:37:02 2010
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.
Tue Jun 22 11:57:21 2010
Starting background process EMN0
EMN0 started with pid=22, OS id=6136
Tue Jun 22 11:57:21 2010
Shutting down instance: further logons disabled
Tue Jun 22 11:57:21 2010
Stopping background process QMNC
Tue Jun 22 11:57:22 2010
Stopping background process CJQ0
Tue Jun 22 11:57:23 2010
Stopping background process MMNL
Tue Jun 22 11:57:24 2010
Stopping background process MMON
Tue Jun 22 11:57:25 2010
Shutting down instance (immediate)
License high water mark = 9
Tue Jun 22 11:57:25 2010
Stopping Job queue slave processes
Tue Jun 22 11:57:26 2010
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Tue Jun 22 11:57:31 2010
ALTER DATABASE CLOSE NORMAL
Tue Jun 22 11:57:31 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Jun 22 11:57:32 2010
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 41
Successful close of redo thread 1
Tue Jun 22 11:57:32 2010
Completed: ALTER DATABASE CLOSE NORMAL
Tue Jun 22 11:57:32 2010
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
Tue Jun 22 11:57:38 2010
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 = 150994944
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 436207616
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=5996
PSP0 started with pid=3, OS id=4532
MMAN started with pid=4, OS id=1920
DBW0 started with pid=5, OS id=4492
LGWR started with pid=6, OS id=5360
CKPT started with pid=7, OS id=5936
SMON started with pid=8, OS id=2500
RECO started with pid=9, OS id=4016
CJQ0 started with pid=10, OS id=3920
MMON started with pid=11, OS id=3704
MMNL started with pid=12, OS id=4256
Tue Jun 22 11:57:39 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Tue Jun 22 11:57:39 2010
ALTER DATABASE MOUNT
Tue Jun 22 11:57:43 2010
Setting recovery target incarnation to 2
Tue Jun 22 11:57:43 2010
Successful mount of redo thread 1, with mount id 1250145715
Tue Jun 22 11:57:43 2010
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue Jun 22 11:57:44 2010
ALTER DATABASE OPEN
Tue Jun 22 11:57:44 2010
Thread 1 opened at log sequence 41
Current log# 1 seq# 41 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1
Tue Jun 22 11:57:44 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Jun 22 11:57:44 2010
SMON: enabling cache recovery
Tue Jun 22 11:57:46 2010
Successfully onlined Undo Tablespace 1.
Tue Jun 22 11:57:46 2010
SMON: enabling tx recovery
Tue Jun 22 11:57:46 2010
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=5264
Tue Jun 22 11:57:51 2010
Completed: ALTER DATABASE OPEN
Tue Jun 22 11:57:51 2010
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.
Tue Jun 22 12:45:06 2010
Thread 1 advanced to log sequence 42
Current log# 2 seq# 42 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Tue Jun 22 22:00:13 2010
Thread 1 advanced to log sequence 43
Current log# 3 seq# 43 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Wed Jun 23 02:53:59 2010
Thread 1 advanced to log sequence 44
Current log# 1 seq# 44 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Wed Jun 23 10:31:05 2010
Thread 1 advanced to log sequence 45
Current log# 2 seq# 45 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Wed Jun 23 20:07:33 2010
Thread 1 advanced to log sequence 46
Current log# 3 seq# 46 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Thu Jun 24 01:51:23 2010
Thread 1 advanced to log sequence 47
Current log# 1 seq# 47 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Thu Jun 24 09:30:45 2010
Thread 1 advanced to log sequence 48
Current log# 2 seq# 48 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Thu Jun 24 19:03:33 2010
Thread 1 advanced to log sequence 49
Current log# 3 seq# 49 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Fri Jun 25 00:02:27 2010
Thread 1 advanced to log sequence 50
Current log# 1 seq# 50 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Fri Jun 25 07:43:28 2010
Thread 1 advanced to log sequence 51
Current log# 2 seq# 51 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Fri Jun 25 17:18:10 2010
Thread 1 advanced to log sequence 52
Current log# 3 seq# 52 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Fri Jun 25 18:44:44 2010
WARNING: inbound connection timed out (ORA-3136)
Fri Jun 25 22:30:22 2010
Thread 1 advanced to log sequence 53
Current log# 1 seq# 53 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Dump file d:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log
Sat Jun 26 11:58:38 2010
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2970M/3317M, Ph+PgF:5020M/5206M, VA:1941M/2047M
Sat Jun 26 11:58:38 2010
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
Sat Jun 26 11:58:49 2010
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 = 159383552
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 427819008
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
MMAN started with pid=4, OS id=196
PMON started with pid=2, OS id=204
PSP0 started with pid=3, OS id=192
DBW0 started with pid=5, OS id=2008
LGWR started with pid=6, OS id=1680
CKPT started with pid=7, OS id=1688
SMON started with pid=8, OS id=1692
RECO started with pid=9, OS id=1696
CJQ0 started with pid=10, OS id=1736
MMON started with pid=11, OS id=1732
MMNL started with pid=12, OS id=1740
Sat Jun 26 11:58:51 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sat Jun 26 11:58:54 2010
alter database mount exclusive
Sat Jun 26 11:58:58 2010
Setting recovery target incarnation to 2
Sat Jun 26 11:58:58 2010
Successful mount of redo thread 1, with mount id 1250452222
Sat Jun 26 11:58:58 2010
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Sat Jun 26 11:58:59 2010
alter database open
Sat Jun 26 11:59:01 2010
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Sat Jun 26 11:59:05 2010
Started redo scan
Sat Jun 26 11:59:07 2010
Completed redo scan
2502 redo blocks read, 356 data blocks need recovery
Sat Jun 26 11:59:15 2010
Started redo application at
Thread 1: logseq 52, block 92004
Sat Jun 26 11:59:15 2010
Recovery of Online Redo Log: Thread 1 Group 3 Seq 52 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Sat Jun 26 11:59:17 2010
Recovery of Online Redo Log: Thread 1 Group 1 Seq 53 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Sat Jun 26 11:59:17 2010
Completed redo application
Sat Jun 26 11:59:20 2010
Completed crash recovery at
Thread 1: logseq 53, block 1323, scn 2921657
356 data blocks read, 356 data blocks written, 2502 redo blocks read
Sat Jun 26 11:59:25 2010
Thread 1 advanced to log sequence 54
Thread 1 opened at log sequence 54
Current log# 2 seq# 54 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1
Sat Jun 26 11:59:26 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Jun 26 11:59:26 2010
SMON: enabling cache recovery
Sat Jun 26 11:59:31 2010
Successfully onlined Undo Tablespace 1.
Sat Jun 26 11:59:31 2010
SMON: enabling tx recovery
Sat Jun 26 11:59:31 2010
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=2904
Sat Jun 26 11:59:46 2010
Completed: alter database open
Sat Jun 26 11:59:48 2010
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.
Dump file d:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log
Mon Jun 28 10:08:02 2010
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 2 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2955M/3317M, Ph+PgF:5027M/5206M, VA:1941M/2047M
Mon Jun 28 10:08:02 2010
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
Mon Jun 28 10:08:16 2010
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 = 163577856
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 423624704
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PSP0 started with pid=3, OS id=2564
MMAN started with pid=4, OS id=2568
PMON started with pid=2, OS id=2556
DBW0 started with pid=5, OS id=2572
LGWR started with pid=6, OS id=2576
CKPT started with pid=7, OS id=2580
SMON started with pid=8, OS id=2584
RECO started with pid=9, OS id=2588
CJQ0 started with pid=10, OS id=2592
MMON started with pid=11, OS id=2596
MMNL started with pid=12, OS id=2600
Mon Jun 28 10:08:21 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Mon Jun 28 10:08:25 2010
alter database mount exclusive
Mon Jun 28 10:08:30 2010
Setting recovery target incarnation to 2
Mon Jun 28 10:08:31 2010
Successful mount of redo thread 1, with mount id 1250610201
Mon Jun 28 10:08:31 2010
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Jun 28 10:08:31 2010
alter database open
Mon Jun 28 10:08:32 2010
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Mon Jun 28 10:08:37 2010
Started redo scan
Mon Jun 28 10:08:39 2010
Completed redo scan
711 redo blocks read, 79 data blocks need recovery
Mon Jun 28 10:08:43 2010
Started redo application at
Thread 1: logseq 54, block 35918
Mon Jun 28 10:08:43 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 54 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Mon Jun 28 10:08:45 2010
Completed redo application
Mon Jun 28 10:08:48 2010
Completed crash recovery at
Thread 1: logseq 54, block 36629, scn 2950047
79 data blocks read, 79 data blocks written, 711 redo blocks read
Mon Jun 28 10:08:52 2010
Thread 1 advanced to log sequence 55
Thread 1 opened at log sequence 55
Current log# 3 seq# 55 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
Mon Jun 28 10:08:53 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Jun 28 10:08:53 2010
SMON: enabling cache recovery
Mon Jun 28 10:09:00 2010
Successfully onlined Undo Tablespace 1.
Mon Jun 28 10:09:00 2010
SMON: enabling tx recovery
Mon Jun 28 10:09:01 2010
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=3820
Mon Jun 28 10:09:23 2010
Completed: alter database open
Mon Jun 28 10:09:26 2010
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.
Mon Jun 28 11:08:31 2010
WARNING: inbound connection timed out (ORA-3136)
Mon Jun 28 17:15:30 2010
Thread 1 advanced to log sequence 56
Current log# 1 seq# 56 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Mon Jun 28 23:40:10 2010
Thread 1 advanced to log sequence 57
Current log# 2 seq# 57 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Tue Jun 29 08:02:36 2010
Thread 1 advanced to log sequence 58
Current log# 3 seq# 58 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Tue Jun 29 11:36:28 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 2252K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==
Tue Jun 29 11:36:29 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 2246K exceeds notification threshold (2048K)
Details in trace file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_5352.trc
KGL object name :XDB.XDZynXpO5DTv2jNMI2jLTZZA==
Tue Jun 29 17:43:44 2010
Thread 1 advanced to log sequence 59
Current log# 1 seq# 59 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Tue Jun 29 23:45:18 2010
Thread 1 advanced to log sequence 60
Current log# 2 seq# 60 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Wed Jun 30 07:49:30 2010
Thread 1 advanced to log sequence 61
Current log# 3 seq# 61 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Wed Jun 30 17:32:37 2010
Thread 1 advanced to log sequence 62
Current log# 1 seq# 62 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Wed Jun 30 23:22:23 2010
Thread 1 advanced to log sequence 63
Current log# 2 seq# 63 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Thu Jul 01 06:30:08 2010
Thread 1 advanced to log sequence 64
Current log# 3 seq# 64 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Thu Jul 01 15:40:32 2010
Thread 1 advanced to log sequence 65
Current log# 1 seq# 65 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Thu Jul 01 22:00:19 2010
Thread 1 advanced to log sequence 66
Current log# 2 seq# 66 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Fri Jul 02 04:37:57 2010
Thread 1 advanced to log sequence 67
Current log# 3 seq# 67 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Fri Jul 02 11:29:42 2010
CREATE TABLESPACE PEL65
DATAFILE 'E:\oradata/PEL65.dbf' SIZE 2000M
AUTOEXTEND ON NEXT 500K MAXSIZE 5000M
ONLINE EXTENT MANAGEMENT LOCAL
Fri Jul 02 11:30:22 2010
Completed: CREATE TABLESPACE PEL65
DATAFILE 'E:\oradata/PEL65.dbf' SIZE 2000M
AUTOEXTEND ON NEXT 500K MAXSIZE 5000M
ONLINE EXTENT MANAGEMENT LOCAL
Fri Jul 02 11:30:22 2010
CREATE TABLESPACE PEL65INT
DATAFILE 'E:\oradata/PEL65INT.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE 5000M
ONLINE EXTENT MANAGEMENT LOCAL
Fri Jul 02 11:30:26 2010
Completed: CREATE TABLESPACE PEL65INT
DATAFILE 'E:\oradata/PEL65INT.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE 5000M
ONLINE EXTENT MANAGEMENT LOCAL
Fri Jul 02 11:30:26 2010
CREATE TABLESPACE PEL65IND
DATAFILE 'E:\oradata/PEL65IND.dbf' SIZE 2000M
AUTOEXTEND ON NEXT 500K MAXSIZE 5000M
ONLINE EXTENT MANAGEMENT LOCAL
Fri Jul 02 11:31:04 2010
Completed: CREATE TABLESPACE PEL65IND
DATAFILE 'E:\oradata/PEL65IND.dbf' SIZE 2000M
AUTOEXTEND ON NEXT 500K MAXSIZE 5000M
ONLINE EXTENT MANAGEMENT LOCAL
Fri Jul 02 11:31:04 2010
CREATE TABLESPACE PEL65INTIND
DATAFILE 'E:\oradata/PEL65INTIND.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE 5000M
ONLINE EXTENT MANAGEMENT LOCAL
Fri Jul 02 11:31:11 2010
Completed: CREATE TABLESPACE PEL65INTIND
DATAFILE 'E:\oradata/PEL65INTIND.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE 5000M
ONLINE EXTENT MANAGEMENT LOCAL
Fri Jul 02 11:31:33 2010
Thread 1 advanced to log sequence 68
Current log# 1 seq# 68 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Fri Jul 02 11:33:32 2010
Thread 1 advanced to log sequence 69
Current log# 2 seq# 69 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Fri Jul 02 14:51:09 2010
Thread 1 advanced to log sequence 70
Current log# 3 seq# 70 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Fri Jul 02 17:51:36 2010
WARNING: inbound connection timed out (ORA-3136)
Fri Jul 02 18:54:25 2010
Thread 1 advanced to log sequence 71
Current log# 1 seq# 71 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Fri Jul 02 22:00:41 2010
Thread 1 advanced to log sequence 72
Current log# 2 seq# 72 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Sat Jul 03 04:47:00 2010
Thread 1 advanced to log sequence 73
Current log# 3 seq# 73 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Sat Jul 03 09:58:24 2010
Thread 1 advanced to log sequence 74
Current log# 1 seq# 74 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Sat Jul 03 18:02:26 2010
Thread 1 advanced to log sequence 75
Current log# 2 seq# 75 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Sat Jul 03 18:11:11 2010
CREATE TABLESPACE TBS_SEPA7
DATAFILE 'D:\oracledb/TBS_SEPA7.dbf' SIZE 800M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Sat Jul 03 18:11:26 2010
Completed: CREATE TABLESPACE TBS_SEPA7
DATAFILE 'D:\oracledb/TBS_SEPA7.dbf' SIZE 800M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Sat Jul 03 18:11:26 2010
CREATE TABLESPACE TBS_SEPA7INT
DATAFILE 'D:\oracledb/TBS_SEPA7INT.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Sat Jul 03 18:11:30 2010
Completed: CREATE TABLESPACE TBS_SEPA7INT
DATAFILE 'D:\oracledb/TBS_SEPA7INT.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Sat Jul 03 18:11:31 2010
CREATE TABLESPACE TBS_SEPA7IND
DATAFILE 'D:\oracledb/TBS_SEPA7IND.dbf' SIZE 500M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Sat Jul 03 18:11:40 2010
Completed: CREATE TABLESPACE TBS_SEPA7IND
DATAFILE 'D:\oracledb/TBS_SEPA7IND.dbf' SIZE 500M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Sat Jul 03 18:11:41 2010
CREATE TABLESPACE TBS_SEPA7INTIND
DATAFILE 'D:\oracledb/TBS_SEPA7INTIND.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Sat Jul 03 18:11:45 2010
Completed: CREATE TABLESPACE TBS_SEPA7INTIND
DATAFILE 'D:\oracledb/TBS_SEPA7INTIND.dbf' SIZE 200M
AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED
ONLINE EXTENT MANAGEMENT LOCAL
Sat Jul 03 18:13:34 2010
Thread 1 advanced to log sequence 76
Current log# 3 seq# 76 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Sat Jul 03 18:39:36 2010
Thread 1 advanced to log sequence 77
Current log# 1 seq# 77 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Sat Jul 03 18:42:42 2010
WARNING: inbound connection timed out (ORA-3136)
Sun Jul 04 00:56:12 2010
Thread 1 advanced to log sequence 78
Current log# 2 seq# 78 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Sun Jul 04 06:50:16 2010
Thread 1 advanced to log sequence 79
Current log# 3 seq# 79 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Sun Jul 04 13:08:47 2010
Thread 1 advanced to log sequence 80
Current log# 1 seq# 80 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Sun Jul 04 19:27:02 2010
Thread 1 advanced to log sequence 81
Current log# 2 seq# 81 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Mon Jul 05 01:39:27 2010
Thread 1 advanced to log sequence 82
Current log# 3 seq# 82 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Mon Jul 05 07:59:27 2010
Thread 1 advanced to log sequence 83
Current log# 1 seq# 83 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Mon Jul 05 14:15:25 2010
Thread 1 advanced to log sequence 84
Current log# 2 seq# 84 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Mon Jul 05 20:37:56 2010
Thread 1 advanced to log sequence 85
Current log# 3 seq# 85 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Mon Jul 05 22:08:23 2010
Thread 1 advanced to log sequence 86
Current log# 1 seq# 86 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Tue Jul 06 04:00:14 2010
Thread 1 advanced to log sequence 87
Current log# 2 seq# 87 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Tue Jul 06 10:16:34 2010
Thread 1 advanced to log sequence 88
Current log# 3 seq# 88 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Tue Jul 06 16:30:57 2010
Thread 1 advanced to log sequence 89
Current log# 1 seq# 89 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Tue Jul 06 22:00:10 2010
Thread 1 advanced to log sequence 90
Current log# 2 seq# 90 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Wed Jul 07 00:38:09 2010
Thread 1 advanced to log sequence 91
Current log# 3 seq# 91 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Wed Jul 07 06:53:33 2010
Thread 1 advanced to log sequence 92
Current log# 1 seq# 92 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Wed Jul 07 13:12:23 2010
Thread 1 advanced to log sequence 93
Current log# 2 seq# 93 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Wed Jul 07 19:30:31 2010
Thread 1 advanced to log sequence 94
Current log# 3 seq# 94 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Wed Jul 07 22:08:39 2010
Thread 1 advanced to log sequence 95
Current log# 1 seq# 95 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Thu Jul 08 04:17:51 2010
Thread 1 advanced to log sequence 96
Current log# 2 seq# 96 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Thu Jul 08 10:30:56 2010
Thread 1 advanced to log sequence 97
Current log# 3 seq# 97 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Thu Jul 08 16:52:28 2010
Thread 1 advanced to log sequence 98
Current log# 1 seq# 98 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Thu Jul 08 22:00:13 2010
Thread 1 advanced to log sequence 99
Current log# 2 seq# 99 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Fri Jul 09 01:46:53 2010
Thread 1 advanced to log sequence 100
Current log# 3 seq# 100 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Fri Jul 09 08:06:27 2010
Thread 1 advanced to log sequence 101
Current log# 1 seq# 101 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Fri Jul 09 14:29:16 2010
Thread 1 advanced to log sequence 102
Current log# 2 seq# 102 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Fri Jul 09 20:46:02 2010
Thread 1 advanced to log sequence 103
Current log# 3 seq# 103 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Fri Jul 09 23:08:37 2010
Thread 1 advanced to log sequence 104
Current log# 1 seq# 104 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Sat Jul 10 05:30:48 2010
Thread 1 advanced to log sequence 105
Current log# 2 seq# 105 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Sat Jul 10 09:11:45 2010
Thread 1 advanced to log sequence 106
Current log# 3 seq# 106 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Sat Jul 10 15:25:29 2010
Thread 1 advanced to log sequence 107
Current log# 1 seq# 107 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Sat Jul 10 21:41:51 2010
Thread 1 advanced to log sequence 108
Current log# 2 seq# 108 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Sun Jul 11 02:51:12 2010
Thread 1 advanced to log sequence 109
Current log# 3 seq# 109 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Sun Jul 11 09:16:45 2010
Thread 1 advanced to log sequence 110
Current log# 1 seq# 110 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Sun Jul 11 15:40:22 2010
Thread 1 advanced to log sequence 111
Current log# 2 seq# 111 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Sun Jul 11 22:02:33 2010
Thread 1 advanced to log sequence 112
Current log# 3 seq# 112 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Mon Jul 12 01:48:34 2010
Thread 1 advanced to log sequence 113
Current log# 1 seq# 113 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Mon Jul 12 08:04:48 2010
Thread 1 advanced to log sequence 114
Current log# 2 seq# 114 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Mon Jul 12 11:49:59 2010
WARNING: inbound connection timed out (ORA-3136)
Mon Jul 12 14:13:06 2010
Thread 1 advanced to log sequence 115
Current log# 3 seq# 115 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Mon Jul 12 17:51:24 2010
Memory Notification: Library Cache Object loaded into SGA
Heap size 2910K exceeds notification threshold (2048K)
KGL object name :select owner, object_type, object_name, object_id, status
from ALL_OBJECTS where object_id in (
select object_id
from public_dependency
connect by prior object_id = referenced_object_id
start with referenced_object_id = (
select object_id from ALL_OBJECTS
where owner = :Owner
and object_name = :name
and object_type = :type ))
Mon Jul 12 20:26:06 2010
Thread 1 advanced to log sequence 116
Current log# 1 seq# 116 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Mon Jul 12 22:09:16 2010
Thread 1 advanced to log sequence 117
Current log# 2 seq# 117 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Tue Jul 13 04:00:21 2010
Thread 1 advanced to log sequence 118
Current log# 3 seq# 118 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Tue Jul 13 10:19:57 2010
Thread 1 advanced to log sequence 119
Current log# 1 seq# 119 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Tue Jul 13 16:45:20 2010
Thread 1 advanced to log sequence 120
Current log# 2 seq# 120 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Tue Jul 13 22:00:12 2010
Thread 1 advanced to log sequence 121
Current log# 3 seq# 121 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Wed Jul 14 02:30:44 2010
Thread 1 advanced to log sequence 122
Current log# 1 seq# 122 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Wed Jul 14 06:30:21 2010
Thread 1 advanced to log sequence 123
Current log# 2 seq# 123 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Wed Jul 14 12:56:32 2010
Thread 1 advanced to log sequence 124
Current log# 3 seq# 124 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Wed Jul 14 15:27:42 2010
Starting background process EMN0
EMN0 started with pid=24, OS id=3468
Wed Jul 14 15:27:42 2010
Shutting down instance: further logons disabled
Wed Jul 14 15:27:43 2010
Stopping background process QMNC
Wed Jul 14 15:27:43 2010
Stopping background process CJQ0
Wed Jul 14 15:27:45 2010
Stopping background process MMNL
Wed Jul 14 15:27:46 2010
Stopping background process MMON
Wed Jul 14 15:27:47 2010
Shutting down instance (immediate)
License high water mark = 14
Wed Jul 14 15:27:47 2010
Stopping Job queue slave processes
Wed Jul 14 15:27:48 2010
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Wed Jul 14 15:27:54 2010
ALTER DATABASE CLOSE NORMAL
Wed Jul 14 15:27:54 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Jul 14 15:27:55 2010
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 124
Successful close of redo thread 1
Wed Jul 14 15:27:56 2010
Completed: ALTER DATABASE CLOSE NORMAL
Wed Jul 14 15:27:56 2010
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
Wed Jul 14 15:29:41 2010
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 = 134217728
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 452984832
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=3672
PSP0 started with pid=3, OS id=3164
MMAN started with pid=4, OS id=4356
DBW0 started with pid=5, OS id=4580
LGWR started with pid=6, OS id=5540
CKPT started with pid=7, OS id=5388
SMON started with pid=8, OS id=4288
RECO started with pid=9, OS id=4784
CJQ0 started with pid=10, OS id=3872
MMON started with pid=11, OS id=4452
Wed Jul 14 15:29:41 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=1656
Wed Jul 14 15:29:41 2010
starting up 1 shared server(s) ...
Wed Jul 14 15:29:42 2010
ALTER DATABASE MOUNT
Wed Jul 14 15:29:46 2010
Setting recovery target incarnation to 2
Wed Jul 14 15:29:46 2010
Successful mount of redo thread 1, with mount id 1252149478
Wed Jul 14 15:29:46 2010
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Wed Jul 14 15:29:57 2010
Starting ORACLE instance (normal)
Wed Jul 14 15:30:11 2010
alter database mount
Wed Jul 14 15:30:11 2010
ORA-1100 signalled during: alter database mount...
Wed Jul 14 15:30:27 2010
alter database open
Wed Jul 14 15:30:28 2010
Thread 1 opened at log sequence 124
Current log# 3 seq# 124 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
Wed Jul 14 15:30:28 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Jul 14 15:30:28 2010
SMON: enabling cache recovery
Wed Jul 14 15:30:30 2010
Successfully onlined Undo Tablespace 1.
Wed Jul 14 15:30:30 2010
SMON: enabling tx recovery
Wed Jul 14 15:30:30 2010
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=4748
Wed Jul 14 15:30:35 2010
Completed: alter database open
Wed Jul 14 15:30:35 2010
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.
Wed Jul 14 15:36:16 2010
Starting background process EMN0
EMN0 started with pid=25, OS id=3768
Wed Jul 14 15:36:16 2010
Shutting down instance: further logons disabled
Wed Jul 14 15:36:17 2010
Stopping background process CJQ0
Wed Jul 14 15:36:17 2010
Stopping background process QMNC
Wed Jul 14 15:36:19 2010
Stopping background process MMNL
Wed Jul 14 15:36:20 2010
Stopping background process MMON
Wed Jul 14 15:36:21 2010
Shutting down instance (immediate)
License high water mark = 11
Wed Jul 14 15:36:21 2010
Stopping Job queue slave processes
Wed Jul 14 15:36:21 2010
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Wed Jul 14 15:36:28 2010
ALTER DATABASE CLOSE NORMAL
Wed Jul 14 15:36:28 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Jul 14 15:36:28 2010
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 124
Successful close of redo thread 1
Wed Jul 14 15:36:29 2010
Completed: ALTER DATABASE CLOSE NORMAL
Wed Jul 14 15:36:29 2010
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
Wed Jul 14 15:37:04 2010
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 = 134217728
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 452984832
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=5472
PSP0 started with pid=3, OS id=3648
MMAN started with pid=4, OS id=4056
DBW0 started with pid=5, OS id=3952
LGWR started with pid=6, OS id=1820
CKPT started with pid=7, OS id=352
SMON started with pid=8, OS id=3720
RECO started with pid=9, OS id=1824
CJQ0 started with pid=10, OS id=704
MMON started with pid=11, OS id=5868
Wed Jul 14 15:37:05 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Jul 14 15:37:05 2010
starting up 1 shared server(s) ...
Wed Jul 14 15:37:05 2010
ALTER DATABASE MOUNT
MMNL started with pid=12, OS id=5112
Wed Jul 14 15:37:09 2010
Setting recovery target incarnation to 2
Wed Jul 14 15:37:09 2010
Successful mount of redo thread 1, with mount id 1252138913
Wed Jul 14 15:37:09 2010
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Wed Jul 14 15:37:10 2010
ALTER DATABASE OPEN
Wed Jul 14 15:37:10 2010
Thread 1 opened at log sequence 124
Current log# 3 seq# 124 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
Wed Jul 14 15:37:10 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Jul 14 15:37:10 2010
SMON: enabling cache recovery
Wed Jul 14 15:37:12 2010
Successfully onlined Undo Tablespace 1.
Wed Jul 14 15:37:12 2010
SMON: enabling tx recovery
Wed Jul 14 15:37:12 2010
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=5448
Wed Jul 14 15:37:17 2010
Completed: ALTER DATABASE OPEN
Wed Jul 14 15:37:17 2010
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.
Wed Jul 14 15:54:35 2010
Starting background process EMN0
EMN0 started with pid=26, OS id=4260
Wed Jul 14 15:54:36 2010
Shutting down instance: further logons disabled
Wed Jul 14 15:54:36 2010
Stopping background process QMNC
Wed Jul 14 15:54:36 2010
Stopping background process CJQ0
Wed Jul 14 15:54:38 2010
Stopping background process MMNL
Wed Jul 14 15:54:39 2010
Stopping background process MMON
Wed Jul 14 15:54:40 2010
Shutting down instance (immediate)
License high water mark = 11
Wed Jul 14 15:54:40 2010
Stopping Job queue slave processes
Wed Jul 14 15:54:40 2010
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Wed Jul 14 15:54:46 2010
ALTER DATABASE CLOSE NORMAL
Wed Jul 14 15:54:46 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Jul 14 15:54:46 2010
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 124
Successful close of redo thread 1
Wed Jul 14 15:54:47 2010
Completed: ALTER DATABASE CLOSE NORMAL
Wed Jul 14 15:54:47 2010
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
Wed Jul 14 16:11:45 2010
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 = 134217728
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 452984832
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=3892
PSP0 started with pid=3, OS id=3240
MMAN started with pid=4, OS id=3224
DBW0 started with pid=5, OS id=2616
LGWR started with pid=6, OS id=3528
CKPT started with pid=7, OS id=5344
SMON started with pid=8, OS id=3512
RECO started with pid=9, OS id=2884
CJQ0 started with pid=10, OS id=4492
MMON started with pid=11, OS id=5492
Wed Jul 14 16:11:46 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2684
Wed Jul 14 16:11:46 2010
starting up 1 shared server(s) ...
Wed Jul 14 16:11:46 2010
ALTER DATABASE MOUNT
Wed Jul 14 16:11:49 2010
ORA-214 signalled during: ALTER DATABASE MOUNT...
Wed Jul 14 16:13:01 2010
Starting ORACLE instance (normal)
Wed Jul 14 16:13:52 2010
Starting ORACLE instance (normal)
Wed Jul 14 16:14:07 2010
Shutting down instance: further logons disabled
Wed Jul 14 16:14:07 2010
Stopping background process MMNL
Wed Jul 14 16:14:08 2010
Stopping background process MMON
Wed Jul 14 16:14:09 2010
Stopping background process CJQ0
Wed Jul 14 16:14:10 2010
Shutting down instance (immediate)
License high water mark = 1
Wed Jul 14 16:14:10 2010
Stopping Job queue slave processes
Wed Jul 14 16:14:10 2010
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jul 14 16:14:12 2010
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Wed Jul 14 16:14:32 2010
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 = 134217728
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 452984832
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=5408
PSP0 started with pid=3, OS id=4536
MMAN started with pid=4, OS id=4328
DBW0 started with pid=5, OS id=3436
LGWR started with pid=6, OS id=4412
CKPT started with pid=7, OS id=3104
SMON started with pid=8, OS id=4664
RECO started with pid=9, OS id=4636
CJQ0 started with pid=10, OS id=4704
MMON started with pid=11, OS id=380
Wed Jul 14 16:14:33 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=3232
Wed Jul 14 16:14:33 2010
starting up 1 shared server(s) ...
Wed Jul 14 16:14:33 2010
ALTER DATABASE MOUNT
Wed Jul 14 16:14:36 2010
ORA-214 signalled during: ALTER DATABASE MOUNT...
Wed Jul 14 17:03:26 2010
Starting ORACLE instance (normal)
Wed Jul 14 17:03:37 2010
Shutting down instance: further logons disabled
Wed Jul 14 17:03:37 2010
Stopping background process MMNL
Wed Jul 14 17:03:38 2010
Stopping background process CJQ0
Wed Jul 14 17:03:38 2010
Stopping background process MMON
Wed Jul 14 17:03:39 2010
Shutting down instance (immediate)
License high water mark = 1
Wed Jul 14 17:03:39 2010
Stopping Job queue slave processes
Wed Jul 14 17:03:39 2010
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jul 14 17:03:41 2010
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Wed Jul 14 17:04:30 2010
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 = 134217728
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 452984832
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=4768
PSP0 started with pid=3, OS id=4436
MMAN started with pid=4, OS id=3704
DBW0 started with pid=5, OS id=2416
LGWR started with pid=6, OS id=3232
CKPT started with pid=7, OS id=2804
SMON started with pid=8, OS id=3364
RECO started with pid=9, OS id=1212
CJQ0 started with pid=10, OS id=3692
MMON started with pid=11, OS id=3928
Wed Jul 14 17:04:31 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Jul 14 17:04:31 2010
starting up 1 shared server(s) ...
Wed Jul 14 17:04:31 2010
ALTER DATABASE MOUNT
MMNL started with pid=12, OS id=2288
Wed Jul 14 17:04:34 2010
ORA-214 signalled during: ALTER DATABASE MOUNT...
Wed Jul 14 17:05:46 2010
Starting ORACLE instance (normal)
Wed Jul 14 17:06:00 2010
Shutting down instance: further logons disabled
Wed Jul 14 17:06:00 2010
Stopping background process CJQ0
Wed Jul 14 17:06:01 2010
Stopping background process MMNL
Wed Jul 14 17:06:02 2010
Stopping background process MMON
Wed Jul 14 17:06:03 2010
Shutting down instance (immediate)
License high water mark = 1
Wed Jul 14 17:06:03 2010
Stopping Job queue slave processes
Wed Jul 14 17:06:03 2010
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jul 14 17:06:05 2010
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Wed Jul 14 17:06:30 2010
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 = 134217728
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 452984832
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=3480
PSP0 started with pid=3, OS id=5040
MMAN started with pid=4, OS id=4016
DBW0 started with pid=5, OS id=5144
LGWR started with pid=6, OS id=2660
CKPT started with pid=7, OS id=4552
SMON started with pid=8, OS id=3908
RECO started with pid=9, OS id=4908
CJQ0 started with pid=10, OS id=5872
MMON started with pid=11, OS id=5820
Wed Jul 14 17:06:30 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=5448
Wed Jul 14 17:06:30 2010
starting up 1 shared server(s) ...
Wed Jul 14 17:06:30 2010
ALTER DATABASE MOUNT
Wed Jul 14 17:06:33 2010
ORA-214 signalled during: ALTER DATABASE MOUNT...
Wed Jul 14 17:07:03 2010
Starting ORACLE instance (normal)
Wed Jul 14 17:07:18 2010
alter database mount
Wed Jul 14 17:07:21 2010
ORA-214 signalled during: alter database mount...
Wed Jul 14 17:08:21 2010
Shutting down instance: further logons disabled
Wed Jul 14 17:08:21 2010
Stopping background process CJQ0
Wed Jul 14 17:08:22 2010
Stopping background process MMNL
Wed Jul 14 17:08:23 2010
Stopping background process MMON
Wed Jul 14 17:08:24 2010
Shutting down instance (immediate)
License high water mark = 1
Wed Jul 14 17:08:24 2010
Stopping Job queue slave processes
Wed Jul 14 17:08:24 2010
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jul 14 17:08:26 2010
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Wed Jul 14 17:08:40 2010
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 = 134217728
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 452984832
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=2856
PSP0 started with pid=3, OS id=5416
MMAN started with pid=4, OS id=1228
DBW0 started with pid=5, OS id=5608
LGWR started with pid=6, OS id=3692
CKPT started with pid=7, OS id=3684
SMON started with pid=8, OS id=5644
RECO started with pid=9, OS id=5308
CJQ0 started with pid=10, OS id=5752
MMON started with pid=11, OS id=3616
Wed Jul 14 17:08:41 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Jul 14 17:08:41 2010
starting up 1 shared server(s) ...
Wed Jul 14 17:08:41 2010
ALTER DATABASE MOUNT
MMNL started with pid=12, OS id=4112
Wed Jul 14 17:08:44 2010
ORA-214 signalled during: ALTER DATABASE MOUNT...
Wed Jul 14 17:09:29 2010
Starting ORACLE instance (normal)
Shutting down instance: further logons disabled
Wed Jul 14 17:09:37 2010
Stopping background process CJQ0
Wed Jul 14 17:09:38 2010
Stopping background process MMNL
Wed Jul 14 17:09:39 2010
Stopping background process MMON
Wed Jul 14 17:09:40 2010
Shutting down instance (immediate)
License high water mark = 1
Wed Jul 14 17:09:40 2010
Stopping Job queue slave processes
Wed Jul 14 17:09:40 2010
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jul 14 17:09:42 2010
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Wed Jul 14 17:11:07 2010
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 = 134217728
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 452984832
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=3480
PSP0 started with pid=3, OS id=4284
MMAN started with pid=4, OS id=704
DBW0 started with pid=5, OS id=3372
LGWR started with pid=6, OS id=4596
CKPT started with pid=7, OS id=1016
SMON started with pid=8, OS id=3384
RECO started with pid=9, OS id=3368
CJQ0 started with pid=10, OS id=1144
MMON started with pid=11, OS id=2672
Wed Jul 14 17:11:07 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=4644
Wed Jul 14 17:11:07 2010
starting up 1 shared server(s) ...
Wed Jul 14 17:11:07 2010
ALTER DATABASE MOUNT
Wed Jul 14 17:11:10 2010
ORA-214 signalled during: ALTER DATABASE MOUNT...
Wed Jul 14 17:26:01 2010
Shutting down instance: further logons disabled
Wed Jul 14 17:26:01 2010
Stopping background process MMNL
Wed Jul 14 17:26:02 2010
Stopping background process CJQ0
Wed Jul 14 17:26:02 2010
Stopping background process MMON
Wed Jul 14 17:26:03 2010
Shutting down instance (immediate)
License high water mark = 1
Wed Jul 14 17:26:03 2010
Stopping Job queue slave processes
Wed Jul 14 17:26:03 2010
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jul 14 17:26:05 2010
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Wed Jul 14 17:26:18 2010
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 = 134217728
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 452984832
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=3656
PSP0 started with pid=3, OS id=4388
MMAN started with pid=4, OS id=5316
DBW0 started with pid=5, OS id=2188
LGWR started with pid=6, OS id=2212
CKPT started with pid=7, OS id=3524
SMON started with pid=8, OS id=4876
RECO started with pid=9, OS id=5056
CJQ0 started with pid=10, OS id=4392
MMON started with pid=11, OS id=1216
Wed Jul 14 17:26:18 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=4188
Wed Jul 14 17:26:18 2010
starting up 1 shared server(s) ...
Wed Jul 14 17:26:18 2010
ALTER DATABASE MOUNT
Wed Jul 14 17:26:21 2010
ORA-214 signalled during: ALTER DATABASE MOUNT...
Wed Jul 14 17:27:32 2010
Starting ORACLE instance (normal)
Wed Jul 14 17:27:48 2010
Shutting down instance: further logons disabled
Wed Jul 14 17:27:48 2010
Stopping background process MMNL
Wed Jul 14 17:27:49 2010
Stopping background process CJQ0
Wed Jul 14 17:27:50 2010
Stopping background process MMON
Wed Jul 14 17:27:50 2010
Shutting down instance (immediate)
License high water mark = 1
Wed Jul 14 17:27:50 2010
Stopping Job queue slave processes
Wed Jul 14 17:27:50 2010
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jul 14 17:27:52 2010
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Wed Jul 14 17:28:59 2010
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 = 134217728
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 452984832
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=2024
PSP0 started with pid=3, OS id=2708
MMAN started with pid=4, OS id=692
DBW0 started with pid=5, OS id=4056
LGWR started with pid=6, OS id=3648
CKPT started with pid=7, OS id=5092
SMON started with pid=8, OS id=1188
RECO started with pid=9, OS id=2700
CJQ0 started with pid=10, OS id=2284
MMON started with pid=11, OS id=2136
Wed Jul 14 17:29:00 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2140
Wed Jul 14 17:29:00 2010
starting up 1 shared server(s) ...
Wed Jul 14 17:29:08 2010
Starting ORACLE instance (normal)
Wed Jul 14 17:29:26 2010
alter database mount
Wed Jul 14 17:29:29 2010
ORA-214 signalled during: alter database mount
...
Wed Jul 14 17:36:57 2010
Starting ORACLE instance (normal)
Shutting down instance: further logons disabled
Wed Jul 14 17:37:03 2010
Stopping background process MMNL
Wed Jul 14 17:37:04 2010
Stopping background process CJQ0
Wed Jul 14 17:37:05 2010
Stopping background process MMON
Wed Jul 14 17:37:05 2010
Shutting down instance (immediate)
License high water mark = 1
Wed Jul 14 17:37:05 2010
Stopping Job queue slave processes
Wed Jul 14 17:37:05 2010
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jul 14 17:37:07 2010
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Wed Jul 14 17:38:25 2010
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 = 134217728
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 452984832
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=1400
PSP0 started with pid=3, OS id=3856
MMAN started with pid=4, OS id=5796
DBW0 started with pid=5, OS id=6116
LGWR started with pid=6, OS id=3260
CKPT started with pid=7, OS id=5876
SMON started with pid=8, OS id=2904
RECO started with pid=9, OS id=3284
CJQ0 started with pid=10, OS id=5912
MMON started with pid=11, OS id=1848
Wed Jul 14 17:38:25 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=1472
Wed Jul 14 17:38:25 2010
starting up 1 shared server(s) ...
Wed Jul 14 17:38:25 2010
ALTER DATABASE MOUNT
Wed Jul 14 17:38:28 2010
ORA-214 signalled during: ALTER DATABASE MOUNT...
Shutting down instance: further logons disabled
Wed Jul 14 17:44:20 2010
Stopping background process MMNL
Wed Jul 14 17:44:21 2010
Stopping background process CJQ0
Wed Jul 14 17:44:21 2010
Stopping background process MMON
Wed Jul 14 17:44:22 2010
Shutting down instance (immediate)
License high water mark = 1
Wed Jul 14 17:44:22 2010
Stopping Job queue slave processes
Wed Jul 14 17:44:22 2010
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jul 14 17:44:24 2010
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Wed Jul 14 17:44:31 2010
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 = 134217728
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 452984832
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=3860
PSP0 started with pid=3, OS id=1420
MMAN started with pid=4, OS id=1688
DBW0 started with pid=5, OS id=2520
LGWR started with pid=6, OS id=5440
CKPT started with pid=7, OS id=2524
SMON started with pid=8, OS id=5216
RECO started with pid=9, OS id=4516
CJQ0 started with pid=10, OS id=2816
MMON started with pid=11, OS id=2572
Wed Jul 14 17:44:32 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2568
Wed Jul 14 17:44:32 2010
starting up 1 shared server(s) ...
Wed Jul 14 17:44:32 2010
ALTER DATABASE MOUNT
Wed Jul 14 17:44:35 2010
ORA-214 signalled during: ALTER DATABASE MOUNT...
Wed Jul 14 17:45:47 2010
ALTER DATABASE RECOVER DATABASE
Wed Jul 14 17:45:47 2010
ORA-1507 signalled during: ALTER DATABASE RECOVER DATABASE ...
Wed Jul 14 17:45:57 2010
ALTER DATABASE MOUNT
Wed Jul 14 17:46:00 2010
ORA-214 signalled during: ALTER DATABASE MOUNT...
Wed Jul 14 18:07:58 2010
Shutting down instance: further logons disabled
Wed Jul 14 18:07:58 2010
Stopping background process MMNL
Wed Jul 14 18:07:59 2010
Stopping background process CJQ0
Wed Jul 14 18:07:59 2010
Stopping background process MMON
Wed Jul 14 18:08:00 2010
Shutting down instance (immediate)
License high water mark = 2
Wed Jul 14 18:08:00 2010
Stopping Job queue slave processes
Wed Jul 14 18:08:00 2010
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jul 14 18:08:08 2010
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Wed Jul 14 18:08:35 2010
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 = 134217728
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 452984832
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=2292
PSP0 started with pid=3, OS id=4972
MMAN started with pid=4, OS id=316
DBW0 started with pid=5, OS id=512
LGWR started with pid=6, OS id=4124
CKPT started with pid=7, OS id=5676
SMON started with pid=8, OS id=4212
RECO started with pid=9, OS id=5040
CJQ0 started with pid=10, OS id=2452
MMON started with pid=11, OS id=1736
Wed Jul 14 18:08:35 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=5904
Wed Jul 14 18:08:35 2010
starting up 1 shared server(s) ...
Wed Jul 14 18:08:42 2010
ALTER DATABASE MOUNT
Wed Jul 14 18:08:45 2010
ORA-214 signalled during: ALTER DATABASE MOUNT...
Wed Jul 14 18:16:29 2010
ALTER SYSTEM SET control_files='D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL' SCOPE=SPFILE;
Wed Jul 14 18:16:51 2010
Shutting down instance: further logons disabled
Wed Jul 14 18:16:51 2010
Stopping background process MMNL
Wed Jul 14 18:16:52 2010
Stopping background process CJQ0
Wed Jul 14 18:16:53 2010
Stopping background process MMON
Wed Jul 14 18:16:53 2010
Shutting down instance (immediate)
License high water mark = 1
Wed Jul 14 18:16:53 2010
Stopping Job queue slave processes
Wed Jul 14 18:16:53 2010
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jul 14 18:16:54 2010
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Wed Jul 14 18:17:34 2010
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
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=2144
PSP0 started with pid=3, OS id=1356
MMAN started with pid=4, OS id=2240
DBW0 started with pid=5, OS id=3820
LGWR started with pid=6, OS id=3524
CKPT started with pid=7, OS id=5056
SMON started with pid=8, OS id=3188
RECO started with pid=9, OS id=3988
CJQ0 started with pid=10, OS id=3148
MMON started with pid=11, OS id=5024
Wed Jul 14 18:17:34 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Jul 14 18:17:34 2010
starting up 1 shared server(s) ...
Wed Jul 14 18:17:34 2010
ALTER DATABASE MOUNT
MMNL started with pid=12, OS id=680
Wed Jul 14 18:17:37 2010
ORA-214 signalled during: ALTER DATABASE MOUNT...
Wed Jul 14 18:18:16 2010
Shutting down instance: further logons disabled
Wed Jul 14 18:18:16 2010
Stopping background process CJQ0
Wed Jul 14 18:18:17 2010
Stopping background process MMNL
Wed Jul 14 18:18:18 2010
Stopping background process MMON
Wed Jul 14 18:18:19 2010
Shutting down instance (immediate)
License high water mark = 1
Wed Jul 14 18:18:19 2010
Stopping Job queue slave processes
Wed Jul 14 18:18:19 2010
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
Waiting for shared server 'S000' to die
All dispatchers and shared servers shutdown
Wed Jul 14 18:18:20 2010
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Wed Jul 14 18:18:26 2010
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 = 134217728
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 452984832
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=2716
PSP0 started with pid=3, OS id=5308
MMAN started with pid=4, OS id=1700
DBW0 started with pid=5, OS id=5108
LGWR started with pid=6, OS id=5760
CKPT started with pid=7, OS id=528
SMON started with pid=8, OS id=4248
RECO started with pid=9, OS id=4484
CJQ0 started with pid=10, OS id=1528
MMON started with pid=11, OS id=132
Wed Jul 14 18:18:27 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=2648
Wed Jul 14 18:18:27 2010
starting up 1 shared server(s) ...
Wed Jul 14 18:18:27 2010
ALTER DATABASE MOUNT
Wed Jul 14 18:18:27 2010
ORA-00202: control file: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 123) The filename, directory name, or volume label syntax is incorrect.
Wed Jul 14 18:18:27 2010
ORA-205 signalled during: ALTER DATABASE MOUNT...
Thu Jul 15 10:11:59 2010
Starting ORACLE instance (normal)
Thu Jul 15 10:12:12 2010
Shutting down instance: further logons disabled
Thu Jul 15 10:12:12 2010
Stopping background process MMNL
Thu Jul 15 10:12:12 2010
Stopping background process CJQ0
Thu Jul 15 10:12:13 2010
Stopping background process MMON
Thu Jul 15 10:12:14 2010
Shutting down instance (immediate)
License high water mark = 1
Thu Jul 15 10:12:14 2010
Stopping Job queue slave processes
Thu Jul 15 10:12:14 2010
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Thu Jul 15 10:12:16 2010
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
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
Thu Jul 15 10:12:44 2010
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 = 134217728
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 452984832
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=4228
PSP0 started with pid=3, OS id=2484
MMAN started with pid=4, OS id=4880
DBW0 started with pid=5, OS id=4192
LGWR started with pid=6, OS id=5904
CKPT started with pid=7, OS id=2628
SMON started with pid=8, OS id=5948
RECO started with pid=9, OS id=1824
CJQ0 started with pid=10, OS id=3452
MMON started with pid=11, OS id=5104
Thu Jul 15 10:12:45 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=4636
Thu Jul 15 10:12:45 2010
starting up 1 shared server(s) ...
Thu Jul 15 10:12:45 2010
ALTER DATABASE MOUNT
Thu Jul 15 10:12:45 2010
ORA-00202: control file: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 123) The filename, directory name, or volume label syntax is incorrect.
Thu Jul 15 10:12:45 2010
ORA-205 signalled during: ALTER DATABASE MOUNT...
Thu Jul 15 10:13:54 2010
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 1836
Thu Jul 15 10:13:56 2010
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 = 134217728
__large_pool_size = 4194304
__java_pool_size = 12582912
__streams_pool_size = 0
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 452984832
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = D:\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=ORCLXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = ORCL
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=3240
PSP0 started with pid=3, OS id=3508
MMAN started with pid=4, OS id=3592
DBW0 started with pid=5, OS id=2704
LGWR started with pid=6, OS id=5064
CKPT started with pid=7, OS id=2680
SMON started with pid=8, OS id=3572
RECO started with pid=9, OS id=5072
CJQ0 started with pid=10, OS id=4052
MMON started with pid=11, OS id=2232
Thu Jul 15 10:13:56 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Jul 15 10:13:56 2010
starting up 1 shared server(s) ...
Thu Jul 15 10:13:57 2010
ALTER DATABASE MOUNT
Thu Jul 15 10:13:57 2010
ORA-00202: control file: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 123) The filename, directory name, or volume label syntax is incorrect.
MMNL started with pid=12, OS id=1300
Thu Jul 15 10:14:00 2010
ORA-205 signalled during: ALTER DATABASE MOUNT...
Thu Jul 15 10:24:38 2010
alter database open
Thu Jul 15 10:24:38 2010
ORA-1507 signalled during: alter database open...
Thu Jul 15 10:24:44 2010
alter database mount
Thu Jul 15 10:24:44 2010
ORA-00202: control file: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 123) The filename, directory name, or volume label syntax is incorrect.
ORA-205 signalled during: alter database mount...
|
|
|
|
| Re: ORA-00214: [message #465630 is a reply to message #465603] |
Thu, 15 July 2010 01:00 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
It is useless to post the WHOLe lert.log just the last startup with the current error would be sufficient.
Quote:O/S-Error: (OS 123) The filename, directory name, or volume label syntax is incorrect.
control_files parameter should be:
control_files = ("D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL", "D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL", "D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL")
Check your init.ora.
Regards
Michel
Regards
Michel
|
|
|
|
Goto Forum:
Current Time: Sun Dec 01 13:15:59 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
