原

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

2017年06月29日 14:30:35 阅读数：7134 标签： APEX
个人分类： Oracle APEX
所属专栏： Oracle APEX新手教程
版权声明：http://www.sunansheng.com/ https://blog.csdn.net/sunansheng/article/details/73897999

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:
Download results:

5- Config ORDS for APEX

CD to apex home directory.
Login to sqlplus as sysdba.
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.
  1. APEX_LISTENER - The account used to query RESTful Services definitions stored in Oracle Application Express.
  2. 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 ofDBMS_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.
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
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.
   Select Acl
   Into   Acl_Path
   From   Dba_Network_Acls
   Where  Host = '*'
   And    Lower_Port Is Null
   And    Upper_Port Is Null;
   If Dbms_Network_Acl_Admin.Check_Privilege(Acl_Path
                                            ,'APEX_050000'
                                            ,'connect') Is Null Then
      Dbms_Network_Acl_Admin.Add_Privilege(Acl_Path
                                          ,'APEX_050000'
                                          ,True
                                          ,'connect');
   End If;
Exception
   -- When no ACL has been assigned to '*'.
   When No_Data_Found Then
      Dbms_Network_Acl_Admin.Create_Acl('power_users.xml'
                                       ,'ACL that lets power users to connect to everywhere'
                                       ,'APEX_050000'
                                       ,True
                                       ,'connect');
      Dbms_Network_Acl_Admin.Assign_Acl('power_users.xml'
                                       ,'*');
End;
/
 
Commit;

Grant connect for APEX_050000 user (If database is Oracle 11g):

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
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.
   Select Acl
   Into   Acl_Path
   From   Dba_Network_Acls
   Where  Host = '*'
   And    Lower_Port Is Null
   And    Upper_Port Is Null;
   If Dbms_Network_Acl_Admin.Check_Privilege(Acl_Path
                                            ,'APEX_050000'
                                            ,'connect') Is Null Then
      Dbms_Network_Acl_Admin.Add_Privilege(Acl_Path
                                          ,'APEX_050000'
                                          ,True
                                          ,'connect');
   End If;
Exception
   -- When no ACL has been assigned to '*'.
   When No_Data_Found Then
      Dbms_Network_Acl_Admin.Create_Acl('power_users.xml'
                                       ,'ACL that lets power users to connect to everywhere'
                                       ,'APEX_050000'
                                       ,True
                                       ,'connect');
      Dbms_Network_Acl_Admin.Assign_Acl('power_users.xml'
                                       ,'*');
End;
/
 
Commit;

Grant connect for APEX_050000 user (If database is Oracle 12c):

Procedures CREATE_ACL, ASSIGN_ACL, ADD_PRIVILEGE and CHECK_PRIVILEGE in DBMS_NETWORK_ACL_ADMIN are deprecated in Oracle Database 12c. Oracle recommends using APPEND_HOST_ACE instead.
?
1
2
3
4
5
6
7
8
9
10
-- Sử dụng cho Oracle 12c.
 
BEGIN
    DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
        host => '*',
        ace => xs$ace_type(privilege_list => xs$name_list('connect'),
                           principal_name => 'APEX_050000',
                           principal_type => xs_acl.ptype_db));
END;
/

6- Deploying ORDS

Note: you must sure that you have installed Jave version 7 or higher and declare PATH variable. You can see how to install Java at:
Add the path to bin folder of Java at the end of PATH
  • ;C:\DevPrograms\Java\jdk1.8.0_65\bin
Unzip the file ord - **. zip that you have downloaded to a folder
You can see that in the folder unzipped have ords.war file
Copy  images folder in apex to ords folder:
Now, we will install  Oracle ORDS independently (It is not necessary to deploy on Weblogic, Tomcat or other web server)
CD to ords folder:
Next, login sqlplus as sysdba.
Your Oracle APEX is running on Oracle XML DB  HTTP Server, you should disable it with the command:
?
1
2
3
4
5
6
7
8
--  Disable Oracle APEX on Oracle XML DB HTTP Server.
 
EXEC DBMS_XDB.SETHTTPPORT(0);
 
 
-- Note: You can enable it with command:
 
EXEC DBMS_XDB.SETHTTPPORT(8080)
Exit sqlplus. And CD to ords:
Run command:
?
1
2
3
4
5
6
7
# Run command:
 
