Bo's Oracle Station

查看: 2342|回复: 0

课程第35次(2017-09-19星期二)

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-9-19 20:34:47 | 显示全部楼层 |阅读模式
1Z0-053第3/4章
1Z0-052
19章(上完12章),1Z0-05321章(上完8章)和1Z0-063多租户部分共9章(上完0章)
总共上完全部49章中的20


虚拟专用catalog的两种建法:

  1. select  * from dba_users u
  2. where u.username='U90';

  3. alter user u90 identified by oracle_4U ;

  4. drop user u90 cascade;


  5. select  * from v$session where username ='V901';

  6. alter system kill session '620,7' immediate;

  7. drop user v901 cascade;

  8. drop user v902 cascade;

  9. drop user v903 cascade;

  10. create user u90 identified by  oracle_4U default tablespace rcat quota unlimited on rcat;

  11. create user v901 identified by  oracle_4U default tablespace rcat quota unlimited on rcat;

  12. create user v902 identified by  oracle_4U default tablespace rcat quota unlimited on rcat;

  13. create user v903 identified by  oracle_4U default tablespace rcat quota unlimited on rcat;

  14. grant recovery_catalog_owner to u90;

  15. grant recovery_catalog_owner to v901;

  16. grant recovery_catalog_owner to v902;

  17. grant recovery_catalog_owner to v903;
复制代码
  1. [oracle@station90 ~]$ sqlplus /nolog

  2. SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 19 21:26:53 2017

  3. Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  4. SQL> conn / as sysdba
  5. Connected.
  6. SQL> select * from v$encryption_wallet ;

  7. WRL_TYPE
  8. --------------------
  9. WRL_PARAMETER
  10. --------------------------------------------------------------------------------
  11. STATUS
  12. ------------------
  13. file
  14. /u01/app/oracle/admin/orcl/wallet
  15. CLOSED


  16. SQL> alter system set encryption key identified by "oracle123";

  17. System altered.

  18. SQL>  select * from v$encryption_wallet ;

  19. WRL_TYPE
  20. --------------------
  21. WRL_PARAMETER
  22. --------------------------------------------------------------------------------
  23. STATUS
  24. ------------------
  25. file
  26. /u01/app/oracle/admin/orcl/wallet
  27. OPEN


  28. SQL> startup force
  29. ORACLE instance started.

  30. Total System Global Area 6680915968 bytes
  31. Fixed Size                    2213936 bytes
  32. Variable Size                 3556771792 bytes
  33. Database Buffers         3087007744 bytes
  34. Redo Buffers                   34922496 bytes
  35. Database mounted.
  36. Database opened.
  37. SQL>  select * from v$encryption_wallet ;

  38. WRL_TYPE
  39. --------------------
  40. WRL_PARAMETER
  41. --------------------------------------------------------------------------------
  42. STATUS
  43. ------------------
  44. file
  45. /u01/app/oracle/admin/orcl/wallet
  46. CLOSED


  47. SQL> alter system set encryption wallet open  identified by "oracle123";

  48. System altered.

  49. SQL> alter system set encryption wallet close  identified by "oracle123";

  50. System altered.

  51. SQL> alter system set encryption wallet open  identified by "oracle123";

  52. System altered.

  53. SQL> alter system set encryption wallet close  identified by "oracle123";

  54. System altered.

  55. SQL> alter system set encryption wallet open  identified by "oracle123";

  56. System altered.

  57. SQL> alter tablespace users offline immediate ;

  58. Tablespace altered.

  59. SQL> alter tablespace users online;
  60. alter tablespace users online
  61. *
  62. ERROR at line 1:
  63. ORA-01113: file 4 needs media recovery
  64. ORA-01110: data file 4: '+DATA/orcl/datafile/users.259.816169553'


  65. SQL> alter system set encryption wallet close  identified by "oracle123";

  66. System altered.

  67. SQL>
复制代码



Screenshot.png
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 10:06 , Processed in 0.037795 second(s), 27 queries .

快速回复 返回顶部 返回列表