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

Jeffrey Yee wrote:
>
> 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.
>
> Also, there is no $ORACLE_BASE/admin directory. Is this normal?
>
> 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

It will probably be using an SPFILE (a binary version of the init.ora). It is still a .ora file, so a search under $ORACLE_HOME for *.ora will turn it up if its gone 'missing'

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"