| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: New to DBA !
It works if you precede it with
SET ORACLE_SID=yourinstancename
(Windoz uses registry settings, not environmental variables)
and run sqlplus from the command line (not the GUI).
Also, the Oracle owner is the ADMINISTRATOR userid (at least on my boxes).
Of course, your milage may vary.
"AK" <oramagic
@hotmail.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent by: cc:
ml-errors Subject: Re: New to DBA !
10/21/2003 12:34
PM
Please respond
to ORACLE-L
why one can't do same on widoz as well ? works well .
-ak
> is this a Unix box?
>
> if so, log on as the oracle account to the Unix server. Then in
> sqlplus, login as follows
>
> sqlplus "/ as sysdba"
>
> this will get you in as the database owner and will allow you to change
> the system password
>
> alter user system identified by your_new_password;
>
> then log out of sqlplus and log in as system to do what you need to
>
>
> --- "Rama, Shreekantha (K.)" <srama2_at_ford.com> wrote:
> > Hi All,
> >
> > I am new to the world of Oracle..
> > I am having this issue..
> >
> > I have created a database on Oracle 8.1.7.4..
> >
> > But I am not able to access as the password is lost..
> > Now, I am not able to login..
> > I tried login using system /manager.. but oracle is not
> > allowing me to login ..
> >
> > What's the solution ??
> >
> > Regards
> > Shreekanth
> >
> >
> >
>
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.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: AK INET: oramagic_at_hotmail.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: Thomas Day INET: tday6_at_csc.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 Tue Oct 21 2003 - 11:59:32 CDT
 |
 |