a亚洲精品_精品国产91乱码一区二区三区_亚洲精品在线免费观看视频_欧美日韩亚洲国产综合_久久久久久久久久久成人_在线区

首頁 > 數據庫 > Oracle > 正文

oracle 11g R AC管理常用命令

2019-11-02 14:26:51
字體:
來源:轉載
供稿:網友

   1)、檢查集群狀態: [[email protected] ~]$ crsctl check cluster CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online 2)、所有 Oracle 實例 —(數據庫狀態): [[email protected] ~]

  1)、檢查集群狀態:

  [[email protected] ~]$ crsctl check cluster

  CRS-4537: Cluster Ready Services is online

  CRS-4529: Cluster Synchronization Services is online

  CRS-4533: Event Manager is online

  2)、所有 Oracle 實例 —(數據庫狀態):

  [[email protected] ~]$ srvctl status database -d racdb

  Instance racdb1 is running on node rac01

  Instance racdb2 is running on node rac02

  3)、檢查單個實例狀態:

  [[email protected] ~]$ srvctl status instance -d racdb -i racdb1

  Instance racdb1 is running on node rac01

  4)、節點應用程序狀態:

  [[email protected] ~]$ srvctl status nodeapps

  VIP rac01-vip is enabled

  VIP rac01-vip is running on node: rac01

  VIP rac02-vip is enabled

  VIP rac02-vip is running on node: rac02

  Network is enabled

  Network is running on node: rac01

  Network is running on node: rac02

  GSD is disabled

  GSD is not running on node: rac01

  GSD is not running on node: rac02

  ONS is enabled

  ONS daemon is running on node: rac01

  ONS daemon is running on node: rac02

  eONS is enabled

  eONS daemon is running on node: rac01

  eONS daemon is running on node: rac02

  5)、列出所有的配置數據庫:

  [[email protected] ~]$ srvctl config database

  racdb

  6)、數據庫配置:

  [[email protected] ~]$ srvctl config database -d racdb -a

  Database unique name: racdb

  Database name: racdb

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

  Oracle user: oracle

  Spfile: +RACDB_DATA/racdb/spfileracdb.ora

  Domain: xzxj.edu.cn

  Start options: open

  Stop options: immediate

  Database role: PRIMARY

  Management policy: AUTOMATIC

  Server pools: racdb

  Database instances: racdb1,racdb2

  Disk Groups: RACDB_DATA,FRA

  Services:

  Database is enabled

  Database is administrator managed

  7)、ASM狀態以及ASM配置:

  [[email protected] ~]$ srvctl status asm

  ASM is running on rac01,rac02

  [[email protected] ~]$ srvctl config asm -a

  ASM home: /u01/app/11.2.0/grid

  ASM listener: LISTENER

  ASM is enabled.

  8)、TNS監聽器狀態以及配置:

  [[email protected] ~]$ srvctl status listener

  Listener LISTENER is enabled

  Listener LISTENER is running on node(s): rac01,rac02

  [[email protected] ~]$ srvctl config listener -a

  Name: LISTENER

  Network: 1, Owner: grid

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 欧美激情视频免费观看 | 久久精品综合 | 久久精品中文 | 国产精品成人在线观看 | 日韩视频免费在线观看 | 一区二区三区日本 | 国产一区二区精品丝袜 | 久久久精品日本 | 每日更新在线观看av | www.欧美视频 | 玖玖操 | 91国内精品久久 | 成人片网址 | 精品一区二区三区三区 | 日韩av一区二区三区在线 | 日本成人一二三区 | 亚洲欧美日本在线 | 涩涩视频在线 | 国产免费一区二区三区网站免费 | 欧洲成人在线视频 | 精品欧美一区二区三区久久久 | 青青草小视频 | 黄色片免费在线观看 | 午夜剧| 色噜噜亚洲 | 亚洲成人高清 | 午夜免费电影 | 免费黄在线观看 | 亚洲精品91 | 欧美精品免费在线观看 | 经典三级在线播放 | 欧美一级片免费观看 | 91视频观看 | 国产精品无码专区在线观看 | 在线免费看a | 午夜精品久久久久久久99樱桃 | 99免费在线视频 | 天天操天天碰 | 黄a视频在线观看 | 美女久久久| 国产亚洲欧美在线 |