Successfully connect services with PLSQL developer after installing Oracle 10g to prevent errors in the middle of the process

Source: Internet
Author: User

Add environment variables before installing Oracle 10g

Variable name: tns_admin

Variable Value: D:\oracleclient\instantclient_11_2

This will generate three files under this file after Oracle installation: Listener.ora, Sqlnet.ora, Tnsnames.ora

Move these three files to D:\oracleclient\instantclient_11_2\NETWORK\ADMIN, the folder is built by itself.

Then extract the Instantclient package downloaded from the Internet, the default is the Instantclient_11_2 file, copy the files in this folder to D:\oracleclient\instantclient_11_2

Baidu Cloud: Link: https://pan.baidu.com/s/1eStmK8a Password: dx33

Open Plsql developer,oracle Login-Cancel

First go to interface, tools, Preferences (Preferences), connect (connection),

Will D:\oracleclient\instantclient_11_2

D:\oracleclient\instantclient_11_2\oci.dll Fill in the box.

Exit the software and log back in

This will allow you to successfully log into the Oracle database.

This way is summed up through multiple installations, because each installation after the use of Plsql developer connection to the Oracle database will have problems, to search the internet to solve the problem is very complicated, and sometimes solve a problem after the emergence of new problems. such as: Ora-12154:tns: Unable to resolve the specified connection identifier, Ora-12514,listener does not currently kown of service requested in Connect descriptor and so on.

This process will automatically generate Oracle's service, and you can connect it directly with Plsql.

In fact, for those who just use and don't delve into Oracle, it may be possible to install using a method that saves a lot of time.

Successfully connect services with PLSQL developer after installing Oracle 10g to prevent errors in the middle of the process

Related Article

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.