API tools faq
paste
Advertisement
Stuporman

Alert.log

Stuporman
Dec 15th, 2012
245
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 30.95 KB | None | 0 0
raw download clone embed print report
  1. Dump file c:\orant\admin\trx\bdump\alert_trx.log
  2. Sun Jan 13 12:46:26 2008
  3. ORACLE V9.2.0.1.0 - Production vsnsta=0
  4. vsnsql=12 vsnxtr=3
  5. Windows 2000 Version 5.2 Service Pack 2, CPU type 586
  6. Sun Jan 13 12:46:26 2008
  7. Starting ORACLE instance (normal)
  8. Sun Jan 13 12:46:26 2008
  9. Running with 1 strand for Non-Enterprise Edition
  10. LICENSE_MAX_SESSION = 0
  11. LICENSE_SESSIONS_WARNING = 0
  12. SCN scheme 2
  13. Using log_archive_dest parameter default value
  14. Running with 1 strand for Non-Enterprise Edition
  15. LICENSE_MAX_USERS = 0
  16. SYS auditing is disabled
  17. Starting up ORACLE RDBMS Version: 9.2.0.1.0.
  18. System parameters with non-default values:
  19. processes = 150
  20. timed_statistics = TRUE
  21. shared_pool_size = 209715200
  22. large_pool_size = 125829120
  23. java_pool_size = 33554432
  24. pre_page_sga = TRUE
  25. enqueue_resources = 4096
  26. control_files = C:\orant\trx\control01.ctl, C:\orant\trx\control02.ctl, C:\orant\trx\control03.ctl
  27. db_block_size = 6144
  28. db_cache_size = 620756992
  29. compatible = 9.2.0.0.0
  30. db_file_multiblock_read_count= 16
  31. fast_start_mttr_target = 0
  32. undo_management = AUTO
  33. undo_tablespace = UNDOTBS1
  34. undo_retention = 10800
  35. remote_login_passwordfile= EXCLUSIVE
  36. db_domain = trxserver.com
  37. instance_name = trx
  38. dispatchers = (PROTOCOL=TCP) (SERVICE=trxXDB)
  39. job_queue_processes = 10
  40. hash_join_enabled = TRUE
  41. background_dump_dest = C:\orant\admin\trx\bdump
  42. user_dump_dest = C:\orant\admin\trx\udump
  43. core_dump_dest = C:\orant\admin\trx\cdump
  44. sort_area_size = 524288
  45. db_name = trx
  46. open_cursors = 4096
  47. star_transformation_enabled= FALSE
  48. query_rewrite_enabled = FALSE
  49. pga_aggregate_target = 272629760
  50. aq_tm_processes = 1
  51. PMON started with pid=2
  52. DBW0 started with pid=3
  53. LGWR started with pid=4
  54. CKPT started with pid=5
  55. SMON started with pid=6
  56. RECO started with pid=7
  57. CJQ0 started with pid=8
  58. QMN0 started with pid=9
  59. Sun Jan 13 12:46:29 2008
  60. starting up 1 shared server(s) ...
  61. starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
  62. Oracle Data Guard is not available in this edition of Oracle.
  63. Sun Jan 13 12:46:30 2008
  64. CREATE DATABASE trx
  65. MAXINSTANCES 1
  66. MAXLOGHISTORY 1
  67. MAXLOGFILES 5
  68. MAXLOGMEMBERS 3
  69. MAXDATAFILES 100
  70. DATAFILE 'C:\orant\trx\system01.dbf' SIZE 500M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
  71. EXTENT MANAGEMENT LOCAL
  72. DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'C:\orant\trx\temp01.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
  73. UNDO TABLESPACE "UNDOTBS1" DATAFILE 'C:\orant\trx\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
  74. CHARACTER SET WE8MSWIN1252
  75. NATIONAL CHARACTER SET AL16UTF16
  76. LOGFILE GROUP 1 ('C:\orant\trx\redo01.log') SIZE 102400K,
  77. GROUP 2 ('C:\orant\trx\redo02.log') SIZE 102400K,
  78. GROUP 3 ('C:\orant\trx\redo03.log') SIZE 102400K
  79. Sun Jan 13 12:46:31 2008
  80. Database mounted in Exclusive Mode.
  81. Sun Jan 13 12:46:41 2008
  82. Successful mount of redo thread 1, with mount id 1951428774.
  83. Assigning activation ID 1951428774 (0x745070a6)
  84. Thread 1 opened at log sequence 1
  85. Current log# 1 seq# 1 mem# 0: C:\ORANT\TRX\REDO01.LOG
  86. Successful open of redo thread 1.
  87. Sun Jan 13 12:46:42 2008
  88. SMON: enabling cache recovery
  89. Sun Jan 13 12:46:42 2008
  90. WARNING: Default passwords for SYS and SYSTEM will be used.
  91. Please change the passwords.
  92. Sun Jan 13 12:46:42 2008
  93. create tablespace SYSTEM datafile 'C:\orant\trx\system01.dbf' SIZE 500M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
  94. EXTENT MANAGEMENT LOCAL online
  95.  
  96. Sun Jan 13 12:46:56 2008
  97. Completed: create tablespace SYSTEM datafile 'C:\orant\trx\s
  98. Sun Jan 13 12:46:56 2008
  99. create rollback segment SYSTEM tablespace SYSTEM
  100. storage (initial 50K next 50K)
  101.  
  102. Completed: create rollback segment SYSTEM tablespace SYSTEM
  103.  
  104. Sun Jan 13 12:46:59 2008
  105. CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE 'C:\orant\trx\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
  106.  
  107. Created Undo Segment _SYSSMU1$
  108. Created Undo Segment _SYSSMU2$
  109. Created Undo Segment _SYSSMU3$
  110. Created Undo Segment _SYSSMU4$
  111. Created Undo Segment _SYSSMU5$
  112. Created Undo Segment _SYSSMU6$
  113. Created Undo Segment _SYSSMU7$
  114. Created Undo Segment _SYSSMU8$
  115. Created Undo Segment _SYSSMU9$
  116. Created Undo Segment _SYSSMU10$
  117. Undo Segment 1 Onlined
  118. Undo Segment 2 Onlined
  119. Undo Segment 3 Onlined
  120. Undo Segment 4 Onlined
  121. Undo Segment 5 Onlined
  122. Undo Segment 6 Onlined
  123. Undo Segment 7 Onlined
  124. Undo Segment 8 Onlined
  125. Undo Segment 9 Onlined
  126. Undo Segment 10 Onlined
  127. Successfully onlined Undo Tablespace 1.
  128. Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE 'C:\oran
  129. Sun Jan 13 12:47:05 2008
  130. CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 'C:\orant\trx\temp01.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
  131.  
  132. Completed: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 'C:\ora
  133. Sun Jan 13 12:47:06 2008
  134. ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
  135.  
  136. Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP
  137. Sun Jan 13 12:47:07 2008
  138. SMON: enabling tx recovery
  139. Sun Jan 13 12:47:13 2008
  140. replication_dependency_tracking turned off (no async multimaster replication found)
  141. Completed: CREATE DATABASE trx
  142. MAXINSTANCES 1
  143. MAXLOGHISTORY 1
  144. Sun Jan 13 12:47:13 2008
  145. 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
  146. Completed: CREATE TABLESPACE "DRSYS" LOGGING DATAFILE 'C:\ora
  147. Sun Jan 13 12:47:14 2008
  148. 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
  149. Completed: CREATE TABLESPACE "TOOLS" LOGGING DATAFILE 'C:\ora
  150. Sun Jan 13 12:47:16 2008
  151. 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
  152. Sun Jan 13 12:47:36 2008
  153. Completed: CREATE TABLESPACE "TRX_DATA" LOGGING DATAFILE 'C:\
  154. Sun Jan 13 12:47:36 2008
  155. 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
  156. Sun Jan 13 12:47:57 2008
  157. Completed: CREATE TABLESPACE "TRX_INDEX" LOGGING DATAFILE 'C:
  158. Sun Jan 13 12:47:57 2008
  159. 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
  160. Completed: CREATE TABLESPACE "XDB" LOGGING DATAFILE 'C:\orant
  161. Sun Jan 13 12:50:08 2008
  162. Thread 1 advanced to log sequence 2
  163. Current log# 2 seq# 2 mem# 0: C:\ORANT\TRX\REDO02.LOG
  164. Sun Jan 13 12:53:52 2008
  165. Thread 1 advanced to log sequence 3
  166. Current log# 3 seq# 3 mem# 0: C:\ORANT\TRX\REDO03.LOG
  167. Sun Jan 13 12:56:46 2008
  168. Thread 1 advanced to log sequence 4
  169. Current log# 1 seq# 4 mem# 0: C:\ORANT\TRX\REDO01.LOG
  170. Sun Jan 13 13:00:35 2008
  171. Thread 1 advanced to log sequence 5
  172. Current log# 2 seq# 5 mem# 0: C:\ORANT\TRX\REDO02.LOG
  173. Sun Jan 13 13:04:24 2008
  174. Thread 1 advanced to log sequence 6
  175. Current log# 3 seq# 6 mem# 0: C:\ORANT\TRX\REDO03.LOG
  176. Sun Jan 13 13:06:40 2008
  177. Thread 1 advanced to log sequence 7
  178. Current log# 1 seq# 7 mem# 0: C:\ORANT\TRX\REDO01.LOG
  179. Sun Jan 13 13:09:29 2008
  180. Shutting down instance: further logons disabled
  181. Sun Jan 13 13:11:33 2008
  182. Shutting down instance (normal)
  183. License high water mark = 3
  184. Waiting for dispatcher 'D000' to shutdown
  185. All dispatchers and shared servers shutdown
  186. Sun Jan 13 13:11:35 2008
  187. ALTER DATABASE CLOSE NORMAL
  188. Sun Jan 13 13:11:35 2008
  189. SMON: disabling tx recovery
  190. SMON: disabling cache recovery
  191. Sun Jan 13 13:11:36 2008
  192. Shutting down archive processes
  193. Archiving is disabled
  194. Archive process shutdown avoided: 0 active
  195. Thread 1 closed at log sequence 7
  196. Successful close of redo thread 1.
  197. Sun Jan 13 13:11:36 2008
  198. Completed: ALTER DATABASE CLOSE NORMAL
  199. Sun Jan 13 13:11:36 2008
  200. ALTER DATABASE DISMOUNT
  201. Completed: ALTER DATABASE DISMOUNT
  202. ARCH: Archiving is disabled
  203. Shutting down archive processes
  204. Archiving is disabled
  205. Archive process shutdown avoided: 0 active
  206. ARCH: Archiving is disabled
  207. Shutting down archive processes
  208. Archiving is disabled
  209. Archive process shutdown avoided: 0 active
  210. Sun Jan 13 13:11:47 2008
  211. Starting ORACLE instance (normal)
  212. Sun Jan 13 13:11:47 2008
  213. Running with 1 strand for Non-Enterprise Edition
  214. LICENSE_MAX_SESSION = 0
  215. LICENSE_SESSIONS_WARNING = 0
  216. SCN scheme 2
  217. Using log_archive_dest parameter default value
  218. Running with 1 strand for Non-Enterprise Edition
  219. LICENSE_MAX_USERS = 0
  220. SYS auditing is disabled
  221. Starting up ORACLE RDBMS Version: 9.2.0.1.0.
  222. System parameters with non-default values:
  223. processes = 150
  224. timed_statistics = TRUE
  225. shared_pool_size = 209715200
  226. large_pool_size = 125829120
  227. java_pool_size = 33554432
  228. pre_page_sga = TRUE
  229. enqueue_resources = 4096
  230. control_files = C:\orant\trx\control01.ctl, C:\orant\trx\control02.ctl, C:\orant\trx\control03.ctl
  231. db_block_size = 6144
  232. db_cache_size = 620756992
  233. compatible = 9.2.0.0.0
  234. db_file_multiblock_read_count= 16
  235. fast_start_mttr_target = 0
  236. undo_management = AUTO
  237. undo_tablespace = UNDOTBS1
  238. undo_retention = 10800
  239. remote_login_passwordfile= EXCLUSIVE
  240. db_domain = trxserver.com
  241. instance_name = trx
  242. dispatchers = (PROTOCOL=TCP) (SERVICE=trxXDB)
  243. job_queue_processes = 10
  244. hash_join_enabled = TRUE
  245. background_dump_dest = C:\orant\admin\trx\bdump
  246. user_dump_dest = C:\orant\admin\trx\udump
  247. core_dump_dest = C:\orant\admin\trx\cdump
  248. sort_area_size = 524288
  249. db_name = trx
  250. open_cursors = 4096
  251. star_transformation_enabled= FALSE
  252. query_rewrite_enabled = FALSE
  253. pga_aggregate_target = 272629760
  254. aq_tm_processes = 1
  255. PMON started with pid=2
  256. DBW0 started with pid=3
  257. LGWR started with pid=4
  258. CKPT started with pid=5
  259. SMON started with pid=6
  260. RECO started with pid=7
  261. CJQ0 started with pid=8
  262. QMN0 started with pid=9
  263. Sun Jan 13 13:11:50 2008
  264. starting up 1 shared server(s) ...
  265. starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
  266. Oracle Data Guard is not available in this edition of Oracle.
  267. Sun Jan 13 13:11:50 2008
  268. ALTER DATABASE MOUNT
  269. Sun Jan 13 13:11:55 2008
  270. Successful mount of redo thread 1, with mount id 1951424662.
  271. Sun Jan 13 13:11:55 2008
  272. Database mounted in Exclusive Mode.
  273. Completed: ALTER DATABASE MOUNT
  274. Sun Jan 13 13:11:55 2008
  275. ALTER DATABASE OPEN
  276. Sun Jan 13 13:11:56 2008
  277. Thread 1 opened at log sequence 7
  278. Current log# 1 seq# 7 mem# 0: C:\ORANT\TRX\REDO01.LOG
  279. Successful open of redo thread 1.
  280. Sun Jan 13 13:11:56 2008
  281. SMON: enabling cache recovery
  282. Sun Jan 13 13:11:56 2008
  283. Undo Segment 1 Onlined
  284. Undo Segment 2 Onlined
  285. Undo Segment 3 Onlined
  286. Undo Segment 4 Onlined
  287. Undo Segment 5 Onlined
  288. Undo Segment 6 Onlined
  289. Undo Segment 7 Onlined
  290. Undo Segment 8 Onlined
  291. Undo Segment 9 Onlined
  292. Undo Segment 10 Onlined
  293. Successfully onlined Undo Tablespace 1.
  294. Sun Jan 13 13:11:56 2008
  295. SMON: enabling tx recovery
  296. Sun Jan 13 13:11:56 2008
  297. Database Characterset is WE8MSWIN1252
  298. replication_dependency_tracking turned off (no async multimaster replication found)
  299. Completed: ALTER DATABASE OPEN
  300. Sun Jan 13 13:42:41 2008
  301. Replication pre-import: trying to disable constraint REPCAT$_TEMPLATE_OBJECTS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS"
  302. Replication pre-import: constraint REPCAT$_TEMPLATE_OBJECTS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS" is disabled successfully
  303. Replication pre-import: trying to disable constraint REPCAT$_TEMPLATE_PARMS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_PARMS"
  304. Replication pre-import: constraint REPCAT$_TEMPLATE_PARMS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_PARMS" is disabled successfully
  305. Replication pre-import: trying to disable constraint REPCAT$_OBJECT_PARMS_FK1 for "SYSTEM"."REPCAT$_OBJECT_PARMS"
  306. Replication pre-import: constraint REPCAT$_OBJECT_PARMS_FK1 for "SYSTEM"."REPCAT$_OBJECT_PARMS" is disabled successfully
  307. Replication pre-import: trying to disable constraint REPCAT$_OBJECT_PARMS_FK2 for "SYSTEM"."REPCAT$_OBJECT_PARMS"
  308. Replication pre-import: constraint REPCAT$_OBJECT_PARMS_FK2 for "SYSTEM"."REPCAT$_OBJECT_PARMS" is disabled successfully
  309. Replication pre-import: trying to disable constraint REPCAT$_USER_AUTHORIZATION_FK2 for "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS"
  310. Replication pre-import: constraint REPCAT$_USER_AUTHORIZATION_FK2 for "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS" is disabled successfully
  311. Replication pre-import: trying to disable constraint REPCAT$_USER_PARM_VALUES_FK1 for "SYSTEM"."REPCAT$_USER_PARM_VALUES"
  312. Replication pre-import: constraint REPCAT$_USER_PARM_VALUES_FK1 for "SYSTEM"."REPCAT$_USER_PARM_VALUES" is disabled successfully
  313. Replication pre-import: trying to disable constraint REPCAT$_FLAVOR_OBJECTS_FK2 for "SYSTEM"."REPCAT$_FLAVOR_OBJECTS"
  314. Replication pre-import: constraint REPCAT$_FLAVOR_OBJECTS_FK2 for "SYSTEM"."REPCAT$_FLAVOR_OBJECTS" is disabled successfully
  315. Replication pre-import: trying to disable constraint REPCAT$_FLAVOR_OBJECTS_FK1 for "SYSTEM"."REPCAT$_FLAVOR_OBJECTS"
  316. Replication pre-import: constraint REPCAT$_FLAVOR_OBJECTS_FK1 for "SYSTEM"."REPCAT$_FLAVOR_OBJECTS" is disabled successfully
  317. Replication pre-import: trying to disable constraint REPCAT$_FLAVORS_FK1 for "SYSTEM"."REPCAT$_FLAVORS"
  318. Replication pre-import: constraint REPCAT$_FLAVORS_FK1 for "SYSTEM"."REPCAT$_FLAVORS" is disabled successfully
  319. Replication pre-import: trying to disable constraint REPCAT$_REPSCHEMA_DEST for "SYSTEM"."REPCAT$_REPSCHEMA"
  320. Replication pre-import: constraint REPCAT$_REPSCHEMA_DEST for "SYSTEM"."REPCAT$_REPSCHEMA" is disabled successfully
  321. Replication pre-import: trying to disable constraint REPCAT$_REPOBJECT_PRNT for "SYSTEM"."REPCAT$_REPOBJECT"
  322. Replication pre-import: constraint REPCAT$_REPOBJECT_PRNT for "SYSTEM"."REPCAT$_REPOBJECT" is disabled successfully
  323. Replication pre-import: trying to disable constraint REPCAT$_REPGEN_PRNT2 for "SYSTEM"."REPCAT$_GENERATED"
  324. Replication pre-import: constraint REPCAT$_REPGEN_PRNT2 for "SYSTEM"."REPCAT$_GENERATED" is disabled successfully
  325. Replication pre-import: trying to disable constraint REPCAT$_REPGEN_PRNT for "SYSTEM"."REPCAT$_GENERATED"
  326. Replication pre-import: constraint REPCAT$_REPGEN_PRNT for "SYSTEM"."REPCAT$_GENERATED" is disabled successfully
  327. Replication pre-import: trying to disable constraint REPCAT$_PARAMETER_COLUMN_F1 for "SYSTEM"."REPCAT$_PARAMETER_COLUMN"
  328. Replication pre-import: constraint REPCAT$_PARAMETER_COLUMN_F1 for "SYSTEM"."REPCAT$_PARAMETER_COLUMN" is disabled successfully
  329. Replication pre-import: trying to disable constraint REPCAT$_PRIORITY_F1 for "SYSTEM"."REPCAT$_PRIORITY"
  330. Replication pre-import: constraint REPCAT$_PRIORITY_F1 for "SYSTEM"."REPCAT$_PRIORITY" is disabled successfully
  331. Replication pre-import: trying to disable constraint REPCAT$_REPSCHEMA_PRNT for "SYSTEM"."REPCAT$_REPSCHEMA"
  332. Replication pre-import: constraint REPCAT$_REPSCHEMA_PRNT for "SYSTEM"."REPCAT$_REPSCHEMA" is disabled successfully
  333. Replication pre-import: trying to disable constraint REPCAT$_REPCOLUMN_FK for "SYSTEM"."REPCAT$_REPCOLUMN"
  334. Replication pre-import: constraint REPCAT$_REPCOLUMN_FK for "SYSTEM"."REPCAT$_REPCOLUMN" is disabled successfully
  335. Replication pre-import: trying to disable constraint REPCAT$_KEY_COLUMNS_PRNT for "SYSTEM"."REPCAT$_KEY_COLUMNS"
  336. Replication pre-import: constraint REPCAT$_KEY_COLUMNS_PRNT for "SYSTEM"."REPCAT$_KEY_COLUMNS" is disabled successfully
  337. Replication pre-import: trying to disable constraint REPCAT$_REPPROP_PRNT for "SYSTEM"."REPCAT$_REPPROP"
  338. Replication pre-import: constraint REPCAT$_REPPROP_PRNT for "SYSTEM"."REPCAT$_REPPROP" is disabled successfully
  339. Replication pre-import: trying to disable constraint REPCAT$_DDL_PRNT for "SYSTEM"."REPCAT$_DDL"
  340. Replication pre-import: constraint REPCAT$_DDL_PRNT for "SYSTEM"."REPCAT$_DDL" is disabled successfully
  341. Replication pre-import: trying to disable constraint REPCAT$_GROUPED_COLUMN_F1 for "SYSTEM"."REPCAT$_GROUPED_COLUMN"
  342. Replication pre-import: constraint REPCAT$_GROUPED_COLUMN_F1 for "SYSTEM"."REPCAT$_GROUPED_COLUMN" is disabled successfully
  343. Replication pre-import: trying to disable constraint REPCAT$_RESOLUTION_F1 for "SYSTEM"."REPCAT$_RESOLUTION"
  344. Replication pre-import: constraint REPCAT$_RESOLUTION_F1 for "SYSTEM"."REPCAT$_RESOLUTION" is disabled successfully
  345. Replication pre-import: trying to disable constraint REPCAT$_RESOLUTION_F3 for "SYSTEM"."REPCAT$_RESOLUTION"
  346. Replication pre-import: constraint REPCAT$_RESOLUTION_F3 for "SYSTEM"."REPCAT$_RESOLUTION" is disabled successfully
  347. Replication pre-import: trying to disable constraint REPCAT$_AUDIT_COLUMN_F2 for "SYSTEM"."REPCAT$_AUDIT_COLUMN"
  348. Replication pre-import: constraint REPCAT$_AUDIT_COLUMN_F2 for "SYSTEM"."REPCAT$_AUDIT_COLUMN" is disabled successfully
  349. Replication pre-import: trying to disable constraint REPCAT$_AUDIT_COLUMN_F1 for "SYSTEM"."REPCAT$_AUDIT_COLUMN"
  350. Replication pre-import: constraint REPCAT$_AUDIT_COLUMN_F1 for "SYSTEM"."REPCAT$_AUDIT_COLUMN" is disabled successfully
  351. Replication pre-import: trying to disable constraint REPCAT$_REPGROUP_PRIVS_FK for "SYSTEM"."REPCAT$_REPGROUP_PRIVS"
  352. Replication pre-import: constraint REPCAT$_REPGROUP_PRIVS_FK for "SYSTEM"."REPCAT$_REPGROUP_PRIVS" is disabled successfully
  353. Replication pre-import: trying to disable constraint REPCAT$_PARAMETER_COLUMN_PK for "SYSTEM"."REPCAT$_PARAMETER_COLUMN"
  354. Replication pre-import: constraint REPCAT$_PARAMETER_COLUMN_PK for "SYSTEM"."REPCAT$_PARAMETER_COLUMN" is disabled successfully
  355. Replication pre-import: trying to disable constraint REPCAT$_GROUPED_COLUMN_PK for "SYSTEM"."REPCAT$_GROUPED_COLUMN"
  356. Replication pre-import: constraint REPCAT$_GROUPED_COLUMN_PK for "SYSTEM"."REPCAT$_GROUPED_COLUMN" is disabled successfully
  357. Replication pre-import: trying to disable constraint REPCAT$_SITES_NEW_FK1 for "SYSTEM"."REPCAT$_SITES_NEW"
  358. Replication pre-import: constraint REPCAT$_SITES_NEW_FK1 for "SYSTEM"."REPCAT$_SITES_NEW" is disabled successfully
  359. Replication pre-import: trying to disable constraint REPCAT$_SITES_NEW_FK2 for "SYSTEM"."REPCAT$_SITES_NEW"
  360. Replication pre-import: constraint REPCAT$_SITES_NEW_FK2 for "SYSTEM"."REPCAT$_SITES_NEW" is disabled successfully
  361. Sun Jan 13 13:42:42 2008
  362. CREATE UNDO TABLESPACE "RBS" BLOCKSIZE 4096 DATAFILE 'C:\ORACLE\ORA92\TRX\UNDOTBS01.DBF' SIZE 555745280 AUTOEXTEND ON NEXT 5242880 MAXSIZE 16383M EXTENT MANAGEMENT LOCAL
  363. ORA-29339 signalled during: CREATE UNDO TABLESPACE "RBS" BLOCKSIZE 4096 DATAFI...
  364. Sun Jan 13 13:42:42 2008
  365. 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
  366. ORA-29339 signalled during: CREATE TEMPORARY TABLESPACE "TEMP" BLOCKSIZE 4096 ...
  367. Sun Jan 13 13:42:42 2008
  368. 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
  369. ORA-29339 signalled during: CREATE TABLESPACE "DRSYS" BLOCKSIZE 4096 DATAFILE ...
  370. Sun Jan 13 13:42:42 2008
  371. 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
  372. ORA-29339 signalled during: CREATE TABLESPACE "TOOLS" BLOCKSIZE 4096 DATAFILE ...
  373. Sun Jan 13 13:42:42 2008
  374. 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
  375. ORA-29339 signalled during: CREATE TABLESPACE "TRX_DATA" BLOCKSIZE 4096 DATAFI...
  376. Sun Jan 13 13:42:42 2008
  377. 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
  378. ORA-29339 signalled during: CREATE TABLESPACE "TRX_INDEX" BLOCKSIZE 4096 DATAF...
  379. Sun Jan 13 13:42:42 2008
  380. 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
  381. ORA-29339 signalled during: CREATE TABLESPACE "XDB" BLOCKSIZE 4096 DATAFILE '...
  382. Sun Jan 13 13:43:04 2008
  383. Thread 1 advanced to log sequence 8
  384. Current log# 2 seq# 8 mem# 0: C:\ORANT\TRX\REDO02.LOG
  385. Sun Jan 13 13:43:54 2008
  386. Thread 1 advanced to log sequence 9
  387. Current log# 3 seq# 9 mem# 0: C:\ORANT\TRX\REDO03.LOG
  388. Sun Jan 13 13:46:20 2008
  389. Thread 1 advanced to log sequence 10
  390. Current log# 1 seq# 10 mem# 0: C:\ORANT\TRX\REDO01.LOG
  391. Sun Jan 13 13:48:49 2008
  392. Thread 1 advanced to log sequence 11
  393. Current log# 2 seq# 11 mem# 0: C:\ORANT\TRX\REDO02.LOG
  394. Sun Jan 13 13:55:41 2008
  395. Thread 1 advanced to log sequence 12
  396. Current log# 3 seq# 12 mem# 0: C:\ORANT\TRX\REDO03.LOG
  397. Sun Jan 13 13:56:23 2008
  398. Replication after-import: trying to enable constraint REPCAT$_TEMPLATE_OBJECTS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS"
  399. Replication after-import: constraint REPCAT$_TEMPLATE_OBJECTS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_OBJECTS" is enabled successfully
  400. Replication after-import: trying to enable constraint REPCAT$_TEMPLATE_PARMS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_PARMS"
  401. Replication after-import: constraint REPCAT$_TEMPLATE_PARMS_FK1 for "SYSTEM"."REPCAT$_TEMPLATE_PARMS" is enabled successfully
  402. Replication after-import: trying to enable constraint REPCAT$_OBJECT_PARMS_FK1 for "SYSTEM"."REPCAT$_OBJECT_PARMS"
  403. Replication after-import: constraint REPCAT$_OBJECT_PARMS_FK1 for "SYSTEM"."REPCAT$_OBJECT_PARMS" is enabled successfully
  404. Replication after-import: trying to enable constraint REPCAT$_OBJECT_PARMS_FK2 for "SYSTEM"."REPCAT$_OBJECT_PARMS"
  405. Replication after-import: constraint REPCAT$_OBJECT_PARMS_FK2 for "SYSTEM"."REPCAT$_OBJECT_PARMS" is enabled successfully
  406. Replication after-import: trying to enable constraint REPCAT$_USER_AUTHORIZATION_FK2 for "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS"
  407. Replication after-import: constraint REPCAT$_USER_AUTHORIZATION_FK2 for "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS" is enabled successfully
  408. Replication after-import: trying to enable constraint REPCAT$_USER_PARM_VALUES_FK1 for "SYSTEM"."REPCAT$_USER_PARM_VALUES"
  409. Replication after-import: constraint REPCAT$_USER_PARM_VALUES_FK1 for "SYSTEM"."REPCAT$_USER_PARM_VALUES" is enabled successfully
  410. Replication after-import: trying to enable constraint REPCAT$_FLAVOR_OBJECTS_FK1 for "SYSTEM"."REPCAT$_FLAVOR_OBJECTS"
  411. Replication after-import: constraint REPCAT$_FLAVOR_OBJECTS_FK1 for "SYSTEM"."REPCAT$_FLAVOR_OBJECTS" is enabled successfully
  412. Replication after-import: trying to enable constraint REPCAT$_FLAVOR_OBJECTS_FK2 for "SYSTEM"."REPCAT$_FLAVOR_OBJECTS"
  413. Replication after-import: constraint REPCAT$_FLAVOR_OBJECTS_FK2 for "SYSTEM"."REPCAT$_FLAVOR_OBJECTS" is enabled successfully
  414. Replication after-import: trying to enable constraint REPCAT$_FLAVORS_FK1 for "SYSTEM"."REPCAT$_FLAVORS"
  415. Replication after-import: constraint REPCAT$_FLAVORS_FK1 for "SYSTEM"."REPCAT$_FLAVORS" is enabled successfully
  416. Replication after-import: trying to enable constraint REPCAT$_REPSCHEMA_DEST for "SYSTEM"."REPCAT$_REPSCHEMA"
  417. Replication after-import: constraint REPCAT$_REPSCHEMA_DEST for "SYSTEM"."REPCAT$_REPSCHEMA" is enabled successfully
  418. Replication after-import: trying to enable constraint REPCAT$_REPOBJECT_PRNT for "SYSTEM"."REPCAT$_REPOBJECT"
  419. Replication after-import: constraint REPCAT$_REPOBJECT_PRNT for "SYSTEM"."REPCAT$_REPOBJECT" is enabled successfully
  420. Replication after-import: trying to enable constraint REPCAT$_REPGEN_PRNT2 for "SYSTEM"."REPCAT$_GENERATED"
  421. Replication after-import: constraint REPCAT$_REPGEN_PRNT2 for "SYSTEM"."REPCAT$_GENERATED" is enabled successfully
  422. Replication after-import: trying to enable constraint REPCAT$_REPGEN_PRNT for "SYSTEM"."REPCAT$_GENERATED"
  423. Replication after-import: constraint REPCAT$_REPGEN_PRNT for "SYSTEM"."REPCAT$_GENERATED" is enabled successfully
  424. Replication after-import: trying to enable constraint REPCAT$_PARAMETER_COLUMN_F1 for "SYSTEM"."REPCAT$_PARAMETER_COLUMN"
  425. Replication after-import: constraint REPCAT$_PARAMETER_COLUMN_F1 for "SYSTEM"."REPCAT$_PARAMETER_COLUMN" is enabled successfully
  426. Replication after-import: trying to enable constraint REPCAT$_PRIORITY_F1 for "SYSTEM"."REPCAT$_PRIORITY"
  427. Replication after-import: constraint REPCAT$_PRIORITY_F1 for "SYSTEM"."REPCAT$_PRIORITY" is enabled successfully
  428. Replication after-import: trying to enable constraint REPCAT$_REPSCHEMA_PRNT for "SYSTEM"."REPCAT$_REPSCHEMA"
  429. Replication after-import: constraint REPCAT$_REPSCHEMA_PRNT for "SYSTEM"."REPCAT$_REPSCHEMA" is enabled successfully
  430. Replication after-import: trying to enable constraint REPCAT$_REPCOLUMN_FK for "SYSTEM"."REPCAT$_REPCOLUMN"
  431. Replication after-import: constraint REPCAT$_REPCOLUMN_FK for "SYSTEM"."REPCAT$_REPCOLUMN" is enabled successfully
  432. Replication after-import: trying to enable constraint REPCAT$_KEY_COLUMNS_PRNT for "SYSTEM"."REPCAT$_KEY_COLUMNS"
  433. Replication after-import: constraint REPCAT$_KEY_COLUMNS_PRNT for "SYSTEM"."REPCAT$_KEY_COLUMNS" is enabled successfully
  434. Replication after-import: trying to enable constraint REPCAT$_REPPROP_PRNT for "SYSTEM"."REPCAT$_REPPROP"
  435. Replication after-import: constraint REPCAT$_REPPROP_PRNT for "SYSTEM"."REPCAT$_REPPROP" is enabled successfully
  436. Replication after-import: trying to enable constraint REPCAT$_DDL_PRNT for "SYSTEM"."REPCAT$_DDL"
  437. Replication after-import: constraint REPCAT$_DDL_PRNT for "SYSTEM"."REPCAT$_DDL" is enabled successfully
  438. Replication after-import: trying to enable constraint REPCAT$_GROUPED_COLUMN_F1 for "SYSTEM"."REPCAT$_GROUPED_COLUMN"
  439. Replication after-import: constraint REPCAT$_GROUPED_COLUMN_F1 for "SYSTEM"."REPCAT$_GROUPED_COLUMN" is enabled successfully
  440. Replication after-import: trying to enable constraint REPCAT$_RESOLUTION_F1 for "SYSTEM"."REPCAT$_RESOLUTION"
  441. Replication after-import: constraint REPCAT$_RESOLUTION_F1 for "SYSTEM"."REPCAT$_RESOLUTION" is enabled successfully
  442. Replication after-import: trying to enable constraint REPCAT$_RESOLUTION_F3 for "SYSTEM"."REPCAT$_RESOLUTION"
  443. Replication after-import: constraint REPCAT$_RESOLUTION_F3 for "SYSTEM"."REPCAT$_RESOLUTION" is enabled successfully
  444. Replication after-import: trying to enable constraint REPCAT$_AUDIT_COLUMN_F2 for "SYSTEM"."REPCAT$_AUDIT_COLUMN"
  445. Replication after-import: constraint REPCAT$_AUDIT_COLUMN_F2 for "SYSTEM"."REPCAT$_AUDIT_COLUMN" is enabled successfully
  446. Replication after-import: trying to enable constraint REPCAT$_AUDIT_COLUMN_F1 for "SYSTEM"."REPCAT$_AUDIT_COLUMN"
  447. Replication after-import: constraint REPCAT$_AUDIT_COLUMN_F1 for "SYSTEM"."REPCAT$_AUDIT_COLUMN" is enabled successfully
  448. Replication after-import: trying to enable constraint REPCAT$_REPGROUP_PRIVS_FK for "SYSTEM"."REPCAT$_REPGROUP_PRIVS"
  449. Replication after-import: constraint REPCAT$_REPGROUP_PRIVS_FK for "SYSTEM"."REPCAT$_REPGROUP_PRIVS" is enabled successfully
  450. Replication after-import: trying to enable constraint REPCAT$_PARAMETER_COLUMN_PK for "SYSTEM"."REPCAT$_PARAMETER_COLUMN"
  451. Replication after-import: constraint REPCAT$_PARAMETER_COLUMN_PK for "SYSTEM"."REPCAT$_PARAMETER_COLUMN" is enabled successfully
  452. Replication after-import: trying to enable constraint REPCAT$_GROUPED_COLUMN_PK for "SYSTEM"."REPCAT$_GROUPED_COLUMN"
  453. Replication after-import: constraint REPCAT$_GROUPED_COLUMN_PK for "SYSTEM"."REPCAT$_GROUPED_COLUMN" is enabled successfully
  454. Replication after-import: trying to enable constraint REPCAT$_SITES_NEW_FK1 for "SYSTEM"."REPCAT$_SITES_NEW"
  455. Replication after-import: constraint REPCAT$_SITES_NEW_FK1 for "SYSTEM"."REPCAT$_SITES_NEW" is enabled successfully
  456. Replication after-import: trying to enable constraint REPCAT$_SITES_NEW_FK2 for "SYSTEM"."REPCAT$_SITES_NEW"
  457. Replication after-import: constraint REPCAT$_SITES_NEW_FK2 for "SYSTEM"."REPCAT$_SITES_NEW" is enabled successfully
  458. Dump file c:\orant\admin\trx\bdump\alert_trx.log
  459. Mon Jan 14 07:44:36 2008
  460. ORACLE V9.2.0.1.0 - Production vsnsta=0
  461. vsnsql=12 vsnxtr=3
  462. Windows 2000 Version 5.2 Service Pack 2, CPU type 586
  463. Mon Jan 14 07:44:36 2008
  464. Starting ORACLE instance (normal)
  465. Mon Jan 14 07:44:36 2008
  466. Running with 1 strand for Non-Enterprise Edition
  467. LICENSE_MAX_SESSION = 0
  468. LICENSE_SESSIONS_WARNING = 0
  469. SCN scheme 2
  470. Using log_archive_dest parameter default value
  471. Running with 1 strand for Non-Enterprise Edition
  472. LICENSE_MAX_USERS = 0
  473. SYS auditing is disabled
  474. Starting up ORACLE RDBMS Version: 9.2.0.1.0.
  475. System parameters with non-default values:
  476. processes = 150
  477. timed_statistics = TRUE
  478. shared_pool_size = 209715200
  479. large_pool_size = 125829120
  480. java_pool_size = 33554432
  481. pre_page_sga = TRUE
  482. enqueue_resources = 4096
  483. control_files = C:\orant\trx\control01.ctl, C:\orant\trx\control02.ctl, C:\orant\trx\control03.ctl
  484. db_block_size = 6144
  485. db_cache_size = 620756992
  486. compatible = 9.2.0.0.0
  487. db_file_multiblock_read_count= 16
  488. fast_start_mttr_target = 0
  489. undo_management = AUTO
  490. undo_tablespace = UNDOTBS1
  491. undo_retention = 10800
  492. remote_login_passwordfile= EXCLUSIVE
  493. db_domain = trxserver.com
  494. instance_name = trx
  495. dispatchers = (PROTOCOL=TCP) (SERVICE=trxXDB)
  496. job_queue_processes = 10
  497. hash_join_enabled = TRUE
  498. background_dump_dest = C:\orant\admin\trx\bdump
  499. user_dump_dest = C:\orant\admin\trx\udump
  500. core_dump_dest = C:\orant\admin\trx\cdump
  501. sort_area_size = 524288
  502. db_name = trx
  503. open_cursors = 4096
  504. star_transformation_enabled= FALSE
  505. query_rewrite_enabled = FALSE
  506. pga_aggregate_target = 272629760
  507. aq_tm_processes = 1
  508. PMON started with pid=2
  509. DBW0 started with pid=3
  510. LGWR started with pid=4
  511. CKPT started with pid=5
  512. SMON started with pid=6
  513. RECO started with pid=7
  514. CJQ0 started with pid=8
  515. QMN0 started with pid=9
  516. Mon Jan 14 07:44:40 2008
  517. starting up 1 shared server(s) ...
  518. starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
  519. Oracle Data Guard is not available in this edition of Oracle.
  520. Mon Jan 14 07:44:41 2008
  521. alter database mount exclusive
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!