问题1:ORA-01950
问题描述:对表空间无权限
解决:
以管理员身份运行cmd,执行以下命令:
grant resource to username; 或者 grant unlimited tablespace to username;
问题2:ORA-12514
问题描述:TNS: listener does not currently know of service requested in connect descriptor
解决:
1、进入Oracle安装目录"11.2.0\dbhome_1\NETWORK\ADMIN" ,打开"listener.ora"文件;
2、添加编辑成以下文本,保存;
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = C:\app\Administer\product\11.2.0\dbhome_1)
(SID_NAME = orcl)
)
)
#注意 "ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1" 为安装目录
3、重启监听服务(关掉Service和LISTENER,再启动Service和LISTENER,注意顺序)。
问题3:ORA-28547
问题描述:connection to server failed,probable Oracle Net admin error
解决:
1、去Oracle官网下载Oracle 11版本的 " oci.dll " 文件," Version 11.1.0.7.0 " --> " instantclient-basic-win-x86-64-11.1.0.7.0.zip ";
下载地址:https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html
2、解压至Navicat安装目录;
3、打开 “Navicat Premium”,“ 工具 --> 选项 --> 环境 --> OCI环境 ”,选择下载的 " oci.dll " 文件;
4、重启Navicat再次连接 --> 解决。