Upgrading form Oracle 10g to 11g and Configuring Oracle Apex

After Upgrade 10g to 11g Oracle Apex
Note : Oracle Application express comes default with Oracle 11g Database,we have to configure ..


Install Oracle 11g Apex

cd $ORACLE_HOME/apex

create apex tablespace
(eg. create tablespace apex datafile '/db/orcl/apex01.dbf' size 1024M;)

sqlplus '/as sysdba'
SQL>@apexins apex apex apex TEMP /i/ none

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)

-- Updating user account expiration. -------
timing for: Upgrade
Elapsed: 00:00:00.13
JOB_QUEUE_PROCESSES: 10

Performing Application Express component validation - please wait...

Completing registration process.
Validating installation.
timing for: Validate Installation
Elapsed: 00:02:43.26
timing for: Complete Installation
Elapsed: 00:13:14.01
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @apxconf.sql
PORT
----------
8080

Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.
Default values are in brackets [ ].
Press Enter to accept the default value.


Enter a password for the ADMIN user [] oracle
Enter a port for the XDB HTTP listener [ 8080] 8080
...changing HTTP Port

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Session altered.

...changing password for ADMIN

PL/SQL procedure successfully completed.

Commit complete.

SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;

User altered.

SQL> @apex_epg_config.sql

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Enter value for 1: /u02/app/product/11.1.0/db_1
old 1: create directory APEX_IMAGES as '&1/apex/images'
new 1: create directory APEX_IMAGES as '/u02/app/product/11.1.0/db_1/apex/images'

Directory created.

PL/SQL procedure successfully completed.

Commit complete.

PL/SQL procedure successfully completed.

timing for: Load Images
Elapsed: 00:03:04.41

Session altered.

PL/SQL procedure successfully completed.

Commit complete.

Session altered.

Directory dropped.

SQL>Col Comp_name Format a35
Col Status Format a12
Select Comp_name, status, Version
From Dba_Registry
Order by Comp_name;



COMP_NAME STATUS VERSION
----------------------------------- ------------ ------------------------------
JServer JAVA Virtual Machine VALID 11.1.0.6.0
OLAP Analytic Workspace VALID 11.1.0.6.0
OLAP Catalog VALID 11.1.0.6.0
Oracle Application Express VALID 3.0.1.00.08
Oracle Data Mining VALID 11.1.0.6.0
Oracle Database Catalog Views VALID 11.1.0.6.0
Oracle Database Java Packages VALID 11.1.0.6.0
Oracle Database Packages and Types VALID 11.1.0.6.0
Oracle Enterprise Manager VALID 11.1.0.6.0
Oracle Expression Filter VALID 11.1.0.6.0
Oracle Multimedia VALID 11.1.0.6.0

COMP_NAME STATUS VERSION
----------------------------------- ------------ ------------------------------
Oracle OLAP API VALID 11.1.0.6.0
Oracle Rules Manager VALID 11.1.0.6.0
Oracle Text VALID 11.1.0.6.0
Oracle Workspace Manager VALID 11.1.0.6.0
Oracle XDK VALID 11.1.0.6.0
Oracle XML Database VALID 11.1.0.6.0
Spatial VALID 11.1.0.6.0