upgrade APEX to 3.0.1

19.11.2007 21:51 | Přečteno: 1406× | Databáze

upgrade APEX to 3.0.1 from Application Express 2.1.0.00.39 (DB_XE 10.2.0.1-1.1)

rozbal ZIP do /opt/apex

cd /opt/apex

sqlplus

connect sys as sysdba
[heslo]

@apexins HESLO SYSAUX SYSAUX TEMP /i/
.
.
Thank you for installing Oracle Application Express.

Oracle Application Express is installed in the FLOWS_030000 schema.

The structure of the link to the Application Express administration services is as follows:
http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql)
http://host:port/apex/apex_admin     (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)
The structure of the link to the Application Express development interface is as follows:
http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)
http://host:port/apex     (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)

-- Now beginning upgrade. This will take several minutes.-------
-- Ensuring template names are unique -------
-- Migrating metadata to new schema -------
-- Switching builder to new schema -------
-- Migrating SQL Workshop metadata -------
-- Upgrading new schema. -------
-- Copying preferences to new schema. -------
-- Updating user account expiration. -------
ERRORS EXIST!!!
...There are 3 errors in the log table!
...Select upgrade_error from WWV_FLOW_UPGRADE_PROGRESS to review errors.

-- Upgrade is complete -----------------------------------------
timing for: Upgrade
Elapsed: 00:02:52.96
JOB_QUEUE_PROCESSES: 4

Performing Application Express component validation - please wait...

Completing registration process.
Validating installation.
FAILED CHECK FOR PACKAGE BODY WWV_FLOW_XE_CONFIG
timing for: Validate Installation
Elapsed: 00:04:22.99
timing for: Complete Installation
Elapsed: 00:18:58.73
not spooling currently
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

.
.

CHYBA: !!!!

FAILED CHECK FOR PACKAGE BODY WWV_FLOW_XE_CONFIG 

.
.

1. Connect to SQL*Plus as SYS

2. @APEX_HOME/apex/apxldimg.sql APEX_HOME

3. @APEX_HOME/apex/apxxepwd.sql password

(where password is the password of the Application Express internal ADMIN account)

For the steps above, APEX_HOME is the directory where the Application Express software was unzipped.

------

#

Connect as user SYS.
#

ALTER SESSION SET CURRENT_SCHEMA = FLOWS_030000
/
#

#The following command imports the administrative interface: #@script\f4050.sql

@builder/f4050.sql

# The following command imports the request for workspace interface: #@script\f4700.sql

@builder/f4700.sql

http://server:port/apex/f?p=4550:10 i.e. http://127.0.0.1:8080/apex/f?p=4550:10 .

--------------------

ALTER SESSION SET CURRENT_SCHEMA = FLOWS_030000
/

ALTER USER FLOWS_030000 IDENTIFIED BY password ACCOUNT UNLOCK
/

       

Komentáře