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

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