Install the search a lot of posts, a lot of is copy and paste (do not need any ip,host), some version is wrong, some version is too old, today decided to post their own virgin stickers
Oracle installation is simple, no need to say anything, PL/SQL It's disgusting.
The steps are as follows:
1, in the directory you resolved to find the Readme.txt file, according to environment variables to configure the environment
D:\install\PLSQL
|--Instantclient_11_2 (There are many files in the folder)
|--Tnsnames.ora
|--Plsql Developer
|--Readme.txt
(Two. Environment variable configuration)
Nls_lang = Simplified Chinese_china. Zhs16gbk
Tns_admin = D:\install\PLSQL\instantclient_11_2 (This is where you plsql the decompression)
2, according to Readme.txt step three
three. PL/SQL Developer environment settings
1. Location
Connections, preferences, tools
2. Settings
Oracle Home Directory name = D:\install\PLSQL\instantclient_11_2 (This is your plsql location)
OCI Library = D:\install\PLSQL\instantclient_11_2\oci.dll (this is your plsql location)
3. Configuring the Tnsnames.ora File
1. Locate the Oracle installation directory (mine is)
D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN folder under Tnsnames.ora,
Copy all contents
2, Find Plsql decompression directory (my is)
D:\PLSQL\PLSQL\instantclient_11_2 folder under Tnsnames.ora,
Paste overwrites the original content,
4, open the Plsql decompression folder, (my decompression location is)
D:\PLSQL\PLSQL\PLSQL Developer Double-click Plsqldev,
Enter user name, password, database select Orcl in the dropdown box
(Perfect login)
Issue One: TNS: Unable to resolve the specified connection identifier
This problem is mainly Tnsnames.ora not configured, please refer to the above configuration
win8.1 64-bit +oracle11g R2 64-bit +pl/sql16.5 cracked version 64-bit