在Tomcat上安装Oracle REST数据服务（ORDS）

本文介绍了在Tomcat上安装Oracle REST数据服务（ORDS）的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我在服务器上安装了JDK和Tomcat 8。现在我需要安装ORDS并将其连接到Tomcat。我浏览了各种文档并在服务器上下载了ORDS。现在我有几个问题，因为所有这些对我来说都是新的，文档在大多数时候都不是很清楚。

I have installed JDK and Tomcat 8 on the server. Now I need to install ORDS and connect it to Tomcat. I went through various documentation and downloaded ORDS on the server. Now I have a couple of questions as all this stuff is new to me and documentation is not very clear most of the time.

目录中有java.exe我安装了JDK，并且所有ORDS文件都解压缩的目录中有java.exe。我使用哪一个来运行安装是否重要？

There is java.exe in the directory to which I installed JDK and there is java.exe in the directory where all the ORDS files are unzipped. Does it matter which one I use to run the installation?

现在我的第二个问题是我是否运行独立的ORDS安装并指定端口8090，然后复制 ords.war 将文件导入Tomcat目录Tomcat / webapp并确保Tomcat正在运行并且它将自行安装ords？这就是我困惑的地方......

Now my second question is do I run standalone ORDS installation and specify port 8090 and then copy ords.war file into Tomcat diirectory Tomcat/webapp and make sure Tomcat is running and it will install ords on its own? That's where I am confused...

我的第三个问题是如何检查ORDS是否安装正确？会吗？

My third question is how do I check if ORDS has been installed correctly? Would going to http://localhost:8090/ords suffice?

PS Oracle数据库安装在另一台服务器上，我拥有所有密码，主机名，端口和服务名称。 APEX也安装在另一台服务器上。

P.S. Oracle database installed on another server, I have all the passwords, hostname, port, and service name. APEX is also installed on another server.

推荐答案

Appex是ORDS的旧名称。在ORDS版本3.x之后，您不需要安装顶点。

Appex is the old name for ORDS. After the ORDS version 3.x you don't need to install apex.

ORDS 3.0能够部署WITHOUT Application Express。它现在有自己的数据库架构。

您的问题的答案：

没关系。但要确保它是java 7+。您可以改为全局安装java并运行： java -jar ords.war 命令。您可以按照本教程在您的计算机上安装java：

It doesn't matter. But make sure it is java 7+. You can instead install java globally and just run: java -jar ords.war command. You can follow this tutorial to install java on your machine: https://docs.oracle.com/javase/8/docs/technotes/guides/install/install_overview.html

当你跑步时 java -jar ords.war 命令然后在此阶段开始在您的系统上安装ORDS。在安装之前，它要求连接oracle服务器主机名，oracle端口，SID和sysdba用户名和密码。一旦提供了所需的所有详细信息和安装类型，它就会开始安装到特定的数据库服务器。您的tomcat / WLS / glassfish服务器将充当数据库服务器和客户端之间的休息端点。

When you run java -jar ords.war command then at this stage it starts installation of ORDS on your system. Before installation it asks for the oracle server hostname, oracle port, SID, and sysdba username and password to connect. Once you provide all the details and the type of installation you want, then it starts installation to the specific database server. Your tomcat/WLS/glassfish server will act as a rest endpoint between the database server and the clients.

在数据库上安装ORDS后，如果右键单击在SQL Developer中的连接上，您可以看到 Rest Service 选项。是的，另一种方式就像你提到的那样： http：< host-name>：< port-name> /< schema-alias> /< object-alias> / 并查看结果。

Once installed ORDS on your database, if you right click on your connection in SQL Developer then you can see the Rest Service options. And yes the other way is like you mentioned: http:<host-name>:<port-name>/<schema-alias>/<object-alias>/ and see the result.

如果您想了解详细架构，我建议您遵循此oracle文档：

If you want to know the detail architecture, I would suggest to follow this oracle document: http://www.oracle.com/technetwork/developer-tools/rest-data-services/overview/index.html

我最近成功地在生产环境中安装了ORDS。实际上有两种方法可以安装ORDS：

I have recently installed the ORDS in production environment successfully. Actually there are two ways you can install ORDS:

独立模式：
使用sql developer，您可以轻松配置独立模式：

但是如果您想使用终端，您可以使用以下步骤：

高级模式：
。
在高级模式下，ORDS支持Tomcat，WebLogic和Glassfish应用程序服务器

Standalone mode: Using sql developer you can easily configure the standalone mode: http://www.thatjeffsmith.com/archive/2015/04/deploying-oracle-rest-data-services-from-oracle-sql-developer/
But if you would like to use the terminal you can use the following steps:https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-standalone-mode
Advanced mode:https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-3-installation-on-tomcat-7.In the advanced mode ORDS supports Tomcat, WebLogic, and Glassfish application servers

何时使用：

使用高级模式进行生产
使用独立模式进行开发和测试。您可以使用高级模式进行开发和测试，但由于独立模式非常容易安装，因此建议使用。

When to use which:
Use Advanced Mode for productionUse Standalone Mode for Development and Testing. You can use Advanced Mode for development and testing but since the standalone mode is quite easy for installation, it is recommended one.

查询：

注意：如果您的数据库是PDB，则可能在安装它时遇到一些问题根据问题，有一些技巧可以解决它。请让我知道我很乐意回答。

Note: If your database is PDB you could have some problem installing it and there are some tricks to solve it depending on the problem. Please let me know I would love to answer.

这篇关于在Tomcat上安装Oracle REST数据服务（ORDS）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！