***************************************************
------Installl Oracle APEX 24.1 on Linux 9---------
***************************************************
------Installl Oracle APEX 24.1 on Linux 9---------
***************************************************
-----------------------------------
>> Step 01: Login as Oracle user <<
-----------------------------------
*********************
>>Install apex 24.1<<
*********************
[oracle@CentOS ~]$ cd /u01/
[oracle@CentOS u01]$ ls
app
apache-tomcat-9.0.91.zip
jdk-11.0.22_linux-x64_bin.tar.gz
apex_24.1_en.zip
jri-2.11.0-jasper-6.20.6.zip
ords-23.2.0.177.0931.zip
[oracle@CentOS u01]$ unzip apex_24.1_en.zip
[oracle@CentOS apex]$ cd apex
[oracle@CentOS apex]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jul 16 23:35:35 2024
Version 19.22.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.22.0.0.0
SQL> alter session set container=maxpdb;
Session altered.
SQL> CREATE TABLESPACE apex DATAFILE '/u01/app/oracle/oradata/MAXCDB/maxpdb/apex01.dbf' SIZE 100m autoextend on;
SQL> @apexins.sql apex apex temp /i/ [Install apex software]
SQL> @apxchpwd.sql [For set ADMIN password]
username [ADMIN] - default [Enter]
email [ADMIN] -
password [ADMIN] - Apex#2
SQL> @apex_rest_config.sql [For webservice]
APEX_LISTENER - Apex#2
APEX_REST_PUBLIC_USER - Apex#2
******************
>>Install jdk 11<<
******************
>>Install jdk 11<<
******************
[oracle@dbserver apex]$ cd /u01
[oracle@dbserver u01]$ tar xzf jdk-11.0.22_linux-x64_bin.tar.gz
[oracle@dbserver u01]$ cd /home/oracle/
[oracle@dbserver ~]$ vi .bash_profile
export JAVA_HOME=/u01/jdk-11.0.22
export PATH=$JAVA_HOME/bin:$PATH
export JAVA_HOME=/u01/jdk-11.0.22
export PATH=$JAVA_HOME/bin:$PATH
[oracle@dbserver ~]$ . .bash_profile
[oracle@dbserver ~]$ java -version
java version "11.0.22" 2024-01-16 LTS
Java(TM) SE Runtime Environment 18.9 (build 11.0.22+9-LTS-219)
Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.22+9-LTS-219, mixed mode)
java version "11.0.22" 2024-01-16 LTS
Java(TM) SE Runtime Environment 18.9 (build 11.0.22+9-LTS-219)
Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.22+9-LTS-219, mixed mode)
*******************
>>Install ORDS 23<<
*******************
>>Install ORDS 23<<
*******************
[oracle@dbserver ~]$ vi .bash_profile
export ORDS_HOME=/u01/ords
export ORDS_CONFIG=$ORDS_HOME/config
[oracle@dbserver ~]$ . .bash_profile
[oracle@dbserver ~]$ cd /u01/
[oracle@dbserver u01]$ mkdir ords
[oracle@dbserver u01]$ mv ords-23.2.0.177.0931.zip ords
[oracle@dbserver ords]$ unzip ords-23.2.0.177.0931.zip
[oracle@dbserver ords]$ mkdir config
[oracle@dbserver ords]$ echo $ORDS_HOME
/u01/ords
[oracle@dbserver ords]$ echo $ORDS_CONFIG
/u01/ords/config
[oracle@dbserver ords]$ $ORDS_HOME/bin/ords --config ${ORDS_CONFIG} install
Choose [2]: Enter
Choose [1]: Enter
Enter the database host name [localhost]: 192.168.56.137
Enter the database listen port [1521]:
Enter the database service name [maxcdb]: maxpdb
Enter the administrator username: sys
Enter the database password for SYS AS SYSDBA: oracle
Enter the default tablespace for ORDS_METADATA and ORDS_PUBLIC_USER [SYSAUX]: apex
Enter the temporary tablespace for ORDS_METADATA and ORDS_PUBLIC_USER [TEMP]: temp
Choose [1]:
Choose [1]: 2 [configure for tomcat/weblogic]
[oracle@dbserver ords]$ vi /home/oracle/.bash_profile
export JAVA_OPTS="-Dconfig.url=${ORDS_CONFIG} -Xms512M -Xmx1024M"
[oracle@dbserver ~]$ . .bash_profile
[oracle@dbserver ords]$ echo $JAVA_OPTS
-Dconfig.url=/u01/ords/config -Xms512M -Xmx1024M
***************************
>>Install Apache Tomcat 9<<
***************************
[oracle@dbserver ords]$ cd /u01/
[oracle@dbserver u01]$ unzip apache-tomcat-9.0.91.zip
[oracle@dbserver u01]$ mkdir tomcat
[oracle@dbserver u01]$ mv /u01/apache-tomcat-9.0.91/* /u01/tomcat/
[oracle@dbserver tomcat]$ cd ..
[oracle@dbserver u01]$ rm -rf apache-tomcat-9.0.91
[oracle@dbserver u01]$ cd /home/oracle/
[oracle@dbserver ~]$ vi .bash_profile
export CATALINA_HOME=/u01/tomcat
export CATALINA_BASE=/u01/tomcat
[oracle@dbserver ~]$ . .bash_profile
[oracle@dbserver ~]$ echo $CATALINA_HOME
/u01/tomcat
[oracle@dbserver ~]$ cd $CATALINA_HOME/bin
[oracle@dbserver bin]$ ./startup.sh
Using CATALINA_BASE: /u01/tomcat
Using CATALINA_HOME: /u01/tomcat
Using CATALINA_TMPDIR: /u01/tomcat/temp
Using JRE_HOME: /u01/jdk-11.0.22
Using CLASSPATH: /u01/tomcat/bin/bootstrap.jar:/u01/tomcat/bin/tomcat-juli.jar
Using CATALINA_OPTS:
Tomcat started.
#Check using browser: http://192.168.56.137:8080/
[oracle@dbserver bin]$ cd /u01/tomcat/conf/
[oracle@dbserver conf]$ vi tomcat-users.xml
<role rolename="manager-gui"/>
<user username="admin" password="admin" roles="manager-gui"/>
[oracle@dbserver conf]$ vi server.xml
<Connector port="8889" protocol="HTTP/1.1"
connectionTimeout="20000"
redirectPort="8443"
maxParameterCount="1000"
/>
[oracle@dbserver conf]$ cd /u01/tomcat/webapps/host-manager/META-INF/
[oracle@dbserver META-INF]$ vi context.xml
allow="127\.\d+\.\d+\.\d+|::1|0:0:0:0:0:0:0:1|192.168.56.137" /> [set IP address]
[oracle@dbserver META-INF]$ vi context.xml
allow="127\.\d+\.\d+\.\d+|::1|0:0:0:0:0:0:0:1|192.168.56.137" /> [set IP address]
[oracle@dbserver META-INF]$ vi /u01/tomcat/webapps/manager/META-INF/context.xml
allow="127\.\d+\.\d+\.\d+|::1|0:0:0:0:0:0:0:1|192.168.56.137" /> [set IP address]
[oracle@dbserver bin]$ ./shutdown.sh
[oracle@dbserver bin]$ ./startup.sh
Tomcat started.
#Check from web browser: http://192.168.56.137:8889/
--admin/admin
[oracle@dbserver bin]$ cd /u01/tomcat/webapps/
[oracle@dbserver webapps]$ mkdir i
[oracle@dbserver webapps]$ cp /u01/apex/images/* /u01/tomcat/webapps/i
[oracle@dbserver i]$ cd /u01/tomcat/bin/
[oracle@dbserver bin]$ ./shutdown.sh
[oracle@dbserver bin]$ ./startup.sh
[oracle@dbserver bin]$ cp $ORDS_HOME/ords.war $CATALINA_HOME/webapps
#Check service: http://192.168.56.137:8889/ords
#Login as sys | maxpdb
select * from dba_users where username like '%APEX%';
alter user APEX_PUBLIC_USER identified by oracle account unlock;
[oracle@dbserver images]$ cd /u01/tomcat/webapps/i
[oracle@dbserver i]$ rm -rf *
[oracle@dbserver images]$ cp /u01/apex/images/* /u01/tomcat/webapps/i
#Check service: http://192.168.56.137:8889/ords
create user rest_ms identified by 123 account unlock;
grant dba to rest_ms;
********************
>>Install Jasper 6<<
********************
[oracle@dbserver ~]$ vi tomcat_start.sh
cd $CATALINA_HOME/bin
./startup.sh
[oracle@dbserver ~]$ vi tomcat_stop.sh
cd $CATALINA_HOME/bin
./shutdown.sh
[oracle@dbserver ~]$ sh tomcat_stop.sh
[oracle@dbserver ~]$ sh tomcat_start.sh
[oracle@dbserver ~]$ cd /u01
[oracle@dbserver u01]$ unzip jri-2.11.0-jasper-6.20.6.zip
[oracle@dbserver u01]$ mkdir jasper
[oracle@dbserver u01]$ mv /u01/jri-2.11.0-jasper-6.20.6/* /u01/jasper/
[oracle@dbserver jasper]$ rm -rf /u01/jri-2.11.0-jasper-6.20.6
[oracle@dbserver u01]$ vi /home/oracle/.bash_profile
export JAVA_OPTS="$JAVA_OPTS-Djava.awt.headless=true"
[oracle@dbserver ~]$ . .bash_profile
[oracle@dbserver ~]$ echo $JAVA_OPTS
-Dconfig.url=/u01/ords/config -Xms512M -Xmx1024M-Djava.awt.headless=true
[oracle@dbserver bin]$ cd /u01/jasper/webapp/
[oracle@dbserver webapp]$ mv jri.war jasper.war
[oracle@dbserver webapp]$ cp /u01/jasper/webapp/jasper.war /u01/tomcat/webapps/
[oracle@dbserver ~]$ cd /u01/jasper/bin/
[oracle@dbserver bin]$ ./setConfigDir.sh /u01/tomcat/webapps/jasper.war /u01/jasper
process web.xml
replace config.home with directory: /u01/jasper
[oracle@dbserver bin]$ cd /u01/jasper/conf/
[oracle@dbserver conf]$ vi application.properties
[datasource:rest_ms]
type=jdbc
name=rest_ms
url=jdbc:oracle:thin:@192.168.56.137:1521/maxpdb
username=rest_ms
password=123
[oracle@dbserver conf]$ cd /u01/jasper/bin/
[oracle@dbserver bin]$ ./encryptPasswords.sh /u01/jasper/conf/application.properties
[oracle@dbserver ~]$ sh tomcat_start.sh
Tomcat started.
#Check jasper on browser: http://192.168.56.137:8889/jasper/
Tags
SCRIPT