客户端 系统是windows 2008 64位 我安装了 64位 11G 客户端
把 服务器那边给的 字符串
aaa =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = bbb)
)
)
粘到 我本地 tnsnames.ora文件中
tnsping ip:1521/bbb tnsping aaa 都显示 OK提示 成功
sqlplus 用户名/密码@ip:1521/bbb 失败
然后我用 Net Manager 测试连接 用户名和密码是用的 他们给的 也失败
oracle客户端 远程连接 连接失败 "监听程序当前无法识别连接描述符中请求的服务"
答案:2 悬赏:70
解决时间 2021-04-18 05:37
- 提问者网友:离殇似水流年飞逝
- 2021-04-17 19:59
最佳答案
- 二级知识专家网友:放肆的依賴
- 2021-04-17 20:45
安装好了之后可以通过这个路径找到一个文本文件:
oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora 还一个在同路径下的tnsnames.ora文件,这两个文本中的一些信息要一样的。
你看看我的这两个文本文件的信息:
listener.ora
# listener.ora Network Configuration File: F:\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 = orcl)
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
tnsnames.ora
# tnsnames.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
另外,站长团上有产品团购,便宜有保证
oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora 还一个在同路径下的tnsnames.ora文件,这两个文本中的一些信息要一样的。
你看看我的这两个文本文件的信息:
listener.ora
# listener.ora Network Configuration File: F:\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 = orcl)
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
tnsnames.ora
# tnsnames.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
另外,站长团上有产品团购,便宜有保证
全部回答
- 1楼网友:飘零作归宿
- 2021-04-17 21:00
首先登陆到远程linux,使用oracle用户登陆
然后修改%oracle_home/network/admin/listener.ora文件
修改为如下内容(按照远程服务器配置)
sid_list_listener =
(sid_list =
(sid_desc =
(sid_name = plsextproc)
(oracle_home = /oracle/product/10g)
(program = extproc)
)
)
listener =
(description_list =
(description =
(address = (protocol = ipc)(key = extproc1))
)
(description =
(address = (protocol = tcp)(host = testserver3)(port = 1521))
)
)
其中,listener是服务器中监听进程的名称;
protocol 表明所使用的网络协议,若是tcp/ip协议,则该值必须为“tcp”;
host 表示服务器的网络地址,为服务器的ip或者网内的机器名;
port 指tcp/ip协议在主机中所占用端口号,oracle缺省使用1521,是在安装oracle数据库时定义的,在安装时可以改变,安装完成后不能改变此值;
sid_name 指服务器上运行的oracle数据库名称,该值应与.bash_profile文件中的环境变量oracle_sid相同(一般情况下此文件为缺省值“plsextproc”);
oracle_home 是指oracle数据库的主目录,该值也应与. bash_profile文件中的环境变量oracle_home相同。
希望能帮到您!
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