没装oracle plsql,64位WIN7系统，未装ORACLE，我用PLSQLDEV 远程连接数据库时报错ORA-12560:TNS:protocol adapter error...

www.mh456.com防采集。

参考这个： 使用2113PL/SQL Developer连接OracleX64版本：5261•1. 下载32位Oracle InstantClient，并展开到某目录，例如C:\instantclient-basic-nt-11.2.0.2.0；•2. 将系4102统的tnsnames.ora拷贝到该目录下；•3. 在PLSQL Developer中设置Oracle_Home和1653OCI Library： ToolsPreferencesOracleConnection：Oracle_Home：C:\instantclient-basic-nt-11.2.0.2.0OCI Library：C:\instantclient-basic-nt-11.2.0.2.0\oci.dll•4. 在PLSQL Developer目录下编辑如下bat文件，替换其快捷方式，启动PLSQL Developer：@echo offset path=C:\instantclient-basic-nt-11.2.0.2.0set ORACLE_HOME=C:\instantclient-basic-nt-11.2.0.2.0set TNS_ADMIN=C:\instantclient-basic-nt-11.2.0.2.0set NLS_LANG=AMERICAN_AMERICA.ZHS16GBKstart plsqldev.exe追问我就是这么弄的，完了之后看不到远程的数据库名追答本地网络服务名的配置弄好了吗？ 在文件 tnsnames.ora 中 ？？？比如： tnsnames.ora# tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora# Generated by Oracle configuration tools.ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )

内容来自www.mh456.com请勿采集。