OpenVMS: DBCA Generates Incomplete Scripts For Database Creation (Doc ID 1425617.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.2 and later
HP OpenVMS Alpha
HP OpenVMS Itanium

Symptoms

The DBCA is used to generate the scripts for database creation.

After the summary screen when the <finish>  button is used,  the pop-up screen with the progress bar is not shown.

Only two files files are created :
<instance_name>.com
<instance_name>.sql

These files are incomplete.

The <instance_name>.sql has as content:
---
set verify off
PROMPT specify a password for sys as parameter 1;
DEFINE sysPassword = &1
PROMPT specify a password for system as parameter 2;
DEFINE systemPassword = &2
---

A DBCA debug trace (after setting logical DBCA_DEBUG) ends with:

.../...
[TaskScheduler timer] [12:51:12:89] [Host.executeSteps:-1] Executing steps....
[TaskScheduler timer] [12:51:12:134] [Host.setUpForOperation:-1] setUpForOperation: Mode = 2
[TaskScheduler timer] [12:51:12:540] [Host.executeSteps:-1] setupForOperation returned: true
[TaskScheduler timer] [12:51:12:581] [Host.createStepSQLInterface:-1] sid =apltst
[Thread-9] [12:51:12:753] [StepContext$ModeRunner.run:-1] ---- Progress Needed:=true
[AWT-EventQueue-0] [12:51:43:151] [DBCAWizard.onFinish:-1] m_bFinishClicked: true



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms