Re: init.ora file?

Your guess was correct,

init.ora.21200311 is your init.ora file (although i was expecting something like init_21200311.ora, maybe they changed format in 9i). The additional numbers could be the date when the database was created in DDYYYYMM format? (just a guess)

The other file is a parameter file which is called from init.ora. Setup info and additional database parameters can be placed in here. Best to check to see if your init.ora actually calls it.

M

"James" <james_at_nothing.com> wrote in message news:<1046258310.824258_at_ftp.adept.co.za>...
> Hi there
> I'm using Oracle 9 on a windows 2k machine.
> I can't find the init.ora file!
> I can find the init.ora.21200311 file in the f:\oracle\admin\seconddb\pfile
> directory. Is this the file that is termed init.ora? If so how does the last
> part of the name get made? (the 21200311?)
>
> Secondly I also have a SPFILESECONDDB.ora file in the
> f:\oracle\ora92\database directory
>
> Hope someone can help
> Thanks in Advance
> Cheers
> James
Received on Wed Feb 26 2003 - 08:27:56 CST