单机19.7应用19.8psu

admin

1.查看19.8-200714

1. [oracle@vm1 media]$ ls
   
2. 31305339  p31305339_190000_Linux-x86-64.zip  PatchSearch.xml
   
3. [oracle@vm1 media]$ cd 31305339/
   
4. [oracle@vm1 31305339]$ ls
   
5. 31281355  31304218  31305087  31335188  automation  bundle.xml  README.html  README.txt
   
6. [oracle@vm1 31305339]$ cd 31281355/
   
7. [oracle@vm1 31281355]$ ls
   
8. custom  etc  files  README.html  README.txt

复制代码

2.查看当前变量

1. [oracle@vm1 31281355]$ env | grep ORA
   
2. ORACLE_SID=ora19
   
3. ORACLE_BASE=/app/oracle/db
   
4. ORACLE_HOME=/app/oracle/db/19.3.0/home1

复制代码

3.进行升级

1. [oracle@vm1 31281355]$ $ORACLE_HOME/OPatch/opatch apply
   
2. Oracle Interim Patch Installer version 12.2.0.1.21
   
3. Copyright (c) 2020, Oracle Corporation.  All rights reserved.
   
4. 
   
5. 
   
6. Oracle Home       : /app/oracle/db/19.3.0/home1
   
7. Central Inventory : /app/oracle/oraInventory
   
8.    from           : /app/oracle/db/19.3.0/home1/oraInst.loc
   
9. OPatch version    : 12.2.0.1.21
   
10. OUI version       : 12.2.0.7.0
    
11. Log file location : /app/oracle/db/19.3.0/home1/cfgtoollogs/opatch/opatch2020-07-21_15-55-38PM_1.log
    
12. 
    
13. Verifying environment and performing prerequisite checks...
    
14. OPatch continues with these patches:   31281355  
    
15. 
    
16. Do you want to proceed? [y|n]
    
17. y
    
18. User Responded with: Y
    
19. All checks passed.
    
20. 
    
21. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
    
22. (Oracle Home = '/app/oracle/db/19.3.0/home1')
    
23. 
    
24. 
    
25. Is the local system ready for patching? [y|n]
    
26. y
    
27. User Responded with: Y
    
28. Backing up files...
    
29. Applying interim patch '31281355' to OH '/app/oracle/db/19.3.0/home1'
    
30. ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.xdk.parser.java.jaxb2, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.sqlj, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ]  not present in the Oracle Home or a higher version is found.
    
31. 
    
32. Patching component oracle.rdbms, 19.0.0.0.0...
    
33. 
    
34. Patching component oracle.rdbms.util, 19.0.0.0.0...
    
35. 
    
36. Patching component oracle.rdbms.rsf, 19.0.0.0.0...
    
37. 
    
38. Patching component oracle.assistants.acf, 19.0.0.0.0...
    
39. 
    
40. Patching component oracle.assistants.deconfig, 19.0.0.0.0...
    
41. 
    
42. Patching component oracle.assistants.server, 19.0.0.0.0...
    
43. 
    
44. Patching component oracle.buildtools.rsf, 19.0.0.0.0...
    
45. 
    
46. Patching component oracle.ctx, 19.0.0.0.0...
    
47. 
    
48. Patching component oracle.dbjava.ic, 19.0.0.0.0...
    
49. 
    
50. Patching component oracle.ldap.rsf, 19.0.0.0.0...
    
51. 
    
52. Patching component oracle.network.rsf, 19.0.0.0.0...
    
53. 
    
54. Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...
    
55. 
    
56. Patching component oracle.rdbms.deconfig, 19.0.0.0.0...
    
57. 
    
58. Patching component oracle.sdo, 19.0.0.0.0...
    
59. 
    
60. Patching component oracle.sdo.locator.jrf, 19.0.0.0.0...
    
61. 
    
62. Patching component oracle.sqlplus, 19.0.0.0.0...
    
63. 
    
64. Patching component oracle.xdk, 19.0.0.0.0...
    
65. 
    
66. Patching component oracle.rdbms.crs, 19.0.0.0.0...
    
67. 
    
68. Patching component oracle.install.deinstalltool, 19.0.0.0.0...
    
69. 
    
70. Patching component oracle.dbjava.ucp, 19.0.0.0.0...
    
71. 
    
72. Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...
    
73. 
    
74. Patching component oracle.rdbms.lbac, 19.0.0.0.0...
    
75. 
    
