單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(8)
單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(1):http://space.itpub.net/81227/viewspace-701181
單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(2):http://space.itpub.net/81227/viewspace-701198
單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(3):http://space.itpub.net/81227/viewspace-701231
單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(4):http://space.itpub.net/81227/viewspace-701293
單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(5):http://space.itpub.net/81227/viewspace-702254
單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(6):http://space.itpub.net/81227/viewspace-702263
單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(7):http://space.itpub.net/81227/viewspace-702264
安裝過程中遇到的問題:ORA-12547: TNS:lost contact
$ export ORACLE_SID=stby
$ sqlplus /nolog
SQL> Conn / as sysdba
ERROR:
ORA-12547: TNS:lost contact
原因為standby庫還未啟動,在Listener中還未註冊,解決辦法是採用靜態註冊,在listen.ora檔案中加入以下程式碼:
SID_LIST_LISTENER =
(SID_LIST =
……
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = …/oracle/product/10.2.0/db_1)
(SID_NAME = stby)
)
)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/81227/viewspace-702270/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【DG】在Linux平臺上搭建單例項的dataguard--duplicateLinux單例
- 【DG】在Linux平臺上搭建單例項的dataguard--rman還原方式Linux單例
- 搭建windows到linux的oracle 12c physical standby備庫WindowsLinuxOracle
- Oracle DG建立Physical Standby DatabaseOracleDatabase
- 【DG】Data Guard搭建(physical standby)
- Oracle 11.2.0.4 physical dataguard和snapshot dataguard切換Oracle
- dataguard 搭建 oracle_sid相同 2節點 primary+standbyOracle
- dataguard 搭建 oracle_sid不同 2節點 primary+standbyOracle
- Oracle 單機配置DataGuardOracle
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- Oracle 12.2 physical standby備庫收集AWR報告Oracle
- 單例項Primary快速搭建Standby RAC參考手冊(19.16 ADG)單例
- Oracle dataguard報錯:Error 1017 received logging on to the standbyOracleError
- oracle資料庫跨平臺(AIX)從RAC恢復至(linux)下的單例項Oracle資料庫AILinux單例
- Performing a Failover to a Physical Standby DatabaseORMAIDatabase
- Oracle 19C CBD Active DataGuard Standby passwd file 注意事項 ORA-01017Oracle
- ORACLE-LINUX環境字元介面單例項安裝OracleLinux字元單例
- Oracle 11.2 DataGuard RAC To RAC搭建Oracle
- 搭建ELK日誌平臺(單機)
- 【DG】Oracle11g異構平臺之Linux To Windows DataGuard安裝配置--duplicateOracleLinuxWindows
- 搭建自己的直播平臺,實現exe單例模式單例模式
- Linux平臺Oracle開機自啟動設定LinuxOracle
- oracle之 單例項監聽修改埠Oracle單例
- linux監控平臺搭建Linux
- DATAGUARD手記(PRIMARY+2STANDBY)(一)
- DATAGUARD手記(PRIMARY+2STANDBY)(二)
- oracle 10g在linux下的安裝及簡單命令Oracle 10gLinux
- Oracle Physical Database LimitsOracleDatabaseMIT
- 跨平臺級聯dataguard配置
- Physical Standby Switchover_status Showing Not Allowed. (Doc ID 1392763.1)
- 【DATAGUARD】Oracle21c Dataguard建立注意事項及主要引數介紹Oracle
- Oracle 12C RAC的單機Standby returning error ORA-16191OracleError
- 從nub備份恢復(同平臺)恢復RAC至單例項單例
- Oracle 11g RAC到單例項OGG同步Oracle單例
- 【Dataguard】DataGuard運維注意事項運維
- 4.1. Oracle例項Oracle
- Oracle Far Sync例項Oracle
- DataGuard---->物理StandBy的角色切換之switchover
- standby_file_management為manual造成dataguard延遲