(O & M log) install Oracle in win7 and deploy the Oracle database

Source: Internet
Author: User

Deployment Environment Description:


OperationWork
SystemUnified: Window 7


OracleManage applications: Pl SQL

1. Select the Oracle version that supports Windows 7 and download it.

Currently, the oracle version that fully supports Windows 7 is 11.2 GB.

 

 Additional instructions: Oracle 10g version released on December 1, 2003


Oracle 11g was released on August 1, 2007.

 These two versions are available in win7The self-check fails during operating system installation. After compatibility, the installation can be completed. After the installation is complete, some services cannot be started..

 

The download address for Oracle 11.2g is as follows:

Http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html? SsSourceSiteId = ocomcn

Note: It is free to register an Oracle account and install Oracle for commercial purposes.

 

2. Select the 32-bit and 64-bit installation files based on the number of digits of the operating system,

Win32_11gR2_database_1of2.zip

Win32_11gr2_databasesilicate f2.zip

After the download is complete, extract the two compressed files to a folder and install them in sequence.

 

3. Use pl SQL to create a user and grant the view creation permission.

  • Use the Administrator account to enter plsql
    And select the User object set on the left.
  • Right-click to create a new user
  • Set tablespace and temporary for users
    Tablespace
  • Configure user accounts, passwords, and grant connect and resource Permissions

 

Set the user's permission to create a view

Grant create any view to [user name]

 

4. Import script

Log in with the newly created account and open
Command dialog box
Run

@ D: \ test. SQL script

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.