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.

init.ora and the UTL_FILE_DIR parameter?

390534Jul 30 2003 — edited Jul 30 2003

Anyone,

I can not get the UTL_FILE_DIR parameter to set on a Windows 2000 Oracle 9.2.0.1.0 Installation.

I have looked in this group and followed all previous suggestions. "No spaces","proper slashes" etc... etc...

It would appear that I am possibly using the wrong init.ora file since I change other params like xyz and I do not see them chaged via SHOW PARAMETER xyz.. after restarting.

Why do my init.ora files now look like init.ora.6172003113929 and a couple others (one for each instance I have on the machine inside their respective \admin\SID\pfile dirs). None discusses this new numbering scheme on the file in this group at all. Everyone discisses init<SID>.ora and no number stuff.

I tried to do a command line startup where I specified the correct init.ora.617.... it acted like it worked but now I broke my Windows service startup so that it appears to start Oracle but I can not connect... However if I start it via command line as below I can connect fine...
oradim -STARTUP -SID MYINST -USRPWD pwd -STARTTYPE srvc,inst

Any ideas what has happened? How do I get the system back to using whatever init.ora was previously working and actually see which one I am using after startup?

Then I will resume issue on why UTL_FILE_DIR will not set itself when coded inside the init file.

Thanks for any help I can get.

Miller

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 27 2003

Added on Jul 30 2003

#general-database-discussions

2 comments

492 views