1

Please anyone tell me how to create DBA user from ORACLE Application express(http://127.0.0.1:8080/apex/apex_admin)?

I installed Oracle 11gR2 XE on windows 8.1 PC and I am able to login to Oracle APEX (above link) with username: "ADMIN" and password used during installation. but I can't use same username/password to login to "Oracle SQL Command Line". I am trying to connect with command

CONNECT username/password

All other solutions suggests a command "CREATE USER....." but I don't know where to write that command without connecting SQL Command line. I am missing a simple step somewhere. please help me.

My question is exactly opposite of this question. User with dba privs can't login to APEX, but can from SQL*Plus

Where I can login to Oracle APEX web interface and create new workspace, Schemas, Users but I am not able to login to SQL Command line to create Database objects.

  • This answer might help you: dba.stackexchange.com/questions/40562/… – Harrison Brock Jul 7 '15 at 16:39
  • Sorry, That didn't help me. SQL> CONNECT /as sysdba Error: ORA-01031: insufficient privileges – Raj-887 Jul 7 '15 at 17:57
  • Raj - In order for that to work, you will need to add your WINDOWS OS USER account to the ora_dba group. This allows any user in that group to issue 'sqlplus / as sysdba' or 'connect / as sysdba' without sys credentials. Then you can use sqlplus to create users, etc. – REW Jul 10 '15 at 22:05
1

Here is an article from dba-oracle which talk about this same problem. This might solve the issue you are having.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.