Navicat for Oracle Cannot create oci environment
使用 Navicat for Oracle 来管理Oracle
意思是不能创建oci环境
我们需要对 Navicat for Oracle 做一下配置
依此选择 Tools ->Options-> Miscellaneous -> OCI
OCI library “D:\Program Files\PremiumSoft\Navicat for Oracle\instantclient_10_2\oci.dll”
修改 为 “D:\oracle\ora92\bin\oci.dll”
重新启动 Navicat for Oracle
选择 Advanced 将 Role “Default”
修改为 “SYSDBA”
点击 OK
ORA-12514:TNS:监听进程不能解析在连接描述符中给出的SERVICE_NAME
只要去修改以下tnsnames.ora文件就可以了
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = "host")(PORT = "port"))
)
(CONNECT_DATA =
(SID = "databasename")
(SERVER = DEDICATED)
)
)
其中把引号部分进行相应的替代就可以了