Link to home
Create AccountLog in
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
Avatar of slightwv (䄆 Netminder)
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
Avatar of 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
>>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.
>>>>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.
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
Do you have more than one Oracle product installed on this machine?
Sorry for delay in replying, no other Oracle products are installed
ASKER CERTIFIED SOLUTION
Avatar of orlakelly
orlakelly

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
>>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.
Found this solution in a different thread in relation to Oracle issues