Thursday, October 8, 2015

[Solved] Forgot SYSDBA credentials for Oracle 11g

This is a really helpful tip incase you forgot the password to the SYSDBA user in your Oracle 11g Database. You can use the following syntax to login to the server as SYSDBA from RUN,
sqlplus / as sysdba

Login to SQLPlus without SYS credentials
This would open SQLPlus as shown below and you can test the same by running the command SHOW USER

Logged into SQLPlus and test the name of the current user.
Note: This will only work if the Windows User is a part of the ORA_DBA user group. 

No comments:

Post a Comment