OpenVMS: DBCA Generates Incomplete Scripts For Database Creation
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
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 :
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
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