Oracle 12.2中设置pdb随cdb启动而自动启动

前端之家收集整理的这篇文章主要介绍了Oracle 12.2中设置pdb随cdb启动而自动启动前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
参考文章:
How to Preserve Open Mode of PDBs When the CDB Restarts (Doc ID 1933511.1)

  1. [oracle@db12cr2 ~]$ sqlplus / as sysdba
  2.  
  3. sql*Plus: Release 12.2.0.1.0 Production on Wed Mar 8 01:56:25 2017
  4.  
  5. Copyright (c) 1982,2016,Oracle. All rights reserved.
  6.  
  7. Connected to:
  8. Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
  9. sql>
  10. sql> set lines 300
  11. sql> column NAME format a30
  12. sql> col pdb format a30
  13. sql> select PDB,INST_ID,NAME from gv$services order by 1;
  14.  
  15.  
  16. PDB INST_ID NAME
  17. ------------------------------ ---------- ------------------------------
  18. CDB$ROOT 1 orclXDB
  19. CDB$ROOT 1 orcl
  20. CDB$ROOT 1 SYS$BACKGROUND
  21. CDB$ROOT 1 SYS$USERS
  22. HIGHGO1 1 highgo1--------->>>注意此处
  23. HIGHGO2 1 highgo2--------->>>注意此处
  24. HIGHGO3 1 highgo3--------->>>注意此处
  25.  
  26.  
  27. 7 rows selected.
  28.  
  29.  
  30. sql> select CON_ID,NAME,OPEN_MODE from V$PDBS;
  31.  
  32.  
  33. CON_ID NAME OPEN_MODE
  34. ---------- ------------------------------ ----------
  35. 2 PDB$SEED READ ONLY
  36. 3 HIGHGO1 MOUNTED--------->>>注意此处
  37. 4 HIGHGO2 MOUNTED--------->>>注意此处
  38. 5 HIGHGO3 MOUNTED--------->>>注意此处
  39.  
  40.  
  41. sql>
  42. sql> alter pluggable database highgo1 open;
  43.  
  44.  
  45. Pluggable database altered.
  46.  
  47.  
  48. sql> set lines 300
  49. sql> column NAME format a30
  50. sql> col pdb format a30
  51. sql> select CON_ID,OPEN_MODE from V$PDBS;
  52.  
  53.  
  54. CON_ID NAME OPEN_MODE
  55. ---------- ------------------------------ ----------
  56. 2 PDB$SEED READ ONLY
  57. 3 HIGHGO1 READ WRITE
  58. 4 HIGHGO2 MOUNTED
  59. 5 HIGHGO3 MOUNTED
  60.  
  61.  
  62. sql> alter pluggable database highgo1 save state;---->>注意此命令(其实此命令从12.1.0.2开始就有了).
  63.  
  64.  
  65. Pluggable database altered.
  66.  
  67.  
  68. sql>
  69. sql> exit
  70. Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
  71. [oracle@db12cr2 ~]$ exit
  72. logout

  1. [root@db12cr2 ~]# init 6 --------该命令仅限试验,后果自负------>>>重启os
  2. [root@db12cr2 ~]#
  3. [root@db12cr2 ~]#
  4. Connection closed by foreign host.
  5.  
  6.  
  7. Disconnected from remote host(192.168.80.12) at 16:01:09.
  8.  
  9.  
  10. Type `help' to learn how to use Xshell prompt.
  11. [c:\~]$
  12. Disconnected from remote host(192.168.80.12) at 16:01:09.
  13.  
  14.  
  15. Type `help' to learn how to use Xshell prompt.
  16. [c:\~]$

  1. Connecting to 192.168.80.12:22...
  2. Connection established.
  3. To escape to local shell,press 'Ctrl+Alt+]'.
  4.  
  5.  
  6. Last login: Wed Mar 8 05:37:33 2017 from 192.168.80.1
  7. [root@db12cr2 ~]# su - oracle
  8. [oracle@db12cr2 ~]$ sqlplus / as sysdba
  9.  
  10. sql*Plus: Release 12.2.0.1.0 Production on Wed Mar 8 06:33:09 2017
  11.  
  12. Copyright (c) 1982,Oracle. All rights reserved.
  13.  
  14. Connected to an idle instance.
  15.  
  16. sql> startup
  17. ORACLE instance started.
  18.  
  19. Total System Global Area 587202560 bytes
  20. Fixed Size 8795424 bytes
  21. Variable Size 348130016 bytes
  22. Database Buffers 222298112 bytes
  23. Redo Buffers 7979008 bytes
  24. Database mounted.
  25. Database opened.
  26. sql> set lines 300
  27. sql> column NAME format a30
  28. sql> col pdb format a30
  29. sql> select CON_ID,OPEN_MODE from V$PDBS;
  30.  
  31.  
  32. CON_ID NAME OPEN_MODE
  33. ---------- ------------------------------ ----------
  34. 2 PDB$SEED READ ONLY
  35. 3 HIGHGO1 READ WRITE -------------->>>pdb状态.
  36. 4 HIGHGO2 MOUNTED
  37. 5 HIGHGO3 MOUNTED
  38.  
  39.  
  40. sql> select PDB,NAME from gv$services order by 1;
  41.  
  42.  
  43. PDB INST_ID NAME
  44. ------------------------------ ---------- ------------------------------
  45. CDB$ROOT 1 orclXDB
  46. CDB$ROOT 1 orcl
  47. CDB$ROOT 1 SYS$BACKGROUND
  48. CDB$ROOT 1 SYS$USERS
  49. HIGHGO1 1 highgo1
  50. HIGHGO2 1 highgo2
  51. HIGHGO3 1 highgo3
  52.  
  53.  
  54. 7 rows selected.
  55.  
  56.  
  57. sql>

猜你在找的Oracle相关文章