Plsql Developer Startup Problem Solving method

Source: Internet
Author: User

Question 1:

Symptom: After entering the correct user name, password and database IP information, click OK, pop-up errors: initialization error Oracle Client not properly installed

      

Cause: The machine does not have Oracle client (Oracle clients) or no environment variables configured

WORKAROUND: Download the Oracle client and configure the system environment variables

: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

Note: To select and plsql the corresponding Oracle client, for example, your plsql is 32-bit, select the 32-bit client. In addition, as a test, you can choose a lightweight client.

Configuration method: Because the client that is downloaded from the above address is a compressed package, for example: Instantclient-basiclite-windows.x64-11.2.0.4.0.zip

This facilitates in-depth understanding of the composition of the Oracle client, and occupies a small footprint, can be extracted to any directory (decompression path is best not to include Chinese)

After extracting, create two files in the extracted directory named: Tnsnames.ora, Listener.ora files

The contents of the Listener.ora file are:

LISTENER1 =                  1521)))    

The contents of the Tnsnames.ora file are:

ORCL =(DESCRIPTION=(ADDRESS= (PROTOCOL = TCP) (HOST =127.0.0.1) (PORT =1521)) (Connect_data=(SERVER=dedicated) (Service_Name=ORCL)) ) Extproc_connection_data=(DESCRIPTION=(Address_list=(ADDRESS= (PROTOCOL = IPC) (KEY =EXTPROC1)) ) (Connect_data=(SID=Plsextproc) (PRESENTATION=RO)) )

Then configure the system environment variable and create a new two variable in the system variable

Nls_lang=american_america. Zhs16gbk

Tns_admin= (Oracle Client decompression path, for example: D:\oracle\instantclient_11_2)

Add an extract path to the Oracle client in the value of the system variable path, for example: path=;D: \oracle\instantclient_11_2

  

Question 2:

Symptom: The Oracle client is also configured with the system environment variables, enter the correct user name, password and database, click OK, pop-up error: Initialization error could not initialize "Oracle client Path" Make sure has the "the" the "Bits Oracle client installed.

  

Cause: The version between Plsql and Oracle client does not correspond, Plsql is 64-bit, Oracle client is 32-bit

Workaround: Replace the 64-bit Oracle client version and reconfigure the system variables

Resolve successful results: A connect as is added below the start-plsql interface

  

Note: In the same vein, if the "Make sure" is displayed in the error prompt, it also indicates that the PLSQL and Oracle client versions do not correspond, or that the next corresponding Plsql is re- or re-download the corresponding Oracle client

Question 3:

Behavior: The previous issue 1, problem 2 is resolved, but enter the correct user name, password and database, click OK, pop-up error prompt: Access violation at address ... in module ...

  

Cause: The locally installed Oracle version is too low. And the Oracle version you're connected to is high

Workaround: Download the latest Oracle client version, then change the system variable to the latest version, and then go to Plsql to configure the connection information.

Plsql Configuration method: After starting the program, click Cancel, then you can go directly to the main interface, select Tools>>preferences>>oracle>>connection in the main interface, find Oracle Home and OCI Library, the Oracle client decompression path copy and paste into, notice the OCI library with the file name, specific as

In the configuration process will pop up a prompt box, the meaning of the content is that these configurations must restart Plsql to take effect, so the direct point to determine the line, after configuration, remember to determine, and then restart Plsql

Novice questions:

When using Plsql, the user name and password on the login interface is simple, just fill in the correct, but how to fill out the database?

The database is populated with a ip/database name, separated by a slash between the IP address and the database name.

  

Plsql Developer Startup Problem Solving method

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.