Oracle APEX安装部署,一起里来用AI开发

原创 IT邦德 All China Database Union 2024-09-29

1490

作者：IT邦德
中国DBA联盟(ACDU)成员，10余年DBA工作经验，
Oracle、PostgreSQL ACE
CSDN博客专家及B站知名UP主，全网粉丝10万+
擅长主流Oracle、MySQL、PG、
高斯及Greenplum备份恢复，
安装迁移，性能优化、故障应急处理

微信:jem_db
QQ交流群:587159446
公众号：IT邦德

文章目录

前言

1.概述
2.安装 APEX

2.1 删除已有安装
2.2 解压安装

3.安装ORDS

3.1 JDK安装
3.2 解压安装文件
3.3 创建静态资源目录
3.4 配置ORDS

4.访问APEX/ORDS

前言

Oracle公司对APEX的口号是：构建企业应用速度提高20倍，代码减少100 倍,截止目前，最新的版本是24.1。

1.概述

APEX/ORDS有多种安装模式，本手册仅为其中一种，采用的是ORDS独立运行模式。根据实际场景，也可以把ORDS部署到Tomcat等Web容器中。
本文中APEX和ORDS都使用目前最新版本：APEX24和ORDS24
APEX和ORDS将安装在Oracle 19C数据库中。

资源下载下载最新的APEX (Oracle APEX xxx - All languages):
https://www.oracle.com/tools/downloads/apex-downloads/

下载最新的ORDS (Oracle REST Data Services):
https://www.oracle.com/database/technologies/appdev/rest-data-services-downloads.html

2.安装 APEX

2.1 删除已有安装

如果已经安装，则执行apxremov.sql删除已有安装。
[root@centos79 ~]# su - oracle
Last login: Fri Sep 27 06:00:25 CST 2024 on pts/0
[oracle@dbhost ~]$ cd $ORACLE_HOME/apex
[oracle@dbhost apex]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Sep 27 06:04:31 2024
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> @apxremov.sql

2.2 解压安装

1.解压安装包，并注意文件目录的权限,以下Oracle用户下操作

mkdir -p /u01/app
unzip -q /opt/apex_24.1.zip -d /u01/app

2.创建表空间
SQL> select FILE_NAME from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORCL/users01.dbf
/u01/app/oracle/oradata/ORCL/undotbs01.dbf
/u01/app/oracle/oradata/ORCL/system01.dbf
/u01/app/oracle/oradata/ORCL/sysaux01.dbf

SQL> create tablespace tbs_apex datafile '/u01/app/oracle/oradata/ORCL/apex01.dbf' size 100m autoextend on maxsize 30G;
Tablespace created.

3.安装APEX
cd /u01/app/apex
SQL> @apexins.sql TBS_APEX TBS_APEX TEMP /i/;
耐心等待，需要一些时间，中途不要退出。

4.创建apex实例管理员及密码
密码必须包含特殊符号，否则设置不上。
这个密码很重要，是管理APEX平台的账号密码，以后创建新的应用schema、解锁账号等都靠它，第一次登录APEX时也要用到。这里密码统一设置为Welcome123##

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] ADMIN
User "ADMIN" does not yet exist and will be created.
Enter ADMIN's email [ADMIN] apex.user@oracle.com
Enter ADMIN's password [] 
Created instance administrator ADMIN.

5.配置 RESTful Services 服务
这里需要输入 APEX_LISTENER 和 APEX_REST_PUBLIC_USER 两个用户密码，我这里统一设置为Welcome123##
SQL> @apex_rest_config.sql

Enter a password for the APEX_LISTENER user              [] 
Enter a password for the APEX_REST_PUBLIC_USER user              [] 
...set_appun.sql
...setting session environment
...create APEX_LISTENER and APEX_REST_PUBLIC_USER users
...grants for APEX_LISTENER and ORDS_METADATA user


6.配置ACL
先找到相应的用户名，本例中是 APEX_240100

SYS> select username from dba_users where username like 'APEX%';  

USERNAME
--------------------------------------------------------------------------------
APEX_LISTENER
APEX_PUBLIC_ROUTER
APEX_PUBLIC_USER
APEX_REST_PUBLIC_USER
APEX_240100

SQL> BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'APEX_240100',
principal_type => xs_acl.ptype_db));
END;
/


7.禁用数据库内置的 PL/SQL 网关
SQL> exec dbms_xdb.sethttpport(0);
SQL> exec dbms_xdb.setftpport(0);

