4 Replies Latest reply on Sep 5, 2013 10:19 AM by Pradeepcmst



      Hi all experts,

      I am new to RAC. My 11GR2 running on windows machine. Could you please tell me how i can find out

      1) How many asm instance and name of the asm database instance in RAC by executing windows command line or some other ways?

      2) How i can connect to RAC database through comand line and how i can find out their name.


      Please help


        • 1. Re: RAC HELP

          Please help

          • 2. Re: RAC HELP

            Q1: You can have only one ASM instance per node, you find out its name in the same way that you would for a non-RAC environment.

            Q2: Connect, using operating system authentication, exactly as you would for a single instance database.


            Can you explain your situation? It sounds as though you are not familiar with Oracle at all, never mind RAC.

            • 3. Re: RAC HELP

              John ,

              Thanks for your explanation . No I m familiar with oracle

              • 4. Re: RAC HELP

                Hi Abu,


                1) If you have n nodes, you will have n ASM instances and db instances. Coz for each and every node one ASm and one db instances will be running. And if you want to know the name of each ASM instances,


                First go to grid_home/bin and execute ./olsnodes -n --> to find out the hostnames and hostnumber in your cluster.

                eg:  let us take 2 node rac as example.

                hostname1     1

                hostname2      2


                Now we got  the hostname and its number in the cluster

                Then again from grid_home/bin, execute

                ./srvctl status asm -n <hostname>  ---> this command will show the asm instance name and its status on the particular node


                2) Say for example if your database name is ORCL, then ORCL1 is the db  instance name on the first node, ORCL2 is the db instance name  on the second node and so on............

                No matter how many nodes you have, the database name is common. ie ORCL. You would've configured this ORCL database entry in your client tnsentry.

                so Just export ORACLE_SID and connect it as you would connect to normal database. you will be connected then.


                Hope this would've cleared your queries.!!



                Pradeep. V