버전 비교

이전 버전 13

changes.mady.by.user 윤병훈

에 저장

비교대상

새 버전 14

changes.mady.by.user 윤병훈

에 저장

키

  • 이 줄이 추가되었습니다.
  • 이 줄이 삭제되었습니다.
  • 서식이 변경되었습니다.

...

펼치기
서식 미적용
[oracle@orcl ~]$ sqlplus /nolog

SQL*Plus: Release 18.0.0.0.0 - Production on Fri Feb 22 18:17:22 2019
Version 18.5.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

SQL> connect / as sysdba
Connected.

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 1660940400 bytes
Fixed Size		    8896624 bytes
Variable Size		 1056964608 bytes
Database Buffers	  587202560 bytes
Redo Buffers		    7876608 bytes
Database mounted.
Database opened.

SQL> alter pluggable database all open;

Pluggable database altered.
코드 블럭
select action_time, action, namespace, version 
  from dba_registry_history
 order by action_time nulls first;
펼치기
서식 미적용
SQL> select action_time, action, namespace, version 
   2   from dba_registry_history
   3  order by action_time nulls first;

ACTION_TIME		       ACTION	  NAMESPACE  VERSION
------------------------------ ---------- ---------- ------------------------------
			       BOOTSTRAP  DATAPATCH  18
19/02/22 17:44:42.007083       RU_APPLY   SERVER     18.0.0.0.0
19/02/22 17:46:13.426194       jvmpsu.sql SERVER     18.3.0.0.180717OJVMRU
19/02/22 17:46:13.462306       APPLY	  SERVER     18.3.0.0.180717OJVMRU
19/02/22 18:12:40.941070       jvmpsu.sql SERVER     18.5.0.0.190115OJVMRU
19/02/22 18:12:40.965684       ROLLBACK   SERVER     18.5.0.0.190115OJVMRU
19/02/22 18:13:35.288708       RU_APPLY   SERVER     18.0.0.0.0
19/02/22 18:13:46.530561       jvmpsu.sql SERVER     18.5.0.0.190115OJVMRU
19/02/22 18:13:46.538723       APPLY	  SERVER     18.5.0.0.190115OJVMRU

9 rows selected.
코드 블럭
select install_id, patch_id, patch_uid, patch_type, action, status, action_time
  from dba_registry_sqlpatch
 order by action_time;
펼치기
서식 미적용
SQL> select install_id, patch_id, patch_uid, patch_type, action, status, action_time
  2    from dba_registry_sqlpatch
  3   order by action_time;

INSTALL_ID   PATCH_ID  PATCH_UID PATCH_TYPE ACTION     STATUS			 ACTION_TIME
---------- ---------- ---------- ---------- ---------- ------------------------- ------------------------------
	 1   28090523	22329768 RU	    APPLY      SUCCESS			 19/02/22 17:46:17.223094
	 1   27923415	22239273 INTERIM    APPLY      SUCCESS			 19/02/22 17:46:17.235883
	 2   27923415	22239273 INTERIM    ROLLBACK   SUCCESS			 19/02/22 18:16:07.735277
	 2   28822489	22669539 RU	    APPLY      SUCCESS			 19/02/22 18:16:10.230987
	 2   28790647	22592236 INTERIM    APPLY      SUCCESS			 19/02/22 18:16:10.240213