Re: how do I chg administrator pwd on oracle 11g 11.2.0.1.0 on Windows Professional 7?
From: ddf <oratune_at_msn.com>
Date: Sun, 11 Mar 2012 14:22:50 -0700 (PDT)
Message-ID: <21440474.2630.1331500970410.JavaMail.geo-discussion-forums_at_pbcgj3>
On Saturday, March 10, 2012 5:29:38 PM UTC-7, Ken Quirici wrote:
> On Mar 10, 6:56 pm, ddf <orat..._at_msn.com> wrote:
> > On Saturday, March 10, 2012 12:49:28 PM UTC-7, Ken Quirici wrote:
> > > help much appreciated.
> >
> > > I have 7 days.
> >
> > > Regards,
> >
> > > Ken Quirici
> >
> > Do you want to change the SYS password in Oracle or the Adminstrator password for Windows?
> >
> > David Fitzjarrell
>
> The SYS password in Oracle I would imagine. Let me fill in a little
> more: when I open sql developer it shows a connection
> to my database ORCL2 - when I click it it asks for a password. It's
> THAT password. Does that answer your question
> fully? I get the message that the pwd is expiring when for example I
> run sqlplus from the cmd line. I think also when
> I opened the sql developer window.
>
> Thanks for the reply.
>
> Regards,
>
> ken Quirici
Date: Sun, 11 Mar 2012 14:22:50 -0700 (PDT)
Message-ID: <21440474.2630.1331500970410.JavaMail.geo-discussion-forums_at_pbcgj3>
On Saturday, March 10, 2012 5:29:38 PM UTC-7, Ken Quirici wrote:
> On Mar 10, 6:56 pm, ddf <orat..._at_msn.com> wrote:
> > On Saturday, March 10, 2012 12:49:28 PM UTC-7, Ken Quirici wrote:
> > > help much appreciated.
> >
> > > I have 7 days.
> >
> > > Regards,
> >
> > > Ken Quirici
> >
> > Do you want to change the SYS password in Oracle or the Adminstrator password for Windows?
> >
> > David Fitzjarrell
>
> The SYS password in Oracle I would imagine. Let me fill in a little
> more: when I open sql developer it shows a connection
> to my database ORCL2 - when I click it it asks for a password. It's
> THAT password. Does that answer your question
> fully? I get the message that the pwd is expiring when for example I
> run sqlplus from the cmd line. I think also when
> I opened the sql developer window.
>
> Thanks for the reply.
>
> Regards,
>
> ken Quirici
Why do you have sql developer connecting to your database as SYS? THat is not a reecommended practice. That being the case you can, from the SQL> prompt, change the password:
SQL> password
Old password:
New Password:
Retype new password:
Password changed.
SQL>
If you're connecting as SYSDBA (which in later relesaes is required) you'll probably be better off connecting to SQL*plus ahd executing the following:
SQL> alter user sys identified by <new password here>;
User altered.
SQL> David Fitzjarrell Received on Sun Mar 11 2012 - 16:22:50 CDT