오라클 패치후 각 컴퍼넌트들 버전 확인 쿼리
2010.10.05 22:07
원문 : http://www.ischo.net -- 조인상 // 시스템 엔지니어
Writer : http://www.ischo.net -- ischo // System Engineer in Replubic Of Korea
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
원문 : http://www.ischo.net -- 조인상 //시스템 엔지니어
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
SQL> select comp_id, version, status from dba_registry;
COMP_ID VERSION STATUS
------------------------------ ------------------------------ -----------
CATALOG 9.2.0.5.0 VALID
CATPROC 9.2.0.5.0 VALID
OWM 9.2.0.1.0 VALID
JAVAVM 9.2.0.5.0 VALID
XML 9.2.0.7.0 VALID
CATJAVA 9.2.0.5.0 VALID
ORDIM 9.2.0.5.0 VALID
SDO 9.2.0.5.0 VALID
CONTEXT 9.2.0.5.0 VALID
XDB 9.2.0.5.0 VALID
WK 9.2.0.5.0 VALID
COMP_ID VERSION STATUS
------------------------------ ------------------------------ -----------
ODM 9.2.0.5.0 INVALID
APS 9.2.0.5.0 UPGRADED
XOQ 9.2.0.5.0 UPGRADED
AMD 9.2.0.5.0 VALID
