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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【ERROR】OPatch failed with error code 73ErrorAI
- Failed to connect to raw.githubusercontent.com port 443AIGithub
- OPatch failed with error code 73AIError
- Fatal NI connect error 12170 錯誤Error
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- Oracle dataguard報錯:Error 1017 received logging on to the standbyOracleError
- 主庫到standby報錯解決:Error 12154 received logging on to the standby ORA-12154Error
- 虛擬機器之間能夠ping通,但是建立tcp連線時卻顯示Failed in connect to TCP server: No route to host虛擬機TCPAIServer
- 解決 Android studio Connect to 127.0.0.1:[/127.0.0.1] failed: Connection refusedAndroid127.0.0.1AI
- Failed to connect to ESP8266: Timed out waiting for packet headerAIHeader
- pod update -- Failed to connect to GitHub to update the CocoaPods/Specs specs repoAIGithub
- 【AndroidStudio】Error:Execution failed for task ':app:preDebugAndroidTestBuild'.AndroidErrorAIAPPUI
- Error: Connection activation failed: Device not managed by NetworkManagerErrorAIdev
- 解決方案 | MiKTex SSL connect error code 35Error
- 執行flutter run命令報錯::ERROR: Could not connect to lockdownd, error code -17FlutterError
- FATAL - Fatal error: Target Interaction Manager failed at StartupErrorAI
- ERROR: Failed to resolve: org.greenrobot:eventbus:2.4.0ErrorAI
- weblogic報錯: OPatch failed with error code 73WebAIError
- git error: RPC failed; HTTP 500 curl 22 The requested URL returned error: 500GitErrorRPCAIHTTP
- Error:Can't connect to SOCKS proxy:Connection refused (Connection refused)Error
- 【Linux】curl: (35) SSL connect error問題處理LinuxError
- 解決 yum clean all Error rpmdb open failedErrorAI
- PSQLException: ERROR: failed to find conversion function from unknown to charSQLExceptionErrorAIFunction
- SSL錯誤ssl connect error 35的解決方案Error
- 邏輯STANDBY上的ORA-00600: internal error code, arguments: [krvtadc], [], [], [], [], []Error
- error in ./src/components/form/Editor.vue Module build failed: Error:Vue packages version mismatchErrorORMVueUIAIPackage
- python爬蟲--urllib.error.URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certiPython爬蟲ErrorAI
- ascp: Failed to open TCP connection for SSH, exiting. Session Stop (Error: Failed to open TCP connection for SSH)AITCPSessionError
- ERROR:Failed to load resource: net::ERR_INCOMPLETE_CHUNKED_ENCODINGErrorAIEncoding
- Error: pngquant failed to build, make sure that libpng-dev is installedErrorAIUIdev
- ERROR: failed to establish dependency between database db_name and diskgroupErrorAIDatabase
- Error - RtlWerpReportException failed with status code :-1073741823. Will try to launch the processErrorExceptionAI
- ElasticSearch啟動報錯 ERROR: [4] bootstrap checks failedElasticsearchErrorbootAI
- Oracle 12C RAC的單機Standby returning error ORA-16191OracleError
- ORA-00257:archiver error. Connect internal only,until freed.HiveError
- lua 中連結 Redis 使用域名報錯 failed to connect: no resolver defined to resolveRedisAI
- unable to access ‘https://gitee.com/XXX/XXX.git/‘: Failed to connect to 127.0.0.1 portHTTPGiteeAI127.0.0.1
- yum install zlib-devel失敗:Failed connect to mirrorlist.centos.org:80devAICentOS