Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
#general-database-discussions
2 comments
1,229 views