java -jar ords.war
 
# Or:
 
java -jar ords.war install
Enter the address of the machine that contains the database (default is localhost):
Port of database (Default is 1521):
Enter Service Name or SID of database:
Enter password for ORDS_PUBLIC_USER
Sqlplus requests to re-enter the user database information with sysdba rights. (Enter sys and then password).
SQLPlus will ask whether you use Oracle APEX or not, if yes let's enter 1, then press "enter" to continue.
Entering a password for user will be created (APEX_PUBLIC_USER):
Next, enter 1 to specify password for 2 newly created  user database (APEX_LISTENER, APEX_REST_PUBLIC_USER).
Select 1 to start ORDS in standalone mode:
You have configured ORDS successfully. Close CMD window

Running ORDS

Note: You can run the command below to see the help:
?
1
java -jar ords.war help standalone
CD to ORDS folder and run command:
?
1
java -jar ords.war standalone --port 8080 --apex-images C:/DevPrograms/ords/images
For the 1st time, it will ask where to place configure file:
ORDS has been successfully deployed.
Note: If you receive an error:
Unlock for APEX_PUBLIC_USER user
?
1
2
3
4
5
6
7
8
Column username format a25;
Column account_status format a25;
 
-- Query unlocked APEX user.
 
select username,account_status from dba_users
 where lock_date is not null
 and username like 'APEX%';
?
1
Alter user APEX_PUBLIC_USER account unlock;
The configure file is also created after you deployed ORDS:
Don't close the window above, you can use APEX with new url:
阅读更多
想对作者说点什么？

Oracle Apex 5.0安装教程

07-03 8191

1- The installation requiresBefore installing  Oracle Application Express (Oracle APEX) you need to:... 来自： 苏南生的CSDN博客

Oracle APEX 4.2安装和配置

12-26 4281

A standard Oracle 11.2.0.3 database installation comes bundled with Application Express (APEX) 3.2.1... 来自： 苏南生的CSDN博客

Oracle EBS + APEX

01-04 3508

除了原有的客户化方式之外，现在又多了一种EBS个性化的方式- Oracle APEX (Oracle Application Express)。如果是做一些不是非常复杂Web应用(并与EBS集成)，使... 来自： Paul's Notes

Oracle APEX 5.1发布 RESTful Web Service教程

07-01 6800

Before You BeginPurposeThis tutorial covers creating a RESTful Web Service and accessing the Web Ser... 来自： 苏南生的CSDN博客

Oracle REST Data Services(ORDS)-通过REST接口操作Oracle数据库

02-08 1202

   简介 ORDS，Oracle REST Data Services，通过一个java中间层应用，将HTTP（S）动词（GET，POST，PUT，DELETE等）等REST接口映射到数据库事务，并... 来自： q499803363的专栏

Oracle REST Data Services (ORDS) 安全认证机制

07-06 5860

HTTP or HTTPSBy default, the OAuth2 protocol requires all calls to be performed using HTTPS. You can... 来自： 苏南生的CSDN博客

Oracle APEX installation with ORDS

08-04 3506

在开始之前，先介绍下Oracle Application Express（APEX）。 Oracle Application Express—APEX for short, or by its for... 来自： yangyangman

Oracle APEX系列（一） 安装

08-29 2.1万

 在网上粗略的搜索了一下，已经有很多关于Oracle Application Express（APEX）的文章了，真的很高兴看到已经有这么多国内的朋友使用起这个工具了。要知道，在Oracle公司的很多... 来自： tina的专栏

Oracle的apex4.2 安装教程（带汉化）

02-08 188

Oracle的apex4.2 安装教程（带汉化）安装介绍前提:      你已经安装完Oracle11g 和下载好apex并解压完毕；我的Oracle是11g 的版本。Apex 4.2.2 版本。Ap... 来自： Mr_Czg

APEX的安装

01-20 3111

http://blog.csdn.net/tinawang11/article/details/1136548 安装APEX还算简单，一步步按照Installation guide就可以。我是装了O... 来自： cnbird's blog

相关热词
oracle和 oracle与 oracle上午 oracle伪劣 oracle空串

博主推荐

换一批

没有更多推荐了，返回首页
注册