ora-12154:could not resolve the connect identifier specified

答案:2 悬赏:70 手机版

解决时间 2021-04-10 01:58

提问者网友：像風在裏
2021-04-09 04:42

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product

\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=134.242.24.94)(PORT=1521))
)
)

ADR_BASE_LISTENER = D:\app\Administrator

最佳答案

五星知识达人网友：渊鱼
2021-04-09 04:55

你用哪个SID连接的

全部回答

1楼网友：爱难随人意
2021-04-09 06:29

在2，tnsnames.ora文件中也把lister加进来, 你要在服务器上用 sqlplus owner/password@服务名能登录上才可以连接的. 2，tnsnames.ora文件： # tnsnames.ora network configuration file: e:\app\h00726092\product\11.2.0\client_1\network\admin\tnsnames.ora # generated by oracle configuration tools. listener = (description_list = (description = (address = (protocol = tcp)(host = prm1)(port = 1521)) ) ) sid_list_listener = (sid_list = (sid_desc = (global_dbname = ora11g) (oracle_home = /oracle/app/product/11g/db) (sid_name = ora11g) ) ) ora11g = (description = (address_list = (address = (protocol = tcp)(host = 192.168.237.220)(port = 1521)) ) (connect_data = (service_name = ora11g) ) )

我要举报

如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！