9 Replies Latest reply: Oct 20, 2009 3:43 AM by 670690 RSS

    ORA-15055: unable to connect to ASM instance

    670690
      Hello Oracle GURU`s!

      I have a problem with creation of a tablespace in +ASM.

      I have manually created ASM instance and diskgroups for it:

      SQL> SELECT group_number "GROUP", disk_number "DISK", mount_status,
      2 header_status, state, path
      3 FROM v$asm_disk;

      GROUP DISK MOUNT_S HEADER_STATU STATE
      ---------- ---------- ------- ------------ --------
      PATH
      --------------------------------------------------------------------------------
      1 0 CACHED MEMBER NORMAL
      D:\ORACLE\PRODUCT\10.2.0\ORADATA\ASMFILES\_FILE_DISK1

      1 1 CACHED MEMBER NORMAL
      D:\ORACLE\PRODUCT\10.2.0\ORADATA\ASMFILES\_FILE_DISK2

      2 0 CACHED MEMBER NORMAL
      D:\ORACLE\PRODUCT\10.2.0\ORADATA\ASMFILES\_FILE_DISK3


      SQL> select group_number, name from v$ASM_DISKGROUP;
      GROUP_NUMBER NAME
      ------------ ------------------------------
      1 DGROUP1
      2 DGROUP2

      SQL> show parameter asm_diskgroups;
      NAME TYPE VALUE
      ------------------------------------ ----------- ------------------------------
      asm_diskgroups string DGROUP1, DGROUP2




      But when I try to create a a table space from a DB Instance I receive below error:

      SQL> Create tablespace ASM_TBS_ONE Datafile '+DGROUP1' size 200m;
      Create tablespace ASM_TBS_ONE Datafile '+DGROUP1' size 200m
      *
      ORA-01119:
      ORA-17502:
      ORA-15001:
      ORA-15055: unable to connect to ASM instance
      ORA-01031: insufficient privileges
        • 1. Re: ORA-15055: unable to connect to ASM instance
          516450
          Is the ASM instance is of 11gR2? If yes, does your user account belong to both SYSDBA and SYSASM groups? Also, can you paste the extract from the alert logs of both the RDBMS and ASM database when this error occurred?
          • 2. Re: ORA-15055: unable to connect to ASM instance
            Satishbabu Gunukula
            See the below link on same issue and solution

            http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=13910

            Hope this helps
            Click here for steps to [upgrade Oracle version to 10.2.0.4|http://www.oracleracexpert.com/2009/10/oracle-version-upgrade-from-1020x-to.html]
            Click here to [Migrate Non-ASM Database to ASM using RMAN|http://www.oracleracexpert.com/2009/10/migrate-database-to-asm-using-rman.html]
            http://www.oracleracexpert.com
            • 3. Re: ORA-15055: unable to connect to ASM instance
              670690
              ASM instance is of 10gR2;
              My user account belongs to SYSDBA group;
              Here is some log info:

              DB ALERT LOG:
              ORA-1119 signalled during: Create tablespace ASM_TBS_ONE Datafile '+DGROUP1' size 200m...
              Tue Oct 20 09:21:36 2009
              MMNL absent for 58837 secs; Foregrounds taking over
              Tue Oct 20 09:33:14 2009
              Create tablespace ASM_TBS_ONE Datafile '+DGROUP1' size 200m
              Tue Oct 20 09:33:16 2009
              Starting background process ASMB
              ASMB started with pid=21, OS id=5168
              Tue Oct 20 09:33:17 2009
              ORA-1119 signalled during: Create tablespace ASM_TBS_ONE Datafile '+DGROUP1' size 200m...

              *** 2009-10-20 09:35:41.286
              kcrrwkx: nothing to do (end)

              DB UDUMP
              *** 2009-10-20 09:33:15.624
              *** SERVICE NAME:(SYS$USERS) 2009-10-20 09:33:15.592
              *** SESSION ID:(154.136) 2009-10-20 09:33:15.592
              2009-10-20 09:33:15.592: [  OCROSD]utgdv:11:could not read reg value ocrmirrorconfig_loc os error= The system could not find the environment option that was entered.

              2009-10-20 09:33:15.624: [  OCROSD]utgdv:11:could not read reg value ocrmirrorconfig_loc os error= The system could not find the environment option that was entered.

              2009-10-20 09:33:16.795: [  OCROSD]utgdv:11:could not read reg value ocrmirrorconfig_loc os error= The system could not find the environment option that was entered.

              2009-10-20 09:33:16.795: [  OCROSD]utgdv:11:could not read reg value ocrmirrorconfig_loc os error= The system could not find the environment option that was entered.


              OCSSD.log
              [    CSSD]2009-10-20 09:33:15.655 [3240] >TRACE: clssgmClientConnectMsg: Connect from con(01B9A810) proc(00CA5088) pid(5668) proto(10:2:1:1)
              [    CSSD]2009-10-20 09:33:16.795 [3240] >TRACE: clssgmClientConnectMsg: Connect from con(01B9A810) proc(00CA5088) pid(5668) proto(10:2:1:1)
              • 4. Re: ORA-15055: unable to connect to ASM instance
                670690
                Marko Kusej says: "I've changed the Windows service accounts for the Oracle Services (CS, ASM, DB) using an appropriate Windows user being in ORA_DBA + Admin groups."


                I have not experienced that type of problems ever before. How do I do what Marko says fixed the problem?
                Thank you!
                • 5. Re: ORA-15055: unable to connect to ASM instance
                  Toni Lazarin
                  Maybe you have os privileges related issue, so check that you are using correct ASM sid and that the database has OS privileges for ASM SYSDBA.
                  What OS is that ?
                  If those db servers are on windows, have in mind that it's reccomended that those servers are not acting as domain controlers also,
                  http://oraclepitstop.wordpress.com/about/installing-oracle-10g-r2-rac-on-windows-2003-with-domain-controller/
                  so, add the user directly to local Administrator and ORA_DBA groups if it is currently defined in a domain group on a remote server.
                  • 6. Re: ORA-15055: unable to connect to ASM instance
                    670690
                    Toni,

                    I am using Windowx XP Pro and it is not a domain controller, but this PC is in domain.
                    • 7. Re: ORA-15055: unable to connect to ASM instance
                      670690
                      And my domain user is added to local administrator group and to ORA_DBA group

                      Edited by: Jopa on 20.10.2009 1:14
                      • 8. Re: ORA-15055: unable to connect to ASM instance
                        Toni Lazarin
                        Ok.
                        It seems you are facing asm privileges related issue.
                        Spare some time reading the following documents and you should be fine:
                        [How ASM disks are discovered|http://download.oracle.com/docs/cd/E11882_01/server.112/e10500/asmdiskgrps.htm#CHDEDBBG]
                        [About privileges for using ASM|http://download.oracle.com/docs/cd/E11882_01/server.112/e10500/asminst.htm#CHDEDIID]
                        • 9. Re: ORA-15055: unable to connect to ASM instance
                          670690
                          Toni,

                          Will do and get back to you with the results. Thank you