SYSASM not granted to sys.

This topic contains 1 reply, has 0 voices, and was last updated by  nhameed 9 years, 8 months ago.

  • Author
    Posts
  • #1910

    nhameed
    Participant

    I have upgraded 10 RAC database to 11g rac, now I cannot connect to ASM instance, in v$pwfile_users, sys dont have SYSASM privilege. How can I manually grant this privilege to SYS user.

  • #2087

    Amit Bansal
    Keymaster

    As per upgrade guide, you had to add a user to password file before upgrading ASM instance.

    http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/upgrade.htm#BABEJBFD

    Did you try recreating password file for ASM?Use orapwd to do same.

    If it still doesn’t work, then would recommend you to raise SR.

You must be logged in to reply to this topic.