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