RE: locating the init.ora
- From: Branimir Petrovic <BranimirP@xxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 3 Sep 2004 12:56:35 -0400
> 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@xxxxxxxxxxxxx&subject=unsubscribe
To search the archives - //www.freelists.org/archives/oracle-l/
Other related posts:
