在C:\instantclient_10_2 目录下安装了从官方网站下的instantclient-basic-win32-10.2.0.3-20061115.zip,instantclient-sqlplus-win32-10.2.0.3-20061115.zip.
CentOS5.1下Oracle 10g实例名:gzga 端口是1522,user:ksxt;pwd:1234;Ip:192.168.0.101,在XP下可正常通过http://192.168.0.101请求10g下连接实例gzga的WEB应用并运行 在WINXP(IP:192.168.0.101)的命令行里运行:C:\instantclient_10_2>sqlplus ksxt/1234@remoteGZGA SQL*Plus: Release 10.2.0.3.0 - Production on Sat Jun 14 21:13:24 2008 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus 我把tnsnames.ora 放在C:\instantclient_10_2下,其中内容如下: # tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0.1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools. # tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0.1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools. remoteGZGA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.101)(PORT = 1522))
)
(CONNECT_DATA =
(SID = gzga)
)
)
我在XP机上装了9.2的服务端,但我把其监听和服务都关掉也问题依旧!
请教什么原因导致远程连接10g不成功?原因什么?XP下的PL/SQL DEV怎么连接上CentOS5.1下的Oracle 10g?具体解决步骤!非常感谢!
CentOS5.1下Oracle 10g实例名:gzga 端口是1522,user:ksxt;pwd:1234;Ip:192.168.0.101,在XP下可正常通过http://192.168.0.101请求10g下连接实例gzga的WEB应用并运行 在WINXP(IP:192.168.0.101)的命令行里运行:C:\instantclient_10_2>sqlplus ksxt/1234@remoteGZGA SQL*Plus: Release 10.2.0.3.0 - Production on Sat Jun 14 21:13:24 2008 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus 我把tnsnames.ora 放在C:\instantclient_10_2下,其中内容如下: # tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0.1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools. # tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0.1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools. remoteGZGA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.101)(PORT = 1522))
)
(CONNECT_DATA =
(SID = gzga)
)
)
我在XP机上装了9.2的服务端,但我把其监听和服务都关掉也问题依旧!
请教什么原因导致远程连接10g不成功?原因什么?XP下的PL/SQL DEV怎么连接上CentOS5.1下的Oracle 10g?具体解决步骤!非常感谢!
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.101)(PORT = 1522))
)
(CONNECT_DATA =
(SID = gzga)
)
)
XP下原来装了9.2的服务端,一打开PL/SQL DEV连接列表里总是本地的服务,通过PL/SQL DEV怎么连接上CentOS5.1下的Oracle 10g的实例gzga?从而可操作10g数据库对象,请教具体解决步骤!非常感谢