This forum is currently locked. You can't register or post questions at this time. (read more)

ASM questions

All posts relating to Oracle database administration.

Moderator: Tim...

kytemaniac
Senior Member
Posts: 234
Joined: Tue May 19, 2009 12:59 am

ASM questions

Postby kytemaniac » Thu Apr 04, 2013 8:26 am

Hi,

firstly is how do I know the version of ASM? Is the following command correct way to find out version of current asm installed? also what's the difference between these 3 commands? looks to me it is the same.

Code: Select all

-bash-3.2$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.3.0]
-bash-3.2$ crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [11.2.0.3.0]
-bash-3.2$ crsctl query crs softwareversion
Oracle Clusterware version on node [sllin1pb] is [11.2.0.3.0]



crsctl query crs activeversion from http://docs.oracle.com/cd/E11882_01/rac ... m#CHEBJCEJ
crsctl query crs releaseversion http://docs.oracle.com/cd/E11882_01/rac ... m#CHEDGJEF
crsctl query crs softwareversion http://docs.oracle.com/cd/E11882_01/rac ... m#CHEFEDFC

is there a way to connect to ASM remotely?

from http://docs.oracle.com/cd/E11882_01/ser ... m#CHDEJIIF

it din mentioned whether it can be connected remotely or not, if yes how to connect to asm instance remotely? +ASM1, +ASM2 or ASM as service name?

I've verified my environment

Code: Select all


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
-bash-3.2$ echo $ORACLE_HOME
/u01/app/11.2.0/grid
-bash-3.2$ echo $ORACLE_SID
+ASM2
-bash-3.2$
-bash-3.2$ echo $PATH
/u01/app/11.2.0/grid/bin:/usr/sbin:/usr/lib64/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin



Code: Select all

SYS@+ASM2>select name, open_mode from v$database;
select name, open_mode from v$database
                            *
ERROR at line 1:
ORA-01507: database not mounted




Can we check the status of ASM from sqlplus connection as sysasm?

thanks a lot!

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: ASM questions

Postby Tim... » Thu Apr 04, 2013 9:12 am

Hi.

1) ASM Verison...

You've answered your own question really. :)

These three commands all report similar things, but there are subtle differences. In a static environment, they will all report the same thing. If you are in the middle of a rolling upgrade, the commands may report differing version, depending on where in the upgrade process you are. I'm not sure I can say it better than the documentation already does.

2) Remote connection...

Connections to ASM instances are just like those to databases, so yes, you can, provided the listener is set up to listen for them and you are using the correct tnsnames.ora entry in your client.

3) Status from sqlplus...

So you are connecting to an ASM instance and expecting it to respond like a database? Interesting. :) Remember, an ASM instance is not a database instance, so you can;t expect it to function like one. You can query from the ASM views:

http://www.oracle-base.com/articles/10g ... #asm_views

If I remember correctly you will also be able to query the v$instance view. I don't have an ASM instance here to test this though, so I could be wrong.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 0 guests

cron