SYSASM not granted to sys.

nhameed

new member
Joined: Jan '10
Posts: 1
offline
Reputation:2

Posted 2 years ago
#

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.
Amit Bansal

Oracle DBA
Joined: Jun '08
Posts: 73
offline
Reputation:96

Posted 2 years ago
#

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.

Cheers
Amit
http://askdba.org/weblog/

Reply

You must log in to post.