GoldenGate 執行ddl_setup.sql出錯 ORA-00942: table or view does not exist
在部署GoldenGate DDL選項時，執行ddl_setup.sql指令碼報錯。雖然OGG使用者已經擁有了DBA許可權，仍然需要顯示的賦予create table和create sequence才能透過。
1. 執行ddl_setup.sql指令碼
SYS@PROD1 > @ddl_setup.sql
Oracle GoldenGate DDL Replication setup script
Verifying that current user has privileges to install DDL Replication...
You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter Oracle GoldenGate schema name:oggadmin
Working, please wait ...
Spooling to file ddl_setup_spool.txt
Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...
Check complete.
Using OGGADMIN as a Oracle GoldenGate schema name.
Working, please wait ...
DDL replication setup script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to OGGADMIN
CLEAR_TRACE STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
CREATE_TRACE STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
TRACE_PUT_LINE STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
INITIAL_SETUP STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
DDLVERSIONSPECIFIC PACKAGE STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
DDLREPLICATION PACKAGE STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
DDLREPLICATION PACKAGE BODY STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
1453/9 PL/SQL: SQL Statement ignored
1455/28 PL/SQL: ORA-00942: table or view does not exist
1464/9 PL/SQL: SQL Statement ignored
1466/28 PL/SQL: ORA-00942: table or view does not exist
1478/9 PL/SQL: SQL Statement ignored
1480/28 PL/SQL: ORA-00942: table or view does not exist
1485/9 PL/SQL: SQL Statement ignored
1487/28 PL/SQL: ORA-00942: table or view does not exist
1492/9 PL/SQL: SQL Statement ignored
1494/28 PL/SQL: ORA-00942: table or view does not exist
1499/9 PL/SQL: SQL Statement ignored
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
1501/28 PL/SQL: ORA-00942: table or view does not exist
1581/4 PL/SQL: SQL Statement ignored
1582/23 PL/SQL: ORA-00942: table or view does not exist
1584/4 PL/SQL: SQL Statement ignored
1585/23 PL/SQL: ORA-00942: table or view does not exist
1600/30 PL/SQL: ORA-00942: table or view does not exist
1600/4 PL/SQL: SQL Statement ignored
1602/30 PL/SQL: ORA-00942: table or view does not exist
1602/4 PL/SQL: SQL Statement ignored
DDL IGNORE TABLE
-----------------------------------
FAILED: Table does not exist
DDL IGNORE LOG TABLE
-----------------------------------
FAILED: Table does not exist
DDLAUX PACKAGE STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
DDLAUX PACKAGE BODY STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/26 PLS-00304: cannot compile body of 'DDLAUX' without its
specification
1/26 PLS-00905: object OGGADMIN.DDLAUX is invalid
SYS.DDLCTXINFO PACKAGE STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
SYS.DDLCTXINFO PACKAGE BODY STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
DDL HISTORY TABLE
-----------------------------------
FAILED: Table does not exist
DDL HISTORY TABLE(1)
-----------------------------------
FAILED: Table does not exist
DDL DUMP TABLES
-----------------------------------
FAILED: Table does not exist
DDL DUMP COLUMNS
-----------------------------------
FAILED: Table does not exist
DDL DUMP LOG GROUPS
-----------------------------------
FAILED: Table does not exist
DDL DUMP PARTITIONS
-----------------------------------
FAILED: Table does not exist
DDL DUMP PRIMARY KEYS
-----------------------------------
FAILED: Table does not exist
DDL SEQUENCE
-----------------------------------
FAILED: Sequence does not exist
GGS_TEMP_COLS
-----------------------------------
FAILED: Table does not exist
GGS_TEMP_UK
-----------------------------------
FAILED: Table does not exist
DDL TRIGGER CODE STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
126/9 PL/SQL: SQL Statement ignored
128/28 PL/SQL: ORA-00942: table or view does not exist
133/26 PL/SQL: ORA-02289: sequence does not exist
133/5 PL/SQL: SQL Statement ignored
657/19 PLS-00905: object OGGADMIN.DDLAUX is invalid
657/5 PL/SQL: Statement ignored
919/30 PL/SQL: ORA-00942: table or view does not exist
919/4 PL/SQL: SQL Statement ignored
DDL TRIGGER INSTALL STATUS
-----------------------------------
OK
DDL TRIGGER RUNNING STATUS
------------------------------------------------------------------------------------------------------------------------
ENABLED
FROM "OGGADMIN" ."GGS_SETUP"
*
ERROR at line 2:
ORA-00942: table or view does not exist
FROM "OGGADMIN" ."GGS_SETUP"
*
ERROR at line 2:
ORA-00942: table or view does not exist
FROM "OGGADMIN" ."GGS_SETUP"
*
ERROR at line 2:
ORA-00942: table or view does not exist
LOCATION OF DDL TRACE FILE
------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/prod/PROD1/trace/ggs_ddl_trace.log
Analyzing installation status...
STATUS OF DDL REPLICATION
------------------------------------------------------------------------------------------------------------------------
ERRORS detected in installation of DDL Replication software components (6)
Script complete.
2.執行一次禁用DDL指令碼
@ddl_disable.sql
3. 檢視OGG使用者的角色，已經賦予了DBA角色
SYS@PROD1 > conn oggadmin/oggadmin
Connected.
OGGADMIN@PROD1 > select * from user_role_privs;
USERNAME GRANTED_ROLE ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
OGGADMIN CONNECT NO YES NO
OGGADMIN DBA NO YES NO
OGGADMIN RESOURCE NO YES NO
4.顯示新增許可權，雖然該使用者已經是DBA許可權了
SYS@PROD1 > grant create table,create sequence to oggadmin;
5.再次執行@ddl_setup.sql,順利透過
SYS@PROD1 > @ddl_setup.sql
Oracle GoldenGate DDL Replication setup script
Verifying that current user has privileges to install DDL Replication...
You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter Oracle GoldenGate schema name:oggadmin
Working, please wait ...
Spooling to file ddl_setup_spool.txt
Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...
Check complete.
Using OGGADMIN as a Oracle GoldenGate schema name.
Working, please wait ...
DDL replication setup script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to OGGADMIN
CLEAR_TRACE STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
CREATE_TRACE STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
TRACE_PUT_LINE STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
INITIAL_SETUP STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
DDLVERSIONSPECIFIC PACKAGE STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
DDLREPLICATION PACKAGE STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
DDLREPLICATION PACKAGE BODY STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
DDL IGNORE TABLE
-----------------------------------
OK
DDL IGNORE LOG TABLE
-----------------------------------
OK
DDLAUX PACKAGE STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
DDLAUX PACKAGE BODY STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
SYS.DDLCTXINFO PACKAGE STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
SYS.DDLCTXINFO PACKAGE BODY STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
DDL HISTORY TABLE
-----------------------------------
OK
DDL HISTORY TABLE(1)
-----------------------------------
OK
DDL DUMP TABLES
-----------------------------------
OK
DDL DUMP COLUMNS
-----------------------------------
OK
DDL DUMP LOG GROUPS
-----------------------------------
OK
DDL DUMP PARTITIONS
-----------------------------------
OK
DDL DUMP PRIMARY KEYS
-----------------------------------
OK
DDL SEQUENCE
-----------------------------------
OK
GGS_TEMP_COLS
-----------------------------------
OK
GGS_TEMP_UK
-----------------------------------
OK
DDL TRIGGER CODE STATUS:
Line/pos Error
---------------------------------------- -----------------------------------------------------------------
No errors No errors
DDL TRIGGER INSTALL STATUS
-----------------------------------
OK
DDL TRIGGER RUNNING STATUS
------------------------------------------------------------------------------------------------------------------------
ENABLED
STAYMETADATA IN TRIGGER
------------------------------------------------------------------------------------------------------------------------
OFF
DDL TRIGGER SQL TRACING
------------------------------------------------------------------------------------------------------------------------
0
DDL TRIGGER TRACE LEVEL
------------------------------------------------------------------------------------------------------------------------
0
LOCATION OF DDL TRACE FILE
------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/prod/PROD1/trace/ggs_ddl_trace.log
Analyzing installation status...
STATUS OF DDL REPLICATION
------------------------------------------------------------------------------------------------------------------------
SUCCESSFUL installation of DDL Replication software components
Script complete.
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29047826/viewspace-1342395/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- streamlit run執行報錯，Invalid value: File does not exist: XXX.py
- SAP MM 對採購訂單執行收貨，報錯 - Table T169P entry ZNMI does not exist -
- [BUG反饋]子查詢報錯，Base table or view not found: 1146 Table 'onethink.(' doesn't existView
- yii2接入pgSQL(查詢不到表The table does not exist: {{%user}})SQL
- ABAP 資料結構啟用時的錯誤訊息 - combination reference table field does not exist資料結構
- pgsql 執行建庫指令碼時候出現ERROR: relation "xxx_id_seq" does not existSQL指令碼Error
- Hadoop的mapreduce出現問題，報錯The auxService:mapreduce_shuffle does not existHadoopUX
- SAP對工單做101收貨，報錯- Check table TFBEFU_CR entry 10 does not exist–對策
- The operation, ‘DecodeJpeg/contents‘, does not exist in the graph.錯誤解決方法
- Waring: /dev/centos/swap does not existdevCentOS
- Property [title] does not exist on this collection instance
- PSQLexception: ERROR ： type "signed" does not existSQLExceptionError
- MySQL 5.6執行DDL報錯ERROR 1050 (42S01): Table 'sms/#sql-ib752' already existMySqlError
- 易優CMS【錯誤程式碼】 SQLSTATE【42S02】：Base table or view not found：1146 Table‘111.ey_admin_theme‘doesn‘t exist-eyoucmsSQLView
- Property 'context' does not exist on type 'NodeRequire'.ts(2339)ContextUI
- Laravel Class env does not exist 問題排查Laravel
- Eclipse裡Tomcat報錯：Document base ……does not exist or is not a readable directory（圖文詳解）...EclipseTomcat
- 安裝kernel...src.rpm錯誤：warning: user mockbuild does not exist - using rootMockUI
- Flutter開發-iOS報錯Trying to embed a platform view but the PrerollContext does not sFlutteriOSPlatformViewContext
- ORA-04043: object DBA_DATA_FILES does not existObject
- [20211231]ORA-01418 specified index does not exist.txtIndex
- PbootCMS 執行SQL發生錯誤!錯誤: no such table:ay_configbootSQL
- dcat-admin 表單 Field type [autocomplete] does not exist.
- SAP Table function 執行報錯 feature not supported 該如何分析Function
- ORA-30012 undo tablespace 'UNDOTBS3' does not exist or of wrong typeS3
- mac scrcpy 報錯 does not exist or is not a regular file，ERROR: Server connection failed（scrcpy mac與極空間衝突）MacErrorServerAI
- Android解決The APK file app-debug.apk does not exist on disk.AndroidAPKAPP
- View Animation 執行原理解析View
- 靜默安裝Oracle建庫時報Template General Purpose does not existOracle
- Error: The directory named as part of the path ./log/supervisord.log does not exist解決方案Error
- windows（10）執行laravel new blog出錯WindowsLaravel
- SAP Data Intelligence API執行出錯的排錯之道IntelAPI
- 《mModel does not exists !? 》Laravel-admin 控制器建立出錯Laravel
- 原程式執行良好，Pyinstaller封裝後執行出錯 的分析封裝
- git中出現”the requested upstream branch ‘origin/master‘ does not exist“問題的解決GitAST
- 整潔的 Table View 程式碼View
- Oracle GoldenGate 18.1釋出OracleGo
- mysql執行函式出現1418錯誤MySql函式
- Laravel 執行 Gulp 命令出錯解決辦法Laravel