OpenVMS: DBCA tips for Oracle RDBMS 10.2.X (Doc ID 391598.1)

Last updated on APRIL 14, 2022

Applies to:

Oracle Database Configuration Assistant - Version 10.2.0.2 and later
HP OpenVMS Alpha
HP OpenVMS Itanium

Purpose

To provide helpful information related to the Database Configuration Assistant (DBCA).

Scope

Anyone needing assistance using the DBCA tool for release 10.2.X on hp OpenVMS. This is intended to
supplement the information already available in the VMS specific Installation and Administration guides.
This note covers both the Alpha and Itanium platforms.

Details

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Tip 1. Use UNIX style syntax for all paths.

Tip 2. DBCA logs database creation

Tip 3. DBCA will enable flash recovery by default and place the archive logs in the directory specified by db_recovery_file_dest.

Tip 4. DBCA can be started from OUI.

Tip 5. DBCA can be used to generate database creation scripts that you can then modify and run manually.

Tip 6. Using DBCA to delete a database does not remove 100% of the database related files.

Tip 7. Define the OpenVMS logical ora_db_nonrac_install if you are NOT creating a RAC db.

Tip 8. DBCA Step 4 of 12, Management Options

Tip 9. DBCA Step 9 of 12, Database Components

Tip 10. DBCA creates the redo log files with a .log extension.

Tip 11. The SID must be 6 or fewer characters.

Tip 12. DBCA database templates are seeded from 10.2.0.2 database format.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.