Oracle 11g dbca templates

We're a place where coders share, stay up-to-date and grow their careers. We finally started creating some Databases once we made sure Marvin stopped whining about why the automatic doors of the spaceship had to be so cheerful. Sometimes however, what you want is to personalize a new DB you need to create or even clone a DB you already have in your cluster.

That is what we are going to explore today, some personalization and cloning using DBCA templates. Sometimes you want to create a new Database keeping the same configuration you have in a DB you have already in the system, but that doesn't mean you want to close its content. To make sure we are not using a "default" Database, lets modify the Database and add some data this will helpful later for another part of the guide into our already existing database "db".

Lets now create a new Database using that new template and confirm is created with "db" configuration. The new Database will be called "test" I know.. The wizard requests your input on the following:. Note that most windows of the wizard provide a default setting. To accept all the default parameters, you can click Finish at any step. DBCA displays a final confirmation window.

Click OK to initiate the database creation. This window enables you to select the type of database you want to create. By default, Oracle ships pre-defined templates. The templates contain settings optimized for workload. Click Show Details to see the configuration for each type of database. Choose the template suited to the type of workload your database will support. If you are not sure which to choose, select the default General Purpose template. For more complex environments, you can select the Custom Database option.

This option results in a more extensive interview, which means that it will take longer to create your database because a database creation script must be run. In the SID box, enter the Oracle system identifier. The SID defaults to the database name and uniquely identifies the instance that runs the database. Use this window to set up your database so it can be managed with Oracle Enterprise Manager.

Oracle Enterprise Manager provides Web-based management tools for individual databases, as well as central management tools for managing your entire Oracle environment.

Select one of the following options:. If the Oracle Management Agent has been installed on your host computer, then you have the option of selecting central management by selecting Use Grid Control for Database Management. If you select this type of management, you must also indicate which management service to use in the drop-down menu.

If you choose this option, you can additionally check Enable Email Notifications for Oracle to e-mail you alerts regarding potential problems, and check Enable Daily Backup. Click Help for more information about these options. Select Use the Same Password for All Accounts and enter the password to use the same password for all accounts. Specify the type of storage mechanism you would like your database to use.

For more information, refer to "Installation Choices". In this window, you specify the Oracle home and directory path in which to install the Oracle software. Choose one of the following:. Later, you can make modifications to database filenames and locations. All the database files will be created in this location. Use Oracle-Managed Files —Select this option to have Oracle directly manage operating system files comprising an Oracle database.

You specify default location called a database area for all your files. Oracle thereafter automatically creates and deletes files in this location as required. You can also create multiple copies of your redo and online log files by selecting Multiplex Redo Logs and Control Files.

To learn more about redo logs and control files, refer to Chapter 9, "Performing Backup and Recovery". Selecting this option enables you to delegate the complete management of database files to the database.

You no longer need to specify the filenames, location, or their sizes. When you create a new database, it is important to configure the database so you can recover your data in the event of a system failure. You can select the following options:. Specify Flash Recovery Area —Select this option to specify a backup and recovery area and specify its directory location and size.

You can use variables to identify standard locations. To review or add additional locations, click File Location Variables at the bottom of the window. Enable Archiving —Select this option to enable archiving of database redo logs, which can be used to recover a database.

You can accept the default archive mode settings or change them by selecting Edit Archive Mode Parameters. Oracle recommends you select Enable Archiving. Selecting this option provides better protection for your database in the case of software or hardware failure. If you do not select this option now, you can enable archive log mode later. The Sample Schemas provide a common platform for examples.

Oracle books and educational materials contain examples based upon the Sample Schemas. This appendix explains how you can use Database Configuration Assistant DBCA to create templates for structuring newly created databases. Note that DBCA can also be used to create scripts for creating databases using the templates. The necessary options for creating templates and scripts in the DBCA help have been highlighted in this appendix. Creating Sample Script template and Bases. Creating a Template from an Existing Database.

Creating a Clone Template from an Existing Database. Query for help by specifying the following options: -h -help Query for help by specifying the following options:-h -help.

Skip Headers.