RE: Forgot password for "internal" , any ideeas what I can do?

Internal is NOT a user, it is the SYS user opened in a special mode. To connect as internal you must have set the Oracle password file to the SYS password and be logged onto the server as the Oracle administrative user. On a Unix system this is normally the "oracle" user with belongs to the "dba" group.

>>> Eddy Confer <EConfer_at_confluence.com> 03/09/01 04:10PM >>>
Pankaj
You say that you can change the internal password by connecting as SYS. Connecting
from where as SYS? SysMgr. After I connect do I just issues the alter user command to
change the internal password.

Thanks

-----Original Message-----
Sent: Friday, March 09, 2001 1:40 PM
To: Multiple recipients of list ORACLE-L

Hi Alex,

the default is "oracle" if you have not changed that...in case you do...you can change that to whatever you want to....by connecting through SYS account..

eNjoy life Technically ;-)

Pankaj

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, March 09, 2001 11:05 PM

>
> Hi all,
>
> I just forgot the password for internal user, do you have any ideea how I
> can connect as 'SYSDBA'?
> Or how I can recover the password.
>
> Thx, alex.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Berindei Alex
> INET: Alex.Berindei_at_elsag.it
>
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Pankaj
  INET: gpankaj_at_yahoo.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
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: BeilstWH_at_obg.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
also send the HELP command for other information (like subscribing).