24setlines300
25colnamefora10
26colcompatibilityfora30
27coldatabase_compatibilityfora40
28selectgroup_number,name,type,compatibility,database_compatibilityfrom
v$asm_diskgroup;
29
30group_numbernametypecompatibilitydatabase_compatibility
31‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
321crsextern11.2.0.0.010.1.0.0.0
332dataextern11.2.0.0.010.1.0.0.0
34‐‐补丁应用情况检查:
35setlines300
36colcomp_namefora50
37colversionfora20
38colcomp_idfora15
39selectcomp_id,comp_name,version,statusfromdba_registryorderby4;
40
41comp_idcomp_nameversionstatus
42‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐‐
43owbowb11.2.0.3.0valid
44racoraclerealapplicationclusters11.2.0.4.0valid
45emoracleenterprisemanager11.2.0.4.0valid
46amdolapcatalog11.2.0.4.0valid
47sdospatial11.2.0.4.0valid
48ordimoraclemultimedia11.2.0.4.0valid
49xdboraclexmldatabase11.2.0.4.0valid
50contextoracletext11.2.0.4.0valid
51exforacleexpressionfilter11.2.0.4.0valid
52ruloraclerulesmanager11.2.0.4.0valid
53owmoracleworkspacemanager11.2.0.4.0valid
54catalogoracledatabasecatalogviews11.2.0.4.0valid
55catprocoracledatabasepackagesandtypes11.2.0.4.0valid
56javavmjserverjavavirtualmachine11.2.0.4.0valid
57xmloraclexdk11.2.0.4.0valid
58catjavaoracledatabasejavapackages11.2.0.4.0valid
59apsolapanalyticworkspace11.2.0.4.0valid
60xoqoracleolapapi11.2.0.4.0valid
61apexoracleapplicationexpress3.2.1.00.12valid
评论