Win64-bit Oracle_11gR2 database installation + PL \ SQL Developer, win64oracle_11gr2

Source: Internet
Author: User

Win64-bit Oracle_11gR2 database installation + PL \ SQL Developer, win64oracle_11gr2

Download required software:

Oracle_11gR2 and instantclient-basic-nt-11.2.0.3.0 and plsqldev9

Download link: http://pan.baidu.com/s/1gdH53IN

Step 1: Install Oracle_11gR2


In the displayed "configuration Security Update" window, cancel "I want to accept security updates through My Oracle Support" and click "Next ":



In the "Installation Options" window, select "Create and configure Database" and click "Next ":



In the system class window, select desktop class and click Next ":



In the "typical installation" window, select the Oracle base Directory, select "Enterprise Edition" and "default", enter the unified password Oracle11g, and click "Next ":



In the prerequisite check window, click Next ":



In the "summary" window, click "finish" to install:



The installation process is as follows:





After the Database is created, the following "Database Configuration Assistant" interface appears:


Select "password management" to view and modify the following users:
(1) normal user: SCOTT (password: tiger)
(2) General Administrator: SYSTEM (password: manager)
(3) Super administrator: SYS (password: change_on_install)
After the modification is complete, click OK ".


In the "finish" window, click "close.


Step 2: Decompress the instantclient-basic-nt-11.2.0.3.0 to the installation directory

I put it in the F: \ CMDL \ product directory



Step 3: install and configure PLSQL Developer


PLSQL Developer can be installed normally.

The configuration is as follows:

After the installation is complete, run PL/SQL Developer. In this case, the logon form cannot be logged on. Click the Calcel button and it will enter in the non-Logon status.





Click OK.


Configure the new environment variable:
TNS_ADMIN and NLS_LANG
TNS_ADMIN = F: \ L \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN
NLS_LANG = AMERICAN_AMERICA.ZHS16GBK (an error will be reported when pl/SQL is enabled ),

The procedure is as follows:

On the computer --- properties --- advanced system settings ---- System Properties (advanced) --- environment variables --- create TNS_ADMIN and NLS_LANG variable names: TNS_ADMIN and NLS_LANG variable values: TNS_ADMIN = F: \ CMDL \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN
NLS_LANG = AMERICAN_AMERICA.ZHS16GBK


In this case, you can open PL \ SQL dve.

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.