sysasm privilege [message #438452] |
Sat, 09 January 2010 03:52 |
nhameed
Messages: 3 Registered: January 2010 Location: Jeddah
|
Junior Member |
|
|
Hi,
I have upgrade my Oracle RAC 10g to 11.2.0 RAC. during the upgrade I have migrated the ASM also and use the existing Linux group dba as asmos , asmdba. the sys user suppose to have sysasm privilege. but when I see V$pwfile_user view, against sys user I dont have sysasm privilege. So I cannot connect with any of my ASM instance. Anyone has idea how can I grant sysasm privilege to sys.
Thanks
|
|
|
Re: sysasm privilege [message #438462 is a reply to message #438452] |
Sat, 09 January 2010 05:14 |
John Watson
Messages: 8958 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Nothing in v$pwfile_users need not be a problem, operating system authentication will do:
C:\Users\john\home>
C:\Users\john\home>set ORACLE_SID=+jonasm
C:\Users\john\home>sqlplus / as sysasm
SQL*Plus: Release 11.1.0.7.0 - Production on Sat Jan 9 11:11:42 2010
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options
+jonasm> sho user
USER is "SYS"
+jonasm> select value from v$parameter where name='instance_type';
VALUE
----------------------------------------------------------------------
asm
+jonasm> select * from v$pwfile_users;
no rows selected
[Updated on: Sat, 09 January 2010 11:52] Report message to a moderator
|
|
|
|