PL/SQL connection error

Win8 x64 PL /SQL Enter user name password, connect times wrong:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/22/wKioL1V1B3jz5PutAAFWFtrv114122.jpg "title=" 10.png "alt=" Wkiol1v1b3jz5putaafwftrv114122.jpg "/>

Environment:

1.win 8 64bit as a client, install the client

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6E/26/wKiom1V1BeiTYDtoAAA2FjZX5OE301.jpg "title=" 11.png "alt=" Wkiom1v1beitydtoaaa2fjzx5oe301.jpg "/>

Unzip, install pl/sql11.0.0

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6E/22/wKioL1V1B53jYd_pAAG8Z8HcQ7M934.jpg "title=" 12.png "alt=" Wkiol1v1b53jyd_paag8z8hcq7m934.jpg "/>

2. database:Centos64 oracle11gr2 pl/sql11.0.0

Cause of the problem

after the installation is complete Oracle 's oci.dll is in the same position, and the Developer application PL/SQL is unable to load. That is, we install the oracle64 bit, but there is no PL/SQL . Therefore, you cannot connect to the database.

Workaround: at this we are you can't use it . PL/SQL Developer For direct connection, you also need to Oracle another tool to help us.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6E/26/wKiom1V1Bg6RLo8JAAGb0-wbs_w804.jpg "title=" 13.png "alt=" Wkiom1v1bg6rlo8jaagb0-wbs_w804.jpg "/>

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

Select the first one instantclient for Microsoft Windows (32-bit) to download it, please do not download 64bit , I tried, can not achieve the connection.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6E/22/wKioL1V1B77wfx93AABrMF84iEs811.jpg "title=" 14.png "alt=" Wkiol1v1b77wfx93aabrmf84ies811.jpg "/>

This is the version I downloaded.

Step two: After the download is complete. Unzip, and unzip the client in the same directory. If I unzip to C:\app\instantclient_11_2.

Step three: Run PL/SQL. do not enter the user name, password login, click " Cancel " and enter the interface.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/22/wKioL1V1B8vAmediAAFDAydAFLo341.jpg "title=" 15.png "alt=" Wkiol1v1b8vamediaafdaydaflo341.jpg "/>

Fourth step: After entering, click " Preferences "

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/26/wKiom1V1BjqymfTqAAPFX7tyNCA917.jpg "title=" 16.png "alt=" Wkiom1v1bjqymftqaapfx7tynca917.jpg "/>

Fifth step: In the Preferences window. Click " connect ". "Oracle home directory name inside the client to enter the extracted path," OCI library , enter the path of Oci.dll.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6E/26/wKiom1V1BkvCV-bmAAKQXu6bR80965.jpg "title=" 17.png "alt=" Wkiom1v1bkvcv-bmaakqxu6br80965.jpg "/>

Sixth step: Modify the client system variables.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/6E/22/wKioL1V1B_6QqkQuAAD2AJOhyLY878.jpg "title=" 18.png "alt=" Wkiol1v1b_6qqkquaad2ajohyly878.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/22/wKioL1V1CAiymx7sAACf_tqXRcw145.jpg "title=" 19.png "alt=" Wkiol1v1caiymx7saacf_tqxrcw145.jpg "/>

Click " Advanced "," environment Variables "," new ", enter " variable name " and " Variable Value ". Note that the value of the variable is to be entered in the location of the Tnsname.ora file for parsing.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/6E/26/wKiom1V1BnbDvKvjAAOXgVTcdnM408.jpg "title=" 20.png "alt=" Wkiom1v1bnbdvkvjaaoxgvtcdnm408.jpg "/>

Seventh step: Run again PL/SQL, enter the user name and password to log in normally.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6E/26/wKiom1V1BsGRNeVkAABTE0__2l4172.jpg "title=" 21.PNG "alt=" Wkiom1v1bsgrnevkaabte0__2l4172.jpg "/>

This article is from the "I am a novice" blog, please be sure to keep this source http://zhuozhuo.blog.51cto.com/6258373/1659579

PL/SQL connection error