各位好!~
我在搭DG,一共两台机器,一台是主库,一台是备库,我想在备库那台在建一个备库,但是监听程序不知道怎么创建,总是报错,ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
监听如下:
# listener.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
LISTENER1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.153.33)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = DGX)
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(SID_NAME = DGX)
)
)
SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = LDG)
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(SID_NAME = LDG)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.153.33)(PORT = 1521))
)
DGX为第一个备库,LDG为第二个,当我CONN SYS/VERYSAFE@LDG AS SYSDBA的时候就报错误(ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务)
TNSNAMES.ORA如下:
LDG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.153.33)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = LDG)
)
DGX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.153.33)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DGX)
)
)
请各位帮帮忙啊,我怎么样才能配置成功啊,怎么样CONN SYS/VERYSAFE@LDG AS SYSDBA能连上啊
|