Home » RDBMS Server » Server Administration » Oracle RAC ASM user (Oracle 11gR2,windows 2008)
Oracle RAC ASM user [message #523885] Tue, 20 September 2011 23:42 Go to next message
jolly_makkar
Messages: 61
Registered: March 2008
Member
Dear Gurus

We have installed Oracle RAC 11gR2, installation was all successful.But i cannot see ASMSNMP user to login as ASM enterprise manager .If i tries to login as sys (even after assigning SYSASM role) he cannot login.

Any suggestions how can i login into ASM instance .

I tried login

Quote:
Set Oracle_sid=+ASM1

sqlplus / as sysasm

grant sysasm to sys;

conn sys/*** as sysasm

ORA-01031 insufficient privileges


Thanks
Re: Oracle RAC ASM user [message #523925 is a reply to message #523885] Wed, 21 September 2011 02:45 Go to previous messageGo to next message
John Watson
Messages: 4369
Registered: January 2010
Location: Global Village
Senior Member
Hi - your post appears to show something impossible: that the first connect succeeds, and the second doesn't. The syntax used is different, but the end result will be the same: connection by operating system authentication. Did you do anything else that you have not shown in your post? Can you post the actual SQL*Plus session? (Not forgetting to use code tags to format it)
Re: Oracle RAC ASM user [message #523930 is a reply to message #523925] Wed, 21 September 2011 03:36 Go to previous messageGo to next message
jolly_makkar
Messages: 61
Registered: March 2008
Member
Thankyou for your Reply

Please find below the problem with sys

Quote:
C:\Windows\system32>set oracle_sid=+asm1

C:\Windows\system32>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 21 11:25:56 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Enter user-name: / as sysasm

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> grant sysasm to sys;

Grant succeeded.

SQL> conn sys as sysasm
Enter password:
ERROR:
ORA-01031: insufficient privileges


Warning: You are no longer connected to ORACLE.
SQL>



Thanks
Re: Oracle RAC ASM user [message #523942 is a reply to message #523930] Wed, 21 September 2011 04:11 Go to previous message
jolly_makkar
Messages: 61
Registered: March 2008
Member
Thanks John It is solved

We created user in ASM instance with SYSASM privilege


Previous Topic: database creation manual error
Next Topic: CPU use with resource manager
Goto Forum:
  


Current Time: Tue Jul 22 21:31:21 CDT 2014

Total time taken to generate the page: 0.09821 seconds