Oracle 12c Windows installation, introduction and simple use (graphics)

Reprint Please specify source: http://blog.csdn.net/anxpp/article/details/51345074, thank you!

This article is for the most basic operations of students who have not used Oracle (whether they have used other databases or not).

1. Download

Address: http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html

Download links with various platforms supported by the Enterprise and Standard editions, select Enterprise Edition under Windows here:

2. Install 2.1 Unzip and run

Directly decompression can, remember that two compressed package to decompress (because the zip format, the RAR format can be determined when the compression decompression is complete), if only extract a list of files will prompt a series of errors not found. The folder size should be: 2.70 GB (2,908,728,482 bytes) after correct decompression

After the decompression run (recommended to use right-click, run as Administrator) after Setup Setup.exe, Oracle checks the system parameters and then the following interface:

The following is described in turn.

2.2. Configuring Security Updates

Configure the mailbox to receive notifications, but you can also skip the following: E-mail items are not filled in, then uncheck the box below, click "Next", Pop-up dialog point "yes" can:

2.3. Installation options

• Create and configure a database: Install the database software and create a DB instance
• Install database software only: Install database software, do not create DB instance
• Upgrading an existing database: Upgrading a lower version of the Oracle database

Select the first item here and select the second item if you do not want to create a new DB instance.

2.4. System class

If you are installing to a server, select the server class. I choose the desktop class here.

2.5. Oracle Home Directory User Selection

• Use an existing Windows user: If you select this item, you need to specify a user who does not have administrative privileges.
• Create a new Windows User: Create a new user, enter a user name and password, confirm the password
• Use the Windows built-in account to select this: built-in accounts, and Oracle also recommends using accounts with restricted privileges.

I choose the second item here. Note that the user name created here is conflicting with the existing one, and the subsequent installation will error!

2.6. Mounting position

The main setup location, the character set selected Utf-8, and then the administrative password. If the password design is too simple to report a warning, you can ignore the warning to continue. Others with default values can also be changed to the way you want them to be.

2.7. Prerequisite Check

Automatic, check for prerequisites.

2.8. Overview

That shows the information that will be installed next, can be modified, and there are buttons in the lower right corner to hold the text of these states. Confirm that you have no problem and then click "Install" directly.

2.9. Install the Product

Wait......

A long wait ...

Then there will be a window containing "Manage password", please click "Manage password" set SYS and the system user's password, remember not to forget oh.

... Then the installation is complete O (∩_∩) o~

Then you can use it.

3, Development tools 3.1, Web-mode management tools

You can access the https://localhost:5500/em/directly into the admin interface, the account password can be entered just set the SYS and corresponding password.

The interface should be like this.

Here you can manage users, including permission settings, new users, and so on.

The new user needs to allocate the tablespace and assign permissions, and the user name must start with "c##", and possibly Oracle 12 to separate the administrative user from the normal user.

3.2. SQL Developer

This is an Oracle-installed graphical management tool for programming and more. Find Open:

Entering the interface is this:

You can right-create a local connection and enter your username password to start managing:

This is true when the login is successful:

You can try running an SQL statement:

However, the most common use of development tools is PL/SQL Dev.

3.3, Pl\sql use

First to download the installation: https://www.allroundautomations.com/plsqldev.html

The installation is simple, step by step down the line.

After the installation, play a meeting pop-up login box:

Enter the username and password and select the right database.

Let's get familiar with other operations.

3.4, Navicat Permium

One of the favorite tools when using MySQL is Navicat permium, which also supports Oracle.

This site has downloaded (and cracked tools):.

Installation and use is very simple, you have to experience it.

4. Configuration

There are 4 subdirectories under the Start Menu directory:

The corresponding tool catalog name has been made very clear, the following is only a brief introduction.

4.1. Install Product Tools

Universal Installer: Primarily for installing or uninstalling Oracle products.

4.2. Integrated management Tools

Wallet Manager: Certificate-related tools

4.3. Configuration and porting tools

Administration Assistant for Windows: Primarily used to configure Oracle services on Windows.

Database Configuration Assistant: You can use this tool to manage databases, create new, delete databases, and more.

Database migration Assistant For Unicode: Provides an end-to-end solution for migrating databases from legacy encoding to Unicode.

Database Upgrade Assistant: DB Upgrade tool.

Locale Builder: A handy tool for customizing local data definitions. Use this tool to view the creation language, character set, and so on. Key features include language settings, geography settings, character set settings, and syntax settings.

Net configuration Assistant: typically configured for network connections, this tool can be installed if a listener installation fails during installation because of some problems.

Net Manager: Above is the configuration, this is the management.

5. Extended Reading

5.1, Oracle 12c simple jdbc Use

5.2. Configuration and use of Oracle 12c in spring and hibernate

5.3. Introduction to data types in Oracle

The above content is still in the edit .... will be completed as soon as possible.

Oracle 12c Windows installation, Introduction, and simple use (graphics)