背景:
一个单机数据库升级为rac,由于该库主要是通过dblink来查询,所以连到该库的dblink都想设置为负载均衡和failover.
-- Create database link
create public database link TO_INCRE
connect to SENDAPP
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.10.0.1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.10.0.2)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER = YES)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME =test)
(FAILOVER_MODE =
(TYPE = select)
(METHOD = basic)
(RETRIES = 10)
)
)
)';
问题描述:
1.alter.log中报错:
ORA-12012: error on auto execute of job 121
ORA-04052: error occurred when looking up remote object SENDDATA.ELEPOLICY@TO_INCRE
ORA-00604: error occurred at recursive SQL level 2
ORA-12545: Connect failed because target host or object does not exis