ORA-16796

显示全部楼层 · 2011-11-1 16:26:29

系统rhel5.4 64位数据库版本：10.2.0.1 64位 DG环境是：最高可用模式
故障：
在配置broker的时候出现ORA-16796错误
DGMGRL> create configuration 'zzh' as primary database is 'db1a' connect identifier is dba1;
Configuration "zzh" created with primary database "db1a"
DGMGRL> add database 'db1b' as connect identifier is db1b maintained as physical;
Error: ORA-16796: one or more properties could not be imported from the database
Failed.

按照官方的解决办法还是不行，求各位大侠指点！

千问 · 2011-11-1 16:26:29

那位仁兄帮帮忙吧！搞了一天了，还是不能解决啊

千问 · 2011-11-1 16:26:29

这个我要好好的学习一下！

千问 · 2011-11-1 16:26:29

16796, 0000, "one or more properties could not be imported from the database"
// *Cause:The broker was unable to import property values for the database
//
being added to the broker configuration. This error indicates:
//
- The Oracle Net service name specified in DGMGRL CREATE
//
CONFIGURATION or ADD DATABASE command was not one that provides
//
access to the database being added.
//
- There were no instances running for the database being added.
// *Action: Remove the database from the configuration using the REMOVE
//
CONFIGURATION or REMOVE DATABASE command. Make sure that the
//
database to be added has at least one instance running and that the
//
Oracle Net service name provides access to the running instance.
//
Also check the broker log file for additional information.
//
Then, reissue the CREATE CONFIGURATION or ADD DATABASE command.

千问 · 2011-11-1 16:26:29

谢谢提供的信息！试了还是不行，到了这步就报错：DGMGRL> add database db1b as connect identifier is db1b maintained as physical;
Error: ORA-16796: one or more properties could not be imported from the database
Error: ORA-16554: translation not valid
怀疑是listener或者tnsnames没有配好，我把相关配置信息贴出来，帮忙看看！
主库：db_unique_name db1a
local_listener
DG1
listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = db1)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(GLOBAL_DBNAME = db1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
tnsnames.ora
DG2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db1)
)
)
DG1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db1)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

备库：db_unique_name db1b
local_listener
DG2
listenre.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = db1)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(GLOBAL_DBNAME = db1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

tnsnames.ora
DG2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db1)
)
)
DG1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db1)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

千问 · 2011-11-1 16:26:29

dg工作状态都正常，备份能正常接收日志