APEX INSTALLATION WITH HTTP(OHS) SERVER



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:


1.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  


  • login as sysdba to database.



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.




2.HTTP INSTALLATION:




COPY THE SOFTWARE IN THE SPECIFIC FOLDER AND RUN IT USING ./runInstaller.


./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:


Processes in Instance: instance1
———————————+——————–+———+——————
ias-component                    | process-type       |     pid | status  
———————————+——————–+———+——————-
webcache1                        | WebCache-admin     |   12370 | Alive   
webcache1                        | WebCache                |   12369 | Alive   
ohs1                                   | OHS                          |   12368 | Alive   


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:


Processes in Instance: instance1
———————————+——————–+———+———
ias-component                    | process-type       |     pid | status  
———————————+——————–+———+———
webcache1                        | WebCache-admin     |   12370 | Alive   
webcache1                        | WebCache                |   12369 | Alive   
ohs1                                  | OHS                          |   12368 | Alive   


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


Finally We Login to apex console:


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






  

  • October 4, 2018 | 20 views
  • Comments