Home » RDBMS Server » Security » sysasm privilege (11.2.0)
sysasm privilege [message #438452] Sat, 09 January 2010 03:52 Go to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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

Re: sysasm privilege [message #438520 is a reply to message #438462] Sun, 10 January 2010 03:20 Go to previous message
nhameed
Messages: 3
Registered: January 2010
Location: Jeddah
Junior Member
Thanks for the reply. The problem solved, I was setting wrong ORACLE_HOME entry.
Previous Topic: sql_text in dba_audit_trail is not populating
Next Topic: Script to list users with select on v$views
Goto Forum:
  


Current Time: Fri Mar 29 00:32:53 CDT 2024