测试ASM ACL 权限控制。
on the oracle:
SQL> show user
USER is "SYS"
SQL> select name from v$database;
NAME
---------
ORCL
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
+DATA/orcl/datafile/users.259.766156881
+DATA/orcl/datafile/undotbs1.258.766156879
+DATA/orcl/datafile/sysaux.257.766156879
+DATA/orcl/datafile/system.256.766156877
+DATA/orcl/datafile/example.264.766157087
+DATA/orcl/datafile/undotbs2.265.766157357
+DATA/orcl/datafile/undotbs3.269.766236417
7 rows selected.
SQL> create tablespace tbs datafile '+ACFS' size 10m;
Tablespace created.
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
+DATA/orcl/datafile/users.259.766156881
+DATA/orcl/datafile/undotbs1.258.766156879
+DATA/orcl/datafile/sysaux.257.766156879
+DATA/orcl/datafile/system.256.766156877
+DATA/orcl/datafile/example.264.766157087
+DATA/orcl/datafile/undotbs2.265.766157357
+DATA/orcl/datafile/undotbs3.269.766236417
+ACFS/orcl/datafile/tbs.259.766320739
8 rows selected.
SQL> alter tablespace tbs offline;
Tablespace altered.
ON ASM:
[grid@host01 ~]$ . oarenv
-bash: oarenv: No such file or directory
[grid@host01 ~]$ . oraenv
ORACLE_SID = [grid] ? +ASM2
The Oracle base for ORACLE_HOME=/u01/app/11.2.0/grid is /u01/app/grid
[grid@host01 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 4 10:50:43 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Real Application Clusters and Automatic Storage Management options
SQL> select * from v$asm_user;
no rows selected
SQL> alter diskgroup acfs set attribute='access_control.enabled'='true';
alter diskgroup acfs set attribute='access_control.enabled'='true'
*
ERROR at line 1:
ORA-15214: missing or invalid attribute specification
SQL> alter diskgroup acfs set attribute 'access_control.enabled'='true';
alter diskgroup acfs set attribute 'access_control.enabled'='true'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15242: could not set attribute access_control.enabled
ORA-15238: true is not a valid value for attribute access_control.enabled
ORA-15283: ASM operation requires compatible.rdbms of 11.2.0.0.0 or higher
SQL> alter diskgroup acfs set attribute 'compatible.rdbms'='11.2.0.0.0';
Diskgroup altered.
SQL> alter diskgroup acfs set attribute 'access_control.enabled'='true';
Diskgroup altered.
SQL> alter tablespace tbs online;
alter tablespace tbs online
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01110: data file 8: '+ACFS/orcl/datafile/tbs.259.766320739'
ON ASM:
SQL> alter diskgroup acfs add user 'oracle';
Diskgroup altered.
ON DB.
SQL> alter tablespace tbs online;
Tablespace altered.
分享到:
相关推荐
ASM远程控制ASM远程控制,很强的,编译已经通过
asm-1.3.3.jar, asm-1.3.4.jar, asm-1.3.5.jar, asm-1.4.1.jar, asm-1.4.2.jar, asm-1.4.3.jar, asm-1.4.jar, asm-1.5.1.jar, asm-1.5.2.jar, asm-1.5.3.jar, asm-2.0.jar, asm-2.1.jar, asm-2.2.1-sources.jar, asm...
基于asm汇编语言的远程控制,开源代码,值得学习
ASM程序交通灯开关量流水灯 Proteus仿真
汇编工具ASM汇编工具ASM汇编工具ASM汇编工具ASM汇编工具ASM
ABB ASM1转矩速度控制程序固件手册pdf,ABB ASM1转矩速度控制程序固件手册
F5 ASM应用安全管理测试方案.docx
包含如下oracleasm包: kmod-oracleasm-2.0.6.rh1-3.el6.x86_64.rpm oracleasm-2.0.8-4.el6_6.src.rpm oracleasm-2.0.8-6.el6_7.src.rpm oracleasm-2.0.8-8.el7.src.rpm oracleasm-2.0.8-15.el7.centos.src.rpm ...
EditPlus是很好用的编辑软件 但网上下的很多EP版本需要自己添加asm.acp,asm.stx,不是很方便 这个里面附带了asm.acp,asm.stx
开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具 asm-5.1开发工具...
ASM4使用指南 ASM GUIDE
ASM1062 pcie 转SATA x2 PCI Express 2.0 to 2 ports SATA 6Gbps AHCI Controller
ASM1061 原理图 PCIE转2 port Sata芯片 ASM1061 原理图 PCIE转2 port Sata芯片
我是在keil 用的是汇编语言写的,希望大家看看
使用用于服务器测试,主要是针对服务器的网卡功能进行测试
赠送jar包:asm-9.1.jar; 赠送原API文档:asm-9.1-javadoc.jar; 赠送源代码:asm-9.1-sources.jar; 赠送Maven依赖信息文件:asm-9.1.pom; 包含翻译后的API文档:asm-9.1-javadoc-API文档-中文(简体)版.zip; ...
asm-util-1.3.4.jar, asm-util-1.3.5.jar, asm-util-1.4.1.jar, asm-util-1.4.3.jar, asm-util-1.5.1.jar, asm-util-1.5.2.jar, asm-util-1.5.3.jar, asm-util-2.0.jar, asm-util-2.1.jar, asm-util-2.2.1-sources....
我学习spring程序,测试程序时.老出bug, 后来从网上找原因说asm.jar版本太低 现把好不容易找来的jar包共享给大家
ASM实例+ASM数据库安装(Win8+Ora10) 1 第一篇 创建未格式化的磁盘分区 1 1.1 打开压缩卷窗口 1 1.2 输入卷大小 3 1.3 选择挂载目录 4 1.4 格式化分区选项 5 1.5汇总信息 6 1.6分区完成后磁盘情况 7 1.7挂载目录...
java字节码操作相关工具asm asm-util asm-tree asm-analysis