我创建的是物理standby数据库,现在监听怎么弄都不对。
主数据库名字是orcl。standby数据库的名字是test
本机IP:192.168.1.100.
谁能帮我把Listener。ora和TNSNAMES.ora写出来啊?万分的感谢,各位大侠帮忙。毕业论文要用,谢谢啦!
主数据库名字是orcl。standby数据库的名字是test
本机IP:192.168.1.100.
谁能帮我把Listener。ora和TNSNAMES.ora写出来啊?万分的感谢,各位大侠帮忙。毕业论文要用,谢谢啦!
listener:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
)
)DBSTANDBY1=
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = D:\oracle\product\10.2.0\)
(PROGRAM = extproc)
)
)
DBSTANDBY_LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
DBSTANDBY=
(SID_LIST =
(SID_DESC =
(SID_NAME = TEST)
(ORACLE_HOME = D:\oracle\product\10.2.0\)
(PROGRAM = extproc)
)
)
DBSTANDBY_LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
tnsnames:
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
DBPRIMARY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =orcl)
)
DBSTANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)但是链接auxiliary数据库的时候一只出现:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
请大家帮忙啊,有一个月没动数据库,不知道监听器怎么写了。
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges没有权限?你用什么用户连接RMAN 的? 监听现在看不出什么问题...
是出现这些问题,说是什么内部错误:C:\Users\Damien>rman target/恢复管理器: Release 10.2.0.3.0 - Production on 星期六 5月 8 07:57:26 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.连接到目标数据库: ORCL (DBID=1245422574)RMAN> connect auxiliary sys/oracle@dbstandby
RMAN> connect auxiliary sys/oracle@dbstandby
rman-04006:来自父主数据库的错误
rman-12154:无法解析指定的链接目标
建议用net manager 工具来配监听。 tnsnames.ora 文件比较敏感,手动来修改这个文件容易出错。比如多个一个空格,找起来是非常的麻烦。 net manager 工具有界面,配起来也很方便。 Oracle 数据库监听配置
http://blog.csdn.net/tianlesoftware/archive/2009/11/25/4861572.aspx
关于逻辑standby,物理standby 的配置,Rman 克隆,我的blog 里都有相关笔记,你也可以参考一下.
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977