[Go] Oracle Learning creation Database (new instance)

Due to project requirements, developed in this machine, you need to create a new Oracle database instance, pro-test can.

Source: http://blog.csdn.NET/luiseradl/article/details/6972217

Http://wenku.baidu.com/view/864b9b2c453610661ed9f469.html

My points:

(1) My boss said that generally do not need to create a database, in the ORCL database to create a user, create a user-corresponding table becomes;

(2) Delete database and CREATE database start software is one.

First, the new instance
1, install the Oracle server.
2. Oracle creates instances using the Database configuration Assistant tool under "Configuration and Migration Tools" under the Orahome directory.
3. Step 2: Select "CREATE DATABASE".
4. Step 3: Select the database template.
5. Step 4: Select "Private Server Mode".
6, Step 5: Set the initialization parameters.
7, other default, click "Done".

Second, the basic concept

A generic Oracle database can be divided into two parts, an instance (Instance) and a database.

Example: is a non-fixed, memory-based basic process and memory structure. When the server shuts down, the instance does not exist.

Database refers to fixed, disk-based data files, control files, log files, parameter files, and archive log files.

In general, an Oracle database is an instance of a database. As shown in.

Of course, you can create multiple databases and corresponding multiple instances as needed.

Test environment

Windows 7 Flagship, 32-bit operating system, already installed Oracle 11g R2, and created a database and instance ORAC11

The services installed in Windows are as shown in.

Create a new database and corresponding instance

Open Database Configuration Assistant

This warning page is not a tube and can be reconfigured later.

Connect a different DB instance

The instance that corresponds to 2 databases is started up.

Link ORAC11

Cmd

SQLPLUS Sys/[email protected] as SYSDBA

Connection ORAC111

Cmd

SQLPLUS Sys/[email protected] as SYSDBA

Everything is fine.

1, install the Oracle server.
2. Oracle creates instances using the Database configuration Assistant tool under "Configuration and Migration Tools" under the Orahome directory.
3. Step 2: Select "CREATE DATABASE".
4. Step 3: Select the database template.
5. Step 4: Select "Private Server Mode".
6, Step 5: Set the initialization parameters.
7, other default, click "Done".

[Goto] Oracle Learning Creation Database (new instance)