8.解锁 APEX account
SQL> alter user APEX_LISTENER account unlock;
SQL> alter user APEX_REST_PUBLIC_USER account unlock;
SQL> alter user APEX_PUBLIC_USER account unlock;
SQL> alter user APEX_PUBLIC_USER identified by Welcome123##;
SQL> CREATE PROFILE password_unlimited LIMIT PASSWORD_LIFE_TIME UNLIMITED;
SQL> ALTER USER apex_public_user PROFILE password_unlimited;
SQL> alter profile default limit password_verify_function null;

8.apex 汉化
SQL> alter session set CURRENT_SCHEMA = APEX_240100;
SQL> start ./builder/zh-cn/load_zh-cn.sql;
耐心等待执行完成。

3.安装ORDS

3.1 JDK安装

ords 24需要 java 11 以上（jdk-21_linux-x64_bin.tar.gz）
tar -zxvf /opt/jdk-21_linux-x64_bin.tar.gz -C /usr/local

vim ~/.bashrc

export JAVA_HOME=/usr/local/jdk-21.0.4
export JRE_HOME=${JAVA_HOME}/jre
export CLASSPATH=.:${JAVA_HOME}/lib:${JRE_HOME}/lib:$CLASSPATH
export JAVA_PATH=${JAVA_HOME}/bin:${JRE_HOME}/bin
export PATH=$PATH:${JAVA_PATH}

##环境变量生效
source ~/.bashrc

##确认安装是否成功
java -version

[root@dbhost ~]# java -version
java version "21.0.4" 2024-07-16 LTS
Java(TM) SE Runtime Environment (build 21.0.4+8-LTS-274)
Java HotSpot(TM) 64-Bit Server VM (build 21.0.4+8-LTS-274, mixed mode, sharing)

3.2 解压安装文件

--以下Oracle用户操作
unzip /opt/ords-24.2.3.201.1847.zip -d /u01/app/ords

设置 PATH, 增加 ords/bin 目录:
vim ~/.bashrc

# ords/bin目录
export PATH=$PATH:/u01/app/ords/bin
# ords/config目录
export ORDS_CONFIG=/u01/app/ords/conf

--变量生效
source ~/.bashrc

3.3 创建静态资源目录

登陆Oracle用户，并记录下此目录路径，下面要用到。
mkdir apex_images
cd apex_images
#apex静态文件目录：/home/oracle/apex_images
cp -r /u01/app/apex/images/* .

3.4 配置ORDS

创建配置目录
mkdir -p /u01/app/ords/conf

ords --config /u01/app/ords/conf install


指定ip、port、service name，最后输入sys及sys密码，反之则选择[1]
Configuration:
  /u01/app/ords/conf

The configuration folder /u01/app/ords/conf does not contain any configuration files.

Oracle REST Data Services - Interactive Install

  Enter a number to select the database connection type to use
    [1] Basic (host name, port, service name)
    [2] TNS (TNS alias, TNS directory)
    [3] Custom database URL
  Choose [1]: 1
  Enter the database host name [localhost]: 
  Enter the database listen port [1521]: 
  Enter the database service name [orcl]: 
  Provide database user name with administrator privileges.
    Enter the administrator username: sys
  Enter the database password for SYS AS SYSDBA: 

Retrieving information.
ORDS is not installed in the database. ORDS installation is required.

  Enter a number to update the value or select option A to Accept and Continue
    [1] Connection Type: Basic
    [2] Basic Connection: HOST=localhost PORT=1521 SERVICE_NAME=orcl
           Administrator User: SYS AS SYSDBA
    [3] Database password for ORDS runtime user (ORDS_PUBLIC_USER): <generate>
    [4] ORDS runtime user and schema tablespaces:  Default: SYSAUX Temporary TEMP
    [5] Additional Feature: Database Actions
    [6] Configure and start ORDS in Standalone Mode: Yes
    [7]    Protocol: HTTP
    [8]       HTTP Port: 8080
    [9]   APEX static resources location: 
    [A] Accept and Continue - Create configuration and Install ORDS in the database
    [Q] Quit - Do not proceed. No changes
    
 --记住这里选择A


--配置 apex静态内容,请先终止ords服务，终止后再进行配置。
ords config set --global standalone.static.context.path /i

#/home/oracle/apex_images为Apex的静态资源目录
ords config set --global standalone.static.path /home/oracle/apex_images

启动：
ords --config /u01/app/ords/conf serve

4.访问APEX/ORDS

访问管理员控制台，执行创建工作区和用户等操作

本例中访问信息如下：
URL: http://192.168.6.8:8080/ords/apex_admin
用户名：ADMIN 密码：Welcome123##

确认apex ords 是否正常安装，如下所示，则安装成功，反之请重新安装ORDS.
wget http://192.168.6.8:8080/ords/


http://192.168.6.8:8080/ords
workspace:internal
username:admin
password:Welcome123##