Oct 26, 2008

How to connect to the Oracle server via PLSQL developer tool with out installation Oracle Client.

/*不用安装Oracle Client,Plsql developer 连接到Oracle server.
1: Seach the following files at your ORACLE server end. and copy those
files to a folder. for example: D:\oraclient
oci.dll
ocijdbc10.dll
ociw32.dll
orannzsbb10.dll
oraocci10.dll
oraociei10.dll
/*if have not found, then plsql develop tools can login via any
account and password. you should seach and download it by google or
baidu:)*/
sqlnet.ora
tnsnames.ora
classes12.jar
ojdbc14.jar

2、create a file: tnsnames.ora in the previous folder. eg. D:\oraclient.
like this:
oracledata =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.111)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

3、Config the env. add TNS_ADMIN=D:\oraclient. if you have install the
oracle client. it should be listed under %ORACLE_HOME%/network/admin/。

4、Set the language env. NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
or AMERICAN_AMERICA.US7ASCII
5、Open your PLSQL developer and set the connection string. then save
it and quit.
check tools->preferences->connection
Oracle Home=D:\oracleclient
OCI library=D:\oracleclient\oci.dll

6、Ok, you can try it now, enjoy it!!! if have any issue, please feel
free contact me: Gtalk & Gmail: zhouxiangzhen@gmail.com

No comments:

Post a Comment