Installing 64-bit Oracle11g+lsql Developer under the WIN10 system

Lsql developer as a powerful Oracle editing tool that only supports 32bit, this article provides an operation method for opening 64bitOracle with Lsql developer installation

Tool/RAW ORACLE11G installation package (64-bit) oracle11g client (32-bit) Lsql Developer installation package method/step

2. Download the installation package on the Oracle website, and after downloading, get the file:

4. Unzip the two files to get the directory:

6. Double-click Setup.exe, the system will be self-test, if prompted [INS-13001] environment does not meet the minimum requirements:

7. Click "No" to terminate the installation, then open the Extract directory \stage\cvu\cvu_prereq.xml, add the following text to the picture location:

   <operating_system release= "6.2" >

   <version value= "3"/>

   <architecture value= "32-bit"/>

   <name value= "Windows ten"/>

   <ENV_VAR_LIST>

   <env_var name= "PATH" max_length= "1023"/>

   </ENV_VAR_LIST>

   </OPERATING_SYSTEM>

   <operating_system release= "6.2" >

   <version value= "3"/>

   <architecture value= "64-bit"/>

   <name value= "Windows ten"/>

   <ENV_VAR_LIST>

   <env_var name= "PATH" max_length= "1023"/>

   </ENV_VAR_LIST>

   </OPERATING_SYSTEM>

9. Double-click Setup.exe again to see the installation interface shown, "Cancel receiving security updates through my Oracle support" and click Next.

11. Tip The email address has not been provided, select Yes.

13. Select Create and configure a database (default) and click Next.

15. Select the Desktop class (default) and click Next.

17. Select the installation directory, enter the admin password, and click Next.

19. If the password does not meet the recommended standard, does not affect the continuation of the installation, select Yes.

21. Prerequisite check, if all successful, click Next; If the check fails, tick ignore all and click Next.

23. Click Finish to install the database.

25. Go to the Database Configuration Assistance page and click Password Management.

27. The default sys and system users are available, you can start the Scott user, set the password, click OK.

Click OK to indicate that the installation of Oracle database is successful and click Close.

Second, inspection

1. Oracle Services

My Computer--management--services->oracle

View the installation of Oracle Services

Where the service name is: Oracleremexecservice is the temporary service that is started by the installation process, and after completing the installation of Oracle, restart the computer and the service automatically stops and logs off.

2. Check the operation of Oracle on the webpage

Open Web page, enter address:

Https://localhost:1158/em

You can see the running reports for Oracle

When prompted for an unsafe connection, select Advanced, and continue to and enter the user and password

3. Environment variables

The associated environment variables have been set, and the path paths have increased

4. Command line Login Test

Enter cmd input: Sqlplus sys/[email protected] as Sysdba

Verify that you are ready to log in

Third, install Plsql Developer

2. Install Plsql Developer, the same as the usual software installation process, as follows:

4. Download the oracle11g 32-bit client and unzip it to the product directory of the Oracle installation directory (for example, C:\Application\Develop\Database\Oracle\product).

6. Copy the Tnsnames.ora files from the Tnsnames.ora (located in%oracle_home%\network\admin) in the Oracle installation directory to the Instantclient_11_2 directory.

8. Enter PL/SQL, do not log in, select Tools--Preferences, set up Oracle home and OCI Library.

   Such as:

   Oracle Home:

   C:\Application\Develop\Database\Oracle\product\instantclient_11_2

    

   OCI library:

   C:\Application\Develop\Database\Oracle\product\instantclient_11_2\oci.dll

10. Set Plsql boot mode (two ways)

    1) in the Plsql Developer installation directory, create a script file that reads as follows:

    @echo off

    Set Path=c:\application\develop\database\oracle\product\instantclient_11_2

    Set Oracle_home=c:\application\develop\database\oracle\product\instantclient_11_2

    Set Tns_admin=c:\application\develop\database\oracle\product\instantclient_11_2

    Set Nls_lang=american_america. Zhs16gbk

    Start Plsqldev.exe

    Tip: Use this bat file instead of the PL/SQL shortcut to start Plsql Developer.

    2) Add system environment variables

    ① variable name: Nsl_lang, Variable value: American_america. Zhs16gbk

    ② variable name: tns_admin,

    Variable Value: C:\Application\Develop\Database\Oracle\product\instantclient_11_2

    Warm tip: According to your own installation directory to set up.

Installing 64-bit Oracle11g+lsql Developer under the WIN10 system