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 .





  • April 24, 2013 | 55 views