I can't remember my Oracle Express Database credentials

I can't remember my Oracle Express Database credentials

Does anyone know how I can retrieve these or reset them ??

Thanks
Orla
orlakellyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

slightwv (䄆 Netminder) Commented:
Oracle Express Edition passwords?

If so:
from a command prompt:
sqlplus / as sysdba

That connects you as the SYS user.  From here you can change whatever users password you want.

For example SYSTEM:
SQL> password system
0
orlakellyAuthor Commented:
Hi

Firstly thanks for prompt response

yes it is currently \oracle\product\10.2.0\ version

This is a legacy install and I have no Oracle experience.

So to confirm from the command prompt
Type sqlplus / as sysdba


Type sysdba> password xxxxx
0
slightwv (䄆 Netminder) Commented:
>>Type sqlplus / as sysdba

Correct.

That should get you to a SQL> prompt

Then you type:
password some_user

You will be prompted for the new password.

Note: If applications connect with the user, they might have the user password stored outside of the database and changing the password can cause the apps to stop working.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

slightwv (䄆 Netminder) Commented:
>>>>Type sqlplus / as sysdba

You need to make sure you are logged into the machine with a user that is a member of the ORA_DBA group.
0
orlakellyAuthor Commented:
Hi

I followed your above instruction and when I get I type in sqlplus / as sysdba
 I get the following error

Error:
Ora-010311:
Insufficient Privileges

I have checked and the account I'm logged in with is in the ora_dba group
0
slightwv (䄆 Netminder) Commented:
Do you have more than one Oracle product installed on this machine?
0
orlakellyAuthor Commented:
Sorry for delay in replying, no other Oracle products are installed
0
orlakellyAuthor Commented:
Hi I was eventually able to reset the system password here was the solution I found on here

Basically, You need to do 2 things. First, add your userid into the windows OS group called ora_dba. Second, go into the directory where Oracle is installed, into the network/admin directory and edit the sqlnet.ora file with notepad. Change (NONE) to (NTS) for the sqlnet_authentication and save the file.

 Then you can login to sqlplus “/as sysdba”
For some reason, the e1 local database installation decided to turn off OS authentication

Thanks for all your help :)
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
slightwv (䄆 Netminder) Commented:
>>Change (NONE) to (NTS) for the sqlnet_authentication

Yes.  I forgot that piece on Windows.  Oracle and Windows really do not get along real well.

Feel free to accept your last post as the answer.
0
orlakellyAuthor Commented:
Found this solution in a different thread in relation to Oracle issues
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.