Thank you Naveen, it's working out now
> -----Original Message-----
> From: Naveen Nahata [SMTP:naveen_nahata_at_mindtree.com]
> Sent: Thursday, December 19, 2002 1:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Open the password
>
> on the machine where the database is installed, you can login as CONNECT
> INTERNAL, and it won't prompt for the password.
>
> the environment variable ORACLE_SID should be pointing to the concerned
> DB's
> SID.
>
> Connect as internal, shutdown the database and then recreate the password
> file using ORAPWD.
>
> Regards
> Naveen
>
> -----Original Message-----
> Sent: Thursday, December 19, 2002 7:09 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Thanks Naveen for suggestions, but by the way what do you mean 'connect
> internal' via sqlplus and check the value of ORACLE-SID, you mean that we
> can enter into database by using 'INTERNAL' user without password, don't
> you
> ?
>
> > -----Original Message-----
> > From: Naveen Nahata [SMTP:naveen_nahata_at_mindtree.com]
> > Sent: Wednesday, December 18, 2002 2:49 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Open the password
> >
> > You can recreate the password file, you can recreate the instance with a
> > different password, and you can also connect from the server machine by
> > simple 'connect internal' in sqlplus. just check the value of
> ORACLE_SID,
> > it
> > should be pointing to the DB
> >
> > Regards
> > Naveen
> >
> > -----Original Message-----
> > Sent: Wednesday, December 18, 2002 12:44 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Dear everyone,
> > I already installed oracle 8i database on my server, to make my
> > system secured I changed my 'INTERNAL' password but I forget to write
> the
> > changed in my book, and now I can't enter to 'INTERNAL' because I forget
> > the
> > password. Please inform me how to open it again perhaps you have tips
> and
> > tricks how to solve it.
> >
> > Thanks
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Sony kristanto
> > INET: Sony_at_polyfincanggih.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > 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: Naveen Nahata
> > INET: naveen_nahata_at_mindtree.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > 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.net
> --
> Author: Sony kristanto
> INET: Sony_at_polyfincanggih.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
> --
> Author: Naveen Nahata
> INET: naveen_nahata_at_mindtree.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
--
Author: Sony kristanto
INET: Sony_at_polyfincanggih.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Thu Dec 19 2002 - 20:08:43 CST