76. Patching component oracle.dbdev, 19.0.0.0.0...
    
77. 
    
78. Patching component oracle.marvel, 19.0.0.0.0...
    
79. 
    
80. Patching component oracle.network.listener, 19.0.0.0.0...
    
81. 
    
82. Patching component oracle.precomp.rsf, 19.0.0.0.0...
    
83. 
    
84. Patching component oracle.javavm.client, 19.0.0.0.0...
    
85. 
    
86. Patching component oracle.precomp.common.core, 19.0.0.0.0...
    
87. 
    
88. Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...
    
89. 
    
90. Patching component oracle.network.client, 19.0.0.0.0...
    
91. 
    
92. Patching component oracle.ctx.atg, 19.0.0.0.0...
    
93. 
    
94. Patching component oracle.ctx.rsf, 19.0.0.0.0...
    
95. 
    
96. Patching component oracle.rdbms.drdaas, 19.0.0.0.0...
    
97. 
    
98. Patching component oracle.duma, 19.0.0.0.0...
    
99. 
    
100. Patching component oracle.javavm.server, 19.0.0.0.0...
     
101. 
     
102. Patching component oracle.odbc, 19.0.0.0.0...
     
103. 
     
104. Patching component oracle.rdbms.oci, 19.0.0.0.0...
     
105. 
     
106. Patching component oracle.rdbms.rman, 19.0.0.0.0...
     
107. 
     
108. Patching component oracle.rdbms.dv, 19.0.0.0.0...
     
109. 
     
110. Patching component oracle.bali.ice, 11.1.1.7.0...
     
111. 
     
112. Patching component oracle.ovm, 19.0.0.0.0...
     
113. 
     
114. Patching component oracle.dbjava.jdbc, 19.0.0.0.0...
     
115. 
     
116. Patching component oracle.oracore.rsf, 19.0.0.0.0...
     
117. 
     
118. Patching component oracle.rdbms.scheduler, 19.0.0.0.0...
     
119. 
     
120. Patching component oracle.rdbms.install.common, 19.0.0.0.0...
     
121. 
     
122. Patching component oracle.ldap.owm, 19.0.0.0.0...
     
123. 
     
124. Patching component oracle.ldap.security.osdt, 19.0.0.0.0...
     
125. 
     
126. Patching component oracle.ons, 19.0.0.0.0...
     
127. 
     
128. Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...
     
129. 
     
130. Patching component oracle.sdo.locator, 19.0.0.0.0...
     
131. 
     
132. Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...
     
133. 
     
134. Patching component oracle.xdk.rsf, 19.0.0.0.0...
     
135. 
     
136. Patching component oracle.sqlplus.ic, 19.0.0.0.0...
     
137. 
     
138. Patching component oracle.oraolap, 19.0.0.0.0...
     
139. 
     
140. Patching component oracle.xdk.parser.java, 19.0.0.0.0...
     
141. 
     
142. Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0...
     
143. 
     
144. Patching component oracle.precomp.common, 19.0.0.0.0...
     
145. 
     
146. Patching component oracle.precomp.lang, 19.0.0.0.0...
     
147. 
     
148. Patching component oracle.jdk, 1.8.0.201.0...
     
149. Patch 31281355 successfully applied.
     
150. Sub-set patch [30869156] has become inactive due to the application of a super-set patch [31281355].
     
151. Please refer to Doc ID 2161861.1 for any possible further required actions.
     
152. Log file location: /app/oracle/db/19.3.0/home1/cfgtoollogs/opatch/opatch2020-07-21_15-55-38PM_1.log
     
153. 
     
154. OPatch succeeded.

复制代码

4.升级数据库

1. [oracle@vm1 31281355]$ sqlplus /nolog
   
2. 
   
3. SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jul 21 16:01:46 2020
   
4. Version 19.8.0.0.0
   
5. 
   
6. Copyright (c) 1982, 2020, Oracle.  All rights reserved.
   
7. 
   
8. SQL> conn / as sysdba
   
9. Connected to an idle instance.
   
10. SQL> startup
    
11. ORACLE instance started.
    
12. 
    
13. Total System Global Area 4294963272 bytes
    
14. Fixed Size                  8904776 bytes
    
15. Variable Size             620756992 bytes
    
16. Database Buffers         3657433088 bytes
    
17. Redo Buffers                7868416 bytes
    
18. Database mounted.
    
19. Database opened.
    
