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