OGG-01453 Database login information not specified in parameter file
今天OGG投遞程式(datapump)中斷,報錯資訊讓我有些費解:Database login information not specified in parameter file。 按說投遞程式是不需要OGG的使用者名稱和密碼的,可這個提示卻指出需要!仔細找了些資料,發現是因為抽取程式extract中的OGG使用者密碼做過加密設定,再這種情況下投遞程式也需要在引數檔案中新增使用者和密碼才行。做法很簡單,如下所示:
1. 報錯資訊
2015-08-11 13:31:42 ERROR OGG-01453 Oracle GoldenGate Capture for Oracle, dp2.prm: Database login information not specified in parameter file.
2015-08-11 13:31:42 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, dp2.prm: PROCESS ABENDING.
2. 抽取程式引數檔案
EXTRACT ext2
setenv (NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
userid oggtt@RAC,password AACAAAAAAAAAAAHAKELIBDTGCEUGCELJ,encryptkey default
GETTRUNCATES
REPORTCOUNT EVERY 1 MINUTES, RATE
numfiles 5000
DISCARDFILE ./dirrpt/ext2sym.dsc,APPEND,MEGABYTES 1024
DISCARDROLLOVER AT 3:00
WARNLONGTRANS 2h,CHECKINTERVAL 3m
DBOPTIONS ALLOWUNUSEDCOLUMN
EXTTRAIL ./dirdat/n2,MEGABYTES 500
DYNAMICRESOLUTION
TRANLOGOPTIONS EXCLUDEUSER oggtt
TRANLOGOPTIONS CONVERTUCS2CLOBS
TRANLOGOPTIONS altarchivelogdest primary instance ORASYM1 /u03/Archive/ORASYM/, altarchivelogdest instance ORASYM2 /u03/Archive/ORASYM/
table symbols.FM_PARAMETER, colsexcept(report_info);
3. 在投遞程式引數引數檔案中新增同樣的使用者密碼
EXTRACT dp2
userid oggtt@RAC,password AACAAAAAAAAAAAHAKELIBDTGCEUGCELJ,encryptkey default
RMTHOST 10.13.54.6, MGRPORT 7809, compress
Numfiles 5000
RMTTRAIL ./dirdat/r2
DYNAMICRESOLUTION
table symbols.FM_PARAMETER, colsexcept(report_info);
4. 重啟投遞程式故障消除
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29047826/viewspace-1768184/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- No input file specified.
- What Is a Server Parameter File?Server
- Exporting the Server Parameter FileExportServer
- Errors and Recovery for the Server Parameter FileErrorServer
- No input file specified 解決方法
- Migrating to a Server Parameter FileServer
- 頁面報錯 No input file specified
- java.sql.SQLException: No value specified for parameter 1 異常分析JavaSQLException
- Step 3: Create the Initialization Parameter File (61)
- no input file specified 三種解決方法
- 使用phpstudy出現No input file specifiedPHP
- a control file contains informationAIORM
- reduce the database log fileDatabase
- 專案遷移 寶塔 No input file specified
- Web 伺服器顯示 no input file specifiedWeb伺服器
- 使用url()後出現No input file specified.
- Step 5: Create a Server Parameter File (Recommended) (63)Server
- 記:痛苦的排錯之” No input file specified.“
- Script to Collect Log File Sync Diagnostic Information (lfsdiag.sql)ORMSQL
- Script toCollect Log File Sync Diagnostic Information (lfsdiag.sql)ORMSQL
- SQL SERVER – Attach mdf file without ldf file in DatabaseSQLServerDatabase
- ORA-32004: obsolete and/or deprecated parameter(s) specified ORACLE instance staOracle
- ORA-32004: obsolete and/or deprecated parameter(s) specified ORACLE instance startedOracle
- 2.2. 第一個應用,遇到 no input file specified
- No input file specified 出現的原因及解決方法
- Information On Installed Database Components and Schemas (Doc ID 472937.1)ORMDatabase
- Information On Installed Database Components and Schemas (文件 ID 472937.1)ORMDatabase
- opatch報錯:The oraInst.loc file specified is not validAI
- Specifying the Database Time Zone File (81)Database
- Certification Information for Oracle Database on Linux x86-64 [ID 1304727.1]ORMOracleDatabaseLinux
- RMAN-05517: temporary file conflicts with file used by target database(zt)Database
- Unload data to a flat file from Oracle databaseOracleDatabase
- Nginx執行php,顯示“No input file specified. ”的處理方法NginxPHP
- Android Studio Gradle編譯報input jar file is specified twiceAndroidGradle編譯JAR
- ORA-29707: inconsistent value 2 for initialization parameter cluster_database_Database
- Oracle Database 11gR2引入的DBFS(Database File System)OracleDatabase
- 已解決 phpstudy切換nts模式出現的No input file specifiedPHP模式
- 網站執行PHP出現No input file specified 的解決辦法網站PHP