20. SQL> alter pluggable database all open;
    
21. alter pluggable database all open
    
22. *
    
23. ERROR at line 1:
    
24. ORA-65090: operation only allowed in a container database
    
25. 
    
26. 
    
27. SQL> exit
    
28. Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    
29. Version 19.8.0.0.0
    
30. c[oracle@vm1 31281355]$ cd $ORACLE_HOME/OPatch
    
31. [oracle@vm1 OPatch]$ ./datapatch -verbose
    
32. SQL Patching tool version 19.8.0.0.0 Production on Tue Jul 21 16:02:54 2020
    
33. Copyright (c) 2012, 2020, Oracle.  All rights reserved.
    
34. 
    
35. Log file for this invocation: /app/oracle/db/cfgtoollogs/sqlpatch/sqlpatch_5091_2020_07_21_16_02_54/sqlpatch_invocation.log
    
36. 
    
37. Connecting to database...OK
    
38. Gathering database info...done
    
39. Bootstrapping registry and package to current versions...done
    
40. Determining current state...done
    
41. 
    
42. Current state of interim SQL patches:
    
43.   No interim patches found
    
44. 
    
45. Current state of release update SQL patches:
    
46.   Binary registry:
    
47.     19.8.0.0.0 Release_Update 200703031501: Installed
    
48.   SQL registry:
    
49.     Applied 19.7.0.0.0 Release_Update 200404035018 successfully on 09-JUL-20 11.32.19.170754 AM
    
50. 
    
51. Adding patches to installation queue and performing prereq checks...done
    
52. Installation queue:
    
53.   No interim patches need to be rolled back
    
54.   Patch 31281355 (Database Release Update : 19.8.0.0.200714 (31281355)):
    
55.     Apply from 19.7.0.0.0 Release_Update 200404035018 to 19.8.0.0.0 Release_Update 200703031501
    
56.   No interim patches need to be applied
    
57. 
    
58. Installing patches...
    
59. Patch installation complete.  Total patches installed: 1
    
60. 
    
61. Validating logfiles...done
    
62. Patch 31281355 apply: SUCCESS
    
63.   logfile: /app/oracle/db/cfgtoollogs/sqlpatch/31281355/23688465/31281355_apply_ORA19_2020Jul21_16_03_49.log (no errors)
    
64. SQL Patching tool complete on Tue Jul 21 16:06:52 2020

复制代码

5.检查升级信息

1. [oracle@vm1 OPatch]$ sqlplus / as sysdba
   
2. 
   
3. SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jul 21 16:07:33 2020
   
4. Version 19.8.0.0.0
   
5. 
   
6. Copyright (c) 1982, 2020, Oracle.  All rights reserved.
   
7. 
   
8. 
   
9. Connected to:
   
10. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    
11. Version 19.8.0.0.0
    
12. 
    
13. SQL> col action for a30
    
14. SQL> col comp_name for a60
    
15. SQL> col time for a30
    
16. SQL> col comments for a30
    
17. SQL> set linesize 180
    
18. SQL>
    
19. SQL> column action_time   format a19 heading 'Action Time'   
    
20. SQL> column action        format a10  heading 'Action'        
    
21. SQL> column namespace     format a10  heading 'Namespace'     
    
22. SQL> column version       format a16 heading 'Version'      
    
23. SQL> column id            format 999 heading 'ID'            
    
24. SQL> column comments      format a25 heading 'Comments'      
    
25. SQL> column bundle_series format a13 heading 'Bundle Series'
    
26. SQL>
    
27. SQL> select action, to_char(action_time, 'yyyy-mm-dd hh24:mi:ss') time, comments
    
28.   2    from dba_registry_history;
    
29. 
    
30. Action     TIME                           Comments
    
31. ---------- ------------------------------ -------------------------
    
32. BOOTSTRAP                                 RDBMS_19.8.0.0.0DBRU_LINU
    
33.                                           X.X64_200702
    
34. 
    
35. RU_APPLY   2020-07-09 11:30:42            Patch applied from 19.3.0
    
36.                                           .0.0 to 19.7.0.0.0: Relea
    
37.                                           se_Update - 200404035018
    
38. 
    
39. RU_APPLY   2020-07-21 16:06:21            Patch applied from 19.7.0
    
40.                                           .0.0 to 19.8.0.0.0: Relea
    
41.                                           se_Update - 200703031501
    
42. 
    
43. 
    
44. SQL>

复制代码