上设置Oracle数据库

上设置Oracle数据库

本文介绍了在Macbook Pro(OS X Yosemite)上设置Oracle数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我看到Oracle 11g或12c没有针对OS X的下载文件.但是,有一个适用于OS X的SQL Developer版本.当您没有SQL Server时,SQL Developer有什么意义?数据库?

I see that Oracle 11g or 12c doesn't have the download files for OS X. However, there is a version of the SQL Developer available for OS X. What's the point of the SQL Developer when you don't have a database?

如何在OS X上安装Oracle数据库(最好是12c或11g Express Edition)?

How do I install the Oracle database (preferable 12c or 11g Express Edition) on OS X?

推荐答案

您不能直接在OS X 上安装数据库服务器软件.甲骨文不久前决定不再提供支持,这可能是因为甲骨文没有足够的理由证明所涉及的成本合理.我似乎记得它的消亡大致与苹果公司放弃Xserve产品线有关,但我可能已经想象到了.

You can't install the database server software directly on OS X. Oracle made a decision some time ago not so support it any more, presumably because it wasn't used enough to justify the costs involved. I seem to recall its demise roughly coincided with Apple dropping their Xserve line, but I may have imagined that.

从支持的角度来看,像SQL Developer这样的客户端是完全不同的主张. SQL Developer是Java应用程序,需要安装JVM/JDK. Java的一次写入运行"可能并不完全正确,但与相对于完整RDBMS之类的本机编译的野兽相比,支持相对较小的Java应用程序的工作量仍然可能较少.他们显然需要做一些工作才能拥有.app软件包,并且与Windows版本有一些应用程序差异,但是他们不必担心体系结构,系统库等不同,因为这是JVM的问题.

A client like SQL Developer is a very different proposition from a support perspective. SQL Developer is a Java application, and requires a JVM/JDK to be installed. Java's write-once-run-anywhere may not be entirely true, but it's still likely to be rather less work to support a relatively small Java application than a natively-compiled beast like an full RDBMS. They obviously have to do some work to have a .app bundle and there are some application difference from the Windows version, but they don't have to worry about different architecture, system libraries, etc. as that's the JVM's problem.

您可以在Mac上使用SQL Developer来连接运行在Windows或Unix/Linux等上的数据库,因此它仍然占有一席之地;您不能在同一硬件上运行本地服务器这一事实对大多数人而言并不重要.它仅允许开发人员使用Mac,而不是将其强制安装到Windows或Linux PC上.

You can use SQL Developer on a Mac to connect to a database running on Windows or Unix/Linux etc., so it still has a place; the fact you can't have a local server running on the same hardware isn't really relevant for most people. It just allows developers to use a Mac instead of forcing them on to a Windows or Linux PC.

如果您只能访问Mac,那么最简单的方法仍然是如前所述,以安装 VirtualBox 预制的VM映像 Oracle提供.

If you only have access to a Mac then the simplest route is still as noted before, to install VirtualBox and one of the pre-built VM images Oracle provides.

您还可以在Bootcamp上或在Virtualbox,Parallels或VMWare中自己的VM中安装Windows或Linux;然后本地安装Oracle.使用预制映像可以节省您学习如何安装数据库服务器软件的麻烦,并使您更轻松地返回数据库-如果您真的搞砸了,可以将其丢弃并相当简单地重新开始.

You can also install Windows or Linux on Bootcamp or in your own VM in Virtualbox, Parallels or VMWare; and then install Oracle natively. Using a pre-built image saves you needing to learn how to install the database server software, and also makes it easier to go back - if you really mess something up you can trash it and start again fairly simply.

如果您担心性能或电源使用问题,建议您从VM开始,然后看看如何进行;您总是可以稍后再添加Bootcamp,甚至如果想沿着那条路线走动,甚至可以移动数据.

If you're worried about performance or power use I'd suggest you start with a VM and see how you get on; you can always add Bootcamp later and even move the data across if you want to go down that route.

当然,您可以尝试一起破解一些东西. 已完成 10克,但我最近没有看到有人尝试过,因此在优胜美地和11克/12克上可能不那么容易.

You could try to hack something together of course; it's been done before with 10g but I haven't seen anyone trying it recently so it may not be as easy on Yosemite and 11g/12c.

这篇关于在Macbook Pro(OS X Yosemite)上设置Oracle数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-31 00:55