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

PLSQL cannot connect to 64-bit Oracle solution

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

Share

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

There is an error when Plsql is opened, and there is no connection target selection in the login interface.

Reason: PLSQL itself doesn't seem to support 64-bit Oracle.

Solution:

Download the 32-bit Oracle client from the Oracle official website at http://www.oracle.com/technetwork/topics/winsoft-085727.html

Decompress the downloaded 32-bit client.

The PLSQL login interface temporarily cancels the login. Go to the PLSQL interface first, click the preferences, and set the OCI library to the OCI path of the 32-bit client you just downloaded. The path must include oci.dll.

Add environment variables:

The first one points to the directory where the TNS file is located, which is the directory where you installed the 64-bit version of Oracle's TNS file. The TNS file is the file that saves the connection information. (127.0.0.1 is no longer required to connect to the local instance after configuration)

TNS_ADMIN value: e:\ app\ OYK\ product\ 11.2.0\ dbhome_1\ NETWORK\ ADMIN

The environment variable is set to read the services configured in NET MANAGER in the 64-bit client. Bypass 32-bit clients.

The second is to specify the encoding used by the database. If it is not set to the following value, then after connecting to the database, all the Chinese content you see will be garbled and a bunch of question marks.

NLS_LANG value: SIMPLIFIED CHINESE_CHINA.ZHS16GBK

Prompt to lose MSVCR71.DLL, COPY the file 64 under the installation path to the downloaded 32-bit client. In the file under:\ oracle\ product\ 10.2.0\ db_1\ BIN\ ctxhx

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