Database creation and deletion of Oracle databases

Create a database

1 Creating an Oracle database using the Database Configuration Assistant tool

Step One Action window

There are 4 choices. A CREATE Database B metabase option C Delete database D Administrative Templates

Step Two Database Template window

There are 3 options for a general purpose or transactional B custom database C Data Warehouse

Step three database identification in this step, you need to enter the global database name and the Oracle system identifier (SID)

The global data name is unique to the Oracle database, so you cannot duplicate the existing database

When you open an Oracle database, the Oracle instance is started. The instance is uniquely identified by an Oracle system identifier, which distinguishes any other instance on that computer.

By default, the global data name and SID have the same name, which is assumed to be ORCL

Step Four management Options window

The default option is to use Enterprise Manager to configure the database and to use database control to manage the databases.

Before you can use database control to manage databases, you need to create a default listener using Net Configuration Assistant in advance.

Step Five Database Identity certificate

For security reasons, you must specify a password for the SYS SYSTEM DBSNMP sysman user in the new database.

You can choose to use the same password for all accounts, or you can set the commands for each of the 4 users.

Step six where the database files are located

Here you can select the storage type for the database, including:

File system: Using File system for database storage

Automated storage Management (ASM) simplifies database storage management and optimizes database layout to improve I/O performance. Use this option to specify a set of disks to create an ASM disk group or to designate an existing ASM disk group

Oracle provides the following two types of database connection modes

Private database mode: The database allocates dedicated resources for each client connection, use this mode when the total number of client connections is expected to be small, or if the client wants the database to make a longer request duration

Shared Server mode: Multiple client connections share a database-allocated resource pool. Use this mode when a large number of users need to connect to the database at the same time and make efficient use of system resources.

This article is from the "GD" blog, please be sure to keep this source http://wangdenghui.blog.51cto.com/9930072/1790705

Database creation and deletion of Oracle databases