Optional Auto-Add support for Oracle DDL
You can expand Auto-Add support to include any of the object types listed in the following table. The object is
added to replication if its name satisfies a wildcard specification in the active configuration file.
To enable auto-add of individual object types
1. Make certain the SP_OCT_AUTOADD_ENABLE parameter is set to 1.
2. Set the appropriate parameter to 1, using the following table as your guide.
DDL to auto-add Parameter to set to 1 Additional requirements
CREATE / DROP SEQUENCE SP_OCT_AUTOADD_SEQ Set the SP_OCT_TARGET_
COMPATIBILITY parameter
to at least 8.6.3.
（序列复制上篇文章已经测试过，详见上篇）
CREATE /DROP
MATERIALIZED VIEW* SP_OCT_AUTOADD_MV Set the SP_OCT_TARGET_
COMPATIBILITY parameter
to at least 8.6.2.
* NOTE: SharePlex does not replicate materialized views to materialized views. SharePlex converts a
CREATE MATERIALIZED VIEW to a CREATE TABLE, applies the CREATE TABLE to the target, and then
replicates the DML that populates the view. SharePlex replicates DROP MATERIALIZED VIEW, but not
ALTER MATERIALIZED VIEW.
See the SharePlex Reference Guide for details about these parameters.
[BEGIN] 2017/4/7 13:24:54
sp_ctrl (node1:2100)> exit
[oracle@node1 ~]$ ps -ef | grep sp_cop
oracle 2572 2458 0 01:23 pts/0 00:00:00 /u01/app/proddir/.app-modules/sp_cop
oracle 2600 2458 0 01:26 pts/0 00:00:00 grep sp_cop
[oracle@node1 ~]$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (node1:2100)> status
Brief Status for node1
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 2572 07-Apr-17 01:23:40
Capture Running 2576 07-Apr-17 01:24:15
Read Running 2584 07-Apr-17 01:24:17
Export Running 2594 07-Apr-17 01:24:19
Cmd & Ctrl Running 2602 07-Apr-17 01:26:13
System is used as a source machine
There is 1 active configuration file
sp_ctrl (node1:2100)> list param
Analyze parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_ANL_CHECKPOINT_FREQ 20000 message Live
SP_ANL_CHECKPOINT_TIME 120 seconds Live
SP_ANL_LOG_FILESIZE 50000000 bytes Restart Process
SP_ANL_LOG_NUMFILES 3 number Restart Process
SP_ANL_RUN_TIME 4320 number Live
Command and Control parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_CNC_COMM_TIMEOUT 0 minutes Live
SP_CNC_LOG 0 number Live
Control Process parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_COP_IDLETIME 60 seconds Live
SP_COP_SCAN_TIMEOUT 300 seconds Live
SP_COP_SO_RCVBUF 0 bytes Restart Cop
Compare/Repair parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_DEQ_AUTO_REPAIR1 1 boolean Live
SP_DEQ_COPY_CHECK_ROWS 200000 Live
SP_DEQ_IGNORE_ORACLE_ERROR_NUM 0 number Live
SP_DEQ_IP_MAPPING Live
SP_DEQ_IP_MAPPING_OPTION 1 number Live
SP_DEQ_LOCK_WAIT 300 seconds Live
SP_DEQ_LOG_FILESIZE 50 MB Live
SP_DEQ_LOG_NUMFILES 3 number Live
SP_DEQ_MALLOC 500 MB Live
SP_DEQ_PADDER 0 number Live
SP_DEQ_PARALLELISM 2 number Live
SP_DEQ_PART_TABLE_UPDATE 0 number Live
SP_DEQ_PARTIAL_REPAIR_CLR_OOS 0 boolean Live
SP_DEQ_QUICK_COMPARE_DEFAULT 0 boolean Live
SP_DEQ_READ_BUFFER_SIZE 1 mbytes Live
SP_DEQ_ROW_LOCK_THRESHOLD 1000 number Live
SP_DEQ_SKIP_LOB 0 boolean Live
SP_DEQ_SWAP_BYTE 0 number Live
SP_DEQ_THREADS 2 threads Live
SP_DEQ_TIMEOUT 1800 seconds Live
Import parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_IMP_QUEUE_PAUSE 0 Kmsgs Live
SP_IMP_QUEUE_RESUME 0 Kmsgs Live
Configuration Management parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_OCF_FK_ANALYSIS 1 boolean Live
SP_OCF_HEAP_NEWLIST 0 boolean Live
SP_OCF_LOCK_WAIT_TIME 5 minutes Live
SP_OCF_LOG_FILESIZE 50000000 bytes Live
SP_OCF_LOG_NUMFILES 3 number Live
SP_OCF_THREAD_COUNT 3 threads Live
SP_OCF_USE_TEMPSEG_LIMIT 100 tables Live
Capture parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_OCT_ARCH_LOC Live
SP_OCT_ASM_USE_OCI 0 boolean Restart Process
SP_OCT_AUTOADD_ENABLE 1 boolean Restart Process
SP_OCT_AUTOADD_MVIEW 0 boolean Restart Process
SP_OCT_AUTOADD_SEQ 1 boolean Restart Process
Default Value: 0
SP_OCT_BIO_CHECKSUM 0 boolean Live
SP_OCT_CHECKPOINT_LOG 2 logs Live
SP_OCT_DATA_OBJ_CACHE_SIZE 50 values Live
SP_OCT_DATE_MSG 0 Live
SP_OCT_DDL_LOGGING 2 Live
SP_OCT_DEF_DAY 1 Live
SP_OCT_DEF_HOUR 0 Live
SP_OCT_DEF_MIN 0 Live
SP_OCT_DEF_MONTH 1 Live
SP_OCT_DEF_SEC 0 Live
SP_OCT_DEF_YEAR 1999 Live
SP_OCT_DENIED_USERID 0x00000000 number Live
SP_OCT_INCLUDE_UNCHANGED_COL 0 boolean Live
SP_OCT_LOG_MEMBER % Restart Process
SP_OCT_LOGWRAP_RESTART 0 seconds Live
SP_OCT_ONELINE_DEBUG Live
SP_OCT_ONELINE_DEBUG_COLUMNS 0 Live
SP_OCT_OPTIMIZE_ROW_MOVEMENT 0 boolean Live
SP_OCT_PREFER_ARCHIVE 0 boolean Restart Process
SP_OCT_REPLICATE_ALL_DDL 0 Live
SP_OCT_REPLICATE_CTAS 1 Restart Process
SP_OCT_REPLICATE_DDL 3 Live
SP_OCT_REPLICATE_DLOAD 1 Live
SP_OCT_REPLICATE_MVIEW 1 boolean Restart Process
SP_OCT_REPLICATE_POSTER 0 Restart Process
SP_OCT_REPLICATE_SEQUENCES 1 boolean Restart Process
SP_OCT_REQUIRED_DATA_IS_LOGGED 1 Restart Process
SP_OCT_TARGET_COMPATIBILITY 8.6.6 Restart Process
SP_OCT_TRUNC_PARTITION_BY_ID 0 boolean Live
Post parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_OPO_CHANGE_ID_START_VALUE Restart Process
SP_OPO_CONT_ON_ERR 0 Live
SP_OPO_DISABLE_OBJECT_NUM Live
SP_OPO_HINTS_LIMIT 100 hints Restart Process
SP_OPO_MAX_CDA 50 Restart Process
SP_OPO_ONELINE_DEBUG Live
SP_OPO_ONELINE_DEBUG_COLUMNS 0 Live
SP_OPO_OUT_OF_SYNC_SUSPEND 0 Live
SP_OPO_PARSE_TIMEOUT 100 msec Live
SP_OPO_POSTER_DELAY 0 minutes Live
SP_OPO_PRB_MISMATCH_SUSPEND 0 Live
SP_OPO_QUE_REREAD_INTERVAL 1 seconds Live
SP_OPO_READRELEASE_INTERVAL 100 Live
SP_OPO_RETRIES_MAX 10 retries Live
SP_OPO_SKIP_BAD_MESSAGE 0 Live
SP_OPO_SKIP_FAIL_DDL_ON_RESTAR 1 Restart Process
SP_OPO_SQL_CACHE_DISABLE 0 Restart Process
SP_OPO_STOP_ON_DDL_ERR 1 Live
SP_OPO_SYNC_LOG_FREQUENCY 1 Live
SP_OPO_SYNC_STATUS_TIMEOUT 180 Seconds Live
SP_OPO_TRACK_COMMITS 0 Restart Process
SP_OPO_TRACK_OPERATIONS I/U/D Restart Process
SP_OPO_TRACK_PREIMAGE Restart Process
SP_OPO_TRACK_TIME_AS_CHAR 0 Restart Process
SP_OPO_TRUSTED_SOURCE Restart Process
SP_OPO_WAIT_MSG_DELAY 300 seconds Restart Process
Open Post parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_OPX_CONT_ON_ERR 0 Live
SP_OPX_DEBUG_FLAG 0x00000000 bitflag Live
SP_OPX_DISABLE_OBJECT_NUM Live
SP_OPX_LOG_FILESIZE 50000000 bytes Restart Process
SP_OPX_LOG_NUMFILES 3 number Restart Process
SP_OPX_MAX_CDA 0 Restart Process
SP_OPX_ONELINE_DEBUG Live
SP_OPX_OUT_OF_SYNC_SUSPEND 0 Live
SP_OPX_READRELEASE_INTERVAL 1000 Restart Process
SP_OPX_SQL_CACHE_DISABLE 0 Restart Process
Read parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_ORD_DATE_MSG 0 Live
SP_ORD_DELAY_RECORDS 200 records Live
SP_ORD_DISABLE_OBJECT_NUM Live
SP_ORD_FILTER_OPEN_TGT_DDL 1 Restart Process
SP_ORD_FIRST_FIND 1 Restart Process
SP_ORD_HP_HASH 16 slots Restart Process
SP_ORD_HP_IN_SYNC 0 Restart Process
SP_ORD_ONELINE_DEBUG Live
SP_ORD_ONELINE_DEBUG_COLUMNS 0 Live
SP_ORD_SEND_DDL_TO_FIRST 1 Live
Sync parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_OSY_COMPRESSION 6 Live
SP_OSY_LOCK_TIMEOUT 2 Seconds Live
SP_OSY_POST_TIMEOUT 1800 Seconds Live
SP_OSY_THREADS 5 Thread Live
SharePlex Queues parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_QUE_MAX_QUEUES 25 queues Restart Cop
SP_QUE_POST_SHMSIZE 32 Mbytes Restart Cop
SP_QUE_Q_SHMSIZE 8 Mbytes Restart Cop
SP_QUE_SHMDBUF 32768 bytes Restart Cop
SP_QUE_SYNC 2 Restart Cop
Event Logging parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_SLG_LOG_MAXSIZE 500 mbytes Restart Cop
SP_SLG_SNMP_ACTIVE 0 Restart Cop
SP_SLG_SNMP_COMMUNITY Restart Cop
SP_SLG_SNMP_ENTERPRISE_OID 1.3.6.1.4.1.3.1.1 Restart Cop
SP_SLG_SNMP_ERROR 0 Restart Cop
SP_SLG_SNMP_EXIT 0 Restart Cop
SP_SLG_SNMP_HOST Restart Cop
SP_SLG_SNMP_INT_ERROR 0 Restart Cop
SP_SLG_SNMP_LAUNCH 0 Restart Cop
SP_SLG_SNMP_MJR_ERRNUM 0 Restart Cop
SP_SLG_SNMP_MNR_ERRNUM 0 Restart Cop
SP_SLG_SNMP_OUT_OF_SYNC 0 Restart Cop
SP_SLG_SNMP_SHUTDOWN 0 Restart Cop
SP_SLG_SNMP_STARTUP 0 Restart Cop
SP_SLG_SNMP_SYS_ERROR 0 Restart Cop
SP_SLG_SNMP_TRAP_OID 1.3.6.1.2.1.1.1.0 Restart Cop
SP_SLG_SNMP_TRAP_PROGRAM iwsnmptrap Restart Cop
System parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_SYS_API_KEY 300d8d80-1aca-11e7-9129-091566695250 Live
SP_SYS_HOST_NAME Restart Cop
SP_SYS_JOB_HISTORY_RETENTION 90 days Live
SP_SYS_LIC_25614 CN0DW1WAVEJG3NCMC4647K0YMEB0SXBJYW:X Install
SP_SYS_SUSPEND_ON_ERROR 1 Live
SP_SYS_VAR_FULL 30 mbytes Live
SP_SYS_VAR_OK 50 mbytes Live
Export parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_XPT_AES_KEY_LENGTH 128 Restart Process
SP_XPT_ALTERNATE_HOST Restart Process
SP_XPT_ENABLE_AES 0 Restart Process
SP_XPT_ENABLE_COMPRESSION 0 Restart Process
SP_XPT_PCT_DEVIATION 50 Live
SP_XPT_PORT_OVERRIDE 0 Restart Process
SP_XPT_SO_SNDBUF 0 bytes Restart Process
SP_XPT_USE_LOCALHOST 0 Restart Process
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> set SP_OCT_AUTOADD_MVIEW 1
Unknown directive for set command: SP_OCT_AUTOADD_MVIEW
Usage: set param name value [on host]
Or: set param name [queue quename] [to host] value [on host]
Or: set param name [from host] [queue quename] value [on host]
Or: set param name [queue quename] [for datasrc-datadst] value [on host]
Or: set param name [for datasrc] value [on host]
Usage: set log maxlines= lpp= reverse forward
sp_ctrl (node1:2100)> set param SP_OCT_AUTOADD_MVIEW 1
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> status
Brief Status for node1
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 2572 07-Apr-17 01:23:40
Capture Running 2576 07-Apr-17 01:24:15
Read Running 2584 07-Apr-17 01:24:17
Export Running 2594 07-Apr-17 01:24:19
Cmd & Ctrl Running 2602 07-Apr-17 01:26:13
System is used as a source machine
There is 1 active configuration file
sp_ctrl (node1:2100)> stop capture
sp_ctrl (node1:2100)> stop read
sp_ctrl (node1:2100)> stop export
sp_ctrl (node1:2100)> status
Brief Status for node1
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 2572 07-Apr-17 01:23:40
Capture Stopped by user
Read Stopping 2584 07-Apr-17 01:24:17
Export Stopped by user
Cmd & Ctrl Running 2602 07-Apr-17 01:26:13
System is used as a source machine
There is 1 active configuration file
sp_ctrl (node1:2100)> start capture
sp_ctrl (node1:2100)> start read
sp_ctrl (node1:2100)> start export
sp_ctrl (node1:2100)> status
Brief Status for node1
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 2572 07-Apr-17 01:23:40
Capture Running 2606 07-Apr-17 01:28:31
Read Running 2614 07-Apr-17 01:28:34
Export Running 2624 07-Apr-17 01:28:36
Cmd & Ctrl Running 2602 07-Apr-17 01:26:13
System is used as a source machine
There is 1 active configuration file
sp_ctrl (node1:2100)> list param SP_OCT_AUTOADD_MVIEW
Usage: list param [basic all modified] [module] [on host]
Module may be only one of the following:
cop, queue, logging, system, import, export, stats, capture,
read, config, post, reconcile, compare, sync, open, analyze,
sp_ctrl (node1:2100)> list param
Analyze parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_ANL_CHECKPOINT_FREQ 20000 message Live
SP_ANL_CHECKPOINT_TIME 120 seconds Live
SP_ANL_LOG_FILESIZE 50000000 bytes Restart Process
SP_ANL_LOG_NUMFILES 3 number Restart Process
SP_ANL_RUN_TIME 4320 number Live
Command and Control parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_CNC_COMM_TIMEOUT 0 minutes Live
SP_CNC_LOG 0 number Live
Control Process parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_COP_IDLETIME 60 seconds Live
SP_COP_SCAN_TIMEOUT 300 seconds Live
SP_COP_SO_RCVBUF 0 bytes Restart Cop
Compare/Repair parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_DEQ_AUTO_REPAIR1 1 boolean Live
SP_DEQ_COPY_CHECK_ROWS 200000 Live
SP_DEQ_IGNORE_ORACLE_ERROR_NUM 0 number Live
SP_DEQ_IP_MAPPING Live
SP_DEQ_IP_MAPPING_OPTION 1 number Live
SP_DEQ_LOCK_WAIT 300 seconds Live
SP_DEQ_LOG_FILESIZE 50 MB Live
SP_DEQ_LOG_NUMFILES 3 number Live
SP_DEQ_MALLOC 500 MB Live
SP_DEQ_PADDER 0 number Live
SP_DEQ_PARALLELISM 2 number Live
SP_DEQ_PART_TABLE_UPDATE 0 number Live
SP_DEQ_PARTIAL_REPAIR_CLR_OOS 0 boolean Live
SP_DEQ_QUICK_COMPARE_DEFAULT 0 boolean Live
SP_DEQ_READ_BUFFER_SIZE 1 mbytes Live
SP_DEQ_ROW_LOCK_THRESHOLD 1000 number Live
SP_DEQ_SKIP_LOB 0 boolean Live
SP_DEQ_SWAP_BYTE 0 number Live
SP_DEQ_THREADS 2 threads Live
SP_DEQ_TIMEOUT 1800 seconds Live
Import parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_IMP_QUEUE_PAUSE 0 Kmsgs Live
SP_IMP_QUEUE_RESUME 0 Kmsgs Live
Configuration Management parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_OCF_FK_ANALYSIS 1 boolean Live
SP_OCF_HEAP_NEWLIST 0 boolean Live
SP_OCF_LOCK_WAIT_TIME 5 minutes Live
SP_OCF_LOG_FILESIZE 50000000 bytes Live
SP_OCF_LOG_NUMFILES 3 number Live
SP_OCF_THREAD_COUNT 3 threads Live
SP_OCF_USE_TEMPSEG_LIMIT 100 tables Live
Capture parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_OCT_ARCH_LOC Live
SP_OCT_ASM_USE_OCI 0 boolean Restart Process
SP_OCT_AUTOADD_ENABLE 1 boolean Restart Process
SP_OCT_AUTOADD_MVIEW 1 boolean Restart Process
Default Value: 0
SP_OCT_AUTOADD_SEQ 1 boolean Restart Process
Default Value: 0
SP_OCT_BIO_CHECKSUM 0 boolean Live
SP_OCT_CHECKPOINT_LOG 2 logs Live
SP_OCT_DATA_OBJ_CACHE_SIZE 50 values Live
SP_OCT_DATE_MSG 0 Live
SP_OCT_DDL_LOGGING 2 Live
SP_OCT_DEF_DAY 1 Live
SP_OCT_DEF_HOUR 0 Live
SP_OCT_DEF_MIN 0 Live
SP_OCT_DEF_MONTH 1 Live
SP_OCT_DEF_SEC 0 Live
SP_OCT_DEF_YEAR 1999 Live
SP_OCT_DENIED_USERID 0x00000000 number Live
SP_OCT_INCLUDE_UNCHANGED_COL 0 boolean Live
SP_OCT_LOG_MEMBER % Restart Process
SP_OCT_LOGWRAP_RESTART 0 seconds Live
SP_OCT_ONELINE_DEBUG Live
SP_OCT_ONELINE_DEBUG_COLUMNS 0 Live
SP_OCT_OPTIMIZE_ROW_MOVEMENT 0 boolean Live
SP_OCT_PREFER_ARCHIVE 0 boolean Restart Process
SP_OCT_REPLICATE_ALL_DDL 0 Live
SP_OCT_REPLICATE_CTAS 1 Restart Process
SP_OCT_REPLICATE_DDL 3 Live
SP_OCT_REPLICATE_DLOAD 1 Live
SP_OCT_REPLICATE_MVIEW 1 boolean Restart Process
SP_OCT_REPLICATE_POSTER 0 Restart Process
SP_OCT_REPLICATE_SEQUENCES 1 boolean Restart Process
SP_OCT_REQUIRED_DATA_IS_LOGGED 1 Restart Process
SP_OCT_TARGET_COMPATIBILITY 8.6.6 Restart Process
SP_OCT_TRUNC_PARTITION_BY_ID 0 boolean Live
Post parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_OPO_CHANGE_ID_START_VALUE Restart Process
SP_OPO_CONT_ON_ERR 0 Live
SP_OPO_DISABLE_OBJECT_NUM Live
SP_OPO_HINTS_LIMIT 100 hints Restart Process
SP_OPO_MAX_CDA 50 Restart Process
SP_OPO_ONELINE_DEBUG Live
SP_OPO_ONELINE_DEBUG_COLUMNS 0 Live
SP_OPO_OUT_OF_SYNC_SUSPEND 0 Live
SP_OPO_PARSE_TIMEOUT 100 msec Live
SP_OPO_POSTER_DELAY 0 minutes Live
SP_OPO_PRB_MISMATCH_SUSPEND 0 Live
SP_OPO_QUE_REREAD_INTERVAL 1 seconds Live
SP_OPO_READRELEASE_INTERVAL 100 Live
SP_OPO_RETRIES_MAX 10 retries Live
SP_OPO_SKIP_BAD_MESSAGE 0 Live
SP_OPO_SKIP_FAIL_DDL_ON_RESTAR 1 Restart Process
SP_OPO_SQL_CACHE_DISABLE 0 Restart Process
SP_OPO_STOP_ON_DDL_ERR 1 Live
SP_OPO_SYNC_LOG_FREQUENCY 1 Live
SP_OPO_SYNC_STATUS_TIMEOUT 180 Seconds Live
SP_OPO_TRACK_COMMITS 0 Restart Process
SP_OPO_TRACK_OPERATIONS I/U/D Restart Process
SP_OPO_TRACK_PREIMAGE Restart Process
SP_OPO_TRACK_TIME_AS_CHAR 0 Restart Process
SP_OPO_TRUSTED_SOURCE Restart Process
SP_OPO_WAIT_MSG_DELAY 300 seconds Restart Process
Open Post parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_OPX_CONT_ON_ERR 0 Live
SP_OPX_DEBUG_FLAG 0x00000000 bitflag Live
SP_OPX_DISABLE_OBJECT_NUM Live
SP_OPX_LOG_FILESIZE 50000000 bytes Restart Process
SP_OPX_LOG_NUMFILES 3 number Restart Process
SP_OPX_MAX_CDA 0 Restart Process
SP_OPX_ONELINE_DEBUG Live
SP_OPX_OUT_OF_SYNC_SUSPEND 0 Live
SP_OPX_READRELEASE_INTERVAL 1000 Restart Process
SP_OPX_SQL_CACHE_DISABLE 0 Restart Process
Read parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_ORD_DATE_MSG 0 Live
SP_ORD_DELAY_RECORDS 200 records Live
SP_ORD_DISABLE_OBJECT_NUM Live
SP_ORD_FILTER_OPEN_TGT_DDL 1 Restart Process
SP_ORD_FIRST_FIND 1 Restart Process
SP_ORD_HP_HASH 16 slots Restart Process
SP_ORD_HP_IN_SYNC 0 Restart Process
SP_ORD_ONELINE_DEBUG Live
SP_ORD_ONELINE_DEBUG_COLUMNS 0 Live
SP_ORD_SEND_DDL_TO_FIRST 1 Live
Sync parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_OSY_COMPRESSION 6 Live
SP_OSY_LOCK_TIMEOUT 2 Seconds Live
SP_OSY_POST_TIMEOUT 1800 Seconds Live
SP_OSY_THREADS 5 Thread Live
SharePlex Queues parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_QUE_MAX_QUEUES 25 queues Restart Cop
SP_QUE_POST_SHMSIZE 32 Mbytes Restart Cop
SP_QUE_Q_SHMSIZE 8 Mbytes Restart Cop
SP_QUE_SHMDBUF 32768 bytes Restart Cop
SP_QUE_SYNC 2 Restart Cop
Event Logging parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_SLG_LOG_MAXSIZE 500 mbytes Restart Cop
SP_SLG_SNMP_ACTIVE 0 Restart Cop
SP_SLG_SNMP_COMMUNITY Restart Cop
SP_SLG_SNMP_ENTERPRISE_OID 1.3.6.1.4.1.3.1.1 Restart Cop
SP_SLG_SNMP_ERROR 0 Restart Cop
SP_SLG_SNMP_EXIT 0 Restart Cop
SP_SLG_SNMP_HOST Restart Cop
SP_SLG_SNMP_INT_ERROR 0 Restart Cop
SP_SLG_SNMP_LAUNCH 0 Restart Cop
SP_SLG_SNMP_MJR_ERRNUM 0 Restart Cop
SP_SLG_SNMP_MNR_ERRNUM 0 Restart Cop
SP_SLG_SNMP_OUT_OF_SYNC 0 Restart Cop
SP_SLG_SNMP_SHUTDOWN 0 Restart Cop
SP_SLG_SNMP_STARTUP 0 Restart Cop
SP_SLG_SNMP_SYS_ERROR 0 Restart Cop
SP_SLG_SNMP_TRAP_OID 1.3.6.1.2.1.1.1.0 Restart Cop
SP_SLG_SNMP_TRAP_PROGRAM iwsnmptrap Restart Cop
System parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_SYS_API_KEY 300d8d80-1aca-11e7-9129-091566695250 Live
SP_SYS_HOST_NAME Restart Cop
SP_SYS_JOB_HISTORY_RETENTION 90 days Live
SP_SYS_LIC_25614 CN0DW1WAVEJG3NCMC4647K0YMEB0SXBJYW:X Install
SP_SYS_SUSPEND_ON_ERROR 1 Live
SP_SYS_VAR_FULL 30 mbytes Live
SP_SYS_VAR_OK 50 mbytes Live
Export parameters:
Parameter Name Actual Value Units Set At
------------------------------ ------------------------------------ ------- ---------------
SP_XPT_AES_KEY_LENGTH 128 Restart Process
SP_XPT_ALTERNATE_HOST Restart Process
SP_XPT_ENABLE_AES 0 Restart Process
SP_XPT_ENABLE_COMPRESSION 0 Restart Process
SP_XPT_PCT_DEVIATION 50 Live
SP_XPT_PORT_OVERRIDE 0 Restart Process
SP_XPT_SO_SNDBUF 0 bytes Restart Process
SP_XPT_USE_LOCALHOST 0 Restart Process
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> status
Brief Status for node1
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 2572 07-Apr-17 01:23:40
Capture Running 2606 07-Apr-17 01:28:31
Read Running 2614 07-Apr-17 01:28:34
Export Running 2624 07-Apr-17 01:28:36
Cmd & Ctrl Running 2602 07-Apr-17 01:26:13
System is used as a source machine
There is 1 active configuration file
sp_ctrl (node1:2100)> exit
[oracle@node1 ~]$ ssh node2
oracle@node2's password:
Last login: Thu Apr 6 10:49:45 2017 from node1
[oracle@node2 ~]$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (node2:2100)> status
Brief Status for node2
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 2544 07-Apr-17 01:23:48
Post Running 2547 07-Apr-17 01:24:00
Cmd & Ctrl Running 2546 07-Apr-17 01:23:51
Import Running 2568 07-Apr-17 01:28:36
Cmd & Ctrl Running 2598 07-Apr-17 01:29:27
There are no active configuration files
sp_ctrl (node2:2100)> exit
[oracle@node2 ~]$ exit
logout
Connection to node2 closed.
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$
[oracle@node1 ~]$ sqlplus source/source
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 7 01:29:38 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create table t3 (id int primary key,name varchar2(20));
insert into t3 values (1,'aaa');
commit;create table t3 (id int primary key,name varchar2(20))
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
SQL> SQL> insert into t3 values (1,'aaa')
*
ERROR at line 1:
ORA-00913: too many values
SQL>drop table t3;
SP2-0734: unknown command beginning "commitdrop..." - rest of line ignored.
SQL> drop table t3;
Table dropped.
SQL> create table t3 (id int primary key,name varchar2(20));
insert into t3 values (1,'aaa');
commit;
Table created.
SQL> SQL>
1 row created.
SQL> desc t3;
commit;desc t3
*
ERROR at line 1:
ORA-00911: invalid character
SQL> desc t3;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER(38)
NAME VARCHAR2(20)
SQL> select count(*) from t3;
COUNT(*)
----------
1
SQL> create materialized view mv_custmer for update as select * from t3;
Materialized view created.
SQL> select * from mv_custmer;
ID NAME
---------- --------------------
1 aaa
SQL> insert into t3 values (2,'ccc');
1 row created.
SQL> commit;
Commit complete.
SQL> EXEC DBMS_MVIEW.refresh('mv_custmer');
PL/SQL procedure successfully completed.
SQL> select * from mv_custmer;
ID NAME
---------- --------------------
1 aaa
2 ccc
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node1 ~]$ ssh node2
oracle@node2's password:
Last login: Fri Apr 7 01:29:25 2017 from node1
s[oracle@node2 ~]$ sqlplus target/target
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 7 01:32:47 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select tname from tab;
TNAME
------------------------------
BIN$TI3vNrxdCizgUwgBqMB61g==$0
BIN$TIr0Nm76CpDgUwgBqMAjZw==$0
MV_CUSTMER
T1
T3
TTT
6 rows selected.
SQL> select * from mv_custmer;
ID NAME
---------- --------------------
1 aaa
2 ccc
SQL> desc user_objects;
Name Null? Type
----------------------------------------- -------- ----------------------------
OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(19)
CREATED DATE
LAST_DDL_TIME DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NUMBER
EDITION_NAME VARCHAR2(30)
SQL> select object_name,object_type from user_objects;
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
T1
TABLE
SYS_C0011410
INDEX
TTT
TABLE
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
SYS_C0011411
INDEX
SYS_C0011444
INDEX
MV_CUSTMER
TABLE
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
SEQ1
SEQUENCE
T3
TABLE
8 rows selected.
SQL> l
1* select object_name,object_type from user_objects
SQL> col object_name for a20;
SQL> set linesize 100;
SQL> /
OBJECT_NAME OBJECT_TYPE
-------------------- -------------------
T3 TABLE
SEQ1 SEQUENCE
MV_CUSTMER TABLE
SYS_C0011444 INDEX
SYS_C0011411 INDEX
TTT TABLE
SYS_C0011410 INDEX
T1 TABLE
8 rows selected.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node2 ~]$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (node2:2100)> stop capture
sp_ctrl (node2:2100)> stop read
sp_ctrl (node2:2100)> stop export
sp_ctrl (node2:2100)> shutdown
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$
[oracle@node2 ~]$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
Your tcp port is not set properly or 'sp_cop' is not running
Attempted to connect to sp_cop on port 2100
sp_ctrl > exit
[oracle@node2 ~]$ exit
logout
Connection to node2 closed.
[oracle@node1 ~]$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (node1:2100)> status
Brief Status for node1
Process State PID Running Since
--------------- ------------------------------ -------- --------------------
Cop Running 2572 07-Apr-17 01:23:40
Capture Running 2606 07-Apr-17 01:28:31
Read Running 2614 07-Apr-17 01:28:34
Export Idle
Cmd & Ctrl Running 2659 07-Apr-17 01:34:46
System is used as a source machine
There is 1 active configuration file
sp_ctrl (node1:2100)> stop capture
sp_ctrl (node1:2100)> stop read
sp_ctrl (node1:2100)> stop export
sp_ctrl (node1:2100)> shutdown
[oracle@node1 ~]$
[1]+ Done sp_cop
[oracle@node1 ~]$ exit
logout
[root@node1 ~]# su - oracle
[oracle@node1 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 7 01:40:04 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> connect /as sysDBA
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node1 ~]$ shutdown -h now
shutdown: Need to be root
[oracle@node1 ~]$ exit
logout
[root@node1 ~]# shutdown -h now
Broadcast message from root@node1
(/dev/pts/0) at 1:41 ...
The system is going down for halt NOW!
[root@node1 ~]#
Connection closed by foreign host.
Disconnected from remote host(192.168.1.7) at 13:41:09.
Type `help' to learn how to use Xshell prompt.
[END] 2017/4/7 13:41:13
|
|
京ICP备12024223-8号
不良信息举报电话：13718043309
转播
分享
淘帖