OpenVMS: DBCA Generates Incomplete Scripts For Database Creation
(Doc ID 1425617.1)
Last updated on AUGUST 01, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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
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
| Symptoms |
| Cause |
| Solution |