Oracl Creating and deleting databases using database Configuration Assistant

Original: Oracl use database Configuration Assistant to create and delete databases

You can use the database Configuration Assistant to create a learning data base. The database Configuration assistant abbreviation is DBCA, which is a tool for creating, configuring, and managing databases.

First, a specific step to create a database:

1. Click "Start"-"All Programs"-"Oracle"-"configuration and porting Tools"-"Database configuration Assistant"

or run-' cmd '-' DBCA '

2. Enter the Welcome screen of the tool

3, click "Next" button to enter "Step 1 operation", which supports five types of operation, respectively, to create a database, configure database options, delete the database, manage templates, configure automatic storage management.

4. Select "CREATE DATABASE", click "Next" button, go to "Step 2: Database Templates" window, the configuration page below four options are: General purpose, transaction processing, custom database, Data Warehouse. (in oracle11g, general purpose and transaction processing are merged into one called General purpose or transaction processing)

5. Select "General Purpose", then click "Next" button to go to "Step 3: Database Identification" window. Here, you need to enter the global database name and the system identifier (SID) of Oracle. The global data name is a unique identifier for Oracle data, so you cannot duplicate the existing database. Oracle instance is started when Oracle data is opened. An instance is uniquely identified by an Oracle system identifier to differentiate any other instance on that computer. By default, the global database name and SID have the same name.

6. After filling in the global database name and SID, click "Next" button to open the "Step 4: Management options" window:

As you can see, this window can be configured to centrally administer each Oracle database using Oracle Enterprise Manager Grid control, or you can use Oracle Enterprise Manager Control manages the Oracle database locally. The default is to use EM to configure the local database, and database control is used to manage the databases. In this place you can choose whether to enable backup of the database.

7. Click the "Next" button to open the "Step 5: Database Identity Certificate" window, which is configured for SYS,SYSTEM,DBSNMP and Sysman users to specify the password, you can choose all accounts with the same password, you can also set the password of the four users:

8. Click "Next" button to open the "Step 6: Storage Options" window, where you can choose the storage mechanism of the database, including three kinds of storage mechanisms: File system, automatic storage Management (ASM), and bare device

9, select "File System" as the storage mechanism of the database, click the "Next" button to open the "Step 7: Database File location" window:

Here you can configure the location of the Oracle data files, and you can click the file location variables button in the lower right corner to view the settings for the current Oracle data file variables.

10. Select "Use data file location in template" Click "Next" button to open the "Step 8: Restore Configuration" window, where you can configure backup and configuration options for Oracle database. You can use the Quick recovery area, or you can enable archiving. The default archive recovery area is {Oracle_base}/flash_recovery_area, and the size of the quick recovery area is 2048M. Recommendation: Place the database files and the recovery files on separate disks under the physical location to facilitate data protection and performance improvements.

11. Click the "Next" button to open the "Step 9: Database Contents" window:

The window has two tabs, each of which are "sample scenarios" and "Custom scripts."

Example Scenario tab, you can configure whether to install the sample scenario in a new database, which creates a tablespace called example, which is approximately 130M in size.

In a custom script, you can specify SQL scripts that need to be run automatically after the database is created, such as creating a default table and so on, and you can choose not to run or run the specified script.

12. Click the "Next" button to open the "Step 10: Initialize Parameters" window.

This tab configures the initialization parameters for the database, including the following: memory, sizing, character set, connection mode.

Memory: Includes two choices of typical and custom. Typically, you can choose a typical configuration, or you can manually set the size of the SGA (System global Zone) and the PGA (Program Global Zone).

Resize: Sets the size of the data block, specifying the maximum number of user processes that can link the database operating system at the same time.

Character set: Sets the character set used by the database, typically using the operating system's default language setting.

Connection mode: Oracle provides two types of database connection modes, dedicated server mode and shared server mode. The private service mode assigns dedicated resources to each client link. Use private server mode when the total number of client connections is expected to be small or if the client requests a longer request to the database. Multiple client connections share a pool of resources allocated by a database. The shared database schema is used when a large number of users need to connect to the database at the same time and need to utilize resources efficiently.

13. Click the "Next" button to enter the "Configuration 11: Database Storage" window. Here, you can specify the storage parameters that create the database, which can produce and modify objects that store parameters, including control files, data files, and redo log groups.

Click on the tree-like list on the left, select the object to view or modify, and in the right window you will see the object's stored information, usually using the default data.

14. Click "Next" button to go to "Step 12: Create Options" window, where you can choose "CREATE DATABASE" can also save the edited database template, you can also generate a script to create the database.

15, click "Done", open the "Confirmation" window, display the database template, here will prompt the user to create a new database.

16. Click the "OK" button to start creating the database and show the process and progress of the database creation:

17. The time to create the database depends on the hardware configuration of the computer and the configuration of the database, and the more you choose to install, the longer it will take. After the creation is complete, the Create complete window pops up. You can open the Password Management dialog box, edit the password for each user in the database, and click the "Exit" button to complete the process of creating the database.

Second, delete the database

1. Click "Start"-"All Programs"-"Oracle"-"configuration and porting Tools"-"Database configuration Assistant"

or run-' cmd '-' DBCA '

2. Enter the Welcome screen of the tool

3, click "Next" button to enter "Step 1 operation", which supports five types of operation, respectively, to create a database, configure database options, delete the database, manage templates, configure automatic storage management.

4, select ' Delete database ' Click Next to go to ' database ' select interface

5. Select the name of the database you want to delete

6, click the completion of the prompt window asks whether to delete the selected database

7. Select Yes to delete the database you want to delete

Oracl Creating and deleting databases using database Configuration Assistant