Version: 11.2.0.4.0 Enterprise Edition
OS Version: SunOS sparc 64bit
Hello Guys, I am trying to install apex in my database which is a 11.2.0.4.0 Enterprise Edition by running the apxconf.sql script and I am getting the error "ORA-01435: user does not exist".
#####################################################################################################
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @apxconf.sql
PORT
----------
8080
Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.
Default values are in brackets [ ].
Press Enter to accept the default value.
Enter a password for the ADMIN user []
Enter a port for the XDB HTTP listener [ 8080]
...changing HTTP Port
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
ERROR:
ORA-01435: user does not exist
#####################################################################################################
at first I didn't know what user it was referring to, so I opened up the apxconf.sql script and went through it and found the line "alter session set current_schema = APEX_030200;", so I thought the schema APEX_030200 should be present for the installation of apex.
So, I tried creating the schema APEX_030200 manually and tried running the apxconf.sql again, and am still presented with errors, the following is the output
#####################################################################################################
SQL> @apxconf.sql
PORT
----------
8080
Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.
Default values are in brackets [ ].
Press Enter to accept the default value.
Enter a password for the ADMIN user []
Enter a port for the XDB HTTP listener [ 8080]
...changing HTTP Port
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Session altered.
...changing password for ADMIN
wwv_flow_security.g_security_group_id := 10;
*
ERROR at line 3:
ORA-06550: line 3, column 5:
PLS-00201: identifier 'WWV_FLOW_SECURITY.G_SECURITY_GROUP_ID' must be declared
ORA-06550: line 3, column 5:
PL/SQL: Statement ignored
ORA-06550: line 4, column 5:
PLS-00201: identifier 'WWV_FLOW_SECURITY.G_USER' must be declared
ORA-06550: line 4, column 5:
PL/SQL: Statement ignored
ORA-06550: line 5, column 5:
PLS-00201: identifier 'WWV_FLOW_SECURITY.G_IMPORT_IN_PROGRESS' must be declared
ORA-06550: line 5, column 5:
PL/SQL: Statement ignored
ORA-06550: line 8, column 23:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 7, column 16:
PL/SQL: SQL Statement ignored
ORA-06550: line 13, column 32:
PLS-00364: loop index variable 'C1' use is invalid
ORA-06550: line 12, column 9:
PL/SQL: Statement ignored
ORA-06550: line 19, column 5:
PLS-00201: identifier 'WWV_FLOW_SECURITY.G_IMPORT_IN_PROGRESS' must be declared
ORA-06550: line 19, column 5:
PL/SQL: Statement ignored
#####################################################################################################
My question is should the schema APEX_030200 already exist? or is the schema APEX_030200 created while executing the apxconf.sql? Can you please give advise on how to resolve this and tell me where I am going wrong?
Thank You