RE: locating the init.ora

> I have inherited a w2k database that has multiple
> oracle/admin/<sid> where
> the <sid> has multiple versions for the dump file structure.
> Is there SQL I
> can use to locate which init.ora is being used?

Run regedit, inside HKEY_LOCAL_MACHINE\Software\Oracle\HOME_N (_N can be 0, 1, ... ), look for ORA_<SID>_PFILE key. String points to pfile/spfile used for SID's strartup. Open and check for IFILE parameter redirection (if any).

Branimir

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/