오라클 19c 수동 업그레이드 후 dba_registry의 status 컬럼 UPGRADED

OS환경 : Oracle Linux 8.1 (64bit)

 

DB 환경 : Oracle Database 19.3.0.0

 

방법 : 오라클 19c 수동 업그레이드 후 dba_registry의 status 컬럼 UPGRADED

오라클을 수동으로 업그레이드 한 후 dba_registry에서 컴포넌트들의 상태를 확인하는데

그 상태가 UPGRADED로 표시되는 경우가 있음

이건 12cR1 부터 나오는 상태임

db 수동 업그레이드 후 utlrp.sql 을 실행해주면 상태가 vaild로 정상적으로 변경됨

 

수동 업그레이드 직후(utlrp 실행 전)

SQL> 
col comp_id format a10
col comp_name format a30
col version format a10
col status format a8
select substr(comp_id,1,15) comp_id,substr(comp_name,1,30) comp_name,substr(version,1,10) version,status 
from dba_registry;
 
COMP_ID    COMP_NAME              VERSION    STATUS
---------- ------------------------------ ---------- --------
CATALOG    Oracle Database Catalog Views  19.0.0.0.0 UPGRADED
CATPROC    Oracle Database Packages and T 19.0.0.0.0 UPGRADED
JAVAVM       JServer JAVA Virtual Machine   19.0.0.0.0 UPGRADED
XML       Oracle XDK              19.0.0.0.0 UPGRADED
CATJAVA    Oracle Database Java Packages  19.0.0.0.0 UPGRADED
APS       OLAP Analytic Workspace      19.0.0.0.0 UPGRADED
RAC       Oracle Real Application Cluste 19.0.0.0.0 OPTION O
                             FF
 
OWM       Oracle Workspace Manager      19.0.0.0.0 UPGRADED
CONTEXT    Oracle Text              19.0.0.0.0 UPGRADED
 
COMP_ID    COMP_NAME              VERSION    STATUS
---------- ------------------------------ ---------- --------
XDB       Oracle XML Database          19.0.0.0.0 UPGRADED
ORDIM       Oracle Multimedia          19.0.0.0.0 UPGRADED
SDO       Spatial              19.0.0.0.0 UPGRADED
XOQ       Oracle OLAP API          19.0.0.0.0 UPGRADED
AMD       OLAP Catalog           11.2.0.4.0 OPTION O
                             FF
 
APEX       Oracle Application Express      3.2.1.00.1 VALID
 
15 rows selected.

 

 

utlrp 실행

SQL> @?/rdbms/admin/utlrp.sql

 

 

utlrp 실행 후

SQL> 
col comp_id format a10
col comp_name format a30
col version format a10
col status format a8
select substr(comp_id,1,15) comp_id,substr(comp_name,1,30) comp_name,substr(version,1,10) version,status 
from dba_registry;
 
COMP_ID    COMP_NAME              VERSION    STATUS
---------- ------------------------------ ---------- --------
CATALOG    Oracle Database Catalog Views  19.0.0.0.0 VALID
CATPROC    Oracle Database Packages and T 19.0.0.0.0 VALID
JAVAVM       JServer JAVA Virtual Machine   19.0.0.0.0 VALID
XML       Oracle XDK              19.0.0.0.0 VALID
CATJAVA    Oracle Database Java Packages  19.0.0.0.0 VALID
APS       OLAP Analytic Workspace      19.0.0.0.0 VALID
RAC       Oracle Real Application Cluste 19.0.0.0.0 OPTION O
                             FF
 
OWM       Oracle Workspace Manager      19.0.0.0.0 VALID
CONTEXT    Oracle Text              19.0.0.0.0 VALID
 
COMP_ID    COMP_NAME              VERSION    STATUS
---------- ------------------------------ ---------- --------
XDB       Oracle XML Database          19.0.0.0.0 VALID
ORDIM       Oracle Multimedia          19.0.0.0.0 VALID
SDO       Spatial              19.0.0.0.0 VALID
XOQ       Oracle OLAP API          19.0.0.0.0 VALID
AMD       OLAP Catalog           11.2.0.4.0 OPTION O
                             FF
 
APEX       Oracle Application Express      3.2.1.00.1 VALID
 
15 rows selected.

정상적으로 VALID 상태로 변함

 

 

참조 : 1572878.1