Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Find ASM Home

Praveen D-OracleJul 3 2010 — edited Jul 4 2010
Hi,

My question is :

To find the ORACLE HOME we use the "echo $ORACLE_HOME" and to find the CRS HOME we use the "echo $ORA_CRS_HOME"; In the same way, What variable i have to use to find ASM HOME ?


------------------------------------
$ ps -ef |grep smon
oracle 7416 1 0 Apr08 ? 00:00:00 asm_smon_+ASM1
oracle 8218 1 0 Apr08 ? 00:06:20 ora_smon_ractest1
oracle 28210 15182 0 15:23 pts/0 00:00:00 grep smon

$ echo $ORACLE_HOME
/u01/app/oracle/product/10.2.0/db_1

$ echo $ORACLE_SID
ractest1

$ export ORACLE_SID=+ASM1

$ echo $ORACLE_SID
+ASM1

$ echo $ASM_HOME >>>>>>>>>>>>>>>>>>>>>>>>

$
$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on Sat Jul 3 15:25:11 2010

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
+ASM1


$ cat /etc/oratab
:
:
+ASM1:/u01/app/oracle/product/10.2.0/db_1:N
ractest:/u01/app/oracle/product/10.2.0/db_1:N
------------------------------------
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 1 2010
Added on Jul 3 2010
5 comments
6,516 views