Avatar of orlakelly
orlakelly
 asked on

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
Oracle Database

Avatar of undefined
Last Comment
orlakelly

8/22/2022 - Mon
slightwv (䄆 Netminder)

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
orlakelly

ASKER
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
slightwv (䄆 Netminder)

>>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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
slightwv (䄆 Netminder)

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

ASKER
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
slightwv (䄆 Netminder)

Do you have more than one Oracle product installed on this machine?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
orlakelly

ASKER
Sorry for delay in replying, no other Oracle products are installed
ASKER CERTIFIED SOLUTION
orlakelly

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
slightwv (䄆 Netminder)

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

ASKER
Found this solution in a different thread in relation to Oracle issues
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck