Multidomain MDM
- Multidomain MDM 10.3 HotFix 1
- All Products
SQL> c:/<MDM installation directory>/hub/server/resources/database/oracle/locale/update_javasp.sql SQL> Create or replace directory GGS_PARAM_DIR as ‘D:/GGS/dirprm’; SQL> Grant read, write on directory GGS_PARAM_DIR to PUBLIC;
SQL > select * from all_directories where directory_name like 'GGS%'; OWNER DIRECTORY_NAME DIRECTORY_PATH ---------- ------------------ ---------------------------------------- SYS GGS_PARAM_DIR D:/ggs/dirprm
ALTER SYSTEM SET enable_goldengate_replication=true;
spool nologging.sql set pagesize 5000 select 'ALTER TABLE ' || TABLE_NAME || ' LOGGING;' from user_tables where LOGGING != 'YES' and TABLE_NAME like 'C^_%' ESCAPE '^'; exit
SQL> @nologgging.sql
UPDATE C_REPOS_TABLE SET NOLOGGING_IND = 0 WHERE NOLOGGING_IND = 1 and table_name != 'C_RBO_BO_CLASS' and table_name != 'C_RBO_BO_HIERARCHY' and table_name != 'C_RBO_REL_TYPE';
C:> sqlplus connect sys as sysdba; SQL> -- make sure you had previously shutdown normally SQL> STARTUP MOUNT; SQL> ALTER DATABASE ARCHIVELOG; SQL> ALTER DATABASE OPEN; SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; SQL> ALTER SYSTEM SWITCH LOGFILE; SQL> EXIT
Column Name | Value | Description |
---|---|---|
debug_ind | 1 | Enables the debug logging process. |
debug_level | 500 | Enables the most detailed level of debugging. When the value is 500, the debug logging process captures errors, warnings, and informational messages, as well as debugging information. |
debug_file_name | user-defined | Specifies a name for the file that contains the debug log information. |
debug_file_path | user-defined | Specifies the directory where the file is stored. This is the same as the utl_file_dir directory in the database.
A DBA creates the utl_file_dir directory within the spfile scope in the Oracle database instance. You can use Oracle Enterprise Manager or SQL*Plus to set the utl_file_dir.
|
log_file_size | 5 | Specifies the maximum size of the database log file in MB. The default is 5. |
log_file_number | 5 | Specifies the number of log files used for log rolling. The default is 5. |
SQL> grant Execute on DBMS_STREAMS to PUBLIC; SQL> grant Execute on DBMS_STREAMS_ADM to PUBLIC;