Link to home
Start Free TrialLog in
Avatar of taaz
taaz

asked on

oracle user password

I installed an oracle database  the installer was user oracle and I forgot the password for that user.

how to retrieve the? lost password
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sean Stuber
Sean Stuber

I made the assumption above that you didn't know the password to any privileged account.

"privileged" meaning it has the "alter user" privilege


If you know at least one, then you can log in as them and use that account to change the others.
Avatar of taaz

ASKER

here is the situation

I login as root user
#
and then from here
#su - oracle
$pwd
$/u01/pp/oracle

Here I am not asked to enter password
Avatar of taaz

ASKER

here is the situation

I login as root user
#
and then from here
#su - oracle
$
$pwd
$/u01/pp/oracle

Here I am not asked to enter password


you may need to set your oracle environment first.

"dot in" oraenv

. oraenv  

when prompted, enter your database and then do the sqlplus login and alter as shown above
do one thing...

after logging into oracle user..


#
and then from here
#su - oracle
$
$pwd
$/u01/pp/oracle

type sqlplus like this
$sqlplus
it will prompt you to enter username
then enter the value enclosed in quotes use
" / as sysdba "

you will get login to database, now execute the command like this

alter user <user_name> identified by <password>
wasimibm - that's essentially the same information that I posted earlier

please read previous posts,  if you don't have anything new to add, please don't repeat.

I'm happy to see you agree with me, but it doesn't help the thread to say so or post the same answer again.
if the version is 8.1.7 (old school), you can try this
[oracle$yourhostname ~] sqlplus 
[sqlplusw] connect internal 

Open in new window

Avatar of taaz

ASKER

thanks