In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.