`

ORACLE 免客户端 PLSQLDeveloper(64位OS)

 
阅读更多
1.下载附件instantclient_10_2.zip,解压到指定目录。如解压到D:\
--附件太大无法上传,可以去
http://dldx.csdn.net/fd.php?i=535341814244011&s=49040ef442d707a83d11296dc2aca5ef下载
2.下载PLSQLDeveloper免安装版。同上,附件太大无法上传。
3.打开PLSQLDeveloper,登陆时点取消进入,设置: 工具->首选项->连接

ORACLE主目录:
D:\instantclient_10_2

OCI库:
D:\instantclient_10_2\oci.dll

4.退出,重新启动PLSQLDeveloper,数据库填: XXX.XXX.XXX.XXX/orc
如:172.16.251.111/myorc


注意:
1.登陆时数据库必须填IP
2.如果出现中文乱码,那么:

select * from v$nls_parameters;

         parameter                               value
---------------------------------------------------------------------------
1	NLS_LANGUAGE	                            SIMPLIFIED CHINESE
2	NLS_TERRITORY	                            CHINA
3	NLS_CURRENCY	                            ¥
4	NLS_ISO_CURRENCY	             CHINA
5	NLS_NUMERIC_CHARACTERS	             .,
6	NLS_CALENDAR	                             GREGORIAN
7	NLS_DATE_FORMAT	                             DD-MON-RR
8	NLS_DATE_LANGUAGE	             SIMPLIFIED CHINESE
9	NLS_CHARACTERSET	             AL32UTF8
10	NLS_SORT	                             BINARY
11	NLS_TIME_FORMAT	                             HH.MI.SSXFF AM
12	NLS_TIMESTAMP_FORMAT	             DD-MON-RR HH.MI.SSXFF AM
13	NLS_TIME_TZ_FORMAT	             HH.MI.SSXFF      AM TZR
14	NLS_TIMESTAMP_TZ_FORMAT	             DD-MON-RR HH.MI.SSXFF AM TZR
15	NLS_DUAL_CURRENCY	             ¥
16	NLS_NCHAR_CHARACTERSET	             AL16UTF16
17	NLS_COMP	                             BINARY
18	NLS_LENGTH_SEMANTICS	             BYTE
19	NLS_NCHAR_CONV_EXCP	             FALSE


增加两个环境变量:[我的电脑->属性->高级系统设置->环境变量]
LANG
     zh_CN.GBK
NLS_LANG
     SIMPLIFIED CHINESE_CHINA.ZHS16GBK

----------------------------------------------------------------------------------------
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics