5 Replies Latest reply: Jul 19, 2011 10:40 AM by 876515 RSS

    ASM Instance...


      I am new to DB, now i am working on a 4-node RAC cluster.I jus connected to ASM using ASMCMD command i am able to see the discgroup and then i have executed sqlplus and then i have connected to an instance.

      Before doing all those thing i have set my environment variables as following.

      export ORACLE_SID=+ASM1

      So now i am connected to database or to only ASM instance..is ASM instance and database instance or different??

      Please clarify my doubts..

        • 1. Re: ASM Instance...
          Sebastian Solbach -Dba Community-Oracle
          Hi Sunil,

          you are not connected to a database, just to an ASM instance.
          The main difference (besides a lot others, like other processes etc.) between an ASM instance and a normal database instance is that an ASM instance does not have and need any controlfiles/datafiles/redologfiles etc.

          So all you can do with an ASM instance is manage storage.

          • 2. Re: ASM Instance...
            Hi Sebastian,

            Thanks for your reply, actually i want make my RAC db up,i logged as sysdba but when execute startup command, i am getting the following error.

            [oracle@server ~]$ sqlplus '/ as sysdba' @ db

            SQL*Plus: Release Production on Thu Mar 10 16:50:21 2011

            Copyright (c) 1982, 2009, Oracle. All rights reserved.

            Connected to an idle instance.

            SP2-0310: unable to open file "db.sql"
            SQL> startup
            ORA-01078: failure in processing system parameters
            ORA-01565: error in identifying file 'DATA/sunil/spfilesunil.ora'
            ORA-27037: unable to obtain file status
            Linux-x86_64 Error: 2: No such file or directory
            Additional information: 3

            I am not sure, why it is poiting some other spfile, even though i mentioned instance specifically.what could be the reason?

            • 3. Re: ASM Instance...
              Need some more info regarding my problem.
              • 4. Re: ASM Instance...
                I got the clear explanation.
                • 5. Re: ASM Instance...
                  How did you get the clear explanation?

                  BTW - if you don't give a path on your startup command it chooses a deafult location which is $ORACLE_HOME/dbs/init.ora or spfile.ora file and tries to open it up from there.

                  Hope this helps