Extract or Replicat Fail to Start (Don't Start) With No Error Messages
Extract or Replicat Fail to Start (Don't Start) With No Error Messages [ID 1338582.1]
修改時間:2011-7-22型別:PROBLEM狀態:PUBLISHED優先順序:3
In this Document
Applies to:
Oracle GoldenGate - Version: 11.1.1.1.16 and later [Release: 11.1.1 and later ]Information in this document applies to any platform.
Symptoms
Extract or Replicat cannot start and there is eitherno report file or the report file does not contain diagnostic/error messages and ends abruptly
or there is no relevant message in GoldenGate error log (ggserr.log).
How to proceed in such cases ?
How to proceed in such cases ?
Cause
Many factors can cause extract or replicat in being not able to display error messages in the normal way, that is writing them down in the report file or the GoldenGate error log.These factors are potential reasons for such failures:
1) system resource issues, such as disk full.
2) access/security issues such as not able to access certain directories like dirrpt, dirchk etc.
3) abnormal process condition where an existing component is stopped by GGSCI but remains running or GoldenGate system files, such as those in dirpcs, dirchk files are not properly cleaned up. Subsequent starts fail because the new process conflicts with the old process.
4) GoldenGate system files are corrupted.
Solution
Run extract or replicat from the Unix or Windows shell, such as the example shown:> replicat paramfile dirprm/myrep.prm
The process will run and display all relevant information on the screen. The significant display can be found at the end. These diagnostics that cannot be found in the report file will be displayed on the screen.
An example of a replicat having an issue with one of its GoldenGate system files is shown below:
ggsadm@spy3db:/users/ggsadm/ggs$ ./replicat paramfile dirprm/rep2.prm
Source Context :
SourceModule : [ggapp.util.pcs]
SourceID : ......
.....................
2011-07-14 05:03:50 ERROR OGG-01454 Unable to lock file "/users/ggsadm/ggs/dirpcs/REP2.pcr" (error 11, Resource temporarily unavailable). Lock currently held by process id (PID) 2731.
2011-07-14 05:03:50 ERROR OGG-01668 PROCESS ABENDING.
Source Context :
SourceModule : [ggapp.util.pcs]
SourceID : ......
.....................
2011-07-14 05:03:50 ERROR OGG-01454 Unable to lock file "/users/ggsadm/ggs/dirpcs/REP2.pcr" (error 11, Resource temporarily unavailable). Lock currently held by process id (PID) 2731.
2011-07-14 05:03:50 ERROR OGG-01668 PROCESS ABENDING.
In the above example, rep2.pcr already exist and an orphan process is still running. These diagnostics can now be seen and action taken (kill the orphan process id).
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/23135684/viewspace-748794/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- LSNRCTL start error!Error
- MySQL 5.5 原始碼安裝報錯"[ERROR] Can't start server"MySql原始碼ErrorServer
- Oracle dbconsole can't startOracle
- mysql can't start dues to the disk space is fullMySql
- why app_start startAPP
- Troubleshooting when srvctl can't start RAC instance, but sqlplus can start it [ID 844272.1]SQL
- listener start fail TNS-12555 利用trace找到問題AI
- 強制關閉extract和replicat程式
- android studio Error:Unable to start the daemon process【轉】AndroidError
- OGG 中replicat 和extract 關係圖
- A New Start
- the new start
- MySQL不能啟動 Can't start server : Bind on unix sockeMySqlServer
- fast_start_parallel_rollback與v$fast_start_servers和v$fast_start_transactionsASTParallelServer
- crsctl start/stop crs and crsctl start/stop cluster 區別
- 【HBase】start master 與 start master --backup 的區別AST
- start with ... connect by
- Fast-StartAST
- start uniappAPP
- PostgreSQL DBA(117) - pgAdmin(Don't do this: Don't use serial)SQL
- MediaRecorder start failed -19 java.lang.RuntimeException: start failedAIJavaException
- OGG EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAIL SIZEAI
- PostgreSQL DBA(113) - pgAdmin(Don't do this:Don't use char(n))SQL
- PostgreSQL DBA(109) - pgAdmin(Don't do this:Don't use BETWEEN)SQL
- rac中 crsctl start/stop crs and crsctl start/stop cluster 區別
- start with connect by prior
- start with connect by 用法
- New start new hope!
- 【青春】farewell and new start
- linux start oracleLinuxOracle
- 開始 - Get Start
- Oracle Start with ....Connect ByOracle
- START WITH...CONNECT BY
- Fatalerror:session_start()ErrorSession
- ERROR namenode.NameNode: Failed to start namenode. java.lang.IllegalArgumentErrorAIJava
- PostgreSQL DBA(108) - pgAdmin(Don't do this:Don't use upper names)SQL
- ERROR: Could not delete DB checkpoint for REPLICATErrordelete
- PostgreSQL DBA(115) - pgAdmin(Don't do this:Don't use varchar(n) by default)SQL