INSTALLING ORACLE APEX 3.1 ON ORACLE 10g

                         

1. Download the Apex 3.1 and move to /home/oracle dir
2. Now unzip the  file .

login to database and execute the following commands.

$sqlplus / as sysdba

sql> show parameter shared_pool_size

If the Shared Pool is Not up to 100M set it.

STEP-3
sql> ALTER SYSTEM SET SHARED_POOL_SIZE='100M' SCOPE=both;

STEP-4
sql> SELECT VALUE FROM v$parameter WHERE NAME = 'job_queue_processes';

STEP-5
If the Job_Queue_Processes is not up 20 then do the Following:

STEP-6
sql> ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 20;

STEP-7
sql> SELECT COMP_NAME,STATUS FROM DBA_REGISTRY WHERE SCHEMA='XDB';

STEP-8
sql> CREATE TABLESPACE apex DATAFILE '/u01/app/oracle/product/10.2.0/oradata/apex/APEX01.DBF ' SIZE 500M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K SEGMENT SPACE MANAGEMENT auto;

cd $ORACLE_HOME/rdbms/admin

Sqlplus "/as sysdba"

SQL> spool text_install.txt
SQL> @catactx.sql CTXSYS SYSAUX TEMP NOLOCK

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 ;

Then Go to Apex home Check the system tablespace is more than 1000M if Not then follow this.


SQL>alter database datafile '/u02/app/oracle/oradata/apex/system01.dbf' resize 2000M;
Database altered.

1. Then Go to the Apex Folder.(cd /home/oracle/apex/)
2. login to sqlplus / as sysdba and execute the following command.
3. SQL>@apexins APEX APEX TEMP /i/

Now the Apex installation was complete. Then follow the steps

Login as sqlplus "/as sysdba"

SQL> ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;

User altered.

STEP
SQL> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle;

User altered.

Integrating Oracle Apex in Web Server

Set the Env for Companion.

 $ vim ias.env 


ORACLE_HOME=/u01/app/oracle/product/10.2.0/ohs; 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


save this file and exit and follw the bellow steps.

$ . ias.env
$ cd /home/oracle/apex
$ cp -R images $ORACLE_HOME/Apache/Apache
$ cd $ORACLE_HOME/Apache/modplsql/conf

Now Edit the Dads.conf file by add and save the fillowing lines into dads.conf

$ vim dads.conf  


Alias /i/ "/u02/app/oracle/product/10.2.0/ias/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         oracle
  PlsqlDatabaseConnectString    192.168.1.2:1521:apex
  PlsqlAuthenticationMode       Basic
  PlsqlDefaultPage              apex
  PlsqlDocumentTablename        wwv_flow_file_objects$
  PlsqlDocumentPath             docs
  PlsqlDocumentProcedure        wwv_flow_file_mgr.process_download
  PlsqlNLSLanguage              AMERICAN_AMERICA.AL32UTF8
</Location>

Enter the following command

$ cd $ORACLE_HOME/Apache/modplsql/conf

$ perl dadTool.pl -o

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

 $ cd /home/oracle/apex
 Login into sqlplus / as sysdba and execute the following cmd.

SQL> @apxchpwd.sql

Enter a value below for the password for the Application Express ADMIN user.
Enter a password for the ADMIN user: Password


After  Enter the Password Login Into Apex .