##########################################################
Environment
##########################################################
APEX Version : 22.1.0
ORDS Version : 21.4.3.117.0405
TOMCAT Version : 9.0.65
Database Version : Oracle Database 12.1.0.2 (Used existing EBS database @ OCI)
Operating System : Oracle Linux 7
##########################################################
Install APEX
##########################################################
=> Remove existing APEX installation from CDB
cd $ORACLE_HOME/apex
sqlplus / as sysdba @apxremov_con.sql
=> Download APEX Software and Copy to database Server as oracle user. unzip apex_22.1.zip
=> https://download.oracle.com/otn_software/apex/apex_22.1.zip
[oracle@ebsdevdb apex]$ pwd
/u01/app/oracle/product/apex
[oracle@ebsdevdb apex]$ ls -ltr
total 235384
-rw-r--r-- 1 oracle oinstall 241017674 Jul 25 11:16 apex_22.1.zip
drwxr-xr-x 2 oracle oinstall 4096 Jul 25 11:16 META-INF
drwxr-xr-x 6 oracle oinstall 4096 Jul 25 12:44 apex
[oracle@ebsdevdb apex]$
=> We are installing APEX in PDB, lets create tablespace in PDB to store APEX data
Session altered.
SQL> create tablespace APEX_DATA datafile size 1G autoextend on maxsize 31g;
Tablespace created.
SQL>
=> Capture existing invalid objects in PDB before installing APEX
create table invalids_ch as (select object_name,owner from dba_objects where status='INVALID');
Post installation verify for any new invalid objects
select count(*) from dba_objects where status='INVALID' and object_name not in (select object_name from invalids_ch);
=> Navigate to apex folder that got create after unzipping apex software and run below command after connecting to PDB
APEX_DATA is the tablespace to store APEX data
TEMP is the temporary tablespace for APEX Schema
Session altered.
SQL> @apexins.sql APEX_DATA APEX_DATA TEMP /i/
.
.
.
ok 3 - 18 actions passed, 0 actions failed | 1.75
Thank you for installing Oracle APEX 22.1.0
Oracle APEX is installed in the APEX_220100 schema.
The structure of the link to the Oracle APEX administration services is as follows:
http://host:port/ords/apex_admin
The structure of the link to the Oracle APEX development interface is as follows:
http://host:port/ords
timing for: Phase 3 (Switch)
Elapsed: 00:01:45.27
timing for: Complete Installation
Elapsed: 00:10:42.04
SYS>
SQL> alter session set container=DEVPDB;
Session altered.
SQL> SELECT STATUS FROM DBA_REGISTRY WHERE COMP_ID = 'APEX';
STATUS
--------------------------------------------
VALID
SQL>
=> Change ADMIN Password for APEX
Session altered.
SQL> @apxchpwd.sql
...set_appun.sql
================================================================================
This script can be used to change the password of an Oracle APEX
instance administrator. If the user does not yet exist, a user record will be
created.
================================================================================
Enter the administrator's username [ADMIN]
User "ADMIN" does not yet exist and will be created.
Enter ADMIN's email [ADMIN]
Enter ADMIN's password []
Created instance administrator ADMIN.
SQL>
=> Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users by running the "@apex_rest_config.sql"
Session altered.
SQL> @apex_rest_config.sql
PL/SQL procedure successfully completed.
Enter a password for the APEX_LISTENER user []
Enter a password for the APEX_REST_PUBLIC_USER user []
...set_appun.sql
...setting session environment
.
.
.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
SQL>
=> Set password for the APEX_PUBLIC_USER, APEX_LISTENER, APEX_REST_PUBLIC_USER and unlock the account
ALTER USER APEX_LISTENER ACCOUNT UNLOCK IDENTIFIED BY "*******";
ALTER USER APEX_REST_PUBLIC_USER ACCOUNT UNLOCK IDENTIFIED BY "*******";
##########################################################
Install ORDS
##########################################################
=> Download ORDS Software and Copy to application server, I created user called xxapache on application server
=> https://download.oracle.com/otn_software/java/ords/ords-21.4.3.117.0405.zip
[xxapache@ebsdevapp01 ords]$ ls -ltr ords-21.4.3.117.0405.zip
-rw-rw-r--. 1 xxapache xxapache 81861484 Jul 26 12:49 ords-21.4.3.117.0405.zip
[xxapache@dlebsdevapp01 ords]$
=> JAVA Pre-Requisite:
This Version of ORDS requires Java 11 and above to run. Please set JAVA_HOME to appropriate version and update PATH.
Download JDK and set environment
export JAVA_HOME=/u01/ords/jdk/jdk-11.0.15.1
export PATH=$JAVA_HOME/bin:$PATH
[xxapache@ebsdevapp01 ~]$
[xxapache@ebsdevapp01 ~]$ which java
/u01/ords/jdk/jdk-11.0.15.1/bin/java
[xxapache@ebsdevapp01 ~]$ java -version
java version "11.0.15.1" 2022-04-22 LTS
Java(TM) SE Runtime Environment 18.9 (build 11.0.15.1+2-LTS-10)
Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.15.1+2-LTS-10, mixed mode)
[xxapache@ebsdevapp01 ~]$
=> Database Parameter Pre-requisite
Set below parameter as per note id - Queries Against SYS.ALL_SYNONYMS Inside A PDB Are Very Slow (Doc ID 2297471.1)
alter system set "_common_data_view_enabled" = false scope=both;
=> Run below command to configure ORDS and provide required details - provide the details of PDB where APEX is already installed.
Ensure that sysdba connection is working from application server through password file.
[xxapache@ebsdevapp01 ords]$ java -jar ords.war setup advanced
Specify the database connection type to use.
Enter number for [1] Basic [2] TNS [3] Custom URL [1]:
Enter the name of the database server [localhost]:ebsdevdb
Enter the database listen port [1521]:
Enter 1 to specify the database service name, or 2 to specify the database SID [1]:
Enter the database service name:DEVPDB
Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]:
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:
Requires to login with administrator privileges to verify Oracle REST Data Services schema.
Enter the administrator username:sys as sysdba
Enter the database password for sys as sysdba:
Confirm password:
Connecting to database user: sys as sysdba url: jdbc:oracle:thin:@//ebsdevdb:1521/DEVPDB
Retrieving information.
Enter the default tablespace for ORDS_METADATA [SYSAUX]:APEX_DATA
Enter the temporary tablespace for ORDS_METADATA [TEMP]:TEMP
Enter the default tablespace for ORDS_PUBLIC_USER [SYSAUX]:APEX_DATA
Enter the temporary tablespace for ORDS_PUBLIC_USER [TEMP]:TEMP
Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:
Enter the PL/SQL Gateway database user name [APEX_PUBLIC_USER]:
Enter the database password for APEX_PUBLIC_USER:
Confirm password:
Enter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) or 2 to skip this step [1]:
Enter the database password for APEX_LISTENER:
Confirm password:
Enter the database password for APEX_REST_PUBLIC_USER:
Confirm password:
Enter a number to select a feature to enable:
[1] SQL Developer Web (Enables all features)
[2] REST Enabled SQL
[3] Database API
[4] REST Enabled SQL and Database API
[5] None
Choose [1]:
2022-07-27T05:28:08.226Z INFO reloaded pools: [|apex||, |apex|al|, |apex|pu|, |apex|rt|]
Installing Oracle REST Data Services version 21.4.3.r1170405
... Log file written to /home/xxapache/ords_install_core_2022-07-27_092808_00977.log
... Verified database prerequisites
... Created Oracle REST Data Services proxy user
... Created Oracle REST Data Services schema
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database objects
... Log file written to /home/xxapache/ords_install_datamodel_2022-07-27_092949_00542.log
... Log file written to /home/xxapache/ords_install_scheduler_2022-07-27_093020_00136.log
... Log file written to /home/xxapache/ords_install_apex_2022-07-27_093047_00988.log
Completed installation for Oracle REST Data Services version 21.4.3.r1170405. Elapsed time: 00:03:07.668
[xxapache@ebsdevapp01 ords]$
=> Configure Network ACL
Session altered.
SQL> BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'APEX_220100',
principal_type => xs_acl.ptype_db));
END;
/ 2 3 4 5 6 7 8
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
##########################################################
Install Apache TOMCAT
##########################################################
I created user called xxapache on application server.
=> installation folder - /u01/xxapache
=> download software - wget https://downloads.apache.org/tomcat/tomcat-9/v9.0.65/bin/apache-tomcat-9.0.65.tar.gz
=> untar software - tar -xvf apache-tomcat-9.0.65.tar.gz -C .
=> start apache
cd /u01/xxapache/apache-tomcat-9.0.65/bin
[xxapache@ebsdevapp01 bin]$ ./catalina.sh start
Using CATALINA_BASE: /u01/xxapache/apache-tomcat-9.0.65
Using CATALINA_HOME: /u01/xxapache/apache-tomcat-9.0.65
Using CATALINA_TMPDIR: /u01/xxapache/apache-tomcat-9.0.65/temp
Using JRE_HOME: /
Using CLASSPATH: /u01/xxapache/apache-tomcat-9.0.65/bin/bootstrap.jar:/u01/xxapache/apache-tomcat-9.0.65/bin/tomcat-juli.jar
Using CATALINA_OPTS:
Tomcat started.
[xxapache@ebsdevapp01 bin]$
[xxapache@ebsdevapp01 bin]$ netstat -an|grep 8080
tcp6 0 0 :::8080 :::* LISTEN
[xxapache@ebsdevapp01 bin]$ ps -ef|grep xxapache
xxapache 5692 1 7 13:53 pts/1 00:00:05 //bin/java -Djava.util.logging.config.file=/u01/xxapache/apache-tomcat-9.0.65/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djdk.tls.ephemeralDHKeySize=2048 -Djava.protocol.handler.pkgs=org.apache.catalina.webresources -Dorg.apache.catalina.security.SecurityListener.UMASK=0027 -Dignore.endorsed.dirs= -classpath /u01/xxapache/apache-tomcat-9.0.65/bin/bootstrap.jar:/u01/xxapache/apache-tomcat-9.0.65/bin/tomcat-juli.jar -Dcatalina.base=/u01/xxapache/apache-tomcat-9.0.65 -Dcatalina.home=/u01/xxapache/apache-tomcat-9.0.65 -Djava.io.tmpdir=/u01/xxapache/apache-tomcat-9.0.65/temp org.apache.catalina.startup.Bootstrap start
##########################################################
Linking TOMCAT, ORDS and APEX
##########################################################
=> Copy /u01/ords/ords.war to /u01/xxapache/apache-tomcat-9.0.65/webapps/ords.war
[xxapache@ebsdevapp01 ords]$ pwd
/u01/ords
[xxapache@ebsdevapp01 ords]$ ls -ltr ords.war
-rw-r--r--. 1 xxapache xxapache 79563604 Jul 26 13:00 ords.war
[xxapache@ebsdevapp01 ords]$
[xxapache@ebsdevapp01 webapps]$ pwd
/u01/xxapache/apache-tomcat-9.0.65/webapps
[xxapache@ebsdevapp01 webapps]$ ls -ltr ords.war
-rw-r--r--. 1 xxapache xxapache 79563604 Jul 26 13:00 ords.war
[xxapache@ebsdevapp01 webapps]$
=> Copy apex images /u01/app/oracle/product/apex/apex/images to Tomcat /u01/xxapache/apache-tomcat-9.0.65/webapps/i/
[oracle@dlebsdevdb images]$ pwd
/u01/app/oracle/product/apex/apex/images
[oracle@dlebsdevdb images]$
[xxapache@ebsdevapp01 i]$ pwd
/u01/xxapache/apache-tomcat-9.0.65/webapps/i/
=> Access ords URL - http://<Apache-IP>:8080/ords
Login through INTERNAL Workspace and ADMIN user password
No comments:
Post a Comment