Re: How to find out concrete ORACLE_HOME via SQL?

On 13 Aug 2006 13:33:33 -0700, nitelyjoy_at_ist-einmalig.de wrote:

>While getting deeper into the question, we got a trick to filter a well
>fitting library from DBA_LIBRARIES that reveals the value of
>ORACLE_HOME. But is there something official, that works well with any
>oracle version?
>

There is not.

You can't retrieve Oracle_home. Nor should you need it. If you did install the sw you know it, and if you didn't install the sw but can't ask the DBA, your purposes are apparently not legitimate.

>Our problem is to calculate the location of the password files
>"?/dbs/orapw<SID>.ora" (unix) and "?/database/orapw<SID>.ora" (windows)
>respectively. We didn't find these values in v$parameter or similar
>either.

Why do you think you need that? For hacking purposes?

--
Sybrand Bakker, Senior Oracle DBA