How I encountered this error:
I Installed Oracle DB 11gR2XE and while creating the schema using SQL Developer I was not able to connect to the DB as SYSDBA for user SYSTEM.
Initially I thought my account does not have DBA access but after checking I found that my account have all required access.
Error Screen Shot:
I Installed Oracle DB 11gR2XE and while creating the schema using SQL Developer I was not able to connect to the DB as SYSDBA for user SYSTEM.
Initially I thought my account does not have DBA access but after checking I found that my account have all required access.
Error Screen Shot:
Where was the issue:
By default in the Oracle DB installation the user SYS has the DBA or SYSDBA permission and not the user SYSTEM so the error.
Solution :
The solution is we need to give DBA permission to user SYSTEM. Here is how you can do it.
1. Open SQL plus or SQL Command Line
2. Connect user SYS as SYSDBA (Enter the password you gave while installation) and grant SYSDBA permission to user SYSTEM
3. Test your DB connection and your problem should be solved.
This helped me thank u
ReplyDeleteThank you very much.........
ReplyDeletemuchas gracias excelente me ayudaste mucho
ReplyDeleteI have created a new user,but I can't login the system. It says insufficient prevelege.any one interested for help.
ReplyDelete