Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

utl_file_dir

986862Jan 24 2013 — edited Jan 24 2013
I am trying to add utl_file_dir parameter (*.utl_file_dir='*') to the newly installed Oracle 11g database to the init.ora file. But while restarting the database, the init.ora file is corrupted/missing, so we recovered the file recover flash option and started the database.

Next we tried adding the utl_file_dir parameter using SQL plus command, "alter system set utl_file_dir='*' scope=spfile", but while restarting the database, the database didn't start up throwing the error "parameters are changed" and went down.

Next we tried the option without spfile using SQL plus "alter system set utl_file_dir='*'", we are getting "ORA-02095: specified initialization parameter cannot be modified"

Any suggestions?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2013
Added on Jan 24 2013
2 comments
1,235 views