LRM-00109 and ORA-01078 when Using DBCA after Modifying Creation Script Destination (Doc ID 226709.1)

Last updated on APRIL 16, 2024

Applies to:

Symptoms

Fact(s):
========

You are using the Database Configuration Assistant (DBCA) to create a database 
with Oracle 9.2 on OpenVMS. You selected to create a NEW database instead of
using one of the seed databases.


Symptom(s):
===========

After you answer all the questions and options, DBCA begins processing 
and appears to hang at 2% completion. Then you receive the error:
    ORA-01078: failure in processing system parameters

When checking the CreateDB.log file, it shows:
    LRM-00109: could not open parameter file 
        'disk$oracle:[O92.admin.test.scripts]/init.ora'
    ORA-01078: failure in processing system parameters

Note:
-----
When you do not choose to create the database immediately but save the create
scripts instead, you will get the following error when running the main create
script <SID>.COM:
    SP2-0310: unable to open file "unix_to_vms_syntax_only():"  

When reviewing the main create script <SID>.COM, you see all lines invoking 
SQL*plus show an error like:
$  sqlplus /nolog @unix_to_vms_syntax_only(): 
   ERROR, "$1$DGA112:[CFABRIE92DB.admin.CFTST.scripts]/CreateDB.sql"
   (isDirectory=false) is not representable as an OpenVMS file specification. 

Changes

You changed the directory specification on tab 8 ("Creation Options") of 
DBCA for the Generate Database Creation Scripts to store the scripts in a 
particular directory and you chose to use the OpenVMS syntax, like in:
   Destination Directory:    DISK$ORACLE:[O92.admin.test.scripts]

Cause