Wednesday, October 29, 2008

Install Apex on 10.2.0.3

Install 10.2.0.1 binaries
Install Companion CD
Install 10.2.0.3 patchset
Create database using dbca

# Download Apex zip file and install full Apex dev environment

@apexins sysaux sysaux temp /i/

# change admin password

@apxchpwd

@apex_epg_config /opt/oracle/product/10.2.0/apex

alter user anonymous account unlock;

SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

EXEC DBMS_XDB.SETHTTPPORT(8080);


When Oracle Application Express installs it creates three new database accounts:

* FLOWS_030100 - The account that owns the Oracle Application Express schema and metadata.
* FLOWS_FILES - The account that owns the Oracle Application Express uploaded files.
* APEX_PUBLIC_USER - The minimally privileged account used for Oracle Application Express configuration with Oracle HTTP Server and mod_plsql.

http://host:port/apex/apex_admin admin/password1

Create Workspace and map to schema

http://host:port/apex system/password admin/password1