OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Oracle RAC ASM user (Oracle 11gR2,windows 2008)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle RAC ASM user [message #523885]

Tue, 20 September 2011 23:42

jolly_makkar
Messages: 63
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

Report message to a moderator

Re: Oracle RAC ASM user [message #523925 is a reply to message #523885]

Wed, 21 September 2011 02:45

John Watson
Messages: 8960
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)

Report message to a moderator

Re: Oracle RAC ASM user [message #523930 is a reply to message #523925]

Wed, 21 September 2011 03:36

jolly_makkar
Messages: 63
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

Report message to a moderator

Re: Oracle RAC ASM user [message #523942 is a reply to message #523930]

Wed, 21 September 2011 04:11

jolly_makkar
Messages: 63
Registered: March 2008

Member

Thanks John It is solved

We created user in ASM instance with SYSASM privilege

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 04:48:50 CST 2024