Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

still struggling to install apex 3.1 ...

627363Mar 10 2008 — edited Jan 19 2009
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 16 2009
Added on Mar 10 2008
22 comments
10,352 views