This discussion is archived
9 Replies Latest reply: Oct 20, 2009 1:43 AM by 670690 RSS

ORA-15055: unable to connect to ASM instance

670690 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Toni,

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points