I just installed the oracle Information lifecycle management assistant so that I could test it with 11g.
You first need to install Oracle Application Express (Apex) and then the Oracle ILM assistant.
When you create a database in 11g you can choose to install application express. In the process below, we skip that and install it manually after the database creation.
You have two options to use application express.
- Use the oracle http server with mod_plsql
- Use the Embedded Pl/Sql gateway. (From the 11g database)
In this example we use the Embedded Pl/Sql gateway. (This is an http server built into the oracle database)
Create a general purpose database with the 11g Dbca. (We assume that a database listener has been already created and is started up).
Download the apex 3.1.1 software from http://www.oracle.com/technology/products/database/application_express/download.html
Install Oracle application express 3.1.1
cd /apex/
sqlplus / as sysdba
@apex_epg_config
alter user anonymous account unlock;
Setup The port for the Embedded pl/sql gateway
Check if the port is already setup
SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
GETHTTPPORT
———–
0
So xmlhttp is disabled.
Set the port for the http listener
SQL> exec dbms_xdb.sethttpport(8080);
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
GETHTTPPORT
———–
8080
Install oracle application express
sqlplus / as sysdba
SQL> @apexins users users TEMP /i/
Set the password for the apex user “Admin”
@apxxepwd.sql admin
You can now login to application express as the admin user by accessing “use http://yourhostname:8080/apex/apex_admin” and start using Oracle Application Express.
Install the Oracle ILM assistant
Download the ilm assistant from http://www.oracle.com/technology/software/deploy/ilm/index.html
Download the ilm demo from http://www.oracle.com/technology/obe/11gr1_db/manage/ilm/files/ilm.zip
sqlplus / as sysdba
SQL> alter user flows_030100 identified by flows_030100 account unlock;
SQL> @ilma_install flows_030100 users RK01
SQL> alter user flows_030100 identified by flows_030100 account lock;
You can now access Oracle ILM assistant using the following URL.
http://yourhostname:8080/apex/f?p=737677
If you want to install the ILM demos then
first create the sh schema using sh_main from $ORACLE_HOME/demo/schemas/sales_history
cd to the directory where you unzipped the files from ilma_demo_012.zip
Then
sqlplus / as sysdba
@ilm_data
You can then try out the examples at http://www.oracle.com/technology/obe/11gr1_db/manage/ilm/ilm.htm
