我的编程空间,编程开发者的网络收藏夹
学习永远不晚

【12c】Oracle Restart中的SRVCTL命令详解

短信预约 信息系统项目管理师 报名、考试、查分时间动态提醒
省份

北京

  • 北京
  • 上海
  • 天津
  • 重庆
  • 河北
  • 山东
  • 辽宁
  • 黑龙江
  • 吉林
  • 甘肃
  • 青海
  • 河南
  • 江苏
  • 湖北
  • 湖南
  • 江西
  • 浙江
  • 广东
  • 云南
  • 福建
  • 海南
  • 山西
  • 四川
  • 陕西
  • 贵州
  • 安徽
  • 广西
  • 内蒙
  • 西藏
  • 新疆
  • 宁夏
  • 兵团
手机号立即预约

请填写图片验证码后获取短信验证码

看不清楚,换张图片

免费获取短信验证码

【12c】Oracle Restart中的SRVCTL命令详解

【12c】Oracle Restart中的SRVCTL命令详解

SRVCTL,服务控制实用工具(Service Control Utility),可用于对Oracle Restart和Oracle RAC的配置和管理,本篇主要介绍SRVCTL命令在Oracle Restart中的应用,其中,详细介绍config、status命令,并列出其它命令的用法。

1 srvctl命令语法

Usage: srvctl []

commands: enable|disable|start|stop|status|add|remove|modify|update|getenv|setenv|unsetenv|config|upgrade|downgrade

objects: database|service|asm|diskgroup|listener|home|ons

2 config命令

srvctl config命令可以展示特定组件或一组组件的Oracle Restart配置信息。

2.1 srvctl config asm

展示asm实例的Oracle Restart配置信息。

1)语法结构

Usage: srvctl config asm [-all]

2)示例

[grid@sz ~]$ srvctl config asm

ASM home:

Password file: +DATA/orapwasm

ASM listener: LISTENER

Spfile: +DATA/ASM/ASMPARAMETERFILE/registry.253.1037659875

