Re: anyone deployed 10gR2 grid control agent on 11gR2 target?
- From: Scott Sibert <ssibert@xxxxxxxxx>
- To: litanli@xxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Dec 2010 13:10:26 -0600
Have you tried: sqlplus / as sysasm
and then try to change the password?
On Thu, Dec 16, 2010 at 1:04 PM, Li Li <litanli@xxxxxxxxx> wrote:
> 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@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@xxxxxxxxx>
> 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@xxxxxxxxx>
> 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@xxxxxxxxx> 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!
> >>>
> >>>>
> >>>>
> >>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
