Oracle APEX 访问
Oracle Application Express 是否适合 Intranet 客户端/服务器应用程序？ 如果是这样，我应该怎么做才能使客户端访问应用程序？
嗯，我是一名 PowerBuilder/Oracle 开发人员，所以我熟悉客户端/服务器架构。 我最近读了一篇关于 APEX 的文章，所以我想开发我的 PowerBuilder/Oracle 应用程序的 APEX 变体，这几乎是 HR 应用程序。 它不应该是可访问互联网的应用程序，而只是小型网络中的几个 Windows 盒子。 我对使用 PL/SQL 和 SQL 开发应用程序没有任何问题（不过，我必须大量阅读和询问）。 我只是想知道 APEX 是否适合 Intranet 应用程序 - 它应该适合 Internet 应用程序:) - 以及我应该如何使客户端的浏览器访问应用程序，因为不会有像 http:/www.appdomain 这样的东西。 com？ 我对win网络几乎一无所知:)
Is Oracle Application Express suitable for Intranet client/server application?
If so, what should I do to enable client access to application?
Well, I am working as a PowerBuilder/Oracle developer, so I am familiar with client/server architecture. I have recently read an article about APEX so I would like to develop APEX variation of my PowerBuilder/Oracle app, which is pretty much HR app. It should not be Internet accessible app, just a couple of windows boxes in a small network. I have no problem with developing app in PL/SQL and SQL (will have to read and ask a lot, though). I would just like to know is APEX suitable for Intranet app - it should be as it is suitable for Internet app :) - and how should I enable client's browser to access an application since there would be nothing like http:/www.appdomain.com ? I know next to nothing about win networks :)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
“因为不会有像 http://www.appdomain.com 这样的东西”
鉴于您熟悉客户端/服务器技术，我猜您了解 TNSNAMES.ORA
您的 Apex 主机的定义方式与 tnsnames.ora 中定义数据库主机的方式类似
如果您的 tnsnames.ora 表示您的数据库位于 192.168.0.255，那么您的 Apex 主机将具有类似（丑陋）的名称。 如果它说它被定义为 dbhost，那么您组织中将 dbhost 映射到特定计算机的任何人都可以对您的 Web 服务器执行相同的操作。 唯一需要注意的是，有时您的浏览器中定义了特定的代理，并且您的 apex Web 服务器可能需要作为例外添加。
"since there would be nothing like http:/www.appdomain.com"
Given you are familiar with client/server technology, I guess you know about TNSNAMES.ORA
Your Apex host would be defined in a similar manner to the way the database host is defined in tnsnames.ora
If your tnsnames.ora says that your database is at 192.168.0.255, then your Apex host would have a similar (ugly) name. If it says it is defined as dbhost, then whoever in your organisation has mapped dbhost to a particular machine can do the same for your webserver. The only caveat is that sometimes you have a specific proxy defined in your browser and your apex webserver may need to be added as an exception.
APEX 不是客户端/服务器应用程序开发环境，因此答案显然是否定的。
Apex 是一个 n 层 Web 应用程序架构，其中 n=3：您的浏览器、Apex Web 应用程序服务器和数据库。 在这种情况下，应用程序服务器有点有趣的混合体，因为它实际上执行数据库中的几乎所有代码，而不是中间层。
客户端/服务器是您在用户端部署应用程序（而不是如上所述使用浏览器）并连接到服务器（例如 Oracle 数据库服务器）的地方。 过去很常见的是 VB 前端连接到 Oracle 后端。 现在已经不那么重要了；）
如果您有 Oracle 商店，APEX 就很棒。 如果是小型应用程序，您可以使用“Oracle Database XE”，这是与 APEX 捆绑在一起的免费版本，但对 CPU 和存储有限制。
我猜您可能会问 Oracle 的 XE 数据库版本是否良好/稳定并准备好在客户端服务器应用程序设置中使用？ 恕我直言，绝对是一个很好的起点，或者停留在小型、简单的应用程序上，但它在修复已知问题、错误等方面停留在原地。虽然这些往往是非常非常具体的情况，需要正确的组合由于多种因素的出现，您不希望期望许可证和支持是免费的，但后来发现您将不得不返回到数据库的完整企业版本。 也不是与 Oracle 销售人员讨价还价的最佳位置:)
也许你可以用不同的方式表达你的问题？
APEX is NOT a client/server application development environment, hence the answer is clearly "no".
Apex is an n-tier web application architecture where n=3: Your browser, the Apex web application server, and the database. The app server in this case is a bit of a funny hybrid because it actually executes almost all the code in the database, not in the middle tier.
Client/server is where you deploy an application on the user side (as opposed to using the browswer as noted above) and you connect to a server (e.g. oracle db server). Very common back in the day was VB front end connecting to an Oracle backend. Not so much of that these days ;)
APEX is GREAT if you have an Oracle shop. If it is a small application, you can use "Oracle Database XE", the free version that comes bundled with APEX with limitations on CPU and storage.
I'm guessing you might be asking if the XE database version from Oracle is good/stable and ready for use in a client server application setting? IMHO, absolutely a great place to start, or stay with small, simple applications, but it it stuck where it is in terms of fixes to known problems, bugs, etc.. While these tend to be very very specific situations where the right combination of factors appears, you don't want to set expectations that license and support will be free to find out later on that you will have to go back to the full enterprise version of the database. Also not the best bargaining position to be in with Oracle sales people :)
Maybe you could phrase your question a bit differently?
伊戈尔，
我参加这个聚会真的迟到了，但你似乎没有得到你喜欢的答案。
Apex 绝对是一个用于开发小型内部 Web 应用程序（如您所描述的）的出色工具。 这比在 PB（我也使用）中做同样的事情要容易英里。 如果您的网络上已经安装了 Oracle，则要求 DBA 也安装 Apex，它仅安装在 Oracle 中（不需要外部东西），这可以相当快地完成。 （我在我的家用 PC 上的 Oracle XE 上运行 Apex。）安装后，DBA 必须告诉您 Apex 的 URL。
完成此操作后，请自己完成为期 2 天的开发人员指南，了解 Apex 应用程序的开发方式，然后尝试一下。 掌握它需要一些时间，但一旦掌握了，它就非常有效。 但是，如果您了解应用程序的数据和业务逻辑，那么您应该不会花很长时间。 您还可以安装许多示例应用程序，然后查看它们的源代码以了解方法。
开始使用后，请加入 Oracle Apex 用户论坛，这是一个供开发人员互相帮助的绝佳社区。 你会经常在那里找到我。
祝你好运！
炖
Igor,
I'm coming really late to this party, but you didn't seem to get an answer you liked.
Apex is absolutely a great tool for developing a small in-house web application such as you're describing. It'll be miles easier than doing the same thing in PB (which I also use). If Oracle is already installed on your network then ask the DBAs to also install Apex, which is installed only within Oracle (no external stuff needed), which can be done fairly quickly. (I'm running Apex on my home PC on top of Oracle XE.) After the installation, the DBAs will have to tell you the URL for Apex.
After they've done that, walk yourself through the 2-day Developer Guide to get an idea of how Apex apps are developed, then try it out. It'll take a bit to get the hang of it, but once you do, it's really efficient. But if you understand the data and business logic for your application, you shouldn't take long. There are also a lot of sample applications out there you can install and then check out their source code for methods.
Once you get started, join Oracle Apex User Forum, which is a great community for developers helping eachother. You'll find me there regularly.
Good luck!
Stew
Application Express 应用程序通过浏览器中的 URL 进行访问，URL 类似于：
客户端/服务器应用程序必须启动浏览器窗口并传入适当的 URL。
Application Express applications are accessed via a URL in a browser, with a URL something like:
A client/server application would have to launch a browser window and pass in the appropriate URL.