Flexfield Value Set Query Security
Update User > Assign Roles > Flexfield Value Set Security: All privileges Reference. https://docs.oracle.com/cd/E26401_01/doc.122/e22963/T354897T623930.htm
發表文章
Oracle 11g - 安裝 Golden Gate Golden Gate 運作如下 Extract:負責撈來源端( Source) 執行過的SQL然後打包成Trail檔案 Data pump:負責把 Source的 Trail 內的資料, 傳送到Target的 Trail內 Trail:負責儲存SQL資料, 預設路徑是放在 $ogg_home/dirdat 下 Replicat:讀取來源端 Trail 的SQL資料 ,然後在Target端的資料庫執行SQL 1.環境說明: Source: Red Hat Enterprise Linux Server release 5.8, Oracle 11.2.0.1.0 (single) Target: Red Hat Enterprise Linux Server release 6.4 , Oracle 11.2.0.1.0 (single) Golden gate 官方下載點: http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html source 端會安裝在 /u02/ogg_sou target 端會安裝在 /u02/ogg_tar [orcl11g@sou ~]$ mkdir -p /u02/ogg_sou [oracle@tar ~]$ mkdir -p /u02/ogg_tar 再 .bash_profile 設置 ORACLE_SID、ORACLE_HOME和LD_LIBRARY_PATH； export ORACLE_BASE=/ora/app/11; export ORACLE_HOME=$ORACLE_BASE/db; export ORACLE_SID=orcl; export ORACLE_TERM=xterm; export PATH=/usr/sbin:$PATH; export PATH=$ORACLE_HOME/bin:$PATH; export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdb
ORA-07445 案例註記
Case for Oracle9i 9.2.0.4.0 - 64bit JServer Release 9.2.0.4.0 System name: SunOS Version: Generic_142900-07 Machine: sun4u Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x588, PC: [0x1021bd314, 00000001021BD314] *** 2021-12-01 16:00:00.742 Current SQL statement for this session: create or replace package body sys.dbms_profiler wrapped - Run utlrp.sql script to recompile the invalid objects - buffer flush : alter system flush shared_pool;