Hi all,
first my spec :
APEX 4.2/5.0
DB : 12c without the PDB option ! so just EE no CDB no PDB
OS : Windows 7 Pro 64 bit
tried to install APEX 5.0 using
sqlplus "sys/syspass as sysdba" @apexins SYSAUX SYSAUX TEMP /i/
Following errors occur in the log file
following errors appear in the log file :
-- Now beginning upgrade. This will take several minutes.-------
-- Ensuring template names are unique -------
-- Migrating metadata to new schema -------
begin
*
ERROR at line 1:
ORA-20000: Unable to gather statistics concurrently: insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 35130
ORA-06512: at "SYS.DBMS_STATS", line 35153
ORA-06512: at "APEX_050000.WWV_FLOW_UPGRADE", line 3728
ORA-06512: at line 4
-- Switching Builder to new schema -------
-- Migrating SQL Workshop metadata -------
-- Upgrading new schema. -------
-- Copying preferences to new schema. -------
-- Upgrading Websheet objects. -------
timing for: Recompiling APEX_050000 schema
Elapsed: 00:00:16.19
THESCRIPT
-------------------------
core/null1.sql
...null1.sql
ERRORS EXIST!!!
...There are 48 errors in the log table! To review errors:
select upgrade_command, upgrade_error from APEX_050000.WWV_FLOW_UPGRADE_PROGRESS
where upgrade_error is not null order by upgrade_date;
-- Upgrade is complete -----------------------------------------
timing for: Upgrade
Elapsed: 00:01:09.01
VIII. I N S T A L L O R A C L E A P E X A P P L I C A T I O N S
define "^" (hex 5e)
...Initialize the table of Oracle default schema names
declare
*
ERROR at line 1:
ORA-01400: cannot insert NULL into
("APEX_050000"."WWV_FLOW_RESTRICTED_SCHEMAS"."ID")
ORA-06512: at line 50
48 errors in the log table :
once :
alter table wwv_flow_file_objects$ drop constraint wwv_flow_file_obj_fk ORA-02443: Cannot drop constraint - nonexistent constraint
47 times :
insert into "APEX_050000".wwv_flow_platform_prefs (name,value,pref_desc,created_on,last_updated_on) values ( :1, :2, :3, :4, :5) ORA-01400: cannot insert NULL into ("APEX_050000"."WWV_FLOW_PLATFORM_PREFS"."ID")
after this the installation continues until we get at themes, then the install simply stops :
Application Express internal themes
...Installing Theme 1
WWV_FLOW_API.FLOWS_API_LAST_EXTENDED20130101
WWV_FLOW_API.CURRENT_FLOWS_VERSION20130101
WWV_FLOW_API.IMPORT_COMPATIBLE_WITH_VERSION 20130101
WWV_FLOW_API.COMPATIBLE
--application/set_environment
APPLICATION 108801 - Theme: Simple Red
--application/delete_application
--application/ui_types
--application/create_application
begin
*
ERROR at line 1:
ORA-00001: unique constraint (APEX_050000.WWV_FLOW_BANNER_U_IDX) violated
ORA-06512: at "APEX_050000.WWV_FLOW_API", line 2811
ORA-06512: at line 2
any help please in fixing this
Kr
Martin