大家好,
我现在机器上装了两个数据库,Orcl1,和Orcl2,在数据库机器上我通过pl sqldevelop能连上这两个数据库,但是我在另一台客户机上,我只能连上一个数据库Orcl1,当连orcl2时,出现
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
上述错误,下面是我数据库服务器监听器,和我本机tns配置,请帮一下,我在客户端用tnsping ORCLXSSF_10.22.1.93 可以ping通的,就是连不上。数据库服务器监听器配置:
# LISTENER.ORA Network Configuration File: D:\oracle\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = urpdb)
(ORACLE_HOME = D:\oracle)
(SID_NAME = urpdb)
)
(SID_DESC =
(GLOBAL_DBNAME = orclxssf)
(ORACLE_HOME = D:\oracle)
(SID_NAME = orclxssf)
)
)
客户端机器tns:ORCLXSSF_10.22.1.93 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.22.1.93)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclxssf)
)
)
我现在机器上装了两个数据库,Orcl1,和Orcl2,在数据库机器上我通过pl sqldevelop能连上这两个数据库,但是我在另一台客户机上,我只能连上一个数据库Orcl1,当连orcl2时,出现
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
上述错误,下面是我数据库服务器监听器,和我本机tns配置,请帮一下,我在客户端用tnsping ORCLXSSF_10.22.1.93 可以ping通的,就是连不上。数据库服务器监听器配置:
# LISTENER.ORA Network Configuration File: D:\oracle\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = urpdb)
(ORACLE_HOME = D:\oracle)
(SID_NAME = urpdb)
)
(SID_DESC =
(GLOBAL_DBNAME = orclxssf)
(ORACLE_HOME = D:\oracle)
(SID_NAME = orclxssf)
)
)
客户端机器tns:ORCLXSSF_10.22.1.93 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.22.1.93)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclxssf)
)
)
urpdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.22.1.93)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = urpdb)
)
)
你好,客户端这个urpdb tnsname我是加过了,我也可以连上这个的,但就是我上面加的 ORCLXSSF_10.22.1.93 不能连上服务器,不知为什么?
orclxssf =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.22.1.93)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclxssf)
)
)
user/passwd@orclxssf
user/passwd@urpdb
orclxssf =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.22.1.93)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclxssf)
)
)
我已经在客户端加上了,但还是不行的
登录的时候要加上连接字符串比如
user/passwd@orclxssf
user/passwd@urpdb
============================================================================================
lsnrctl status 命令查看一下监听状态,是不是同一个listener 监听了两个数据库服务