Re: Where is the init.ora file for the demo db (Oracle9i R2)?

"Jeffrey Yee" <jeffyee_at_hotmail.com> wrote in message news:ec4cec95.0305071700.1045e826_at_posting.google.com...
> Hi,
>
> I have just install Oracle9i 9.0.2.1 Enterprise Edition on Windows XP.
> After installation, I realise that the demo database is taken up too
> much memory. So, I search for the init<ora92>.ora file (my db name is
> ora92). To my surprise, I can't find it anywhere. I even try searching
> for files that contains 'control01.ctl, but nothing from the search
> result.

If you allowed the installer to create a 9i template database, then it will be using a file called SPFILE.ORA, which is a binary replacement for init.ora. You won't be able to edit it, because it's binary. Use 'create pfile from spfile' in sqlplus to create an old-fashioned init.ora if you want to, but if both types of file exist, Oracle prefers to use the spfile (but you can delete it once an init.ora's in place, and 9i then works exactly as 8i did in this respect).

>
> Also, there is no $ORACLE_BASE/admin directory. Is this normal?

It is certainly normal because Windows XP doesn't use forward slashes, nor dollar signs for its environment variables! But XP definitely does normally have a 'x:\oracle\admin' directory, where X is the drive you installed to.

Regards
HJR
>
> Can anyone please help me on the above question. I'm only familiar
> with Oracle 8i 8.1.7. Only this week, I start trying out Oracle9i.
>
> Thank you very much in advance for your help.
>
> Best Regards,
> Jeffrey
Received on Thu May 08 2003 - 14:33:25 CDT