Oracle11gR2 (database creation and OEM Management)

After Oracle is installed, create a database. You must configure the listening port of the database before creating the database. Otherwise, you will be prompted to configure the listening port before creating the database. 1. The Listener Configuration is as follows. continue to the next step... Netca -- Listenerconfiguretion -- Add -- Listenername: LISTENER -- select the Protocol (TCP) -- use port 1521 --

After Oracle is installed, create a database. You must configure the listening port of the database before creating the database. Otherwise, you will be prompted to configure the listening port before creating the database. 1. The Listener Configuration is as follows. continue to the next step... Netca -- Listenerconfiguretion -- Add -- Listener name: LISTENER -- select the Protocol (TCP) -- use port 1521 --

After Oracle is installed, create a database. You must configure the listening port of the database before creating the database. Otherwise, you will be prompted to configure the listening port before creating the database.

1. The Listener Configuration is as follows. continue to the next step...

Netca --> Listenerconfiguretion --> Add --> Listener name: LISTENER --> select protocol (TCP) --> use port 1521 --> configuration complete

2. Create a database

Database Configuration starts

Create or delete a database

Select the database type.

1. General Purpose

2. Custom Database

3. Data Warehouse

Set Database Name and SID

1. We are prompted that we do not need to use EM to manage Oracle.

2. Enable email notification

3. Enable daily backup

Four users will be created by default. We will use the unified password.

1. Specify the database storage mechanism. We select a file system and use a lot of ASM in the production environment.

2. specify the location of the created database file

Use the database file location in the template

Common location of all database files

Use oracle to manage files

Select database recovery options

1. Specify the quick recovery zone and default values for all backup and recovery operations. We recommend that you store the recovered files in different locations in the database file box.

2. Enable Archiving

Select to create some sample tables for learning and use, and do not create a production environment

Allocate 40% of the physical memory to Oracle

Set database character sets

Database Files: control files, data files, and log files

Start creating

Database Created

3. Use EM to manage databases

When EM is started, the following error occurs:

[Oracle @ oracledb ~] $ Emctl status dbconsole

Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.

Solution: Set the. bash_profile environment variable.

The following describes that the OEM is already running.

The following shows that the Oracle port 1521 has been listened on normally.

Log on to the EM page. The first time you log on to the system, you need a certificate. Ignore the certificate and use the highest permission of sys to log on to the system.

The "UP" status indicates that the database is connected correctly.

"Penguin" That Thing "blog, please be sure to keep this source http://going.blog.51cto.com/7876557/1347637