Re: apps password

Srinivas,

Connect to your database as sysdba (on your db-node)
sqlplus
SQL> conn /as sysdba
SQL> select account_status from dba_users where username='APPLSYS';
-- The o/p should show the account is locked.
SQL> alter user applsys account unlock;

Next, on your application node, resume the adadmin session

Thanks,
Vikram

On Sat, May 3, 2008 at 12:40 PM, k srinivas <k.sridba@xxxxxxxxx> wrote:

> Hi Vikram,
>
> Thanks for the prompt response .
>
> .When I try to connect as applsys user... it shows account is locked .
> .GUEST user password is not changed recently .
> .Vikram .. How to find the ATG level ..
>
> Thanks,
> Sri
>
>
>   On 5/3/08, vikram singh <vikramsingh120@xxxxxxxxx> wrote:
> >
> > Srinivas,
> >
> > - Can you check if you are able to connect to SQL*Plus as APPLSYS user?
> > - Also, can you confirm if the GUEST user password has not been changed
> > recently? If changed, does it reflect correctly in the profiles, and dbc
> > file as well?
> > - What ATG level are you in?
> >
> > Thanks,
> > Vikram
> >
> >  On Sat, May 3, 2008 at 11:56 AM, k srinivas <k.sridba@xxxxxxxxx> wrote:
> >
> > > DBAS,
> > >
> > > I Have a mutinode setup with only database on one node and other
> > > application(viz. Forms,Reports,CM,Apache) on the
> > > other node .When I try to connect to the application tier through
> > > SQLPLUS with apps user it connects .But when I run adadmin and pass apps
> > > password it does not connect (user/password is incorrect) . Please help me
> > > out in resolving this .
> > >
> > > Thanks in advance
> > > Sri ...
> > >
> >
> >
>

Other related posts: