SYSASM not granted to sys. « AskDBA.org Forum

SYSASM not granted to sys.

(2 posts)

Average Rating For This Topic:

Rate This Topic Yourself:

No tags yet.

nhameed

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

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.

Posted 6 months ago #
Amit Bansal

Oracle DBA
Joined: Jun '08
Posts: 44
offline
Reputation:57

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/

Posted 6 months ago #

You must log in to post.