DBCA stands for Database Configuration Assistant. Creation of Database for the first time is carried out using DBCA. It is a graphical user interface and involves certain steps based on desired attributes of the database we are going to create.
We have organised this chapter covers this process and designed in sequential steps involved in database creation. Other methods used for creation of database are SQL, and Enterprise Manager which will be discussed later.
The DBCA provides more flexible environment for creating databases as well as templates based on the already created databases.
Adding options to an existing database or to remove a database.
Database can be created using DBCA either during Oracle software installation or later manually.
Windows: Start → Programs → Oracle → Oracle Home → Configuration And Migration Tools→ Database Configuration Assistant.
Command line in Windows / Unix: type dbca from the $ORACLE_HOME/bin location. Welcome screen appears.
From among the management options select one.
Allows for the step-by-step creation of a database. The database can be created based on an existing template or customized for the specific needs of the organization.
Performs the necessary changes to move from a dedicated server to a Shared Server. You can also add database options that have not been previously configured for use with your database.
Completely removes a database and all associated files.
Manages database templates. The database templates are definitions of your database configuration saved in an XML file format on your local hard disk. You can choose from several predefined templates, or you can create customized templates.
Select appropriate Template Definition.
To display the configuration definitions for the specific Template Definition (pre-configured database) chosen, click Show Details. These details give further information about the template.
For example, under the Common Options, a list shown for the chosen database template.
The DBCA comes with several preconfigured database templates. These XML-based documents contain the information necessary to create the Oracle database. You can choose one of these predefined templates, or you can build a custom database definition. The predefined database templates are Data Warehouse, General Purpose, and Transaction Processing. These templates were designed to create databases that are optimized for a particular type of workload.
The following is the information about what is contained in template definition.
Each section of the page gives further information about the template.
Example: Under the Common Options section, a list of each of the database options is shown that gets installed for the chosen template definition.
After choosing the appropriate template to use, Click Next.
Database Identification Screen appears.
The global database name is the fully qualified name of the database in the enterprise. It is composed of a database name and a database domain and takes the format database_name.database_domain, for example, marketing.us.aceinc.com.
In this example, the first part of the global database name, marketing, is the name of your database.
The second part of the global database name—in this example, us.aceinc.com—is the domain.
Normally, the database domain is the same as the network domain within the enterprise. A global database name must be unique within a given network domain.
The Oracle system identification (SID) name is the name of the instance associated with the database. The Oracle SID can be a maximum of eight characters and must be unique on the server. For example, you cannot have two Oracle SIDs called PROD on a single server.
Manager to monitor and manage your database using the DBCA After you choose the database name, you can configure Enterprise .Management
The name of the agent service. If selected, this Management Agent manages this database and the database becomes one of the managed targets for the existing Agent.
If you don’t have an agent installed or are not doing centralized database management, you can still use Enterprise Manager to monitor and maintain the database. Choose Use Database Control For Database Management if you want EM installed, and configure it locally.
E-mail notifications are generated when certain database thresholds are reached, for example, the maximum number of database sessions. These threshold notifications can be configured after installing Enterprise Manager. To get these e-mail notifications, you’ll need the name of your SMTP mail server and the e-mail address to which e-mail notifications are to be sent.
Configuring backups of the database: If Enable Daily Backup is selected EM backs up the database to a designated area in the computer system based on the start time entered.
The prerequisite for this backup configuration is that an operating system username (with proper write authorisation) and password are to be supplied to EM to perform the backup.