oracle - "Faking"Oracle 数据库

Question

在工作中测试我的应用程序的 QA 部门使用他们共享的 Oracle 数据库。事情变得非常棘手，因为他们的案件发生了变化。提交错误报告 + 我花时间只是为了找出测试用例已更改 = 浪费时间。

我希望 dev 和 qa 都在我们的机器上运行我们自己的 Oracle 副本，这样我们就可以保护我们的数据并追逐我们的尾部......更少。

据我所知，问题是我们没有足够的资金来获得所有这些许可。使用开源数据库是行不通的，因为我们有各种 PL/SQL 包和触发器，我敢肯定，它们将我们与 Oracle 联系在一起。

有谁知道“伪造”Oracle 数据库的方法(或者开源产品)？根本没有性能要求。我不是指模拟对象(我们确实将其用于单元测试)，而是实际的“在端口上监听您的请求”RDMS。这是一个远景，但我不得不问。

Answer 1

为此目的使用 Oracle Express。

http://www.oracle.com/technetwork/products/express-edition/overview/index.html

Oracle Database 11g Express Edition

Free to develop, deploy, and distribute

Oracle Database 11g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 11g Release 2 code base. It's free to develop, deploy, and distribute; fast to download; and simple to administer.

Oracle Database XE is a great starter database for:

Developers working on PHP, Java, .NET, XML, and Open Source applications

DBAs who need a free, starter database for training and deployment

Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute free of charge

Educational institutions and students who need a free database for their curriculum

With Oracle Database XE, you can now develop and deploy applications with a powerful, proven, industry-leading infrastructure, and then upgrade when necessary without costly and complex migrations.

Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 11GB of user data, use up to 1GB of memory, and use one CPU on the host machine.

Support is provided through a free Oracle Discussion Forum monitored by Oracle employees as well as community experts.