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.