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.

Improve this question
3
  • This answer might help you: dba.stackexchange.com/questions/40562/…
    – user12964
    Commented Jul 7, 2015 at 16:39
  • Sorry, That didn't help me. SQL> CONNECT /as sysdba Error: ORA-01031: insufficient privileges
    – Raj-887
    Commented Jul 7, 2015 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
    Commented Jul 10, 2015 at 22:05

1 Answer 1

Reset to default
1

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

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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