Installing APEX - Oracle Application Express 3.0.1 on SLES 10.0

Previous Posts:
Oracle 10g Rel 2 on SLES 10.0
Installation Prepation
Hardware and Software check
Software Installation
Patch Oracle Database Software
Create Database
Install Oracle HTTP Server
Next Posts:
Install BI Publisher
Automate Startup/Shutdown
Install Oracle Workflow

The Installation of Oracle Application Express consists of Installation of PL/SQL Packages and other DB Objects (Users, Tables, Indexes ...) and Configuration of Oracle HTTP Servers modplsql module.

Download the Installation and Documentation Files:
Oracle Application Express 3.0.1

Following Steps will be executed as user oracle.

Connect to Linux Box as user oracle:
vl094:~ # ssh -Xl oracle vl094
Password:
Last login: Tue Sep 25 17:26:20 2007 from vl094.fla.net
oracle@vl094:~>

Unzip the file apex_3.0.1.zip and change directory to apex.
You cann access the Documentation using the HTML file welcome.html.
Start SQLPLUS and install Apex in the database.
oracle@vl094:~/apex> sqlplus

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Sep 25 19:06:55 2007

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> @apexins qwertz SYSAUX SYSAUX TEMP /i/

Check the spool file install.log for errors.

Following steps will be executed as user orahs - Oracle HTTP Server software owner.

Connect to Linux Box as User orahs:
vl094:~ # ssh -Xl orahs vl094
Password:
Last login: Tue Sep 25 17:48:34 2007 from vl094.fla.net
orahs@vl094:~>

Copy the Image File to Apach Directory:
orahs@vl094:~> cp -rf /appl/home/oracle/apex/images/ $ORACLE_HOME/Apache/Apache/

Create the tnsnames.ora file with connection string to DB094.
orahs@vl094:~> cat /appl/orahs/product/10.2.0/db_1/network/admin/tnsnames.ora
DB094 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vl094.fla.net)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB094.fla.net)
)
)

Check the connection with the DB:
orahs@vl094:~> sqlplus system/qwertz@DB094

SQL*Plus: Release 10.1.0.3.0 - Production on Tue Sep 25 20:04:23 2007

Copyright (c) 1982, 2004, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
orahs@vl094:~>

Modify the dads.conf file:
orahs@vl094:~> cat /appl/orahs/product/10.2.0/db_1/Apache/modplsql/conf/dads.conf
# ============================================================================
# mod_plsql DAD Configuration File
# ============================================================================
# 1. Please refer to dads.README for a description of this file
# ============================================================================

# Note: This file should typically be included in your plsql.conf file with
# the "include" directive.

# Hint: You can look at some sample DADs in the dads.README file

# ============================================================================
Alias /i/ "/appl/orahs/product/10.2.0/db_1/Apache/Apache/images/"
AddType text/xml xbl
AddType text/x-component htc
<Location /pls/apex>
Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlDatabaseConnectString DB094 TNSFormat
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername APEX_PUBLIC_USER
PlsqlDefaultPage apex
PlsqlDatabasePassword qwertz
Allow from all
</Location>

Restart the Oracle HTTP Server:
orahs@vl094:~> /appl/orahs/product/10.2.0/db_1/opmn/bin/opmnctl stopall
opmnctl: stopping opmn and all managed processes...
orahs@vl094:~> sleep 60
orahs@vl094:~> /appl/orahs/product/10.2.0/db_1/opmn/bin/opmnctl startall
opmnctl: starting opmn and all managed processes...

Connect to APEX on http://vl094:7780/pls/apex/apex_admin.

Form: Application Express Administration Service
Enter Usename ADMIN, Password qwertz.
Press Login.
-----------------------------------------------------------------------------------
Form: Change Password.
I entered 3 times the value qwertz.
Press "Apply Changes".
-----------------------------------------------------------------------------------
form: Change Password.
Press "Return"
-----------------------------------------------------------------------------------
Form: Application Express Administration Services.
Enter username ADMIN and password qwertz.
Press "Login".
-----------------------------------------------------------------------------------
Form: Application Express Administration.
Press "Logout".
-----------------------------------------------------------------------------------


Congratulation: Oracle Application Axpress is installed!

Regards,
Flavio