Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to find out concrete ORACLE_HOME via SQL?
On 14 Aug 2006 12:12:51 -0700, "NitelyJoy" <nitelyjoy_at_ist-einmalig.de>
wrote:
>Imagine, you have direct server access and you are the new DBA und you
>never saw the former DBA, which was fired by your boss. You see 3
>apparently fitting ORACLE_HOMEs. Which one was used to start up the
>instance? - You just have the trial and error method...
incorrect. Just search for init<sid>.ora or spfile<sid>.ora
-- Sybrand Bakker, Senior Oracle DBAReceived on Mon Aug 14 2006 - 16:34:13 CDT
![]() |
![]() |