系统原来安装了oracle9i client +pl/sql,后来卸载了oracle9i client安装了oracle11g,pl/sql无法连接上数据库了,提示如下
PL/SQL Developer - (Not logged on)
---------------------------
Initialization error
SQL*Net not properly installed
OracleHomeKey: SOFTWARE\ORACLE
OracleHomeDir:
上网查了下,是oracle9i和oracle11目录结构变化了的问题,按下列修改:
在PLSQL Developer选择Tools > Preferences > options > "Oracle Home" and "OCI Library",例如:
Oracle11g装在D:\oracle11g
Oracle Home为D:\oracle11g\product\11.1.0
OCI Library为D:\oracle11g\product\11.1.0\Db_1\BIN\oci.dll
阅读(3836) | 评论(1) | 转发(0) |