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
taazAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sdstuberCommented:
you can't extract the password directly, but you don't need it to be able to change it.

log in as the oracle owner (usually called "oracle"),  or other user with the sysdba privilege

sqlplus / as sysdba

alter user youruser identified by newpassword


for more info about Oracle passwords...

http://www.experts-exchange.com/A_855.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sdstuberCommented:
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.
0
taazAuthor Commented:
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
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

taazAuthor Commented:
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
0
sdstuberCommented:


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
0
Wasim Akram ShaikCommented:
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>
0
sdstuberCommented:
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.
0
ikamilCommented:
if the version is 8.1.7 (old school), you can try this
[oracle$yourhostname ~] sqlplus 
[sqlplusw] connect internal 

Open in new window

0
taazAuthor Commented:
thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.