njliuqi
2010-12-30 10:20 阅读 255

ORACLE data guard 配置调试问题

oracle Data guard 都安装好了,启动顺序是
先启动备库
SQL> startup nomount;

SQL>alter database mount standby database ;

[color=blue]SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
ERROR at line 1:
ORA-16136: Managed Standby Recovery not active

出错后打开备库 alert_primarydb.log
Errors in file /u01/oracle/admin/primarydb/bdump/primarydb_arc1_9794.trc:
ORA-12541: TNS:no listener
PING[ARC1]: Heartbeat failed to connect to standby '172.16.41.162'. Error is 12541.[/color]
【说明】
[primary database]
IP:172.16.41.162
ORACLE_SID=primarydb
DB_UNIQUE_NAME=primarydb

[physical standby database]
IP:172.16.41.238
ORACLE_SID=primarydb
DB_UNIQUE_NANEM=primarydb

我是从主库中拷贝listener.ora 和tnsnames.ora文件到备库中的。
内容如下
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = primarydb)
(GLOBAL_DBNAME = primarydb)
(ORACLE_HOME = /u01/oracle)
)
)

LISTENER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)(Host = 172.16.41.162)(PORT = 1521))
)
)

Generated by Oracle configuration tools.

PRIMARYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.41.162)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = primarydb)
)
)

STANDBYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.41.238)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = primarydb)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

请达人们指教一下,这个是什么错啊。

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

2条回答 默认 最新

  • 已采纳
    enet_java enet_java 2010-12-31 09:56

    看这个异常及oracle编码确实是因为oracle监听没有起来,最好是先确认一下。

    运行监听 lsnrctl 查看状态status 启动tnslsnr start

    点赞 评论 复制链接分享
  • enet_java enet_java 2010-12-30 11:07

    [quote]ORA-12541: TNS:no listener [/quote] 是不是因为服务端监听没有起来呀。
    确认oracle服务端启动了吗?

    点赞 评论 复制链接分享

相关推荐