手抄报 安全手抄报 手抄报内容 手抄报图片 英语手抄报 清明节手抄报 节约用水手抄报

sqlplus sys as sysasm进入ASM管理工具

时间:2025-01-04 08:43:01

1、1:配置oracle用户PATH[oracle@node1 ~]$ cat .bash_profile# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then . ~/.bashrcfi# User specific environment and startup programsexport ORACLE_SID=orcl1export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=/u01/app/11.2.0.4/oracleexport PATH=$ORACLE_HOME/bin:$PATH:$HOME/binexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib[oracle@node1 ~]$ echo $PATH/u01/app/11.2.0.4/oracle/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin注意:因为ASM管理工具需要使用PLSQL工具,所以PATH中需要配置oracle关键安装目录

sqlplus sys as sysasm进入ASM管理工具

2、2:export增加集群软件安装目录[root@node1 ~]# su - oracle[oracle@node1 ~]$ export ORACLE_SID=+ASM1[oracle@node1 ~]$ export ORACLE_HOME=/u01/app/11.2.0.4/grid/[oracle@node1 ~]$ export PATH=$PATH:$ORACLE_HOME/bin

sqlplus sys as sysasm进入ASM管理工具

3、3:sqlplus sys as sysasm 进入工具

sqlplus sys as sysasm进入ASM管理工具

4、4:查看DG和磁盘信息[oracle@node1 ~]$ sqlplus sys as sysasmSQL*Plus: Release 11.2.0.4.0 Production on Wed Jul 22 16:21:47 2015Copyright (c) 1982, 2013, Oracle. All rights reserved.Enter password:Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Real Application Clusters and Automatic Storage Management optionsSQL> col name for a20SQL> col path for a30SQL> select name,path from v$asm_disk;NAME PATH-------------------- ------------------------------ /dev/mapper/dataB04 /dev/mapper/crsB13 /dev/mapper/dataB02 /dev/mapper/dataA04 /dev/mapper/crsB11 /dev/mapper/crsA12 /dev/mapper/dataA01 /dev/mapper/crsB12 /dev/mapper/dataA05 /dev/mapper/dataA03 /dev/mapper/crsA13NAME PATH-------------------- ------------------------------ /dev/mapper/crsA11 /dev/mapper/dataA02 /dev/mapper/dataB03 /dev/mapper/dataB01 /dev/mapper/dataB05GRIDDG_0002 /dev/mapper/crsB14GRIDDG_0001 /dev/mapper/crsA15GRIDDG_0003 /dev/mapper/crsB15GRIDDG_0000 /dev/mapper/crsA1420 rows selected.只有集群信息

sqlplus sys as sysasm进入ASM管理工具
sqlplus sys as sysasm进入ASM管理工具

5、5:查看实例名和spfileSQL> show parameter nameNAME TYPE VALUE------------------------------------ ----------- ------------------------------db_unique_name string +ASMinstance_name string +ASM1lock_name_space stringservice_names string +ASMSQL> show parameter spfileNAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string +GRIDDG/node-cluster/asmparame terfile/registry.253.885742421

sqlplus sys as sysasm进入ASM管理工具

6、6:相关ASM视图V$ASM_ALIAS,V$ASM_CLIENT,V$ASM_DISK,V$ASM_DISK_IOSTAT,V$ASM_DISK_STAT,V$ASM_DISKGROUP,V$ASM_DISKGROUP_STAT,V$ASM_FILE,V$ASM_TEMPLATE,V$ASM_USER,V$ASM_USERGROUP,V$ASM_USERGROUP_MEMBER

© 手抄报圈