单机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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/81227/viewspace-702270/