버전 비교

이전 버전 14

changes.mady.by.user 윤병훈

에 저장

비교대상

새 버전 15

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.

결과 확인

코드 블럭
titlesys 또는 system 계정으로 실행
linenumberstrue
select version_full from v$instance;
펼치기
서식 미적용
SQL> select version_full from v$instance;

VERSION_FULL
-----------------
18.5.0.0.0
코드 블럭
titlesys 또는 system 계정으로 실행
linenumberstrue
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.
코드 블럭
titlesys 또는 system 계정으로 실행
linenumberstrue
select install_id, patch_id, patch_uid, patch_type, action, status, action_time
  from dba_registry_sqlpatch
 order by action_time;

...