Oracle APEX 安装Oracle REST Data Services (ORDS) 教程

最新推荐文章于 2025-06-06 09:06:45 发布

原创

最新推荐文章于 2025-06-06 09:06:45 发布 · 1.4w 阅读

10 ·

CC 4.0 BY-SA版权

文章标签：

#APEX

这是一篇关于如何在Oracle APEX环境中安装Oracle REST Data Services (ORDS) 的详细教程，引导读者完成整个配置过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1- Introduction

Tài liệu được viết dựa trên:

Oracle 11g, 12c
ORDS 3.x

2- What is Oracle REST Data Services?

Oracle REST Data Services (ORDS) is a data service which is used to replace Oracle HTTP server and mod_plsql. It bases on Java EE that provides RESTful service and increases security capability. it can deploy on WebLogic, Tomcat, Glassfish or independently.

3- Interaction between Oracle and Oracle APEX ORDS

Normally, there are two ways to install Oracle APEX.

Method 1: Configure the Embedded PL/SQL Gateway: This is the way to configure Oracle APEX which can run on Oracle XML DB HTTP Server, it is a HTTP that is available when you install Oracle 11g or higher.

Method 2: Install Oracle APEX on a specific web server such as WebLogic, Tomcat or Glassfish, ...

Link worked with Oracle APEX as followed:

http://your-server:8080/apex

To use RESTful services, you need to install Oracle ORDS which can deploy on WebLogic Server, Tomcat, Glassfish,.. or independently. Oracle ORDS can read directly to Oracle APEX and replace completely Oracle HTTP Server, therefore you can use RESTful on APEX and new URL to work with Oracle APEX.

http://your-server:8080/ords

4- Download Oracle ORDS

You can download Oracle ORDS at:

http://www.oracle.com/technetwork/developer-tools/rest-data-services/downloads/index.html

Download results:

5- Config ORDS for APEX

CD to apex home directory.

Run the command to configure REST Service.

1

2

3

4

 
         -- Configuring REST Service. 
        
         @apex_rest_config.sql

Sau khi lệnh trên thực thi thành công, 2 user APEX_LISTENER và APEX_REST_PUBLIC_USER đã được tạo ra.

APEX_LISTENER - The account used to query RESTful Services definitions stored in Oracle Application Express.
APEX_REST_PUBLIC_USER - The account used when calling RESTful Services definitions stored in Oracle Application Express.

Enable Network Services

By default, Network Services are disable in Oracle 11g or the newer version. Therefore, you must use the package of DBMS_NETWORK_ACL_ADMIN in order to to grant connect privileges to any host for the APEX_050000 database user

You need to query to view the APEX users in the database:

?

1

Select Username from All_Users where username like 'APEX%' ;

Run command to grant connect privileges to any host for the APEX_050000 database user.

 
         Declare 
        
         Acl_Path Varchar2(4000); 
        
         Begin 
        
         -- Look for the ACL currently assigned to '*' and give APEX_050000 
        
         -- the "connect" privilege if APEX_050000 does not have the privilege yet.