Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Dump file c:\orant\admin\trx\bdump\alert_trx.log
- Sun Jan 13 12:46:26 2008
- ORACLE V9.2.0.1.0 - Production vsnsta=0
- vsnsql=12 vsnxtr=3
- Windows 2000 Version 5.2 Service Pack 2, CPU type 586
- Sun Jan 13 12:46:26 2008
- Starting ORACLE instance (normal)
- Sun Jan 13 12:46:26 2008
- Running with 1 strand for Non-Enterprise Edition
- LICENSE_MAX_SESSION = 0
- LICENSE_SESSIONS_WARNING = 0
- SCN scheme 2
- Using log_archive_dest parameter default value
- Running with 1 strand for Non-Enterprise Edition
- LICENSE_MAX_USERS = 0
- SYS auditing is disabled
- Starting up ORACLE RDBMS Version: 9.2.0.1.0.
- System parameters with non-default values:
- processes = 150
- timed_statistics = TRUE
- shared_pool_size = 209715200
- large_pool_size = 125829120
- java_pool_size = 33554432
- pre_page_sga = TRUE
- enqueue_resources = 4096
- control_files = C:\orant\trx\control01.ctl, C:\orant\trx\control02.ctl, C:\orant\trx\control03.ctl
- db_block_size = 6144
- db_cache_size = 620756992
- compatible = 9.2.0.0.0
- db_file_multiblock_read_count= 16
- fast_start_mttr_target = 0
- undo_management = AUTO
- undo_tablespace = UNDOTBS1
- undo_retention = 10800
- remote_login_passwordfile= EXCLUSIVE
- db_domain = trxserver.com
- instance_name = trx
- dispatchers = (PROTOCOL=TCP) (SERVICE=trxXDB)
- job_queue_processes = 10
- hash_join_enabled = TRUE
- background_dump_dest = C:\orant\admin\trx\bdump
- user_dump_dest = C:\orant\admin\trx\udump
- core_dump_dest = C:\orant\admin\trx\cdump
- sort_area_size = 524288
- db_name = trx
- open_cursors = 4096
- star_transformation_enabled= FALSE
- query_rewrite_enabled = FALSE
- pga_aggregate_target = 272629760
- aq_tm_processes = 1
- PMON started with pid=2
- DBW0 started with pid=3
- LGWR started with pid=4
- CKPT started with pid=5
- SMON started with pid=6
- RECO started with pid=7
- CJQ0 started with pid=8
- QMN0 started with pid=9
- Sun Jan 13 12:46:29 2008
- starting up 1 shared server(s) ...
- starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
- Oracle Data Guard is not available in this edition of Oracle.
- Sun Jan 13 12:46:30 2008
- CREATE DATABASE trx
- MAXINSTANCES 1
- MAXLOGHISTORY 1
- MAXLOGFILES 5
- MAXLOGMEMBERS 3
- MAXDATAFILES 100
- DATAFILE 'C:\orant\trx\system01.dbf' SIZE 500M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
- EXTENT MANAGEMENT LOCAL
- DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'C:\orant\trx\temp01.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
- UNDO TABLESPACE "UNDOTBS1" DATAFILE 'C:\orant\trx\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
- CHARACTER SET WE8MSWIN1252
- NATIONAL CHARACTER SET AL16UTF16
- LOGFILE GROUP 1 ('C:\orant\trx\redo01.log') SIZE 102400K,
- GROUP 2 ('C:\orant\trx\redo02.log') SIZE 102400K,
- GROUP 3 ('C:\orant\trx\redo03.log') SIZE 102400K
- Sun Jan 13 12:46:31 2008
- Database mounted in Exclusive Mode.
- Sun Jan 13 12:46:41 2008
- Successful mount of redo thread 1, with mount id 1951428774.
- Assigning activation ID 1951428774 (0x745070a6)
- Thread 1 opened at log sequence 1
- Current log# 1 seq# 1 mem# 0: C:\ORANT\TRX\REDO01.LOG
- Successful open of redo thread 1.
- Sun Jan 13 12:46:42 2008
- SMON: enabling cache recovery
- Sun Jan 13 12:46:42 2008
- WARNING: Default passwords for SYS and SYSTEM will be used.
- Please change the passwords.
- Sun Jan 13 12:46:42 2008
- create tablespace SYSTEM datafile 'C:\orant\trx\system01.dbf' SIZE 500M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
- EXTENT MANAGEMENT LOCAL online
- Sun Jan 13 12:46:56 2008
- Completed: create tablespace SYSTEM datafile 'C:\orant\trx\s
- Sun Jan 13 12:46:56 2008
- create rollback segment SYSTEM tablespace SYSTEM
- storage (initial 50K next 50K)
- Completed: create rollback segment SYSTEM tablespace SYSTEM
- Sun Jan 13 12:46:59 2008
- CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE 'C:\orant\trx\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
- Created Undo Segment _SYSSMU1$
- Created Undo Segment _SYSSMU2$
- Created Undo Segment _SYSSMU3$
- Created Undo Segment _SYSSMU4$
- Created Undo Segment _SYSSMU5$
- Created Undo Segment _SYSSMU6$
- Created Undo Segment _SYSSMU7$
- Created Undo Segment _SYSSMU8$
- Created Undo Segment _SYSSMU9$
- Created Undo Segment _SYSSMU10$
- Undo Segment 1 Onlined
- Undo Segment 2 Onlined
- Undo Segment 3 Onlined
- Undo Segment 4 Onlined
- Undo Segment 5 Onlined
- Undo Segment 6 Onlined
- Undo Segment 7 Onlined
- Undo Segment 8 Onlined
- Undo Segment 9 Onlined
- Undo Segment 10 Onlined
- Successfully onlined Undo Tablespace 1.
- Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE 'C:\oran
- Sun Jan 13 12:47:05 2008
- CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 'C:\orant\trx\temp01.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
- Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 'C:\ora
- Sun Jan 13 12:47:06 2008
- ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
- Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
- Sun Jan 13 12:47:07 2008
- SMON: enabling tx recovery
- Sun Jan 13 12:47:13 2008
- replication_dependency_tracking turned off (no async multimaster replication found)
- Completed: CREATE DATABASE trx
- MAXINSTANCES 1
- MAXLOGHISTORY 1
- Sun Jan 13 12:47:13 2008
- CREATE TABLESPACE "DRSYS" LOGGING DATAFILE 'C:\orant\trx\drsys01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
- Completed: CREATE TABLESPACE "DRSYS" LOGGING DATAFILE 'C:\ora
- Sun Jan 13 12:47:14 2008
- CREATE TABLESPACE "TOOLS" LOGGING DATAFILE 'C:\orant\trx\tools01.dbf' SIZE 10M REUSE AUTOEXTEND ON NEXT 320K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
- Completed: CREATE TABLESPACE "TOOLS" LOGGING DATAFILE 'C:\ora
- Sun Jan 13 12:47:16 2008
- CREATE TABLESPACE "TRX_DATA" LOGGING DATAFILE 'C:\orant\trx\trx_data.dbf' SIZE 750M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
- Sun Jan 13 12:47:36 2008
- Completed: CREATE TABLESPACE "TRX_DATA" LOGGING DATAFILE 'C:\
- Sun Jan 13 12:47:36 2008
- CREATE TABLESPACE "TRX_INDEX" LOGGING DATAFILE 'C:\orant\trx\trx_index.dbf' SIZE 750M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
- Sun Jan 13 12:47:57 2008
- Completed: CREATE TABLESPACE "TRX_INDEX" LOGGING DATAFILE 'C:
- Sun Jan 13 12:47:57 2008
- CREATE TABLESPACE "XDB" LOGGING DATAFILE 'C:\orant\trx\xdb01.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
- Completed: CREATE TABLESPACE "XDB" LOGGING DATAFILE 'C:\orant
- Sun Jan 13 12:50:08 2008
- Thread 1 advanced to log sequence 2
- Current log# 2 seq# 2 mem# 0: C:\ORANT\TRX\REDO02.LOG
- Sun Jan 13 12:53:52 2008
- Thread 1 advanced to log sequence 3
- Current log# 3 seq# 3 mem# 0: C:\ORANT\TRX\REDO03.LOG
- Sun Jan 13 12:56:46 2008
- Thread 1 advanced to log sequence 4
- Current log# 1 seq# 4 mem# 0: C:\ORANT\TRX\REDO01.LOG
- Sun Jan 13 13:00:35 2008
- Thread 1 advanced to log sequence 5
- Current log# 2 seq# 5 mem# 0: C:\ORANT\TRX\REDO02.LOG
- Sun Jan 13 13:04:24 2008
- Thread 1 advanced to log sequence 6
- Current log# 3 seq# 6 mem# 0: C:\ORANT\TRX\REDO03.LOG
- Sun Jan 13 13:06:40 2008
- Thread 1 advanced to log sequence 7
- Current log# 1 seq# 7 mem# 0: C:\ORANT\TRX\REDO01.LOG
- Sun Jan 13 13:09:29 2008
- Shutting down instance: further logons disabled
- Sun Jan 13 13:11:33 2008
- Shutting down instance (normal)
- License high water mark = 3
- Waiting for dispatcher 'D000' to shutdown
- All dispatchers and shared servers shutdown
- Sun Jan 13 13:11:35 2008
- ALTER DATABASE CLOSE NORMAL
- Sun Jan 13 13:11:35 2008
- SMON: disabling tx recovery
- SMON: disabling cache recovery
- Sun Jan 13 13:11:36 2008
- Shutting down archive processes
- Archiving is disabled
- Archive process shutdown avoided: 0 active
- Thread 1 closed at log sequence 7
- Successful close of redo thread 1.
- Sun Jan 13 13:11:36 2008
- Completed: ALTER DATABASE CLOSE NORMAL
- Sun Jan 13 13:11:36 2008
- ALTER DATABASE DISMOUNT
- Completed: ALTER DATABASE DISMOUNT
- ARCH: Archiving is disabled
- Shutting down archive processes
- Archiving is disabled
- Archive process shutdown avoided: 0 active
- ARCH: Archiving is disabled
- Shutting down archive processes
- Archiving is disabled
- Archive process shutdown avoided: 0 active
- Sun Jan 13 13:11:47 2008
- Starting ORACLE instance (normal)
- Sun Jan 13 13:11:47 2008
- Running with 1 strand for Non-Enterprise Edition
- LICENSE_MAX_SESSION = 0
- LICENSE_SESSIONS_WARNING = 0
- SCN scheme 2
- Using log_archive_dest parameter default value
- Running with 1 strand for Non-Enterprise Edition
- LICENSE_MAX_USERS = 0
- SYS auditing is disabled
- Starting up ORACLE RDBMS Version: 9.2.0.1.0.
- System parameters with non-default values:
- processes = 150
- timed_statistics = TRUE
- shared_pool_size = 209715200
- large_pool_size = 125829120
- java_pool_size = 33554432
- pre_page_sga = TRUE
- enqueue_resources = 4096
- control_files = C:\orant\trx\control01.ctl, C:\orant\trx\control02.ctl, C:\orant\trx\control03.ctl
- db_block_size = 6144
- db_cache_size = 620756992
- compatible = 9.2.0.0.0
- db_file_multiblock_read_count= 16
- fast_start_mttr_target = 0
- undo_management = AUTO
- undo_tablespace = UNDOTBS1
- undo_retention = 10800
- remote_login_passwordfile= EXCLUSIVE
- db_domain = trxserver.com
- instance_name = trx
- dispatchers = (PROTOCOL=TCP) (SERVICE=trxXDB)
- job_queue_processes = 10
- hash_join_enabled = TRUE
- background_dump_dest = C:\orant\admin\trx\bdump
- user_dump_dest = C:\orant\admin\trx\udump
- core_dump_dest = C:\orant\admin\trx\cdump
- sort_area_size = 524288
- db_name = trx
- open_cursors = 4096
- star_transformation_enabled= FALSE
- query_rewrite_enabled = FALSE
- pga_aggregate_target = 272629760
- aq_tm_processes = 1
- PMON started with pid=2
- DBW0 started with pid=3
- LGWR started with pid=4
- CKPT started with pid=5
- SMON started with pid=6
- RECO started with pid=7
- CJQ0 started with pid=8
- QMN0 started with pid=9
- Sun Jan 13 13:11:50 2008
- starting up 1 shared server(s) ...
- starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
- Oracle Data Guard is not available in this edition of Oracle.
- Sun Jan 13 13:11:50 2008
- ALTER DATABASE MOUNT
- Sun Jan 13 13:11:55 2008
- Successful mount of redo thread 1, with mount id 1951424662.
- Sun Jan 13 13:11:55 2008
- Database mounted in Exclusive Mode.
- Completed: ALTER DATABASE MOUNT
- Sun Jan 13 13:11:55 2008
- ALTER DATABASE OPEN
- Sun Jan 13 13:11:56 2008
- Thread 1 opened at log sequence 7
- Current log# 1 seq# 7 mem# 0: C:\ORANT\TRX\REDO01.LOG
- Successful open of redo thread 1.
- Sun Jan 13 13:11:56 2008
- SMON: enabling cache recovery
- Sun Jan 13 13:11:56 2008
- Undo Segment 1 Onlined
- Undo Segment 2 Onlined
- Undo Segment 3 Onlined
- Undo Segment 4 Onlined
- Undo Segment 5 Onlined
- Undo Segment 6 Onlined
- Undo Segment 7 Onlined
- Undo Segment 8 Onlined
- Undo Segment 9 Onlined
- Undo Segment 10 Onlined
- Successfully onlined Undo Tablespace 1.
- Sun Jan 13 13:11:56 2008
- SMON: enabling tx recovery
- Sun Jan 13 13:11:56 2008
- Database Characterset is WE8MSWIN1252
- replication_dependency_tracking turned off (no async multimaster replication found)
- Completed: ALTER DATABASE OPEN
- Sun Jan 13 13:42:41 2008
- Replication pre-import: trying to disable constraint REPCAT$_TEMPLATE_OBJECTS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS"
- Replication pre-import: constraint REPCAT$_TEMPLATE_OBJECTS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_TEMPLATE_PARMS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_PARMS"
- Replication pre-import: constraint REPCAT$_TEMPLATE_PARMS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_PARMS" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_OBJECT_PARMS_FK1 for "SYSTEM"."REPCAT$_OBJECT_PARMS"
- Replication pre-import: constraint REPCAT$_OBJECT_PARMS_FK1 for "SYSTEM"."REPCAT$_OBJECT_PARMS" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_OBJECT_PARMS_FK2 for "SYSTEM"."REPCAT$_OBJECT_PARMS"
- Replication pre-import: constraint REPCAT$_OBJECT_PARMS_FK2 for "SYSTEM"."REPCAT$_OBJECT_PARMS" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_USER_AUTHORIZATION_FK2 for "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS"
- Replication pre-import: constraint REPCAT$_USER_AUTHORIZATION_FK2 for "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_USER_PARM_VALUES_FK1 for "SYSTEM"."REPCAT$_USER_PARM_VALUES"
- Replication pre-import: constraint REPCAT$_USER_PARM_VALUES_FK1 for "SYSTEM"."REPCAT$_USER_PARM_VALUES" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_FLAVOR_OBJECTS_FK2 for "SYSTEM"."REPCAT$_FLAVOR_OBJECTS"
- Replication pre-import: constraint REPCAT$_FLAVOR_OBJECTS_FK2 for "SYSTEM"."REPCAT$_FLAVOR_OBJECTS" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_FLAVOR_OBJECTS_FK1 for "SYSTEM"."REPCAT$_FLAVOR_OBJECTS"
- Replication pre-import: constraint REPCAT$_FLAVOR_OBJECTS_FK1 for "SYSTEM"."REPCAT$_FLAVOR_OBJECTS" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_FLAVORS_FK1 for "SYSTEM"."REPCAT$_FLAVORS"
- Replication pre-import: constraint REPCAT$_FLAVORS_FK1 for "SYSTEM"."REPCAT$_FLAVORS" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_REPSCHEMA_DEST for "SYSTEM"."REPCAT$_REPSCHEMA"
- Replication pre-import: constraint REPCAT$_REPSCHEMA_DEST for "SYSTEM"."REPCAT$_REPSCHEMA" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_REPOBJECT_PRNT for "SYSTEM"."REPCAT$_REPOBJECT"
- Replication pre-import: constraint REPCAT$_REPOBJECT_PRNT for "SYSTEM"."REPCAT$_REPOBJECT" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_REPGEN_PRNT2 for "SYSTEM"."REPCAT$_GENERATED"
- Replication pre-import: constraint REPCAT$_REPGEN_PRNT2 for "SYSTEM"."REPCAT$_GENERATED" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_REPGEN_PRNT for "SYSTEM"."REPCAT$_GENERATED"
- Replication pre-import: constraint REPCAT$_REPGEN_PRNT for "SYSTEM"."REPCAT$_GENERATED" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_PARAMETER_COLUMN_F1 for "SYSTEM"."REPCAT$_PARAMETER_COLUMN"
- Replication pre-import: constraint REPCAT$_PARAMETER_COLUMN_F1 for "SYSTEM"."REPCAT$_PARAMETER_COLUMN" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_PRIORITY_F1 for "SYSTEM"."REPCAT$_PRIORITY"
- Replication pre-import: constraint REPCAT$_PRIORITY_F1 for "SYSTEM"."REPCAT$_PRIORITY" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_REPSCHEMA_PRNT for "SYSTEM"."REPCAT$_REPSCHEMA"
- Replication pre-import: constraint REPCAT$_REPSCHEMA_PRNT for "SYSTEM"."REPCAT$_REPSCHEMA" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_REPCOLUMN_FK for "SYSTEM"."REPCAT$_REPCOLUMN"
- Replication pre-import: constraint REPCAT$_REPCOLUMN_FK for "SYSTEM"."REPCAT$_REPCOLUMN" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_KEY_COLUMNS_PRNT for "SYSTEM"."REPCAT$_KEY_COLUMNS"
- Replication pre-import: constraint REPCAT$_KEY_COLUMNS_PRNT for "SYSTEM"."REPCAT$_KEY_COLUMNS" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_REPPROP_PRNT for "SYSTEM"."REPCAT$_REPPROP"
- Replication pre-import: constraint REPCAT$_REPPROP_PRNT for "SYSTEM"."REPCAT$_REPPROP" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_DDL_PRNT for "SYSTEM"."REPCAT$_DDL"
- Replication pre-import: constraint REPCAT$_DDL_PRNT for "SYSTEM"."REPCAT$_DDL" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_GROUPED_COLUMN_F1 for "SYSTEM"."REPCAT$_GROUPED_COLUMN"
- Replication pre-import: constraint REPCAT$_GROUPED_COLUMN_F1 for "SYSTEM"."REPCAT$_GROUPED_COLUMN" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_RESOLUTION_F1 for "SYSTEM"."REPCAT$_RESOLUTION"
- Replication pre-import: constraint REPCAT$_RESOLUTION_F1 for "SYSTEM"."REPCAT$_RESOLUTION" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_RESOLUTION_F3 for "SYSTEM"."REPCAT$_RESOLUTION"
- Replication pre-import: constraint REPCAT$_RESOLUTION_F3 for "SYSTEM"."REPCAT$_RESOLUTION" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_AUDIT_COLUMN_F2 for "SYSTEM"."REPCAT$_AUDIT_COLUMN"
- Replication pre-import: constraint REPCAT$_AUDIT_COLUMN_F2 for "SYSTEM"."REPCAT$_AUDIT_COLUMN" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_AUDIT_COLUMN_F1 for "SYSTEM"."REPCAT$_AUDIT_COLUMN"
- Replication pre-import: constraint REPCAT$_AUDIT_COLUMN_F1 for "SYSTEM"."REPCAT$_AUDIT_COLUMN" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_REPGROUP_PRIVS_FK for "SYSTEM"."REPCAT$_REPGROUP_PRIVS"
- Replication pre-import: constraint REPCAT$_REPGROUP_PRIVS_FK for "SYSTEM"."REPCAT$_REPGROUP_PRIVS" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_PARAMETER_COLUMN_PK for "SYSTEM"."REPCAT$_PARAMETER_COLUMN"
- Replication pre-import: constraint REPCAT$_PARAMETER_COLUMN_PK for "SYSTEM"."REPCAT$_PARAMETER_COLUMN" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_GROUPED_COLUMN_PK for "SYSTEM"."REPCAT$_GROUPED_COLUMN"
- Replication pre-import: constraint REPCAT$_GROUPED_COLUMN_PK for "SYSTEM"."REPCAT$_GROUPED_COLUMN" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_SITES_NEW_FK1 for "SYSTEM"."REPCAT$_SITES_NEW"
- Replication pre-import: constraint REPCAT$_SITES_NEW_FK1 for "SYSTEM"."REPCAT$_SITES_NEW" is disabled successfully
- Replication pre-import: trying to disable constraint REPCAT$_SITES_NEW_FK2 for "SYSTEM"."REPCAT$_SITES_NEW"
- Replication pre-import: constraint REPCAT$_SITES_NEW_FK2 for "SYSTEM"."REPCAT$_SITES_NEW" is disabled successfully
- Sun Jan 13 13:42:42 2008
- CREATE UNDO TABLESPACE "RBS" BLOCKSIZE 4096 DATAFILE 'C:\ORACLE\ORA92\TRX\UNDOTBS01.DBF' SIZE 555745280 AUTOEXTEND ON NEXT 5242880 MAXSIZE 16383M EXTENT MANAGEMENT LOCAL
- ORA-29339 signalled during: CREATE UNDO TABLESPACE "RBS" BLOCKSIZE 4096 DATAFI...
- Sun Jan 13 13:42:42 2008
- CREATE TEMPORARY TABLESPACE "TEMP" BLOCKSIZE 4096 TEMPFILE 'C:\ORACLE\ORA92\TRX\TEMP01.DBF' SIZE 41943040 AUTOEXTEND ON NEXT 655360 MAXSIZE 16383M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576
- ORA-29339 signalled during: CREATE TEMPORARY TABLESPACE "TEMP" BLOCKSIZE 4096 ...
- Sun Jan 13 13:42:42 2008
- CREATE TABLESPACE "DRSYS" BLOCKSIZE 4096 DATAFILE 'C:\ORACLE\ORA92\TRX\DRSYS01.DBF' SIZE 20971520 AUTOEXTEND ON NEXT 655360 MAXSIZE 16383M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT NOLOGGING SEGMENT SPACE MANAGEMENT AUTO
- ORA-29339 signalled during: CREATE TABLESPACE "DRSYS" BLOCKSIZE 4096 DATAFILE ...
- Sun Jan 13 13:42:42 2008
- CREATE TABLESPACE "TOOLS" BLOCKSIZE 4096 DATAFILE 'C:\ORACLE\ORA92\TRX\TOOLS01.DBF' SIZE 10485760 AUTOEXTEND ON NEXT 327680 MAXSIZE 16383M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT NOLOGGING SEGMENT SPACE MANAGEMENT AUTO
- ORA-29339 signalled during: CREATE TABLESPACE "TOOLS" BLOCKSIZE 4096 DATAFILE ...
- Sun Jan 13 13:42:42 2008
- CREATE TABLESPACE "TRX_DATA" BLOCKSIZE 4096 DATAFILE 'C:\ORACLE\ORA92\TRX\TRX_DATA01.DBF' SIZE 772014080 AUTOEXTEND ON NEXT 1310720 MAXSIZE 16383M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT NOLOGGING SEGMENT SPACE MANAGEMENT AUTO
- ORA-29339 signalled during: CREATE TABLESPACE "TRX_DATA" BLOCKSIZE 4096 DATAFI...
- Sun Jan 13 13:42:42 2008
- CREATE TABLESPACE "TRX_INDEX" BLOCKSIZE 4096 DATAFILE 'C:\ORACLE\ORA92\TRX\TRX_INDEX01.DBF' SIZE 734003200 AUTOEXTEND ON NEXT 1310720 MAXSIZE 16383M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT NOLOGGING SEGMENT SPACE MANAGEMENT AUTO
- ORA-29339 signalled during: CREATE TABLESPACE "TRX_INDEX" BLOCKSIZE 4096 DATAF...
- Sun Jan 13 13:42:42 2008
- CREATE TABLESPACE "XDB" BLOCKSIZE 4096 DATAFILE 'C:\ORACLE\ORA92\TRX\XDB01.DBF' SIZE 39976960 AUTOEXTEND ON NEXT 655360 MAXSIZE 16383M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT NOLOGGING SEGMENT SPACE MANAGEMENT AUTO
- ORA-29339 signalled during: CREATE TABLESPACE "XDB" BLOCKSIZE 4096 DATAFILE '...
- Sun Jan 13 13:43:04 2008
- Thread 1 advanced to log sequence 8
- Current log# 2 seq# 8 mem# 0: C:\ORANT\TRX\REDO02.LOG
- Sun Jan 13 13:43:54 2008
- Thread 1 advanced to log sequence 9
- Current log# 3 seq# 9 mem# 0: C:\ORANT\TRX\REDO03.LOG
- Sun Jan 13 13:46:20 2008
- Thread 1 advanced to log sequence 10
- Current log# 1 seq# 10 mem# 0: C:\ORANT\TRX\REDO01.LOG
- Sun Jan 13 13:48:49 2008
- Thread 1 advanced to log sequence 11
- Current log# 2 seq# 11 mem# 0: C:\ORANT\TRX\REDO02.LOG
- Sun Jan 13 13:55:41 2008
- Thread 1 advanced to log sequence 12
- Current log# 3 seq# 12 mem# 0: C:\ORANT\TRX\REDO03.LOG
- Sun Jan 13 13:56:23 2008
- Replication after-import: trying to enable constraint REPCAT$_TEMPLATE_OBJECTS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS"
- Replication after-import: constraint REPCAT$_TEMPLATE_OBJECTS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_TEMPLATE_PARMS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_PARMS"
- Replication after-import: constraint REPCAT$_TEMPLATE_PARMS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_PARMS" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_OBJECT_PARMS_FK1 for "SYSTEM"."REPCAT$_OBJECT_PARMS"
- Replication after-import: constraint REPCAT$_OBJECT_PARMS_FK1 for "SYSTEM"."REPCAT$_OBJECT_PARMS" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_OBJECT_PARMS_FK2 for "SYSTEM"."REPCAT$_OBJECT_PARMS"
- Replication after-import: constraint REPCAT$_OBJECT_PARMS_FK2 for "SYSTEM"."REPCAT$_OBJECT_PARMS" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_USER_AUTHORIZATION_FK2 for "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS"
- Replication after-import: constraint REPCAT$_USER_AUTHORIZATION_FK2 for "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_USER_PARM_VALUES_FK1 for "SYSTEM"."REPCAT$_USER_PARM_VALUES"
- Replication after-import: constraint REPCAT$_USER_PARM_VALUES_FK1 for "SYSTEM"."REPCAT$_USER_PARM_VALUES" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_FLAVOR_OBJECTS_FK1 for "SYSTEM"."REPCAT$_FLAVOR_OBJECTS"
- Replication after-import: constraint REPCAT$_FLAVOR_OBJECTS_FK1 for "SYSTEM"."REPCAT$_FLAVOR_OBJECTS" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_FLAVOR_OBJECTS_FK2 for "SYSTEM"."REPCAT$_FLAVOR_OBJECTS"
- Replication after-import: constraint REPCAT$_FLAVOR_OBJECTS_FK2 for "SYSTEM"."REPCAT$_FLAVOR_OBJECTS" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_FLAVORS_FK1 for "SYSTEM"."REPCAT$_FLAVORS"
- Replication after-import: constraint REPCAT$_FLAVORS_FK1 for "SYSTEM"."REPCAT$_FLAVORS" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_REPSCHEMA_DEST for "SYSTEM"."REPCAT$_REPSCHEMA"
- Replication after-import: constraint REPCAT$_REPSCHEMA_DEST for "SYSTEM"."REPCAT$_REPSCHEMA" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_REPOBJECT_PRNT for "SYSTEM"."REPCAT$_REPOBJECT"
- Replication after-import: constraint REPCAT$_REPOBJECT_PRNT for "SYSTEM"."REPCAT$_REPOBJECT" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_REPGEN_PRNT2 for "SYSTEM"."REPCAT$_GENERATED"
- Replication after-import: constraint REPCAT$_REPGEN_PRNT2 for "SYSTEM"."REPCAT$_GENERATED" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_REPGEN_PRNT for "SYSTEM"."REPCAT$_GENERATED"
- Replication after-import: constraint REPCAT$_REPGEN_PRNT for "SYSTEM"."REPCAT$_GENERATED" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_PARAMETER_COLUMN_F1 for "SYSTEM"."REPCAT$_PARAMETER_COLUMN"
- Replication after-import: constraint REPCAT$_PARAMETER_COLUMN_F1 for "SYSTEM"."REPCAT$_PARAMETER_COLUMN" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_PRIORITY_F1 for "SYSTEM"."REPCAT$_PRIORITY"
- Replication after-import: constraint REPCAT$_PRIORITY_F1 for "SYSTEM"."REPCAT$_PRIORITY" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_REPSCHEMA_PRNT for "SYSTEM"."REPCAT$_REPSCHEMA"
- Replication after-import: constraint REPCAT$_REPSCHEMA_PRNT for "SYSTEM"."REPCAT$_REPSCHEMA" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_REPCOLUMN_FK for "SYSTEM"."REPCAT$_REPCOLUMN"
- Replication after-import: constraint REPCAT$_REPCOLUMN_FK for "SYSTEM"."REPCAT$_REPCOLUMN" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_KEY_COLUMNS_PRNT for "SYSTEM"."REPCAT$_KEY_COLUMNS"
- Replication after-import: constraint REPCAT$_KEY_COLUMNS_PRNT for "SYSTEM"."REPCAT$_KEY_COLUMNS" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_REPPROP_PRNT for "SYSTEM"."REPCAT$_REPPROP"
- Replication after-import: constraint REPCAT$_REPPROP_PRNT for "SYSTEM"."REPCAT$_REPPROP" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_DDL_PRNT for "SYSTEM"."REPCAT$_DDL"
- Replication after-import: constraint REPCAT$_DDL_PRNT for "SYSTEM"."REPCAT$_DDL" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_GROUPED_COLUMN_F1 for "SYSTEM"."REPCAT$_GROUPED_COLUMN"
- Replication after-import: constraint REPCAT$_GROUPED_COLUMN_F1 for "SYSTEM"."REPCAT$_GROUPED_COLUMN" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_RESOLUTION_F1 for "SYSTEM"."REPCAT$_RESOLUTION"
- Replication after-import: constraint REPCAT$_RESOLUTION_F1 for "SYSTEM"."REPCAT$_RESOLUTION" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_RESOLUTION_F3 for "SYSTEM"."REPCAT$_RESOLUTION"
- Replication after-import: constraint REPCAT$_RESOLUTION_F3 for "SYSTEM"."REPCAT$_RESOLUTION" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_AUDIT_COLUMN_F2 for "SYSTEM"."REPCAT$_AUDIT_COLUMN"
- Replication after-import: constraint REPCAT$_AUDIT_COLUMN_F2 for "SYSTEM"."REPCAT$_AUDIT_COLUMN" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_AUDIT_COLUMN_F1 for "SYSTEM"."REPCAT$_AUDIT_COLUMN"
- Replication after-import: constraint REPCAT$_AUDIT_COLUMN_F1 for "SYSTEM"."REPCAT$_AUDIT_COLUMN" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_REPGROUP_PRIVS_FK for "SYSTEM"."REPCAT$_REPGROUP_PRIVS"
- Replication after-import: constraint REPCAT$_REPGROUP_PRIVS_FK for "SYSTEM"."REPCAT$_REPGROUP_PRIVS" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_PARAMETER_COLUMN_PK for "SYSTEM"."REPCAT$_PARAMETER_COLUMN"
- Replication after-import: constraint REPCAT$_PARAMETER_COLUMN_PK for "SYSTEM"."REPCAT$_PARAMETER_COLUMN" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_GROUPED_COLUMN_PK for "SYSTEM"."REPCAT$_GROUPED_COLUMN"
- Replication after-import: constraint REPCAT$_GROUPED_COLUMN_PK for "SYSTEM"."REPCAT$_GROUPED_COLUMN" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_SITES_NEW_FK1 for "SYSTEM"."REPCAT$_SITES_NEW"
- Replication after-import: constraint REPCAT$_SITES_NEW_FK1 for "SYSTEM"."REPCAT$_SITES_NEW" is enabled successfully
- Replication after-import: trying to enable constraint REPCAT$_SITES_NEW_FK2 for "SYSTEM"."REPCAT$_SITES_NEW"
- Replication after-import: constraint REPCAT$_SITES_NEW_FK2 for "SYSTEM"."REPCAT$_SITES_NEW" is enabled successfully
- Dump file c:\orant\admin\trx\bdump\alert_trx.log
- Mon Jan 14 07:44:36 2008
- ORACLE V9.2.0.1.0 - Production vsnsta=0
- vsnsql=12 vsnxtr=3
- Windows 2000 Version 5.2 Service Pack 2, CPU type 586
- Mon Jan 14 07:44:36 2008
- Starting ORACLE instance (normal)
- Mon Jan 14 07:44:36 2008
- Running with 1 strand for Non-Enterprise Edition
- LICENSE_MAX_SESSION = 0
- LICENSE_SESSIONS_WARNING = 0
- SCN scheme 2
- Using log_archive_dest parameter default value
- Running with 1 strand for Non-Enterprise Edition
- LICENSE_MAX_USERS = 0
- SYS auditing is disabled
- Starting up ORACLE RDBMS Version: 9.2.0.1.0.
- System parameters with non-default values:
- processes = 150
- timed_statistics = TRUE
- shared_pool_size = 209715200
- large_pool_size = 125829120
- java_pool_size = 33554432
- pre_page_sga = TRUE
- enqueue_resources = 4096
- control_files = C:\orant\trx\control01.ctl, C:\orant\trx\control02.ctl, C:\orant\trx\control03.ctl
- db_block_size = 6144
- db_cache_size = 620756992
- compatible = 9.2.0.0.0
- db_file_multiblock_read_count= 16
- fast_start_mttr_target = 0
- undo_management = AUTO
- undo_tablespace = UNDOTBS1
- undo_retention = 10800
- remote_login_passwordfile= EXCLUSIVE
- db_domain = trxserver.com
- instance_name = trx
- dispatchers = (PROTOCOL=TCP) (SERVICE=trxXDB)
- job_queue_processes = 10
- hash_join_enabled = TRUE
- background_dump_dest = C:\orant\admin\trx\bdump
- user_dump_dest = C:\orant\admin\trx\udump
- core_dump_dest = C:\orant\admin\trx\cdump
- sort_area_size = 524288
- db_name = trx
- open_cursors = 4096
- star_transformation_enabled= FALSE
- query_rewrite_enabled = FALSE
- pga_aggregate_target = 272629760
- aq_tm_processes = 1
- PMON started with pid=2
- DBW0 started with pid=3
- LGWR started with pid=4
- CKPT started with pid=5
- SMON started with pid=6
- RECO started with pid=7
- CJQ0 started with pid=8
- QMN0 started with pid=9
- Mon Jan 14 07:44:40 2008
- starting up 1 shared server(s) ...
- starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
- Oracle Data Guard is not available in this edition of Oracle.
- Mon Jan 14 07:44:41 2008
- alter database mount exclusive
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement