Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Settings of sql/sql develop on installing 64-bit oracle machines

2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Do not use the (x86) folder to connect to the OracleX64 version using PL/SQL Developer when installing sql/del develop:

1. Download 32-bit Oracle InstantClient and expand to a directory, such as C:\ instantclient_10_2; http://pan.baidu.com/s/1eQ1nV3O

2. Copy the tnsnames.ora of the system to this directory

3. Set up Oracle_Home and OCI Library in PLSQL Developer:

Tools  Preferences  Oracle  Connection:

Oracle_Home: C:\ instantclient_10_2

OCI Library: C:\ instantclient_10_2\ oci.dll

4. Edit the following bat file in the PLSQL Developer directory, replace its shortcut, and start PLSQL Developer:

@ echo off

Set path=C:\ instantclient_10_2

Set ORACLE_HOME=C:\ instantclient_10_2

Set TNS_ADMIN=C:\ instantclient_10_2

Set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

Start plsqldev.exe

If prompted that msvcr71.dll cannot be found, please download the msvcr71.dll http://pan.baidu.com/s/1mg7hwVI in the link below and put it in the system32 and ps/sql developer directories

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report