如何浏览 Oracle 服务器上的数据库？
因此，我作为一名 SQL Server 开发人员，在很久以前就编写过一些 PL/SQL，但实际上一无所知。
我有一台笔记本电脑，它运行 Oracle。笔记本电脑上有一个数据库，我需要查看一下，但我或我能与之交谈的其他人都不知道它的名字。
我有几个登录名，其中一个声称是管理员登录名。
浏览服务器上的数据库然后连接到数据库的最简单方法是什么？
我怀疑我对 SQL Server 服务器、用户和数据库之间关系的假设让我误入歧途，但现在我无法摆脱 Oracle 提供的客户端工具只是某人的一个笑话的想法，但我真的没有找到它太有趣了。
我很确定正在运行的是 9.2 版本。
很高兴提供更多信息，但现在我不知道从哪里开始。
So I'm coming from a position as a SQL Server developer who has written a little bit of PL/SQL way back in the mists of time but effectively knows nothing.
I've got a laptop, it's running Oracle. There is a database on the laptop which I need to have a look at and neither I, nor anyone else I can speak to, knows what it's called.
I have a couple of logins including one which alleges to be an Admin login.
What's the easiest way to browse the databases on the server and then connect to one?
I suspect that my assumptions about relationships between servers, users and databases from SQL Server are leading me astray but right now I can't get past idea that the client tools Oracle ships are someone's idea of a joke but I'm really not finding it that funny.
I'm pretty sure that it's version 9.2 that's running.
Happy to provide more information but right now I don't know where to start.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
如果这是 Windows，请查看服务。每个数据库都有一个单独的服务。默认情况下，它们被命名为 OracleServiceDATABASENAME。
您也许可以仅使用默认端口 1521 上的此信息进行连接。
如果这不起作用，请打开该服务的属性，您可以找到 oracle home 的位置。保存连接信息的默认位置是 ORACLEHOME\network\admin\tnsnames.ora 。使用数据库名称，您可以在此文件中找到连接信息。
如果是 linux/unix，请查看 /etc/oratab 文件。这应该列出数据库名称和 oracle 主目录。 tnsnames.ora 文件的默认位置与 Windows 上的相同。
获得此信息后，您可以使用上述任何工具连接到数据库。
If this is windows look in the services. Each database will have a separate service. By default these are named OracleServiceDATABASENAME.
You may be able to connect with just this information on the default port 1521.
If that does not work open the properties of that service you can find the location of the oracle home. The default place to keep your connection information in the ORACLEHOME\network\admin\tnsnames.ora . Using the database name you can find your connect information in this file.
If this is linux/unix look in the /etc/oratab file. This should have the database name and oracle home listed. The default location of the tnsnames.ora file is the same as on windows.
Once you have this information you can use any of the tools mentioned above to connect to the database.
我不知道你书中什么是“最简单的”。我比较喜欢 Aqua Data Studio (www.aquafold.com)；很好&视觉与漂亮&全部。它也不便宜，但可能值得花两周时间进行评估，看看它是否对您有帮助。我不是这方面的专家，我加入了一个具有 SQL Server 背景的基于 Oracle 的小组；这就是他们当时使用的工具，我发现它非常有用。但这只是我。祝你好运。
I don't know what qualifies as "easiest" in your book. I'm moderately fond of Aqua Data Studio (www.aquafold.com); it's nice & visual & pretty & all. It's also Not Cheap, but might be worth a 2-week evaluation to see if it does anything helpful for you. I'm not an expert on this, and I joined an Oracle-based group from a SQL Server background; that's the tool they were using at the time, and I've found it extremely usable. But that's just me. Good luck.
请查看 Oracle SQL Developer。 （它是免费的）
我不是SQL Server专家，但是术语上有差异。
Oracle“实例”是Oracle 软件的单个实体。数据库是实例所服务的实际逻辑数据。您可能有多个 Oracle 数据库软件实例针对一个数据库运行（这被视为 RAC 设置）；或者只是针对一个数据库运行一个实例。
我假设您所说的数据库实际上是 Oracle 数据库中的不同模式/用户/表空间/过程等。在这种情况下，Oracle SQL Developer 应该可以很好地完成这项工作。
如果您能够使用 Enterprise Manager（这是一个许可选项），它也提供此功能，尽管它比 SQL Developer 恕我直言更麻烦。 EM 确实提供了许多其他工具，用于提供 Oracle 实例运行状况、警报以及许多用于帮助调整 Oracle 实例性能的总体概述。
Check out Oracle SQL Developer. (It's free)
I'm not a SQL Server expert, but there are differences in terminology.
An Oracle "Instance" is a single entity of the Oracle software. A database is the actual logical data that the instance serves. You may have multiple instances of the Oracle database software running against one database (This is considered a RAC setup); or just one instance running against one database.
I'm assuming what you mean by database here is actually the different schemas/users/tablespaces/procedures etc. that you have within an Oracle database. In that case, Oracle SQL Developer should do the job nicely.
If you are able to utilize Enterprise Manager (this is a licensed option), it provides this functionality as well, though it is more cumbersome than SQL Developer IMHO. EM does provide many other tools for providing a general overview of your Oracle instance health, alerts, and many things used to help tune the performance of your Oracle instance.
在 Windows 中，以下命令列出正在运行的数据库服务：
在 Unix/Linux 中，对 Oracle SMON 进程进行 grep 操作将为您提供正在运行的数据库的名称：
In Windows, the following command lists running database services:
In Unix/Linux, grepping for the Oracle SMON process will give you the names of running databases: