Friday, June 8, 2007

Oracle Application Express Software on 11i

Installing the Oracle Application Express Software on 11i

Software Requirement :
1. EBSO Dump to Setup R11i Instance
2. Oracle Application Express Dump 2.2v

Installation Steps:
1. Setup R11i Instance and make sure all the components are working fine.
2. Login as Oracle Database User of the 11i Instance.
3. Make a directory 'mkdir $ORACLE_HOME/apex'
4. Move to $ORACLE_HOME/apex
5. Unzip
6. sqlplus sys/SYS_password as sysdba
7. Create a Tablespace for HTMLDB on the 11i Database.
SQL> create tablespace htmldb datafile '/home1/orr11i/ebsor11i/data/htmldb_01.dbf'
2 size 100m
3 autoextend on
4 next 50m
5 maxsize 2048m
6 extent management local;
8. Run apexins.sql
Syntax :apexins
- is the password for the Oracle Application Express administrator account.
- is the name of the tablespace for the Oracle Application Express application user
- is the name of the tablespace for the Oracle Application Express files user.
- is the name of the temporary tablespace.
- is the virtual directory for Oracle Application Express images.
- is the Oracle Net connect string to the database. If this is a local install, use none or NONE.

SQL> start apexins apex_password HTMLDB HTMLDB TEMP /i/ none

. Application Express Installation.
Thank you for installing Oracle Application Express.

Oracle Application Express is installed in the FLOWS_020200 schema.

The structure of the link to the Application Express administration services is as follows:

The structure of the link to the Application Express development interface is as follows:

-- 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. -------
...There are 10 errors in the log table!
...Select upgrade_error from WWV_FLOW_UPGRADE_PROGRESS to review errors.
-- Upgrade is complete -----------------------------------------
timing for: Upgrade
Elapsed: 00:01:28.95
Completing registration process.
Validating installation.
timing for: Validate Installation
Elapsed: 00:00:02.28
timing for: Complete Installation
Elapsed: 00:12:25.01
Disconnected from Oracle9i Enterprise Edition Release - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release - Production

Since we are running from the Server where DB Runs we will use NONE for connect

Server Installation:
@apexins password HTMLDB HTMLDB TEMP /i/ none

Post Installation Steps:
1. Stop Application 11i using
2. Recompiling Invalid PL/SQL Packages
SQL> @?/rdbms/admin/utlrp.sql
3. Copying the Images Directory to 11i Middle Tier
cp -rf apex/images $IAS_ORACLE_HOME/Apache/Apache
4. Configuring Oracle HTTP Server
Oracle Application Express must have access to Oracle HTTP Server with mod_plsql
4.1: Modifying the File
vi $IAS_ORACLE_HOME/Apache/modplsql/cfg/
4.2: Comment "custom_auth=CUSTOM"
defaultDAD = EBSO11I
administrators = system
adminPath = /admin_/
;custom_auth = CUSTOM
4.3: Add an entry for Oracle Application Express using the following syntax
connect_string = EBSO11I
password = apex_password
username = apex_public_user
default_page = apex
document_table = wwv_flow_file_objects$
document_path = docs
document_proc = wwv_flow_file_mgr.process_download
reuse = Yes
enablesso = No
nls_lang = American_America.UTF8
4.4: Modify the plsql.conf File
vi $IAS_ORACLE_HOME/Apache/modplsql/cfg/plsql.conf
4.5: Add the following entry to the end of the file and save

SetHandler pls_handler
Order deny,allow
Allow from all

4.6: Modify the security.conf File
vi $IAS_ORACLE_HOME/Apache/Apache/conf/security.conf
4.7: Add the following entry between and Tag and save
# Allow for partial urls for default pages. i.e. /pls/sid or /pls/sid/
SecFilterSelective "REQUEST_URI" ^/pls/[-a-z0-9_]+(/){0,1}$ "allow,nolog"
4.8: Modify the httpd.conf File
vi $IAS_ORACLE_HOME/Apache/Apache/conf/httpd.conf
4.9: Add the following entry to the httpd.conf and save
Alias /i/ "/home1/orr11i/ebsor11i/Apache/Apache/images/"
AddType text/xml xbl
AddType text/x-component htc
5. Start Application 11i using
6. Applying the PL/SQL Web Toolkit Patch
Apply the PL/SQL Web Toolkit patch to every database where you wish to run ApEx 2.2
Review the README.txt file contained in the directory apex/patch/bug4554072
7. If JOB_QUEUE_PROCESSES is not enabled and working properly, you cannot successfully execute a script.

We have completed HTMLDB Installation on Release 11i.

Some Troubleshooting :
I forgot the admin password and used the following procedure to recover it;

SQL> alter user FLOWS_020200 account unlock;

User altered.

SQL> alter user FLOWS_020200 identified by FLOWS_020200;

User altered.

SQL> connect FLOWS_020200/FLOWS_020200
SQL> begin
2 wwv_flow_api.set_security_group_id(p_security_group_id=>10);
3 wwv_flow_fnd_user_api.create_fnd_user(
4 p_user_name => 'admin2',
5 p_email_address => '',
6 p_web_password => 'admin2') ;
7 end;
8 /

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

SQL> alter user FLOWS_020200 account lock;

User altered.


Now logged in as admin2 user
>> Manage Workspace
>> Existing Workspace
>> Select INTERNAL
>> Manage USERS
>> Select ADMIN and Reset the Password

Now login as ADMIN and delete ADMIN2

Must Read at Oracle Documentation

Popular Posts