在本地 Oracle 实例上开发
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/26002/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Develop on local Oracle instance
提问by Matt Hinze
I want our team to develop against local instances of an Oracle database. With MS SQL, I can use SQL Express Edition. What are my options?
我希望我们的团队针对 Oracle 数据库的本地实例进行开发。使用 MS SQL，我可以使用 SQL Express Edition。我有哪些选择？
采纳答案by AlexCuse
回答by stevechol
I have had a lot of success using Oracle 10g Express Edition. It comes with Oracle Aplication Express which allows the simple admin and creation of software via a web interface. It is limited to 4Gb of Disk Space, 1Gb of Ram and will only use 1 processor.
我使用 Oracle 10g Express Edition 取得了很多成功。它带有 Oracle Aplication Express，允许通过 Web 界面进行简单的软件管理和创建。它被限制为 4Gb 的磁盘空间，1Gb 的 RAM，并且只能使用 1 个处理器。
It's free and in my experience has been 100% reliable. It can easily be hosted within a Virtual machine.
它是免费的，根据我的经验，它是 100% 可靠的。它可以轻松托管在虚拟机中。
Also Oracle SQL Developer is a cross platform application that can be used with any version of Oracle and is also free. Oracle 10g is superb. Go for it :-)
此外，Oracle SQL Developer 是一个跨平台的应用程序，可以与任何版本的 Oracle 一起使用，而且是免费的。Oracle 10g 非常棒。去吧 ：-）
回答by morais
I'm happy with Oracle XE for development purposes.
我对用于开发目的的 Oracle XE 感到满意。
I do have this piece of wisdow to share; if you're having problems like ORA-12519: TNS:no appropriate service handler found or ORA-12560: TNS:protocol adapter error from time to time then try to change your PROCESSES parameter, logon to Oracle using sys as sysdba and execute the following:
我确实有这个智慧要分享；如果您遇到诸如 ORA-12519: TNS:no合适的服务处理程序或 ORA-12560: TNS:protocol adapter error 之类的问题，请尝试更改您的 PROCESSES 参数，使用 sys 作为 sysdba 登录到 Oracle 并执行下列的：
ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;
After changing the PROCESSES parameter restart your Oracle service.
更改 PROCESSES 参数后，重新启动 Oracle 服务。
回答by Matthew Christensen
回答by Matt Hinze
We ended up using Oracle XE. Install client, install express, reboot, it just works.
我们最终使用了 Oracle XE。安装客户端，安装 express，重启，就可以了。
回答by Eli Courtwright
I don't recommend Oracle XE. My co-workers and I have been doing a project in Oracle and got severely tripped up after trying to use XE for our local development instances. The database worked fine until we started running local stress tests, at which point it started dropping connections.
我不推荐 Oracle XE。我和我的同事一直在 Oracle 中做一个项目，并在尝试将 XE 用于我们的本地开发实例后被严重绊倒。数据库运行良好，直到我们开始运行本地压力测试，此时它开始断开连接。
I don't know whether this is an intentional, documented limitation or if perhaps we each just hit a weird bug, but I strongly recommend that you stay away from XE. When we both switched over to the full version, our problems immediately went away.
我不知道这是有意的、记录在案的限制，还是我们每个人都遇到了一个奇怪的错误，但我强烈建议您远离 XE。当我们都切换到完整版时，我们的问题立即消失了。
Also, Oracle doesn't require any kind of licensing confirmation for the full server; you have to click something to say that you have indeed acquired a license, but it doesn't make you prove it. So if you indeed have a license to use Oracle, there's no reason why you can't just install the full version on your development machines.
此外，Oracle 不需要对整个服务器进行任何类型的许可确认；您必须单击某些内容才能说您确实获得了许可证，但这并不能使您证明这一点。因此，如果您确实拥有使用 Oracle 的许可证，那么您没有理由不能在您的开发机器上安装完整版本。
