PING[ARC5]: Heartbeat failed to connect to standby 'dghq'. Error is 12154.
在dataguard搭建之後,主庫報錯:
Tue Jul 31 15:57:11 2018 Error 12154 received logging on to the standby PING[ARC5]: Heartbeat failed to connect to standby 'dghq'. Error is 12154.
tnsping dghq是ok的。
檢查lns程式不存在
SQL> select process, status, thread#,sequence#, block#, blocks from v$managed_standby; PROCESS STATUS THREAD#SEQUENCE# BLOCK# BLOCKS ------------------ ------------------------ ---------- ---------- ---------- ---------- ARCH CONNECTED 00 0 0 ARCH CLOSING 1 154096 666 ARCH CONNECTED 00 0 0 ARCH CLOSING 1 17 1 400 ARCH CLOSING 1 17 1 400 ARCH CLOSING 1 14 1 24896 ARCH CONNECTED 00 0 0 ARCH CONNECTED 00 0 0 ARCH CONNECTED 00 0 0 ARCH CONNECTED 00 0 0 最後我修改了/etc/hosts後問題解決了--前兩行內容註釋掉,最後把備庫的ip和別名也寫到檔案裡,重啟os。 [oracle@oraclerac1 ~]$ more /etc/hosts #127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 #::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.10.180 oraclerac1 192.168.10.181 oraclerac2
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20893244/viewspace-2168769/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- PING[ARC2]: Heartbeat failed to connect to standby 'xyxdbs'. Error is 1605AIError
- PING[ARC2]: Heartbeat failed to connect to standby 'DG'. Error is 12541AIError
- PING[ARC2]: Heartbeat failed to connect to standby 'jzhddg'. Error is 16032.AIError
- 一天兩次,PING[ARC1]: Heartbeat failed to connect to standbyAI
- Oracle ADG Heartbeat failed to connect to standby故障案例OracleAI
- Ping:Transmit Failed, Error Code 65問題解決MITAIError
- 【ERROR】OPatch failed with error code 73ErrorAI
- 主庫報 Error 12154 received logging on to the standby PING[ARC2]Error
- [ERROR] Failed to open logErrorAI
- OPatch failed with error code 73AIError
- 【遠端除錯】Failed to connect to remote VM除錯AIREM
- [ CSSCLNT][1]clsssInitNative: connect failed, rc 9CSSAI
- Fatal NI connect error 12170Error
- Error: failed PB timebomb checkErrorAI
- Starting HEARTBEAT with WARNING: string2msg_ll: node [... ] failed authenticationAI
- Xtrabackup備份報錯Failed to connect to MySQL serverAIMySqlServer
- Fatal NI connect error 12170.Error
- 虛擬機器之間能夠ping通,但是建立tcp連線時卻顯示Failed in connect to TCP server: No route to host虛擬機TCPAIServer
- maridb Error 'Operation DROP USER failed forErrorAI
- Opiino: Attach Failed! Error=-1 Ifvp=0AIError
- Failed to connect to raw.githubusercontent.com port 443AIGithub
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- Fatal NI connect error 12170 錯誤Error
- FATAL - Fatal error: Target Interaction Manager failed at StartupErrorAI
- Android 3.0 DELETE_FAILED_INTERNAL_ERRORAndroiddeleteAIError
- pod update -- Failed to connect to GitHub to update the CocoaPods/Specs specs repoAIGithub
- ubuntu gedit出錯:Failed to connect to the session manager的問題UbuntuAISession
- 執行flutter run命令報錯::ERROR: Could not connect to lockdownd, error code -17FlutterError
- Error: Connection activation failed: Device not managed by NetworkManagerErrorAIdev
- ERROR: Failed to resolve: org.greenrobot:eventbus:2.4.0ErrorAI
- weblogic報錯: OPatch failed with error code 73WebAIError
- OPatch failed with error code 73(OracleHomeInventory gets null oracleHomeInfo)AIErrorOracleNull
- LOGIN:ERROR-Failed to initialize policy manager(轉)ErrorAI
- "OPatch failed with error code 73"故障一例AIError
- [筆記].痛哉!!!Error: Can't access JTAG chain, Error: Operation failed筆記ErrorAI
- git error: RPC failed; HTTP 500 curl 22 The requested URL returned error: 500GitErrorRPCAIHTTP
- AS編譯不通過,提示Error:Connection refused: connect編譯Error
- ORA-00257: archiver error. Connect internal onlyHiveError