Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to Change ini.ora filename on Windows?

Re: How to Change ini.ora filename on Windows?

From: EscVector <Junk_at_webthere.com>
Date: 17 May 2007 13:36:55 -0700
Message-ID: <1179434214.955798.11480@q23g2000hsg.googlegroups.com>


On May 17, 4:35 pm, EscVector <J..._at_webthere.com> wrote:
> On May 17, 4:06 pm, "red_val..._at_yahoo.com" <red_val..._at_yahoo.com>
> wrote:
>
> > I've inherited Oracle databases which use the filename "init.ora" for
> > the instance initialization file regardless of database/sid name. I'd
> > like to rename these files to something more readily identifiable.
> > How do I do this?
>
> > Running Oracle 8i on Win2000; 10g on Win2003.
>
> On windows, Oracle default the init directory to %ORACLE_HOME%
> \database directory.
>
> You should see files with the init<dbname>.ora in this directory.
>
> I you really are using a file called ini.ora to start all the
> databases you'll have to post more info, because I don't think it
> works like that.
>
> You can IFILE from database directory from a file called
> init<dbname>.ora and then point to a single file, but you start in the
> database directory and call a dbnamed file.

This is also the default SPFILE directory on Windows. If an SPFILE is found here it will use it instead of the init<dbname>.ora file. Received on Thu May 17 2007 - 15:36:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US