Re: anyone deployed 10gR2 grid control agent on 11gR2 target?
Date: Thu, 16 Dec 2010 13:04:09 -0600
Message-ID: <AANLkTinnn8S2j6N0cYYQ3=uPeC6uLRqmVBiLWGUttxzH_at_mail.gmail.com>
Hi, Rajeev,
"alter user asmsnmp identified by" doesn't work, it gives an "insufficient privilege" error. I've tried to login as asmsnmp through SQLPLUS with no issue:
[grid_at_nrac01 ~]$ sqlplus asmsnmp as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Thu Dec 16 13:02:18 2010
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS ------------------------------ ----- ----- ----- SYS TRUE TRUE TRUE ASMSNMP TRUE FALSE FALSE
SQL> Thanks!
On Thu, Dec 16, 2010 at 11:47 AM, Rajeev Prabhakar <rprabha01_at_gmail.com> wrote:
>
> Also, can you check the permissions
> of orapwd file for asm on both nodes
> and verify sqlplus connectivity for both
> instances for the asmsnmp id.
>
> On Dec 16, 2010, at 12:37 PM, Rajeev Prabhakar <rprabha01_at_gmail.com> wrote:
>
>> Hi Li,
>>
>> Can you clarify this please ?
>>
>> Have you already tried alter
>> user asmsnmp ...and does
>> It still not work ?
>>
>> Thanks,
>> Rajeev
>>
>>
>> On Dec 16, 2010, at 10:12 AM, Li Li <litanli_at_gmail.com> wrote:
>>
>>> Yes I tried to re-configure the ASM target through grid control and I
>>> am getting the same username/password invalid error. My password is
>>> just an alphanumeric one and doesn't have any special character. This
>>> is weird. Anyone know how to change the password for user asmsnmp? I
>>> searched on metalink and couldn't find anyway to change the password.
>>> there's a note regarding creating this user but nothing about how to
>>> change an existing asmsnmp's password.
>>>
>>> Thanks!
>>>
>>>>
>>>>
>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 16 2010 - 13:04:09 CST