whic user have I reset password use orsdim for oracle 9i?
This is a discussion on whic user have I reset password use orsdim for oracle 9i? within the Oracle Database forums, part of the Database Server Software category; --> Hi, I have tried to use oradim -EDIT -SID <your sid name> -INTPWD <your new password> to reset password, ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-23-2008, 05:33 AM
| ||||
| ||||
 whic user have I reset password use orsdim for oracle 9i? Hi, I have tried to use oradim -EDIT -SID <your sid name> -INTPWD <your new password> to reset password, but after I changed the password succesfully I can't log in using SYS or SYSTEM with the password I just set? so which user have I reset the password? is it internal? no internal user for 9i , right? How Can I log back in ? Thanks for your help!      |
|
02-23-2008, 05:34 AM
| |||
| |||
| Re: whic user have I reset password use orsdim for oracle 9i? > How Can I log back in ? > Hi! sqlplus "/ as sydba" will give you a log in as sys. Make sure the environment is set correctly before issuing the command. Then do an alter user xxxx identified by yyyy; To set the correct password (yyyy) for the user (xxxx). Best regards Dennis |
|
02-23-2008, 05:34 AM
| |||
| |||
| Re: whic user have I reset password use orsdim for oracle 9i? I tried sqlplus "/ as sydba" get an invalid option error. I reset the password to 'oracle'. which user have I reset it? Dennis Bieling <dennis.bieling@epigenomics.com> wrote in message news:<bpco9p$q13$1@broglie.epigenomics.epi>... > > How Can I log back in ? > > > > Hi! > > sqlplus "/ as sydba" > > will give you a log in as sys. Make sure the environment is set > correctly before issuing the command. > Then do an > > alter user xxxx identified by yyyy; > > To set the correct password (yyyy) for the user (xxxx). > > > Best regards > Dennis |
|
02-23-2008, 05:35 AM
| |||
| |||
| Re: whic user have I reset password use orsdim for oracle 9i? yan wang wrote: > I tried sqlplus "/ as sydba" > get an invalid option error. > > I reset the password to 'oracle'. > which user have I reset it? > Your interpretation of an error message is inadequate for anyone to help you. Publish the actual message beginning with ORA-. We are unable to see you monitor clearly in our crystal balls and the Taro cards are out being marked. -- Daniel Morgan http://www.outreach.washington.edu/e...ad/oad_crs.asp http://www.outreach.washington.edu/e...oa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply) |
|
02-23-2008, 05:35 AM
| ||||
| ||||
| Re: whic user have I reset password use orsdim for oracle 9i? yan wang wrote: > I tried sqlplus "/ as sydba" > get an invalid option error. > > I reset the password to 'oracle'. > which user have I reset it? > > Dennis Bieling <dennis.bieling@epigenomics.com> wrote in message news:<bpco9p$q13$1@broglie.epigenomics.epi>... > >>>How Can I log back in ? >>> >> >>Hi! >> >>sqlplus "/ as sydba" >> >>will give you a log in as sys. Make sure the environment is set >>correctly before issuing the command. >>Then do an >> >>alter user xxxx identified by yyyy; >> >>To set the correct password (yyyy) for the user (xxxx). >> >> >>Best regards >>Dennis probably the sys user, try sqlplus "sys/<your new password> as sysdba" Has the same rights as "/ as sysdba" - is actually the same oracle user. You do mean you changed the password with oradim - right? -- Regards, Frank van Bortel |
Linear Mode
