1. 64bit 下使用 PLSQL Developer 操作步骤
1.把instantclient-basic-win32-11.2.0.1.0压缩包中文件夹instantclient_11_2 复制到 C:\ 2.把D:\oracle\product\10.2.0\db_1\ 路径下的NETWORK文件夹复制到
C:\ instantclient_11_2\ 3. 系统环境变量 PATH 最右边添加 ; C:\ instantclient_11_2 红色分号 不要忘记
3. 打开PLSQL Developer程序 Tools--> Preferences
修改Oracle主目录名以及OCI库目录
2.警告日志中出现如下错误提示： ksvcreate: Process(m000) creation failed Mon Jul 27 05:02:15 2015 Process m001 died, see its trace file ksvcreate:
Process(m001) creation failed Mon Jul 27 05:03:50 2015 Process J000 died, see its trace file Mon Jul 27 05:03:50 2015 kkjcre1p: Unable to spawn jobq slave process Errors in file d:\oracle\product\10.2.0\admin\medicu\bdump\medicu_c jq0_3384.trc:
查看medicu_cjq0_3384.trc 进一步明确错误信息 ORA-00020:
maximum number of processes (150) exceeded ORA-00020: maximum number of processes (150) exceeded Sql> select * from v$resource_limit; 查询 这个错误明确了processes 设置过低 解决步骤：
sql> alter system set processes=600 scope=spfile; sql> shutdown immediate; sql> startup
