http://www.forum.askdba.org/ Forum for Oracle DBA's en Sun, 12 Feb 2012 09:23:00 +0000 http://www.forum.askdba.org/topic/sysasm-not-granted-to-sys#post-119 Tue, 12 Jan 2010 06:25:34 +0000 Amit Bansal 119@http://www.forum.askdba.org/ <p>As per upgrade guide, you had to add a user to password file before upgrading ASM instance.</p> <p><a href="http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/upgrade.htm#BABEJBFD" rel="nofollow">http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/upgrade.htm#BABEJBFD</a></p> <p>Did you try recreating password file for ASM?Use orapwd to do same.<br /> If it still doesn't work, then would recommend you to raise SR. </p> http://www.forum.askdba.org/topic/sysasm-not-granted-to-sys#post-118 Sat, 09 Jan 2010 10:22:15 +0000 nhameed 118@http://www.forum.askdba.org/ <p>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. </p>