ASM diskgroup discovery string: /dev/oracleasm/disks/*

2.2 srvctl config database

展示数据库相关信息。

1)语法结构

Usage: srvctl config database [-db [-all]] [-verbose]

2)示例

[grid@sz ~]$ srvctl config database -db orcl -all

Database unique name: orcl

Database name: orcl

Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1

Oracle user: oracle

Spfile: +DATA/ORCL/PARAMETERFILE/spfile.267.1037831659

Password file:

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Disk Groups: FRA,DATA

Services:

Database is enabled

OSDBA group:

OSOPER group:

Database instance: orcl

2.3 srvctl config listener

展示监听器相关信息。

1)语法结构

Usage: srvctl config listener [-listener ]

2)示例

[grid@sz ~]$ srvctl config listener

Name: LISTENER

Type: Database Listener

Home: /u01/app/grid/product/12.1.0/grid

End points: TCP:1521

Listener is enabled.

2.4 srvctl config ons

展示Oracle通知服务信息。

1)语法结构

Usage: srvctl config ons

2)示例

[grid@sz ~]$ srvctl config ons

ONS exists: Local port 6100, remote port 6200, EM port 2016, Uses SSL: false

2.5 srvctl config service

展示服务信息。

1)语法结构

Usage: srvctl config service -db [-service ] [-verbose]

2)示例

[grid@sz ~]$ srvctl config service -db orcl

3 status命令

srvctl status命令用于展示组件对应的运行状态信息。

3.1 srvctl status asm

1)语法结构

Usage: srvctl status asm [-all] [-verbose]

2)示例

[grid@sz ~]$ srvctl status asm -detail

ASM is running on sz

ASM is enabled.

3.2 srvctl status database

1)语法结构

Usage: srvctl status database {-db | -thisversion | -thishome} [-force] [-verbose]

2)示例

[grid@sz ~]$ srvctl status database -db orcl -verbose

Database orcl is running. Instance status: Open.

3.3 srvctl status diskgroup

1)语法结构

Usage: srvctl status diskgroup -diskgroup [-all] [-verbose]

2)示例

[grid@sz ~]$ srvctl status diskgroup -diskgroup DATA -detail

Disk Group DATA is running on sz

Disk Group DATA is enabled

3.4 srvctl status home

展示特定的ORACLE HOME下的所有组件的运行状态。

1)语法结构

Usage: srvctl status home -oraclehome -statefile

2)示例

[grid@sz ~]$ srvctl status home -oraclehome /u01/app/grid/product/12.1.0/grid -statefile /home/grid/grid.txt

Disk Group ora.DATA.dg is running on sz

Disk Group ora.FRA.dg is running on sz

ASM is running on sz

Listener LISTENER is running on node sz

[grid@sz ~]$ cat grid.txt

diskgroup-ora.DATA.dg

diskgroup-ora.FRA.dg

asm-ora.asm

lsnr-LISTENER

3.5 srvctl status listener

1)语法结构

Usage: srvctl status listener [-listener ] [-verbose]

2)示例

[grid@sz ~]$ srvctl status listener

Listener LISTENER is enabled

Listener LISTENER is running on node(s): sz

3.6 srvctl status ons

1)语法结构

Usage: srvctl status ons [-verbose]

2)示例

[grid@sz ~]$ srvctl status ons

ONS is disabled

ONS daemon is not running

3.7 srvctl status service

1)语法结构

Usage: srvctl status service -db [-service ""] [-force] [-verbose]

2)示例

[grid@sz ~]$ srvctl status service -db orcl

4 stop命令

srvctl stop用于停止特定的组件或组件集。

[grid@sz ~]$ srvctl stop -help

 

The SRVCTL stop command stops, Oracle Restart enabled, starting or running objects.

 

Usage: srvctl stop database -db [-stopoption ] [-force]

Usage: srvctl stop service -db [-service ""] [-global_override] [-force] [-verbose]

Usage: srvctl stop asm [-stopoption ] [-force]

Usage: srvctl stop listener [-listener ] [-force]

Usage: srvctl stop diskgroup -diskgroup [-force]

Usage: srvctl stop ons [-verbose]

Usage: srvctl stop home -oraclehome -statefile [-stopoption ] [-force]

For detailed help on each command and object and its options use:

srvctl -help [-compatible]

5 start命令

srvctl start用于启动组件及其服务。

[grid@sz ~]$ srvctl start -help

 

The SRVCTL start command starts, Oracle Restart enabled, non-running objects.

 

Usage: srvctl start database -db [-startoption ]

Usage: srvctl start service -db [-service ""] [-startoption ] [-global_override] [-verbose]

Usage: srvctl start asm [-startoption ]

Usage: srvctl start listener [-listener ]

Usage: srvctl start diskgroup -diskgroup

Usage: srvctl start ons [-verbose]

Usage: srvctl start home -oraclehome -statefile

For detailed help on each command and object and its options use:

srvctl -help [-compatible]

6 remove命令

[grid@sz ~]$ srvctl remove -help

 

The SRVCTL remove command removes the configuration, for the object from the Oracle Restart. Environment settings for the object are also removed.

 

Usage: srvctl remove database -db [-force] [-noprompt] [-verbose]

Usage: srvctl remove service -db -service [-global_override] [-force]

Usage: srvctl remove asm [-force]

Usage: srvctl remove listener [-listener | -all] [-force]

Usage: srvctl remove diskgroup -diskgroup [-force]

Usage: srvctl remove ons [-force] [-verbose]

For detailed help on each command and object and its options use:

srvctl -help [-compatible]

7 add命令

[grid@sz ~]$ srvctl add -help

 

The SRVCTL add command adds the configuration and the Oracle Restart application to the OCR for the cluster database, named instances, named services, or for the named nodes.

 

Usage: srvctl add database -db -oraclehome [-domain ] [-spfile ] [-pwfile ] [-role {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY | FAR_SYNC}] [-startoption ] [-stopoption ] [-dbname ] [-instance ] [-policy {AUTOMATIC | MANUAL | NORESTART}] [-diskgroup ""]

Usage: srvctl add service -db -service [-role [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-policy {AUTOMATIC | MANUAL}][-notification {TRUE|FALSE}] [-clbgoal {SHORT|LONG}] [-rlbgoal {NONE|SERVICE_TIME|THROUGHPUT}][-failovertype {NONE|SESSION|SELECT|TRANSACTION}] [-failovermethod {NONE|BASIC}][-failoverretry ] [-failoverdelay ] [-edition ] [-pdb ] [-global ] [-maxlag ] [-sql_translation_profile ] [-commit_outcome {TRUE|FALSE}] [-retention ] [replay_init_time ] [-session_state {STATIC|DYNAMIC}] [-force]

Usage: srvctl add asm [-listener ] [-spfile ] [-pwfile ] [-diskstring ]

Usage: srvctl add listener [-listener ] [-skip] [-endpoints "[TCP:][, ...][/IPC:][/NMP:][/TCPS:] [/SDP:]"] [-oraclehome ]

Usage: srvctl add ons [-emport ] [-onslocalport ] [-onsremoteport ] [-remoteservers [:][,[:]...]] [-verbose]

For detailed help on each command and object and its options use:

srvctl -help [-compatible]

8 modify命令

[grid@sz ~]$ srvctl modify -help

 

The SRVCTL modify command enables user to modify configuration of the object without removing and adding Oracle Restart resources. The changes takes effect when the application is restarted.

 

Usage: srvctl modify database -db [-dbname ] [-instance ] [-oraclehome ] [-user ] [-domain ] [-spfile ] [-pwfile ] [-role {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-startoption ] [-stopoption ] [-policy {AUTOMATIC | MANUAL | NORESTART}] [-diskgroup ""|-nodiskgroup] [-force]

Usage: srvctl modify service -db -service [-role [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-policy {AUTOMATIC | MANUAL}][-notification {TRUE|FALSE}] [-clbgoal {SHORT|LONG}] [-rlbgoal {NONE|SERVICE_TIME|THROUGHPUT}] [-failovertype {NONE|SESSION|SELECT|TRANSACTION}] [-failovermethod {NONE|BASIC}] [-failoverretry ] [-failoverdelay ] [-edition ] [-pdb ] [-sql_translation_profile ] [-commit_outcome {TRUE|FALSE}] [-retention ] [replay_init_time ] [-session_state {STATIC|DYNAMIC}] [-global_override]

Usage: srvctl modify asm [-listener ] [-spfile ] [-pwfile ] [-diskstring ]

Usage: srvctl modify listener [-listener ] [-oraclehome ] [-endpoints "[TCP:][, ...][/IPC:][/NMP:][/TCPS:] [/SDP:]"]

Usage: srvctl modify ons [-emport ] [-onslocalport ] [-onsremoteport ] [-remoteservers [:][,[:]...]] [-verbose]

For detailed help on each command and object and its options use:

srvctl -help [-compatible]

9 disable命令

[grid@sz ~]$ srvctl disable -help

 

The SRVCTL disable command disables the named object so that it is unavailable to run under Oracle Restart for automatic startup, failover, or restart.

 

Usage: srvctl disable database -db

Usage: srvctl disable service -db -service "" [-global_override]

Usage: srvctl disable asm

Usage: srvctl disable listener [-listener ]

Usage: srvctl disable diskgroup -diskgroup

Usage: srvctl disable ons [-verbose]

For detailed help on each command and object and its options use:

srvctl -help [-compatible]

10 enable命令

[grid@sz ~]$ srvctl enable -help

 

The SRVCTL enable command enables the named object so that it can run under Oracle Restart for automatic startup, failover, or restart.

 

Usage: srvctl enable database -db

Usage: srvctl enable service -db -service "" [-global_override]

Usage: srvctl enable asm

Usage: srvctl enable listener [-listener ]

Usage: srvctl enable diskgroup -diskgroup

Usage: srvctl enable ons [-verbose]

For detailed help on each command and object and its options use:

srvctl -help [-compatible]

11 getenv命令

[grid@sz ~]$ srvctl getenv -help

 

The SRVCTL getenv command Gets and displays values for the environment from the configuration file. It allows users to administer environment configuration for the objects.

 

Usage: srvctl getenv database -db [-envs "[,...]"]

Usage: srvctl getenv asm [-envs "[,...]"]

Usage: srvctl getenv listener [-listener ] [-envs "[,...]"]

For detailed help on each command and object and its options use:

srvctl -help [-compatible]

12 setenv命令

[grid@sz ~]$ srvctl setenv -help

 

The SRVCTL setenv command sets values for the environment in the configuration file. It allows users to administer environment configuration for the objects.

 

Usage: srvctl setenv database -db {-envs "=[,...]" | -env "="}

Usage: srvctl setenv asm {-envs "=[,...]" | -env "="}

Usage: srvctl setenv listener [-listener ] -envs "=[,...]" | -env "="

For detailed help on each command and object and its options use:

srvctl -help [-compatible]

13 update命令

[grid@sz ~]$ srvctl update -help

 

The SRVCTL update command requests specified running object to use the new configuration information stored in the OCR.

 

Usage: srvctl update database -db -startoption

For detailed help on each command and object and its options use:

srvctl -help [-compatible]

14 upgrade命令

[grid@sz ~]$ srvctl upgrade -help

 

Upgrades the resources types and resources from an older version to a newer version.

 

Usage: srvctl upgrade database -db -oraclehome

srvctl -help [-compatible]

15 downgrade命令

[grid@sz ~]$ srvctl downgrade -help

 

The SRVCTL downgrade command enables the user to downgrade resources from their current software version to an older version.

 

Usage: srvctl downgrade database -db -oraclehome -targetversion

srvctl -help [-compatible]

 

免责声明:

① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的,并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据,供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。

② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

【12c】Oracle Restart中的SRVCTL命令详解

下载Word文档到电脑,方便收藏和打印~

下载Word文档

猜你喜欢

【12c】Oracle Restart中的SRVCTL命令详解

SRVCTL,服务控制实用工具(Service Control Utility),可用于对Oracle Restart和Oracle RAC的配置和管理,本篇主要介绍SRVCTL命令在Oracle Restart中的应用,其中,详细介绍config、statu
【12c】Oracle Restart中的SRVCTL命令详解
2018-12-23

Oracle中srvctl命令的用法是什么

Oracle中的srvctl命令是用于管理Oracle数据库集群环境的命令行工具。以下是srvctl命令的常见用法:1. 创建数据库服务:srvctl add database -d -o -p -r -n -d:数据库名称-o:O
2023-10-19

详解Linux中的awk命令

简介awk是一个强大的文本分析工具,相对于grep的查找,sed的编辑,awk在其对数据分析并生成报告时,显得尤为强大。简单来说awk就是把文件逐行的读入,以空格为默认分隔符将每行切片,切开的部分再进行各种分析处理。 awk有3个不同版本:
2022-06-04

详解 Shell中的grep命令

用‘grep'搜索文本文件 如果您要在几个文本文件中查找一字符串,可以使用‘grep'命令。‘grep'在文本中搜索指定的字符串。举个例子:假设您正在‘/usr/src/linux/Documentation'目录下搜索带字符串‘magic
2022-06-04

详解Linux中的wget命令

wget命令用来从指定的URL下载文件。wget非常稳定,它在带宽很窄的情况下和不稳定网络中有很强的适应性,如果是由于网络的原因下载失败,wget会不断的尝试,直到整个文件下载完毕。如果是服务器打断下载过程,它会再次联到服务器上从停止的地方
2022-06-04

oracle中解决锁表的命令

oracle 锁表问题可以通过以下命令解决:查看已锁定的表:select * from v$locked_objects;释放表锁:alter system kill session '[session_id]';解除锁定或等待:commi
oracle中解决锁表的命令
2024-05-09

详解Python中命令行参数argparse的常用命令

这篇文章主要为大家详细介绍了Python中命令行参数argparse的一些常用命令,文中的示例代码讲解详细,具有一定的学习价值,需要的可以了解一下
2023-01-29

Redis中的连接命令与键命令操作详解

目录一、连接命令pingecho mselect iauth pwordquit二、键命令set key valueget keydel key1 [key2 … keyn]exists keytype keyexpire k
Redis中的连接命令与键命令操作详解
2024-09-24

Linux中的screen命令使用详解

GUN Screen:官方网址:http://www.gnu.org/software/screen/ 1、简介Screen是一款由GNU计划开发的用于命令行终端切换的自由软件。用户可以通过该软件同时连接多个本地或远程的命令行会话,并在其间
2022-06-04

Linux 中的export与alias命令详解

目录一、alias二、export摘要:export和alias都是用来简化命令行输入的工具。export用于设置环境变量,环境变量是一些系统级别的变量,用于指定一些系统的默认值或者搜索路径等。 alias用于给较长的命令取别名,只是给命令
2023-04-06

Linux 中的export与alias命令详解

export和alias都是用来简化命令行输入的工具。export用于设置环境变量,环境变量是一些系统级别的变量,用于指定一些系统的默认值或者搜索路径等,这篇文章主要介绍了Linux 中的export与alias命令,需要的朋友可以参考下
2023-05-14

Linux中的tcpdump命令示例详解

前言用简单的话来定义tcpdump,就是:dump the traffic on a network,根据使用者的定义对网络上的数据包进行截获的包分析工具。 tcpdump可以将网络中传送的数据包的“头”完全截获下来提供分析。它支持针对网络
2022-06-04

linux 中的ls命令参数详解及ls命令的使用实例

一、ls命令参数详解可以通过阅读 ls 的说明书页(man ls)来获得选项的完整列表。 -a ? 全部(all)。列举目录中的全部文件,包括隐藏文件(.filename)。位于这个列表的起首处的 .. 和 . 依次是指父目录和你的当前目录
2022-06-04

编程热搜

目录