OraFAQ Forum: Unix » Table storing Oracle Home

Home » Infrastructure » Unix » Table storing Oracle Home (Oracle on Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table storing Oracle Home [message #334396]

Wed, 16 July 2008 06:36

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

Report message to a moderator

Re: Table storing Oracle Home [message #334399 is a reply to message #334396]

Wed, 16 July 2008 06:39

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Nowhere.

Regards
Michel

Report message to a moderator

Re: Table storing Oracle Home [message #334416 is a reply to message #334399]

Wed, 16 July 2008 07:27

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?

Report message to a moderator

Re: Table storing Oracle Home [message #334422 is a reply to message #334416]

Wed, 16 July 2008 07:41

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.

Report message to a moderator

Re: Table storing Oracle Home [message #334430 is a reply to message #334416]

Wed, 16 July 2008 07:56

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Table storing Oracle Home [message #334432 is a reply to message #334422]

Wed, 16 July 2008 08:01

mruravner
Messages: 5
Registered: July 2008

Junior Member

How to open a databse?

Report message to a moderator

Re: Table storing Oracle Home [message #334436 is a reply to message #334432]

Wed, 16 July 2008 08:12

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

alter database open;

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

Regards
Michel

Report message to a moderator

Re: Table storing Oracle Home [message #334587 is a reply to message #334396]

Thu, 17 July 2008 04:24

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

Report message to a moderator

Re: Table storing Oracle Home [message #334595 is a reply to message #334587]

Thu, 17 July 2008 05:19

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator