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

From: EscVector <Junk_at_webthere.com>
Date: 17 May 2007 13:35:23 -0700
Message-ID: <1179434123.618178.265970@p77g2000hsh.googlegroups.com>

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. Received on Thu May 17 2007 - 15:35:23 CDT