Re: Initialisation file riddle

"Thomas Kyte" <tkyte_at_oracle.com> wrote in message news:aa7jaa015fv_at_drn.newsguy.com...

> care to share -- show the cut and paste of the lines surrounding the
> utl_file_dir when it does not work, show the error you get upon startup,
show
> the workaround that is working.
>

Sorry Tom,
I am not sure I caught your point, do you want me to include the initialisation file specs here or not ?

In either case, I tried to start the DB using DBA Studio, which is asking for an initialisation file and by default it prompts you with a default entry created in the %ORACLE_HOME%/sysman/ifiles, called def<instance>.ORA I put the UTL_FILE_DIR at the end of this file and startup failed. Then I tried a different approach, since DBA studio comes with a button showing all the initialisation settings and there was an empty box for this parameter. I put the value "D:\data" there and then I tried to save the contents to a new file.
With great surprise the file was created but it didn't contain the UTL_FILE_DIR! (DBA studio bug??)

Then i took the original initialisation file and I put it under %ORACLE_BASE%\Admin\<instance>\pfile, then I created another file containing only the UTL_FILE_DIR parameter and put it there too. Then I went back to the sysman\ifiles directory and changed the def<instance>.ora so that it containted just two lines like these:
IFILE=%ORACLE_BASE%\Admin\<instance>\pfile\init.ora IFILE=%ORACLE_BASE%\Admin\<instance>\pfile\utl.ora

It works as I can finally see the UTL_FILE_DIR containing what I need and my procedure can read and write files from that directory.

I wonder if the problem is just a DBA studio bug as I didn't try to start up the database using other methods.

Bye,
Flavio Received on Thu Apr 25 2002 - 05:26:28 CDT