still struggling to install apex 3.1 ...
627363Mar 10 2008 — edited Jan 19 2009I have to wonder if the uninstall is leaving incompatible stuff behind. After my /i/ goof I ran
drop user FLOWS_030100 cascade;
drop user FLOWS_FILES cascade;
and
SQL> @apxremov.sql
over 5 times with attempted installs in between. Major log errors about loop breaks etc. I finally got into Oracle and poked around. Found an APEX PUBLIC USER that I removed and also a complete FLOWS_030100 schema full of Apex objects. So I did a
drop user FLOWS_030000 cascade;
and then attempted another install. This time I thought I was there. Not the immediate flood of errors ..... but then I hit
create public synonym wwv_flow_file_objects$ for wwv_flow_file_objects$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package "FLOWS_030100.WWV_FLOW_GLOBAL" has been
invalidated
ORA-04065: not executed, altered or dropped package
"FLOWS_030100.WWV_FLOW_GLOBAL"
ORA-06508: PL/SQL: could not find program unit being called:
"FLOWS_030100.WWV_FLOW_GLOBAL"
ORA-06512: at "FLOWS_030100.WWV_FLOW", line 41
ORA-06512: at line 2
ERROR at line 1:
ORA-02291: integrity constraint (FLOWS_030100.WWV_FLOW_COMP_SCHEMAS_FK)
violated - parent key not found
ORA-06512: at line 2
ERROR at line 1:
ORA-02291: integrity constraint (FLOWS_030100.WWV_FLOW_DB_AUTH_FK) violated -
parent key not found
ORA-06512: at line 2
The log ends with
...internal messages
APPLICATION 4411 - APEX - System Messages
Set Credentials...
Check Compatibility...
WWV_FLOW_API.FLOWS_API_LAST_EXTENDED20070906
WWV_FLOW_API.CURRENT_FLOWS_VERSION20070906
WWV_FLOW_API.IMPORT_COMPATIBLE_WITH_VERSION 20070108
WWV_FLOW_API.COMPATIBLE
Set Application ID...
begin
*
ERROR at line 1:
ORA-02291: integrity constraint (FLOWS_030100.WWV_FLOWS_FK) violated - parent
key not found
ORA-06512: at "FLOWS_030100.WWV_FLOW_API", line 551
ORA-06512: at line 3
which is not the "successful" in the docs. I went ahead anyway with the rest of the config, but
SELECT STATUS FROM DBA_REGISTRY
WHERE COMP_ID = 'APEX';
returns "loading". Not sure what to do at this stage and would appreciate advice. TIA,
Mic.