API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 12th, 2018
95
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 42.31 KB | None | 0 0
raw download clone embed print report
  1. bash-4.2$ ant drop-dbschema
  2. Buildfile: /scratch/rajraman/work/pgbu_platform-2.0/projects/dbboot/build.xml
  3.  
  4. -init:
  5.  
  6. load_user_properties:
  7.  
  8. drop-dbschema:
  9. [echo] Dropping dbschema for:
  10. [echo] db.host : localhost
  11. [echo] db.port : 1521
  12. [echo] db.name : primedb.us.oracle.com
  13. [echo] db.sys.username : sys
  14. [echo] db.sys.password : Prima123Vera
  15. [echo] db.jdbc.user : T_tenant1_PIMSAPP_ADM
  16. [echo] db.tenant.password : Prima123Vera
  17. [echo] ****************************************************************************************************************
  18. [echo] Dropping schema T_tenant1_PIMSAPP_ADM in database localhost:1521/primedb.us.oracle.com
  19. [echo] ****************************************************************************************************************
  20.  
  21. -init:
  22.  
  23. load_user_properties:
  24.  
  25. check_active_sessions:
  26. [echo] Checking for Additional Active Sessions : START
  27. [sql] Executing commands
  28. [sql] 1 of 1 SQL statements executed successfully
  29. [echo] Checking for Additional Active Sessions: END
  30. [sql] Executing commands
  31. [sql] 5 of 5 SQL statements executed successfully
  32.  
  33. BUILD SUCCESSFUL
  34. Total time: 31 seconds
  35. bash-4.2$ ant init-dbschema
  36. Buildfile: /scratch/rajraman/work/pgbu_platform-2.0/projects/dbboot/build.xml
  37.  
  38. -init:
  39.  
  40. load_user_properties:
  41.  
  42. init-dbschema:
  43. [echo] Initializing dbschema for:
  44. [echo] db.host : localhost
  45. [echo] db.port : 1521
  46. [echo] db.name : primedb.us.oracle.com
  47. [echo] db.sys.username : sys
  48. [echo] db.sys.password : Prima123Vera
  49. [echo] db.jdbc.user : T_tenant1_PIMSAPP_ADM
  50. [echo] db.tenant.password : Prima123Vera
  51. [echo] ****************************************************************************************************************
  52. [echo] Initializing schema for T_tenant1_PIMSAPP_ADM in database localhost:1521/primedb.us.oracle.com
  53. [echo] ****************************************************************************************************************
  54. [java] Running init schema for user T_tenant1_PIMSAPP_ADM@jdbc:oracle:thin:@//localhost:1521/primedb.us.oracle.com prefix=T_tenant1
  55. [java] [INFO | Apr 12, 01:32:48] com.oracle.cegbu.microservice.tenant.service.Main:74 - Running Tablespace Create: CREATE BIGFILE TABLESPACE COMMON_PRIM_DAT DATAFILE '/opt/orcl/oradata/orcl/primedb/common_prim_dat.dbf' SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
  56. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:74 - Running Tablespace Create: CREATE BIGFILE TABLESPACE COMMON_PRIM_NDX DATAFILE '/opt/orcl/oradata/orcl/primedb/common_prim_ndx.dbf' SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
  57. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:74 - Running Tablespace Create: CREATE BIGFILE TABLESPACE COMMON_PRIM_LOB DATAFILE '/opt/orcl/oradata/orcl/primedb/common_prim_lob.dbf' SIZE 12M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
  58. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:74 - Running Tablespace Create: CREATE BIGFILE TABLESPACE COMMON_PRIM_SF_LOB DATAFILE '/opt/orcl/oradata/orcl/primedb/common_prim_sf_lob.dbf' SIZE 12M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
  59. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:74 - Running Tablespace Create: CREATE BIGFILE TABLESPACE COMMON_PRIM_HT_DAT DATAFILE '/opt/orcl/oradata/orcl/primedb/common_prim_ht_dat.dbf' SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
  60. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:74 - Running Tablespace Create: CREATE BIGFILE TABLESPACE COMMON_PRIM_HT_NDX DATAFILE '/opt/orcl/oradata/orcl/primedb/common_prim_ht_ndx.dbf' SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
  61. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:74 - Running Tablespace Create: CREATE BIGFILE TABLESPACE COMMON_PRIM_MCD DATAFILE '/opt/orcl/oradata/orcl/primedb/common_prim_mcd.dbf' SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
  62. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:74 - Running Tablespace Create: CREATE BIGFILE TABLESPACE COMMON_PRIM_OV_DAT DATAFILE '/opt/orcl/oradata/orcl/primedb/common_prim_ov_dat.dbf' SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
  63. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:74 - Running Tablespace Create: CREATE BIGFILE TABLESPACE COMMON_PRIM_OV_NDX DATAFILE '/opt/orcl/oradata/orcl/primedb/common_prim_ov_ndx.dbf' SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
  64. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:74 - Running Tablespace Create: CREATE BIGFILE TEMPORARY TABLESPACE COMMON_PRIM_TEMP TEMPFILE '/opt/orcl/oradata/orcl/primedb/common_prim_temp.dbf' SIZE 250M AUTOEXTEND ON NEXT 250M EXTENT MANAGEMENT LOCAL
  65. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: CREATE USER T_tenant1_PIMSAPP_ADM IDENTIFIED BY Prima123Vera TEMPORARY TABLESPACE COMMON_PRIM_TEMP DEFAULT TABLESPACE COMMON_PRIM_DAT QUOTA UNLIMITED ON COMMON_PRIM_DAT QUOTA UNLIMITED ON COMMON_PRIM_NDX QUOTA UNLIMITED ON COMMON_PRIM_LOB QUOTA UNLIMITED ON COMMON_PRIM_SF_LOB QUOTA UNLIMITED ON COMMON_PRIM_HT_DAT QUOTA UNLIMITED ON COMMON_PRIM_HT_NDX QUOTA UNLIMITED ON COMMON_PRIM_MCD QUOTA UNLIMITED ON COMMON_PRIM_OV_DAT QUOTA UNLIMITED ON COMMON_PRIM_OV_NDX
  66. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: ALTER USER T_tenant1_PIMSAPP_ADM IDENTIFIED BY Prima123Vera
  67. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: GRANT SELECT ON SYS.V_$SESSION to T_tenant1_PIMSAPP_ADM
  68. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: GRANT SELECT ON SYS.V_$TRANSACTION to T_tenant1_PIMSAPP_ADM
  69. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: GRANT EXECUTE ON DBMS_SESSION to T_tenant1_PIMSAPP_ADM
  70. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: GRANT EXECUTE ON CTXSYS.CTX_DDL to T_tenant1_PIMSAPP_ADM
  71. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: GRANT EXECUTE ON DBMS_APPLICATION_INFO to T_tenant1_PIMSAPP_ADM
  72. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: GRANT EXECUTE ON DBMS_SQL to T_tenant1_PIMSAPP_ADM
  73. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: GRANT EXECUTE ON DBMS_LOB to T_tenant1_PIMSAPP_ADM
  74. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: GRANT CREATE SESSION, ALTER SESSION, CREATE VIEW, CREATE TABLE, CREATE TRIGGER, CREATE SEQUENCE , CREATE TYPE , CREATE PROCEDURE , CREATE INDEXTYPE , CREATE MATERIALIZED VIEW to T_tenant1_PIMSAPP_ADM
  75. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: CREATE OR REPLACE TYPE T_tenant1_PIMSAPP_ADM.MV_STRINGLIST AS TABLE OF VARCHAR2(1000);
  76. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: CREATE OR REPLACE TYPE T_tenant1_PIMSAPP_ADM.MV_NUMBERLIST AS TABLE OF NUMBER;
  77. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: CREATE OR REPLACE TYPE T_tenant1_PIMSAPP_ADM.MV_DATELIST AS TABLE OF DATE;
  78. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: CREATE TABLE T_tenant1_PIMSAPP_ADM.DBPROVISIONING_IGNORE ( IGNORE_ID NUMBER(18), OBJECT_NAME VARCHAR2(1024), OBJECT_TYPE VARCHAR2(1024), IGNORE_TYPE VARCHAR2(1024), CONSTRAINT DBPROVISIONING_IGNORE_PK PRIMARY KEY (IGNORE_ID) USING INDEX PCTFREE 10 STORAGE(INITIAL 1M NEXT 1M MINEXTENTS 1 MAXEXTENTS unlimited PCTINCREASE 0) TABLESPACE COMMON_PRIM_NDX )
  79. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: CREATE TABLE T_tenant1_PIMSAPP_ADM.DBPROVISIONING_MIGRATION ( MIGRATION_ID NUMBER(18) NOT NULL, FILE_NAME VARCHAR2(1024) NOT NULL, STATUS VARCHAR2(64) NULL, START_TS TIMESTAMP NULL, END_TS TIMESTAMP NULL) TABLESPACE COMMON_PRIM_NDX STORAGE (INITIAL 1M NEXT 1M)
  80. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: CREATE SEQUENCE T_tenant1_PIMSAPP_ADM.DBPROVISIONING_MIGRATION_SEQ MINVALUE 1 INCREMENT BY 1 START WITH 1
  81. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: CREATE SEQUENCE T_tenant1_PIMSAPP_ADM.DBPROVISIONING_IGNORE_SEQ MINVALUE 1 INCREMENT BY 1 START WITH 1
  82. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: INSERT INTO T_tenant1_PIMSAPP_ADM.DBPROVISIONING_IGNORE (IGNORE_ID, OBJECT_NAME, OBJECT_TYPE, IGNORE_TYPE) Values (T_tenant1_PIMSAPP_ADM.DBPROVISIONING_IGNORE_SEQ.nextval, 'DBPROVISIONING_MIGRATION', 'TABLE', 'NOT_TRACKED')
  83. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: INSERT INTO T_tenant1_PIMSAPP_ADM.DBPROVISIONING_IGNORE (IGNORE_ID, OBJECT_NAME, OBJECT_TYPE, IGNORE_TYPE) Values (T_tenant1_PIMSAPP_ADM.DBPROVISIONING_IGNORE_SEQ.nextval, 'LOG$_PKG', 'TABLE', 'NOT_TRACKED')
  84. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: INSERT INTO T_tenant1_PIMSAPP_ADM.DBPROVISIONING_IGNORE (IGNORE_ID, OBJECT_NAME, OBJECT_TYPE, IGNORE_TYPE) Values (T_tenant1_PIMSAPP_ADM.DBPROVISIONING_IGNORE_SEQ.nextval, 'LOG$', 'TABLE', 'NOT_TRACKED')
  85. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: INSERT INTO T_tenant1_PIMSAPP_ADM.DBPROVISIONING_IGNORE (IGNORE_ID, OBJECT_NAME, OBJECT_TYPE, IGNORE_TYPE) Values (T_tenant1_PIMSAPP_ADM.DBPROVISIONING_IGNORE_SEQ.nextval, 'DBPROVISIONING_IGNORE', 'TABLE', 'NOT_TRACKED')
  86. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: INSERT INTO T_tenant1_PIMSAPP_ADM.DBPROVISIONING_IGNORE (IGNORE_ID, OBJECT_NAME, OBJECT_TYPE, IGNORE_TYPE) Values (T_tenant1_PIMSAPP_ADM.DBPROVISIONING_IGNORE_SEQ.nextval, 'DBPROVISIONING_SQL_LOG', 'TABLE', 'NOT_TRACKED')
  87. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: CREATE TABLE T_tenant1_PIMSAPP_ADM.DBPROVISIONING_SQL_LOG ( SQL_LOG_ID NUMBER (18) NOT NULL , TIMESTAMP TIMESTAMP(6) NOT NULL , STATUS VARCHAR2 (1024 CHAR ) NOT NULL , OBJECT_OWNER VARCHAR2 (1024 CHAR ) NOT NULL , OBJECT_TYPE VARCHAR2 (1024 CHAR ) NOT NULL , OBJECT_NAME VARCHAR2 (1024 CHAR ) NOT NULL , SQL CLOB NOT NULL )
  88. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: CREATE SEQUENCE T_tenant1_PIMSAPP_ADM.DBPROVISIONING_SQL_LOG_SEQ MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE
  89. [java] [INFO | Apr 12, 01:32:49] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: CREATE TABLE T_tenant1_PIMSAPP_ADM.DBPROVISIONING_LOCK ( LOCK_ID NUMBER(18), LOCK_HOLDER VARCHAR2(1024), CONSTRAINT DBPROVISIONING_LOCK_PK PRIMARY KEY (LOCK_ID) USING INDEX PCTFREE 10 STORAGE(INITIAL 1M NEXT 1M MINEXTENTS 1 MAXEXTENTS unlimited PCTINCREASE 0) TABLESPACE COMMON_PRIM_NDX )
  90. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: CREATE TABLE T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING ( SYS_APPL_SETTING_ID NUMBER(18,0) NOT NULL , APPL_SETTING_CATEGORY VARCHAR2(20 CHAR) NOT NULL , APPL_SETTING_NAME VARCHAR2(255 CHAR) NOT NULL , APPL_SETTING_VALUE VARCHAR2(4000 CHAR), CREATE_USER VARCHAR2(255 CHAR), CREATE_TS TIMESTAMP (6), UPDATE_USER VARCHAR2(255 CHAR), UPDATE_TS TIMESTAMP (6) )
  91. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: CREATE SEQUENCE T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ MINVALUE 100 INCREMENT BY 100 START WITH 100
  92. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: ALTER TABLE T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING ADD CONSTRAINT SYS_APPL_SETTING_UKT UNIQUE ( APPL_SETTING_CATEGORY, APPL_SETTING_NAME)
  93. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: INSERT INTO T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING(SYS_APPL_SETTING_ID, APPL_SETTING_CATEGORY, APPL_SETTING_NAME, APPL_SETTING_VALUE, CREATE_USER, CREATE_TS, UPDATE_USER, UPDATE_TS) Values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'dbboot','PRIMEADM','T_tenant1_PIMSAPP_ADM','rcu', current_timestamp, 'rcu', current_timestamp)
  94. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: INSERT INTO T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING(SYS_APPL_SETTING_ID, APPL_SETTING_CATEGORY, APPL_SETTING_NAME, APPL_SETTING_VALUE, CREATE_USER, CREATE_TS, UPDATE_USER, UPDATE_TS) Values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'dbboot','PRIMEDB_DAT','COMMON_PRIM_DAT','rcu', current_timestamp, 'rcu', current_timestamp)
  95. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: INSERT INTO T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING(SYS_APPL_SETTING_ID, APPL_SETTING_CATEGORY, APPL_SETTING_NAME, APPL_SETTING_VALUE, CREATE_USER, CREATE_TS, UPDATE_USER, UPDATE_TS) Values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'dbboot','PRIMEDB_NDX','COMMON_PRIM_NDX','rcu', current_timestamp, 'rcu', current_timestamp)
  96. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: INSERT INTO T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING(SYS_APPL_SETTING_ID, APPL_SETTING_CATEGORY, APPL_SETTING_NAME, APPL_SETTING_VALUE, CREATE_USER, CREATE_TS, UPDATE_USER, UPDATE_TS) Values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'dbboot','PRIMEDB_LOB','COMMON_PRIM_LOB','rcu', current_timestamp, 'rcu', current_timestamp)
  97. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: INSERT INTO T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING(SYS_APPL_SETTING_ID, APPL_SETTING_CATEGORY, APPL_SETTING_NAME, APPL_SETTING_VALUE, CREATE_USER, CREATE_TS, UPDATE_USER, UPDATE_TS) Values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'dbboot','PRIMEDB_LOB_SF','COMMON_PRIM_SF_LOB','rcu', current_timestamp, 'rcu', current_timestamp)
  98. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: INSERT INTO T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING(SYS_APPL_SETTING_ID, APPL_SETTING_CATEGORY, APPL_SETTING_NAME, APPL_SETTING_VALUE, CREATE_USER, CREATE_TS, UPDATE_USER, UPDATE_TS) Values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'dbboot','PRIMEDB_DAT_SF','COMMON_PRIM_SF_LOB','rcu', current_timestamp, 'rcu', current_timestamp)
  99. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: INSERT INTO T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING(SYS_APPL_SETTING_ID, APPL_SETTING_CATEGORY, APPL_SETTING_NAME, APPL_SETTING_VALUE, CREATE_USER, CREATE_TS, UPDATE_USER, UPDATE_TS) Values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'dbboot','PRIMEDB_DAT_HT','COMMON_PRIM_HT_DAT','rcu', current_timestamp, 'rcu', current_timestamp)
  100. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: INSERT INTO T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING(SYS_APPL_SETTING_ID, APPL_SETTING_CATEGORY, APPL_SETTING_NAME, APPL_SETTING_VALUE, CREATE_USER, CREATE_TS, UPDATE_USER, UPDATE_TS) Values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'dbboot','PRIMEDB_NDX_HT','COMMON_PRIM_HT_NDX','rcu', current_timestamp, 'rcu', current_timestamp)
  101. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: INSERT INTO T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING(SYS_APPL_SETTING_ID, APPL_SETTING_CATEGORY, APPL_SETTING_NAME, APPL_SETTING_VALUE, CREATE_USER, CREATE_TS, UPDATE_USER, UPDATE_TS) Values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'dbboot','PRIMEDB_DAT_OV','COMMON_PRIM_OV_DAT','rcu', current_timestamp, 'rcu', current_timestamp)
  102. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: INSERT INTO T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING(SYS_APPL_SETTING_ID, APPL_SETTING_CATEGORY, APPL_SETTING_NAME, APPL_SETTING_VALUE, CREATE_USER, CREATE_TS, UPDATE_USER, UPDATE_TS) Values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'dbboot','PRIMEDB_NDX_OV','COMMON_PRIM_OV_NDX','rcu', current_timestamp, 'rcu', current_timestamp)
  103. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: INSERT INTO T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING(SYS_APPL_SETTING_ID, APPL_SETTING_CATEGORY, APPL_SETTING_NAME, APPL_SETTING_VALUE, CREATE_USER, CREATE_TS, UPDATE_USER, UPDATE_TS) Values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'dbboot','PRIMEDB_DAT_MC','COMMON_PRIM_MCD','rcu', current_timestamp, 'rcu', current_timestamp)
  104. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','USERENV_NAMESPACE','USERENV','rcu', current_timestamp, 'rcu', current_timestamp)
  105. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','USERENV_PARAM_CLIENT_IDENT','CLIENT_IDENTIFIER','rcu', current_timestamp, 'rcu', current_timestamp)
  106. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','USERENV_PARAM_CURRENT_USER','CURRENT_USER','rcu', current_timestamp, 'rcu', current_timestamp)
  107. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','USERENV_PARAM_CURRENT_USERID','CURRENT_USERID','rcu', current_timestamp, 'rcu', current_timestamp)
  108. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','USERENV_PARAM_IP_ADDRESS','IP_ADDRESS','rcu', current_timestamp, 'rcu', current_timestamp)
  109. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING(sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','USERENV_PARAM_HOST','HOST','rcu', current_timestamp, 'rcu', current_timestamp)
  110. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','USERENV_PARAM_ISDBA','ISDBA','rcu', current_timestamp, 'rcu', current_timestamp)
  111. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','USERENV_PARAM_MODULE','MODULE','rcu', current_timestamp, 'rcu', current_timestamp)
  112. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','USERENV_PARAM_OS_USER','OS_USER','rcu', current_timestamp, 'rcu', current_timestamp)
  113. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','USERENV_PARAM_SERVER_HOST','SERVER_HOST','rcu', current_timestamp, 'rcu', current_timestamp)
  114. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','USERENV_PARAM_SERVICE_NAME','SERVICE_NAME','rcu', current_timestamp, 'rcu', current_timestamp)
  115. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','USERENV_PARAM_SESSION_USERID','SESSION_USERID','rcu', current_timestamp, 'rcu', current_timestamp)
  116. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','USERENV_PARAM_SESSIONID','SESSIONID','rcu', current_timestamp, 'rcu', current_timestamp)
  117. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','INTERNAL_DATE_FORMAT','YYYY.MM.DD HH24:MI:SS','rcu', current_timestamp, 'rcu', current_timestamp)
  118. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING(sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','INTERNAL_TS_FORMAT','YYYY.MM.DD HH24:MI:SSxFF','rcu', current_timestamp, 'rcu', current_timestamp)
  119. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','DEFAULT_SEQUENCE_START','1','rcu', current_timestamp, 'rcu', current_timestamp)
  120. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','DEFAULT_SEQUENCE_CACHE','20','rcu', current_timestamp, 'rcu', current_timestamp)
  121. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','SEQUENCE_SUFFIX','_SEQ','rcu', current_timestamp, 'rcu', current_timestamp)
  122. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','HISTORY_TABLE_PREFIX','HT$','rcu', current_timestamp, 'rcu', current_timestamp)
  123. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','HISTORY_TABLE_HTX_PREFIX','HTX$','rcu', current_timestamp, 'rcu', current_timestamp)
  124. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','OVERLAY_TABLE_PREFIX','OV$','rcu', current_timestamp, 'rcu', current_timestamp)
  125. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING(sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','ROLLUP_TABLE_SUFFIX','_R','rcu', current_timestamp, 'rcu', current_timestamp)
  126. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','DEF_HISTPART_MERGE_THRESHOLD','50000','rcu', current_timestamp, 'rcu', current_timestamp)
  127. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','MAXIMUM_DATE_VALUE','12/31/9999 23:59:59','rcu', current_timestamp, 'rcu', current_timestamp)
  128. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: CREATE OR REPLACE CONTEXT T_tenant1_PIMS_LOGCTX USING T_tenant1_PIMSAPP_ADM.co_log
  129. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: CREATE OR REPLACE CONTEXT T_tenant1_PIMS_SESCTX USING T_tenant1_PIMSAPP_ADM.co_session
  130. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','SESSCTX',upper('T_tenant1_PIMS_SESCTX'),'rcu', current_timestamp, 'rcu', current_timestamp)
  131. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: Insert into T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING (sys_appl_setting_id, appl_setting_category, appl_setting_name, appl_setting_value, create_user, create_ts, update_user, update_ts) values (T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING_SEQ.nextval,'database','LOGCTX',upper('T_tenant1_PIMS_LOGCTX'),'rcu', current_timestamp, 'rcu', current_timestamp)
  132. [java] [INFO | Apr 12, 01:32:50] com.oracle.cegbu.microservice.tenant.service.Main:81 - Running DDL: ALTER TABLE T_tenant1_PIMSAPP_ADM.SYS_APPL_SETTING DROP CONSTRAINT SYS_APPL_SETTING_UKT
  133.  
  134. BUILD SUCCESSFUL
  135. Total time: 6 seconds
  136. bash-4.2$ ant run-dbboot
  137. Buildfile: /scratch/rajraman/work/pgbu_platform-2.0/projects/dbboot/build.xml
  138.  
  139. -init:
  140.  
  141. load_user_properties:
  142.  
  143. run-dbboot:
  144.  
  145. -init:
  146.  
  147. load_user_properties:
  148.  
  149. run-dbbuilder:
  150. [echo] db.host : localhost
  151. [echo] db.port : 1521
  152. [echo] db.name : primedb.us.oracle.com
  153. [echo] db.sys.username : sys
  154. [echo] db.sys.password : Prima123Vera
  155. [echo] db.jdbc.user : T_tenant1_PIMSAPP_ADM
  156. [echo] db.tenant.password : Prima123Vera
  157. [echo] Using Jar : /scratch/rajraman/work/pgbu_platform-2.0/projects/dbboot/../../3rdparty/schema-defs/gateway-schema-defs.jar
  158. [echo] ****************************************************************************************************************
  159. [echo] Running dbbuilder for T_tenant1_PIMSAPP_ADM in database localhost:1521/primedb.us.oracle.com
  160. [echo] Schema gateway and prefix T_tenant1
  161. [echo] ****************************************************************************************************************
  162. [java] [INFO | Apr 12, 01:33:09] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Begin Prime Database Upgrade : [ln=235,gateway-T_tenant1]
  163. [java] [INFO | Apr 12, 01:33:09] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Found connection and custom script 1 for user PRIMEADM, running : [ln=375,gateway-T_tenant1]
  164. [java] [INFO | Apr 12, 01:33:12] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Finished custom script 1 for user PRIMEADM, OK : [ln=399,gateway-T_tenant1]
  165. [java] [INFO | Apr 12, 01:33:12] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Need to run one time file: fd_entries_for_sys_appl_setting.sql : [ln=538,gateway-T_tenant1]
  166. [java] [INFO | Apr 12, 01:33:13] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Need to run one time file: dedupe_ra_sa_column.sql : [ln=538,gateway-T_tenant1]
  167. [java] [INFO | Apr 12, 01:33:13] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Need to run one time file: update_fd_table.sql : [ln=538,gateway-T_tenant1]
  168. [java] [INFO | Apr 12, 01:33:20] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - retrieved table renames : [ln=584,gateway-T_tenant1]
  169. [java] [INFO | Apr 12, 01:33:20] com.oracle.pgbu.db.dbboot.upgrade.rename.UpgradeLogic:60 - Finding modified index tables : [ln=440,gateway-T_tenant1]
  170. [java] [INFO | Apr 12, 01:33:23] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type SEQUENCE (81) : [ln=211,gateway-T_tenant1]
  171. [java] [INFO | Apr 12, 01:33:23] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type TABLE (81) : [ln=211,gateway-T_tenant1]
  172. [java] [INFO | Apr 12, 01:33:23] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type TABLE_FIELD (0) : [ln=211,gateway-T_tenant1]
  173. [java] [INFO | Apr 12, 01:33:23] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type CONSTRAINT (273) : [ln=211,gateway-T_tenant1]
  174. [java] [INFO | Apr 12, 01:33:23] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type INDEX (160) : [ln=211,gateway-T_tenant1]
  175. [java] [INFO | Apr 12, 01:33:23] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type TYPE (5) : [ln=211,gateway-T_tenant1]
  176. [java] [INFO | Apr 12, 01:33:24] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type GRANT (0) : [ln=211,gateway-T_tenant1]
  177. [java] [INFO | Apr 12, 01:33:24] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type PLSOURCE (41) : [ln=211,gateway-T_tenant1]
  178. [java] [INFO | Apr 12, 01:33:24] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type VIEW (0) : [ln=211,gateway-T_tenant1]
  179. [java] [INFO | Apr 12, 01:33:24] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type TRIGGER (0) : [ln=211,gateway-T_tenant1]
  180. [java] [INFO | Apr 12, 01:33:24] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type CTXINDEX (2) : [ln=211,gateway-T_tenant1]
  181. [java] [INFO | Apr 12, 01:33:24] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type CTXPREF (3) : [ln=211,gateway-T_tenant1]
  182. [java] [INFO | Apr 12, 01:33:24] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type CTXPREFVALUE (4) : [ln=211,gateway-T_tenant1]
  183. [java] [INFO | Apr 12, 01:33:24] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type FD_COLUMN (0) : [ln=211,gateway-T_tenant1]
  184. [java] [INFO | Apr 12, 01:33:24] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type FD_TABLE (0) : [ln=211,gateway-T_tenant1]
  185. [java] [INFO | Apr 12, 01:33:24] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type FD_LIST (10) : [ln=211,gateway-T_tenant1]
  186. [java] [INFO | Apr 12, 01:33:24] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type FD_LIST_VALUE (105) : [ln=211,gateway-T_tenant1]
  187. [java] [INFO | Apr 12, 01:33:24] com.oracle.pgbu.db.dbboot.DBProvisioningDeltaScanner:60 - Deltas for type MDRT_ENTRY (0) : [ln=211,gateway-T_tenant1]
  188. [java] [INFO | Apr 12, 01:33:24] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Disable triggers on tables : [ln=523,gateway-T_tenant1]
  189. [java] [INFO | Apr 12, 01:33:25] com.oracle.pgbu.db.dbboot.direct.DirectDBProvisioningStatusEventHandler:60 - Delta Resolution Percent Complete: 10% : [ln=22,gateway-T_tenant1]
  190. [java] [INFO | Apr 12, 01:33:33] com.oracle.pgbu.db.dbboot.direct.DirectDBProvisioningStatusEventHandler:60 - Delta Resolution Percent Complete: 20% : [ln=22,gateway-T_tenant1]
  191. [java] [INFO | Apr 12, 01:33:36] com.oracle.pgbu.db.dbboot.direct.DirectDBProvisioningStatusEventHandler:60 - Delta Resolution Percent Complete: 30% : [ln=22,gateway-T_tenant1]
  192. [java] [INFO | Apr 12, 01:33:40] com.oracle.pgbu.db.dbboot.direct.DirectDBProvisioningStatusEventHandler:60 - Delta Resolution Percent Complete: 40% : [ln=22,gateway-T_tenant1]
  193. [java] [INFO | Apr 12, 01:33:45] com.oracle.pgbu.db.dbboot.direct.DirectDBProvisioningStatusEventHandler:60 - Delta Resolution Percent Complete: 50% : [ln=22,gateway-T_tenant1]
  194. [java] [INFO | Apr 12, 01:33:51] com.oracle.pgbu.db.dbboot.direct.DirectDBProvisioningStatusEventHandler:60 - Delta Resolution Percent Complete: 60% : [ln=22,gateway-T_tenant1]
  195. [java] [INFO | Apr 12, 01:34:01] com.oracle.pgbu.db.dbboot.direct.DirectDBProvisioningStatusEventHandler:60 - Delta Resolution Percent Complete: 70% : [ln=22,gateway-T_tenant1]
  196. [java] [INFO | Apr 12, 01:34:09] com.oracle.pgbu.db.dbboot.direct.DirectDBProvisioningStatusEventHandler:60 - Delta Resolution Percent Complete: 80% : [ln=22,gateway-T_tenant1]
  197. [java] [INFO | Apr 12, 01:34:15] com.oracle.pgbu.db.dbboot.direct.DirectDBProvisioningStatusEventHandler:60 - Delta Resolution Percent Complete: 90% : [ln=22,gateway-T_tenant1]
  198. [java] [INFO | Apr 12, 01:34:16] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Delta Resolution Percent Complete: 100% : [ln=487,gateway-T_tenant1]
  199. [java] [INFO | Apr 12, 01:34:16] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Synching history and rollup on 89 tables : [ln=490,gateway-T_tenant1]
  200. [java] [INFO | Apr 12, 01:34:30] com.oracle.pgbu.db.dbboot.upgrade.rename.UpgradeLogic:60 - Synching Percent Complete: 10% : [ln=586,gateway-T_tenant1]
  201. [java] [INFO | Apr 12, 01:34:32] com.oracle.pgbu.db.dbboot.upgrade.rename.UpgradeLogic:60 - Synching Percent Complete: 20% : [ln=586,gateway-T_tenant1]
  202. [java] [INFO | Apr 12, 01:34:38] com.oracle.pgbu.db.dbboot.upgrade.rename.UpgradeLogic:60 - Synching Percent Complete: 30% : [ln=586,gateway-T_tenant1]
  203. [java] [INFO | Apr 12, 01:34:40] com.oracle.pgbu.db.dbboot.upgrade.rename.UpgradeLogic:60 - Synching Percent Complete: 40% : [ln=586,gateway-T_tenant1]
  204. [java] [INFO | Apr 12, 01:34:44] com.oracle.pgbu.db.dbboot.upgrade.rename.UpgradeLogic:60 - Synching Percent Complete: 50% : [ln=586,gateway-T_tenant1]
  205. [java] [INFO | Apr 12, 01:34:50] com.oracle.pgbu.db.dbboot.upgrade.rename.UpgradeLogic:60 - Synching Percent Complete: 60% : [ln=586,gateway-T_tenant1]
  206. [java] [INFO | Apr 12, 01:34:51] com.oracle.pgbu.db.dbboot.upgrade.rename.UpgradeLogic:60 - Synching Percent Complete: 70% : [ln=586,gateway-T_tenant1]
  207. [java] [INFO | Apr 12, 01:34:53] com.oracle.pgbu.db.dbboot.upgrade.rename.UpgradeLogic:60 - Synching Percent Complete: 80% : [ln=586,gateway-T_tenant1]
  208. [java] [INFO | Apr 12, 01:34:53] com.oracle.pgbu.db.dbboot.upgrade.rename.UpgradeLogic:60 - Synching Percent Complete: 100% : [ln=591,gateway-T_tenant1]
  209. [java] [INFO | Apr 12, 01:34:53] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Enable triggers on tables : [ln=512,gateway-T_tenant1]
  210. [java] [INFO | Apr 12, 01:34:53] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - There were 0 deltas out of 765 that threw errors : [ln=898,gateway-T_tenant1]
  211. [java] [INFO | Apr 12, 01:34:53] com.oracle.pgbu.db.dbboot.runner.SeedDataUtil:60 - Loading seed data for FD_LIST_VALUE : [ln=73,gateway-T_tenant1]
  212. [java] [INFO | Apr 12, 01:34:57] com.oracle.pgbu.db.dbboot.runner.SeedDataUtil:60 - Loading seed data for FD_COLUMN : [ln=73,gateway-T_tenant1]
  213. [java] [INFO | Apr 12, 01:35:15] com.oracle.pgbu.db.dbboot.runner.SeedDataUtil:60 - Loading seed data for FD_COLUMN_NM : [ln=73,gateway-T_tenant1]
  214. [java] [INFO | Apr 12, 01:36:05] com.oracle.pgbu.db.dbboot.runner.SeedDataUtil:60 - Loading seed data for WS_WORKSPACE : [ln=73,gateway-T_tenant1]
  215. [java] [INFO | Apr 12, 01:36:13] com.oracle.pgbu.db.dbboot.runner.SeedDataUtil:60 - Loading seed data for FD_LIST_VALUE : [ln=73,gateway-T_tenant1]
  216. [java] [INFO | Apr 12, 01:36:13] com.oracle.pgbu.db.dbboot.runner.SeedDataUtil:60 - Loading seed data for FD_LIST_VALUE_NM : [ln=73,gateway-T_tenant1]
  217. [java] [INFO | Apr 12, 01:36:35] com.oracle.pgbu.db.dbboot.runner.SeedDataUtil:60 - Loading seed data for FD_COLUMN : [ln=73,gateway-T_tenant1]
  218. [java] [INFO | Apr 12, 01:36:35] com.oracle.pgbu.db.dbboot.runner.SeedDataUtil:60 - Loading seed data for FD_COLUMN_NM : [ln=73,gateway-T_tenant1]
  219. [java] [INFO | Apr 12, 01:36:35] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Need to run one time file: dm_period_fill.sql : [ln=538,gateway-T_tenant1]
  220. [java] [INFO | Apr 12, 01:37:59] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Need to run one time file: update_fd_column_view_column_name.sql : [ln=538,gateway-T_tenant1]
  221. [java] [INFO | Apr 12, 01:37:59] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Need to run one time file: leantask_field_map_template.sql : [ln=538,gateway-T_tenant1]
  222. [java] [INFO | Apr 12, 01:38:01] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Need to run one time file: resource_calendar_filter.sql : [ln=538,gateway-T_tenant1]
  223. [java] [INFO | Apr 12, 01:38:05] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Need to run one time file: fieldmaptemplate_calendar_field.sql : [ln=538,gateway-T_tenant1]
  224. [java] [INFO | Apr 12, 01:38:08] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Found connection and custom script 1 for user PRIMEADM, running : [ln=375,gateway-T_tenant1]
  225. [java] [INFO | Apr 12, 01:38:21] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Finished custom script 1 for user PRIMEADM, OK : [ln=399,gateway-T_tenant1]
  226. [java] [INFO | Apr 12, 01:38:21] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Found connection and custom script 2 for user PRIMEADM, running : [ln=375,gateway-T_tenant1]
  227. [java] [INFO | Apr 12, 01:38:47] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - Finished custom script 2 for user PRIMEADM, OK : [ln=399,gateway-T_tenant1]
  228. [java] [INFO | Apr 12, 01:38:47] com.oracle.pgbu.db.dbboot.runner.DBProvisioningController:60 - End Prime Database Upgrade : [ln=246,gateway-T_tenant1]
  229. [java] [INFO | Apr 12, 01:38:47] com.oracle.pgbu.db.framework.hydrate.SchemaCreator:203 - complete
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!