Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: forgotten sys password

Re: forgotten sys password

From: Paul Drake <paled_at_home.com>
Date: Fri, 15 Sep 2000 01:29:26 -0400
Message-Id: <10619.117062@fatcity.com>


Hi Zhuchao,

In 8.1.6 on NT, a local group ORA_DBA is created at install time. It is higly likely that the user that is currently logged into the console is not the same user that was logged in during the install. grant the group ORA_DBA to the user, and you should be able to connect internal without a password.

there more than 1 way to grant the ORA_DBA group to the local user - either directly or implicitly. I"d just grant it directly in User Manager.

email me directly if you need further info.

Paul

zhuchao wrote:

> hi,all
> I am running oracle8.1.6 on nt,and oraginnaly i can connect internal under svrmgrl without password.the default parameter in pfile remote_login_passwordfile is none.
> but without noticing any change by myself,it refused to let me connect as internal again.i forgot what i have done.but now whenever i connect as internal or connect sys/xxx as SYSDBA, it always prompts me that invald username/password.login denied. alter user sys doesn't work either.
> i even tried orapwd to create a password file and change setting in initsid.ora.but connect internal still failed.
> what shall i do?
> can someone help me?
>
>
> 00-9-14 03:12:00 you write:
> >John,
> > If you can log in to Unix as Oracle (or any user in the dba group),
> >then you can run svrmrgl and connect internal. Then you can change the
> >sys password from there.
> >
> >John Dunn wrote:
> >
> >> We have an installation of Oracle 8 on Unix that we use only for
> >> demonstrations. We have forgotten the sys password.
> >>
> >> Anything we can do?
> >>
> >> John
> >>
> >> --
> >> Author: John Dunn
> >> INET: john.dunn_at_sefas.co.uk
> >>
> >> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >> San Diego, California -- Public Internet access / Mailing Lists
> >> --------------------------------------------------------------------
> >> To REMOVE yourself from this mailing list, send an E-Mail message
> >> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >> the message BODY, include a line containing: UNSUB ORACLE-L
> >> (or the name of mailing list you want to be removed from). You may
> >> also send the HELP command for other information (like subscribing).
> >
> >--
> >Scott Canaan (srcdco_at_rit.edu)
> >"Life is like a sewer, what you get out of it depends on what you put into
> >it" - Tom Lehrer
> >
> >
> >--
> >Author: Scott Canaan
> > INET: srcdco_at_ritvax.isc.rit.edu
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> good luck!
> bye......
>
>
>
> ..................................
> ..................................
> zhuchao
> chaos_at_cattsoft.com
> ___________________________________
>
> --
> Author: zhuchao
> INET: chaos_at_cattsoft.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri Sep 15 2000 - 00:29:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US