Linux 上的 Oracle 命令行工具

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/519797/
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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-18 17:45:30  来源:igfitidea点击:

Oracle command-line tools on Linux

linuxoracle

提问by Bogdan

What is the equivalent of oradimon Linux? Does Oracle even provide anything like that for Linux?

Linux 上的oradim等价物是什么?Oracle 甚至为 Linux 提供类似的东西吗?

回答by Polo

There is not alternate command for oradim. On Linux simply manually create new environment for new instance.

没有oradim 的备用命令。在 Linux 上,只需手动为新实例创建新环境。

On Linux (and Unix) there are no Services (at least not as on Windows), but only processes, and these processes are automatically activated when the instance is started, and removed when the instance is shut down.

在 Linux(和 Unix)上没有服务(至少不像在 Windows 上那样),只有进程,这些进程在实例启动时自动激活,并在实例关闭时删除。

To start a new instance, say newsid, you create an initnewsid.orafile, then

要启动一个新实例,例如newsid,您创建一个initnewsid.ora文件,然后

$ export ORACLE_SID=newsid
$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 5 16:38:30 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SYS@newsid SQL> startup nomount pfile=<complete path for initnewsid.ora>                   

If you are running Red Hat (or CentOS), you could copy and change one of the scripts in /etc/init.dand add it to your service list by using chkconfig. This can help you with automagically starting your database after a reboot of the machine.

如果您运行的是 Red Hat(或 CentOS),则可以/etc/init.d使用chkconfig. 这可以帮助您在机器重新启动后自动启动数据库。

It does seem that you are fairly new to the Linux platform though, so please ask an administrator to help you with those scripts (nofi).

不过,您似乎对 Linux 平台还很陌生,所以请让管理员帮助您处理这些脚本 (nofi)。