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:56:04 -0700
Message-ID: <1179435364.063578.157800@k79g2000hse.googlegroups.com>


On May 17, 4:37 pm, Charles Hooper <hooperc2..._at_yahoo.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.
>
> For Oracle 8i, see page 352 Oracle 8i Administrator's Guide for
> Windows NT:
> "By default, Oracle8i uses the initialization parameter files located
> in ORACLE_BASE\ADMIN\DB_NAME\PFILE, unless you specify a different
> initialization file with the PFILE option at database startup."
> For Example:
> STARTUP PFILE=D:\ORA81\ADMIN\TEST\PFILE\INITTEST.ORA
>
> Page 361 of the same book:
> "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID {in the Windows Registry}
> includes the following parameters for an Oracle home directory on a
> computer. Depending on the products you install, additional parameters
> can also be created..." "Parameter: ORA_SID_PFILE Description: The
> full path to the initialization parameter file. Default: ORACLE_BASE
> \ADMIN\DB_NAME\PFILE\INIT.ORA"
>
> For Oracle 10g, you should be using an SPFILE with a backup of the
> parameters in a PFILE, which can be used to bring the database up in
> the event that inappropriate parameters are specified in the SPFILE
> (do not edit the SPFILE using Notepad).
>
> Charles Hooper
> IT Manager/Oracle DBA
> K&M Machine-Fabricating, Inc.

Tested in 9i (same reg hive as 8) and 10. Even with the registry pfile setting, it still looks to the database directory when starting even in 9i. If the init<dbname> file is not there, it won't start even if the pfile entry and path value is in the registry. Justed tested it out in 9 and 10. I'm fairly sure it applies to 8 because my win rmanless clone scripts were developed for 8.1.7 peoplesoft instance replication on windows. I don't believe there is a way around this other than to specify a different RDBMS_CONTROL directory, but I think it still looks for init<dbname> in the control directory and then points from there. Received on Thu May 17 2007 - 15:56:04 CDT

Original text of this message

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