虚拟托管 Oracle DB 和数据仓库功能
我正在尝试创建一个测试环境(用于我自己的实践和研究),以了解如何使用 Windows 虚拟化 Oracle DB(Unix/Linux 稍后出现......很久以后)。
想法是这样的:
使用Virtual PC(对于win7)并安装带有Hyper V的Server 2008 x64。然后,创建一个连接到它的虚拟客户(XP或其他)。在服务器上安装 Oracle 实例 (11gR2),然后开始从进一步虚拟化的 XP 操作系统连接到数据库实例。 之后,使用该服务器作为数据源,在另一个虚拟化操作系统上创建数据仓库(DWH)。 基本上: 服务器(DB)到DWH 服务器(DB)到客户端计算机 客户端计算机(DWH 管理器)到 DWH
我只是想知道这是否是构建测试环境的有效方法,或者这不是一个好主意,有更好的方法吗?
此外,我对 Hyper-V Server 2008 和虚拟化非常不熟悉(即使在阅读了有关它的文档之后 - 具有实际经验的人会在建议中有所帮助)
我的计算机上安装了 Win 7 x64,并且一直在运行 11gR2 DB过去 6 个月作为个人项目(和继续教育)的一部分,
我感谢所有建议,谢谢
I am trying to create a test environment (for my own practice and research) on how best to virtualize an Oracle DB using windows (Unix/Linux comes later...much later).
Here's the idea:
Use Virtual PC (for win7) and install Server 2008 x64 with Hyper V. Then, create a virtual guest (XP or something) that connects to it. Install an Oracle instance (11gR2) on the server and then go to work to connect to the DB instance from furhter vitualized XP O/S.
After that, create a Data Warehouse (DWH) on another virtualized O/S using the server as the data source.
Basically:
Server(DB) to DWH
Server(DB) to client computer
client computer (DWH Manager) to DWH
I would just like to know if this seems a valid way to build a testing environment or is this not such a good idea and there are better ways to do this?
Additionally, I am largely unfamiliar with Hyper-V Server 2008 and virtualization (even after reading the docs on it - someone with practical experience would be helpful in suggestions)
I have Win 7 x64 installed on my machine and have been running an 11gR2 DB for the past 6 months as part of a personal project (and continued education)
I appreciate any and all suggestions, thanks
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
您有什么顾虑?主要缺点是性能,但这在开发环境中通常并不那么重要。
What are your concerns? The main disadvantage will be performance, but that's usually not that important in a development environment.