init.ora and the UTL_FILE_DIR parameter?
390534Jul 30 2003 — edited Jul 30 2003Anyone,
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