Using DBCA to Configure Database Options

Using DBCA to Configure Database Options To change the database configuration, select Configure database options in a database from the Operations page.

Oracle DBA can change your configuration from a dedicated server to a shared server. Oracle DBA can add database options that have not been previously configured for use with your database, for example: Oracle Label Security or Oracle OLAP.

Read more at http://Oracleonline.info.

Delete database using DBCA

To delete a database using DBCA, select Delete a database from the Operations page.

When Oracle DBA select this option, DBCA deletes all the files associated with this database. On Windows, any associated services are also deleted.

Read more at http://Oracleonline.info.

Starting DBCA

Learn Oracle - Starting DBCA

To launch DBCA on the Windows operating system use the following procedure:

1. Log onto your computer as a member of the administrative group that is authorized to install Oracle software and create and run the database.

2. To launch DBCA on a Windows operating system select the following: Start > Programs > Oracle - home_name > Configuration and Migration Tools > Database Configuration Assistant To launch the DBCA on a UNIX, or as another method on a Windows operating system, enter the following at a command prompt: dbca which is typically found in $ORACLE_HOME/bin. The Welcome page appears.

3. Click Next to continue. Using DBCA to Create a Database Select Create a Database on the DBCA Operations page to begin a wizard that enables Oracle DBA to configure and create a database.

During the interview, Oracle DBA are asked for your input on the following:

Learn oracle - Database Templates

Learn oracle - Database Identification

Learn oracle - Management Options

Learn oracle - Database Credentials

Learn oracle - Storage Options

Learn oracle - Database File Locations

Learn oracle - Recovery Configuration

Learn oracle - Database Content

Learn oracle - Initialization Parameters

Learn oracle - Database Storage

Learn oracle - Creation Options

Note that most pages of the wizard provide a default setting that Oracle DBA can accept. To accept all the default parameters, Oracle DBA can click Finish at any step. Database Templates This page enables Oracle DBA to select the type of database Oracle DBA want to create.

By default, Oracle Corporation ships pre-defined templates. There are templates for Data Warehouse, General Purpose, and Transaction Processing databases. 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 Oracle DBA are not sure, select the default General Purpose template. For more complex environments, Oracle DBA may want to select the Custom Database option. This will result in a more extensive interview and it will take longer to create your database, since a database creation script must be run.

Read the complete article at http://Oracleonline.info/dbca_create.html.

Installing Your Oracle Software and Database

These steps provide a summary of the installation process. Online help is available to provide further direction in the choices that Oracle DBA make.

1. Log on to your computer as a member of the administrative group that is authorized to install Oracle software and create and run the database. Refer to your operating specific documentation or contact your system administrator find out if Oracle DBA have the necessary privileges to install new software.

2.Insert the distribution CD for the database into your CD drive. The Autorun window will appear automatically. Select Install/Deinstall Products. If downloading from Oracle’s download site, follow the instructions given on the Web site.

3. The Oracle Universal Installer Welcome page appears. Select Next to begin the installation of your software

4. Linux and Unix Only. If this is the first time that Oracle DBA are installing any Oracle software on this machine, the following occurs: The Specify Inventory Directory page appears. Oracle DBA must specify a directory for installation files and the name of an operating system group that has write permission to the directory. OUI uses this location to keep track of all Oracle software. This information is used while applying patches to or upgrading and existing installation and while deinstalling Oracle software. Note that this area is different from the Oracle home, which Oracle DBA specify later. Select Next to continue. A dialog page appears. You are asked to open a new terminal window, log in as root, and to run the oraInst.sh script. When the script finishes, return to the Oracle Universal Installer page and select Continue.


Read the complete steps at http://Oracleonline.info