Installing Oracle Apex

Oracle Apex Installing Step

1.Installing Oracle 10g Database.
2.Installing Oracle AS 10.1.3 Middle Tier (or) Oracle 10g Compation
3.Installing Oracle Apex
4.Integration Oracle Apex in Web Server


1. Install Oracle 10g Database.
Pls See Post Installing Oracle 10g On Linux 4.5

2. Installing Oracle iAS 10.1.3.
Pls See Post Oracle iAS 10.1.3.1.0 windows

3. Installing Oracle Apex
Download Oracle Apex

Per Request
SQL>CREATE TABLESPACE apex DATAFILE '/u01/app/oracle/oradata/orcl/APEX01.DBF ' SIZE 500M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K SEGMENT SPACE MANAGEMENT auto;


SQL>show parameter shared_pool_size

SQL>ALTER SYSTEM SET SHARED_POOL_SIZE='100M' SCOPE=spfile;

SQL>SELECT VALUE FROM v$parameter WHERE NAME = 'job_queue_processes';

SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 20;

SQL>SELECT COMP_NAME,STATUS FROM DBA_REGISTRY WHERE SCHEMA='XDB';

connect ctxsys
Enter password: password
SQL> @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/drdefus.sql


SQL> SELECT COMP_NAME,STATUS FROM DBA_REGISTRY ;

COMP_NAME STATUS
----------------------------------- --------------------------------------------
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID
Oracle Workspace Manager VALID
JServer JAVA Virtual Machine VALID
Oracle XDK VALID
Oracle Database Java Packages VALID
Oracle Expression Filter VALID
Oracle Data Mining VALID
Oracle Text VALID
Oracle XML Database VALID
Oracle Rules Manager VALID
Oracle interMedia VALID
OLAP Analytic Workspace VALID
Oracle OLAP API VALID
OLAP Catalog VALID
Spatial VALID
Oracle Enterprise Manager VALID

SQL>@apexins.sql APEX APEX TEMP /i/

SQL>SELECT COMP_NAME,STATUS FROM DBA_REGISTRY ;
COMP_NAME STATUS
----------------------------------- --------------------------------------------
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID
Oracle Workspace Manager VALID
JServer JAVA Virtual Machine VALID
Oracle XDK VALID
Oracle Database Java Packages VALID
Oracle Expression Filter VALID
Oracle Data Mining VALID
Oracle Text VALID
Oracle XML Database VALID
Oracle Rules Manager VALID
Oracle interMedia VALID
OLAP Analytic Workspace VALID
Oracle OLAP API VALID
OLAP Catalog VALID
Spatial VALID
Oracle Enterprise Manager VALID
Oracle Application Express VALID

18 rows selected.

4.Integration Oracle Apex in Web Server


export ORACLE_HOME
PATH=$ORACLE_HOME/perl/bin:$ORACLE_HOME/Apache/modplsql/conf:$PATH; export PATH
PERL5LIB=$ORACLE_HOME/perl/lib/5.6.1; export PERL5LIB


Copy image folder to iAS_ORACLE_HOME
cp -R images $ORACLE_HOME/Apache/Apache

(images ==> Oracle Apex Download folder apex/images)
Copy tnsnames.ora to iAS_ORACLE_HOME

cp $ORACLE_HOME/network/admin/tnsnames.ora $iAS_ORACLE_HOME/network/admin

$ORACLE_HOME/Apache/modplsql/conf
edit dads.conf and Add Following Lines

Alias /i/ "/u01/app/oracle/product/10.2.0/ohs/Apache/Apache/images/"

AddType text/xml xbl
AddType text/x-component htc

<<Location /pls/apex>>
SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDatabasePassword apexpwd
PlsqlDatabaseConnectString sys34.doyen.in:1521:ORCL
PlsqlAuthenticationMode Basic
PlsqlDefaultPage apex
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDocumentPath docs
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8

<>

====END DADS.CONF

cd $ORACLE_HOME/Apache/modplsql/conf
$perl dadTool.pl -o

$ORACLE_HOME/opmn/bin/opmnctl restartproc ias-component=HTTP_Server

Change Apex admin Password
SQL>@apxchpwd.sql

Oracle Apex Admin Page
http://sys9.doyen.in:7777/pls/apex/apex_admin


Oracle Apex Workspace Name
http://sys9.doyen.in:7777/pls/apex