A blog on Business Intelligence, Data Warehouse Tools and Databases.
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