SYSASM not granted to sys.

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • 9 January, 2010 at 10:22 am #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.

    • 12 January, 2010 at 6:25 am #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.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.