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/…user12964– user129642015年07月07日 16:39:49 +00:00Commented Jul 7, 2015 at 16:39
-
Sorry, That didn't help me. SQL> CONNECT /as sysdba Error: ORA-01031: insufficient privilegesRaj-887– Raj-8872015年07月07日 17:57:51 +00:00Commented 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– REW2015年07月10日 22:05:54 +00:00Commented Jul 10, 2015 at 22:05
1 Answer 1
Here is an article from dba-oracle which talk about this same problem. This might solve the issue you are having.