APEX INSTALLATION WITH HTTP(OHS) SERVER

Description:

1.We have to install first apex in our database after we have to install http(OHS) server:

Apex Installation

Unzip Apex files in specific PATH.

/u01/htp_new/apex_4.2.5_en.zip
UNZIP apex_4.2.5_en.zip

You unzipped this zip file it can contain a many .sql files in a directory called apex.

Goto apex directory

* /u01/htp_new/apex

create tablespace apex:

CREATE TABLESPACE TAPEX DATAFILE ‘/u01/app/oracle/oradata/HTTPNEW/APEX.dbf’ SIZE 1000M;

Increase the system tablespace size:

alter database datafile ‘/u01/app/oracle/oradata/HTTPNEW/system01.dbf’ resize 2000M;

Check which version is currently installed:

set lines 180
COL comp_name FOR A30
SELECT comp_name, version, status FROM dba_registry WHERE comp_id=’APEX’;

COMP_NAME VERSION STATUS
—————————— —————————— ———–
Oracle Application Express 3.2.1.00.12 VALID

install apex software:
———————–
@apexins.sql TAPEX TAPEX TEMP /i/

Define the virtual image directory as /i/ for future updates.

Change the admin password for admin:
————————————-
again login as sysdba from apex folder.

@apxchpwd

for change the admin password the password contains the following characters:(!”#$%&()”*+,-/:;)

Check again the apex version in registry:
——————————————
set lines 180
COL comp_name FOR A30
SELECT comp_name, version, status FROM dba_registry WHERE comp_id=’APEX’;

COMP_NAME VERSION STATUS
—————————— —————————— ———–
Oracle Application Express 4.2.5.0.0 VALID

Unlock the APEX_PUBLIC_USER ACCOUNT:

ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;

apex installation completed.

HTTP INSTALLATION

COPY THE SOFTWARE IN THE SPECIFIC FOLDER AND

RUN IT USING ./runInstaller.

oracle_home set to /home/oracle/Middleware (0r) set /u01/app/oracle/Middleware
ohs component name: ohs1
instance_name: instance1

after run the ./runInstaller the GUI Mode:
and make the steps are possible.

After installation the finishing stage provide a some Url’s:

1.HTTP SERVER URL–http://Apex2020.doyen.com:7778
2.HTTP SERVER SSL URL—http://Apex2020.doyen.com:4444

Check if its working properly after installation:

cd /home/oracle/Middleware/Oracle_WT1/instances/instance1/bin

the bin folder contains the opmnctl program/

now run the opmnctl command:
@bin>./opmnctl status —the following alive processes are execitables:

Note:
The following 2 commamnds are used to bounce the HTTP server components:

@bin>./opmnctl stopall —is used to stop all the components.
opmnctl stopall: stopping opmn and all managed processes…

@bin>./opmnctl startall– is used to start all the components.
opmnctl startall: starting opmn and all managed processes…

configure ohs for APEX:(HTTP SERVER)

We have to change the following parameters in dads.conf file

these are,

Alias /i/
PlsqlDatabaseConnectString
PlsqlDatabasePassword

copy the image folder from apex folder to Oracle_WT1/images

cp /u01/htp_new/apex/images /home/oracle/Middleware/Oracle_WT1/images

The dads.config stored in the following directory path:

vi /home/oracle/Middleware/Oracle_WT1/instances/instance1/config/OHS/ohs1/mod_plsql/dads.conf

Alias /i/ “/home/oracle/Middleware/Oracle_WT1/images/”

<Location /pls/apex>
Order deny,allow
PlsqlDocumentPath docs
AllowOverride None
PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
PlsqlDatabaseConnectString 192.168.112.147:1521:HTTPNEW TNSFormat
PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8 ———————Character set
PlsqlAuthenticationMode Basic
SetHandler pls_handler
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDatabaseUsername APEX_PUBLIC_USER ——————————-Apex username
PlsqlDefaultPage apex
PlsqlDatabasePassword ************ ————————————password
PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize
Allow from all
</Location>

————————————————————————-
After the change we have to bounce our http components:

@bin>./opmnctl stopall —is used to stop all the components.
opmnctl stopall: stopping opmn and all managed processes…

@bin>./opmnctl startall– is used to start all the components.
opmnctl startall: starting opmn and all managed processes…

@bin>./opmnctl status —the following alive processes are executables:

—————————————————————————

Finally We Login to apex console:

http://<HOSTNAME>:7778/pls/apex.

Sathish Lakshmanan