• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 334
  • Last Modified:

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
0
orlakelly
Asked:
orlakelly
  • 5
  • 5
1 Solution
 
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
Ultimate Tool Kit for Technology Solution Provider

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

 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now