This content has been marked as final. Show 5 replies
Check the install*.log file created by install. It will show you the error.
Chances are you ran out of space in one of the tablespaces.
If that is the case,
a. Add a datafile to the tablespace
b. Drop the APEX_040200 user, with cascade
c. Run apexins again.
Not really a 4.2 specific issue, applies to all prior versions as well.
log file say exactly like i posted.This never happen when install 4.0 or 4.1.
i already have new tablespace apex42 before i run @apexins.sql APEX42 APEX42 TEMP /i/
Look for errors before the below error. Some table, view or other db object has failed in creation.
We did an upgrade from 4.1 to 4.2 this morning and went through smoothly, so I doubt there is an issue with the scripts.
begin * ERROR at line 1: ORA-04063: package body "APEX_040200.WWV_FLOW_UTILITIES" has errors ORA-06508: PL/SQL: could not find program unit being called:
Praboth i think this is happen on fresh install on oracle XE 11g (existing 4.0) not like your scenario update from existing 4.1 to 4.2
BTW there many error on log file
ERROR at line 1: ORA-01920: user name 'FLOWS_FILES' conflicts with another user or role name ORA-06512: at line 3 ...create flows_files ... create wwv_flow_file_objects create table wwv_flow_file_objects$ ( * ERROR at line 1: ORA-00955: name is already used by an existing object create index wwv_flow_files_file_idx on wwv_flow_file_objects$ (security_group_id, filename, flow_id) * ERROR at line 1: ORA-00955: name is already used by an existing object 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 declare * ERROR at line 1: ORA-43853: SECUREFILE lobs cannot be used in non-ASSM tablespace "APEX42" ORA-06512: at line 7 Table altered. m.c048, m.c049, m.c050, m.clob001, m.blob001, m.xmltype001, m.n001, m.n002, m.n003, * ERROR at line 7: ORA-00904: "M"."XMLTYPE001": invalid identifier . . . many more