plsql链接Oracle登陆时报:
ora-12504:tns 监听程序在connect_data中未获得service _name
我是下载的instantclient_11_2 没安装Oracle,查百度需要配置listener.ora文件里
(ORACLE_HOME = e:\oracle\product\10.2.0\db_1);但我我没有路径,难道用instantclient_11_2还需要安装一个Oracle吗?
listener.ora文件在.....\instantclient_11_2\NETWORK\ADMIN\listener.ora 配置内容如下
# listener.ora Network Configuration File: e:\oracle\product\10.2.0\db_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = F:\oracle\product\10.2.0\db_1) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = oracle) (ORACLE_HOME = e:\oracle\product\10.2.0\db_1) (SID_NAME = oracle) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) )