Home » Infrastructure » Unix » Table storing Oracle Home (Oracle on Unix)
Table storing Oracle Home [message #334396] Wed, 16 July 2008 06:36 Go to next message
mruravner
Messages: 5
Registered: July 2008
Junior Member
Hi All,

We normally have Oracle_home in /etc/oratab file.
In which table we can get value of ORACLE_HOME if we don't want to use /etc/oratab?

Mrunal
Re: Table storing Oracle Home [message #334399 is a reply to message #334396] Wed, 16 July 2008 06:39 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nowhere.

Regards
Michel
Re: Table storing Oracle Home [message #334416 is a reply to message #334399] Wed, 16 July 2008 07:27 Go to previous messageGo to next message
mruravner
Messages: 5
Registered: July 2008
Junior Member
Pls chk this link:

http://www.psoug.org/reference/environ_vars.html

as per this link "SELECT * FROM sysman.mgmt$software_homes;" identifies home directories for Oracle products.
When run this query i am getting following message:

ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only

how this error can be rectified?
Re: Table storing Oracle Home [message #334422 is a reply to message #334416] Wed, 16 July 2008 07:41 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

ORA-01219:database not open: queries allowed on fixed tables/views only
Cause:	A query was issued against an object not recognized as a fixed table or fixed view before the database has been opened.
Action:	Re-phrase the query to include only fixed objects, or open the database.
Re: Table storing Oracle Home [message #334430 is a reply to message #334416] Wed, 16 July 2008 07:56 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
SELECT * FROM sysman.mgmt$software_homes;

Only if entreprise manager repository is installed and if you are in 10g and up.

Regards
Michel


Re: Table storing Oracle Home [message #334432 is a reply to message #334422] Wed, 16 July 2008 08:01 Go to previous messageGo to next message
mruravner
Messages: 5
Registered: July 2008
Junior Member
How to open a databse?
Re: Table storing Oracle Home [message #334436 is a reply to message #334432] Wed, 16 July 2008 08:12 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alter database open;

But if it is not open it is likely you have a problem.

Regards
Michel
Re: Table storing Oracle Home [message #334587 is a reply to message #334396] Thu, 17 July 2008 04:24 Go to previous messageGo to next message
mruravner
Messages: 5
Registered: July 2008
Junior Member
Thanks all for your help

I have found a command which gives the oracle home value

select NVL(substr(file_spec, 1, instr(file_spec, '\', -1, 2) -1) , substr(file_spec, 1, instr(file_spec, '/', -1, 2) -1)) folder from dba_libraries where library_name = 'DBMS_SUMADV_LIB';


This works on all the Oracle versions

Smile
Re: Table storing Oracle Home [message #334595 is a reply to message #334587] Thu, 17 July 2008 05:19 Go to previous messageGo to next message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is unfair to not post your source.
Maybe it is this Brian's post:
http://www.orafaq.com/forum/m/209200/102589/?srch=DBMS_SUMADV_LIB#msg_209200

Please note Frank's answer.

I'd also add this only reports the Oracle home you used when you created the database (actually when you ran catalog.sql)

Regards
Michel
Re: Table storing Oracle Home [message #334623 is a reply to message #334595] Thu, 17 July 2008 07:26 Go to previous messageGo to next message
mruravner
Messages: 5
Registered: July 2008
Junior Member
sorry Michel for not mentioning the source, but i got it from
http://tonguc.oracleturk.org/index.php/2006/09/21/how-to-get-oracle_home-from-sql-or-plsql/


Re: Table storing Oracle Home [message #334625 is a reply to message #334623] Thu, 17 July 2008 07:44 Go to previous message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks, please take care of the remarks from Frank and me.

Regards
Michel
Previous Topic: Oracle 10g R2 RAC: ASM storage configuration options
Next Topic: add string to a file of specific size
Goto Forum:
  


Current Time: Sun Apr 20 19:10:00 CDT 2014

Total time taken to generate the page: 0.11610 seconds