2019. 8. 3. 00:01 좋아하는 음악
'분류 전체보기'에 해당되는 글 1023건
- 2019.08.03 조성진 Rachmaninoff:Piano Concerto No. 2 in C minor, OP. 18
- 2019.08.01 Oracle 패치작업 12.2.0.1.190716
- 2019.07.01 CDB내의 모든 PDB의 Keystore 상태확인 Procedure
- 2019.06.19 Oracle Cloud 서울 리전 서비스 목록
- 2019.06.18 Oracle PDB rename
- 2019.06.11 Pearl Jam - Jeremy
- 2019.05.21 Oracle Cloud DBCS listener port 확인
- 2019.05.15 Azure Datacenter liquid cooling
- 2019.05.13 Oracle 패치작업 11.2.0.4.190416
- 2019.05.13 Oracle 패치작업 12.2.0.1.190416
2019. 8. 1. 17:22 오라클
Oracle 패치작업 12.2.0.1.190716
2019.8월 1일 작성
패치작업 12.2.0.1.190716 (GI PSU 29708720 )
DB RU : 12.2.0.1.190716 (29757449)
OCW RU : 12.2.0.1.190716 (29770040)
ACFS RU : 12.2.0.1.190716 (29770090)
DBWLM : 12.2.0.1.170913 (26839277)
TOMCAT : 12.2.0.1.0 (28566910)
Oracle Grid Infrastructure Patch Set Update 12.2.0.1.190716 (Includes Database PSU 12.2.0.1.190716)
-------------------------------------
GRID_HOME, ORACLE_HOME 을 개별로 각각 할때
- grid
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1
$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/29708720/29757449
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/29708720/29770040
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/29708720/29770090
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/29708720/26839277
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/29708720/28566910
- oracle
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/29708720/29757449
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/29708720/29770040
- oracle
$<ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>
(root)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/crs/install/rootcrs.sh -prepatch
$GRID_HOME/crs/install/rootcrs.sh -prepatch -nonrolling (롤링으로 하고자 할때)
(grid)
export OPATCH_DEBUG=true
export GRID_HOME=/u01/app/12.2.0.1/grid
cd /home/oracle
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29708720/29770040 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29708720/29770090 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29708720/26839277 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29708720/29757449 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29708720/28566910 -silent
(oracle)
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1
cd <UNZIPPED_PATCH_LOCATION>
./29708720/29770040/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./29708720/29770040 -silent
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./29708720/29757449 -silent
./29708720/29770040/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
(root)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.sh -postpatch
$GRID_HOME/crs/install/rootcrs.sh -postpatch -nonrolling (롤링으로 하고자 할때)
(oracle)
$ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name>
- Loading Modified SQL Files into the Database
sqlplus /nolog
SQL> conect / as sysdba
SQL> startup
SQL> quit
cd $ORACLE_HOME/OPatch
./datapatch -verbose
-----------------------------
### [롤백하는 경우] ###########
(oracle)
$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>
(root)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/crs/install/rootcrs.sh -prepatch -rollback
(grid)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/OPatch/opatch nrollback -local -id 29770040,29770090,29757449,26839277,28566910 -oh $GRID_HOME
(oracle)
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1
cd <UNZIPPED_PATCH_LOCATION>
./29708720 /29770040/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch nrollback -local -id 29770040,29757449 -oh /oracle/product/12.2.0.1/dbhome_1
./29708720 /29770040/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
Run post script
(root)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.sh -postpatch -rollback
(oracle)
$ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name>
sqlplus /nolog
SQL> conect / as sysdba
SQL> startup
SQL> quit
cd $ORACLE_HOME/OPatch
./datapatch -verbose
2019. 7. 1. 15:44 오라클
CDB내의 모든 PDB의 Keystore 상태확인 Procedure
- CDB내에 존재하는 모든 PDB의 Keystore 상태를 한방에 확인하는 Procedure
CREATE OR REPLACE PROCEDURE all_pdb_v$encryption_wallet
IS
err_occ BOOLEAN;
curr_pdb VARCHAR2(30);
pdb_name VARCHAR2(30);
wrl_type VARCHAR2(20);
status VARCHAR2(30);
wallet_type VARCHAR2(20);
wallet_order VARCHAR2(12);
fully_backed_up VARCHAR2(15);
wrl_parameter VARCHAR2(4000);
cursor sel_pdbs IS SELECT NAME FROM V$CONTAINERS
WHERE NAME <> 'PDB$SEED' order by con_id desc;
BEGIN
-- Store the original PDB name
SELECT sys_context('userenv', 'con_name') INTO curr_pdb FROM DUAL;
IF curr_pdb <> 'CDB$ROOT' THEN
dbms_output.put_line('Operation valid in ROOT only');
END IF;
err_occ := FALSE;
dbms_output.put_line('---');
dbms_output.put_line('PDB_NAME WRL_TYPE STATUS ');
dbms_output.put_line('------------------------------ -------- ------------------------------');
dbms_output.put_line('WALLET_TYPE WALLET_ORDER FULLY_BACKED_UP');
dbms_output.put_line('-------------------- ------------ ---------------');
dbms_output.put_line('WRL_PARAMETER');
dbms_output.put_line('--------------------------------------------------------------------------');
FOR pdbinfo IN sel_pdbs LOOP
pdb_name := DBMS_ASSERT.ENQUOTE_NAME(pdbinfo.name, FALSE);
EXECUTE IMMEDIATE 'ALTER SESSION SET CONTAINER = ' || pdb_name;
BEGIN
pdb_name := rpad(substr(pdb_name,1,30), 30, ' ');
EXECUTE IMMEDIATE 'SELECT wrl_type from V$ENCRYPTION_WALLET' into wrl_type;
wrl_type := rpad(substr(wrl_type,1,8), 8, ' ');
EXECUTE IMMEDIATE 'SELECT status from V$ENCRYPTION_WALLET' into status;
status := rpad(substr(status,1,30), 30, ' ');
EXECUTE IMMEDIATE 'SELECT wallet_type from V$ENCRYPTION_WALLET' into wallet_type;
wallet_type := rpad(substr(wallet_type,1,20), 20, ' ');
EXECUTE IMMEDIATE 'SELECT wallet_order from V$ENCRYPTION_WALLET' into wallet_order;
wallet_order := rpad(substr(wallet_order,1,9), 12, ' ');
EXECUTE IMMEDIATE 'SELECT fully_backed_up from V$ENCRYPTION_WALLET' into fully_backed_up;
fully_backed_up := rpad(substr(fully_backed_up,1,9), 15, ' ');
EXECUTE IMMEDIATE 'SELECT wrl_parameter from V$ENCRYPTION_WALLET' into wrl_parameter;
wrl_parameter := rpad(substr(wrl_parameter,1,79), 79, ' ');
dbms_output.put_line(pdb_name || ' ' || wrl_type || ' ' || status);
dbms_output.put_line(wallet_type || ' ' || wallet_order || ' ' || fully_backed_up);
dbms_output.put_line(wrl_parameter);
EXCEPTION
WHEN OTHERS THEN
err_occ := TRUE;
END;
END LOOP;
IF err_occ = TRUE THEN
dbms_output.put_line('One or more PDB resulted in an error');
END IF;
END;
.
/
set serveroutput on
exec all_pdb_v$encryption_wallet;
결과 :
---
PDB_NAME WRL_TYPE STATUS
------------------------------ -------- ------------------------------
WALLET_TYPE WALLET_ORDER FULLY_BACKED_UP
-------------------- ------------ ---------------
WRL_PARAMETER
--------------------------------------------------------------------------
"PDB1" FILE OPEN
AUTOLOGIN SINGLE NO
"PDB2" FILE CLOSED
UNKNOWN SINGLE UNDEFINED
"CDB$ROOT" FILE OPEN
AUTOLOGIN SINGLE NO
/home/oracle/wallet/
PL/SQL procedure successfully completed.
2019. 6. 19. 11:15 오라클/오라클 클라우드
Oracle Cloud 서울 리전 서비스 목록
오라클 홈페이지에 서울 Region 에서 가능한 서비스 리스트가 업데이트 되었습니다.
몇몇 아직 안되는 서비스도 있지만 웬만한 서비스는 다 제공을 하고 있네요.
https://www.oracle.com/cloud/data-regions.html#apac
Oracle Cloud Service Data Regions
Find your cloud service regional data center and country guidelines
www.oracle.com
2019. 6. 18. 17:06 오라클
Oracle PDB rename
- Oracle PDB rename 테스트 (12.2.0.1)
pdb1 -> pdb2 로 이름변경
1. 해당 pdb close
SQL> alter pluggable database pdb1 close immediate;
2. restricted mode 로 open
SQL> alter pluggable database pdb1 open restricted;
SQL> select name, restricted from v$pdbs;
3. 해당 pdb 접속
SQL> alter session set container=pdb1;
SQL> alter pluggable database pdb1 rename global_name to pdb2;
4. pdb close
SQL> alter pluggable database close immediate;
5. pdb open
SQL> alter pluggable database open;
SQL> select name, open_mode from v$pdbs;
2019. 6. 11. 23:24 좋아하는 음악
Pearl Jam - Jeremy
2019. 5. 21. 15:11 오라클/오라클 클라우드
Oracle Cloud DBCS listener port 확인
DBCS provisioning 후 listener port 확인
기본은 1521이며 다른 포트로 변경하는것은 권장하지 않고 있다.
[oracle@gtplus102 ~]$ ps -ef |grep tns
root 22 2 0 05:55 ? 00:00:00 [netns]
grid 9983 1 0 05:57 ? 00:00:00 /u01/app/18.0.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit
grid 9993 1 0 05:57 ? 00:00:00 /u01/app/18.0.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
oracle 47177 36087 0 06:07 pts/0 00:00:00 grep tns
SYS@GTPLUS 06:07:45> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
forward_listener string
listener_networks string (( NAME=net1)(LOCAL_LISTENER=(
ADDRESS=(PROTOCOL=TCP)(HOST=10
.0.0.3)(PORT=1521))))
local_listener string LISTENER_GTPLUS
remote_listener string
[oracle@gtplus102 ~]$ srvctl config listener -a
Name: LISTENER
Type: Database Listener
Network: 1, Owner: grid
Home:
/u01/app/18.0.0.0/grid on node(s) gtplus102
End points: TCP:1521
Listener is enabled.
Listener is individually enabled on nodes:
Listener is individually disabled on nodes:
[oracle@gtplus102 ~]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
Registration invited nodes:
Registration invited subnets:
SCAN Listener is disabled.
SCAN Listener is individually enabled on nodes:
SCAN Listener is individually disabled on nodes:
[oracle@gtplus102 ~]$ srvctl config listener -l ASMNET1LSNR_ASM
Name: ASMNET1LSNR_ASM
Type: ASM Listener
Owner: grid
Subnet: 192.168.16.0
Home:
End points: TCP:1525
Listener is enabled.
Listener is individually enabled on nodes:
Listener is individually disabled on nodes:
[oracle@gtplus102 ~]$ lsnrctl status
LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 21-MAY-2019 06:09:08
Copyright (c) 1991, 2018, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Start Date 21-MAY-2019 05:57:37
Uptime 0 days 0 hr. 11 min. 30 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/18.0.0.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/gtplus102/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.3)(PORT=1521)))
Services Summary...
Service "+APX" has 1 instance(s).
Instance "+APX1", status READY, has 1 handler(s) for this service...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_RECO" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "894ba6bc89eb7f72e0530300000ac70b.sub05170506180.gtplus102vcn.oraclevcn.com" has 1 instance(s).
Instance "GTPLUS", status READY, has 2 handler(s) for this service...
Service "GTPLUSXDB.sub05170506180.gtplus102vcn.oraclevcn.com" has 1 instance(s).
Instance "GTPLUS", status READY, has 1 handler(s) for this service...
Service "GTPLUS_icn1t9.sub05170506180.gtplus102vcn.oraclevcn.com" has 1 instance(s).
Instance "GTPLUS", status READY, has 2 handler(s) for this service...
Service "pdb1.sub05170506180.gtplus102vcn.oraclevcn.com" has 1 instance(s).
Instance "GTPLUS", status READY, has 2 handler(s) for this service...
The command completed successfully
[oracle@gtplus102 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE gtplus102 STABLE
ora.DATA.COMMONSTORE.advm
ONLINE ONLINE gtplus102 STABLE
ora.DATA.dg
ONLINE ONLINE gtplus102 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE gtplus102 STABLE
ora.RECO.dg
ONLINE ONLINE gtplus102 STABLE
ora.data.commonstore.acfs
ONLINE ONLINE gtplus102 mounted on /opt/orac
le/dcs/commonstore,S
TABLE
ora.net1.network
ONLINE ONLINE gtplus102 STABLE
ora.ons
ONLINE ONLINE gtplus102 STABLE
ora.proxy_advm
ONLINE ONLINE gtplus102 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 OFFLINE OFFLINE STABLE
ora.asm
1 ONLINE ONLINE gtplus102 Started,STABLE
ora.cvu
1 ONLINE ONLINE gtplus102 STABLE
ora.gtplus102.vip
1 ONLINE ONLINE gtplus102 STABLE
ora.gtplus_icn1t9.db
1 ONLINE ONLINE gtplus102 Open,HOME=/u01/app/o
racle/product/18.0.0
.0/dbhome_1,STABLE
ora.qosmserver
1 OFFLINE OFFLINE STABLE
ora.scan1.vip
1 OFFLINE OFFLINE STABLE
--------------------------------------------------------------------------------
2019. 5. 15. 15:50 오라클/오라클 클라우드
Azure Datacenter liquid cooling
2019. 5. 13. 14:50 오라클
Oracle 패치작업 11.2.0.4.190416
=====================================================
2019.5.7일 작성
패치작업 11.2.0.4.190416 (GI PSU 29255947)
Database Patch Set Update : 11.2.0.4.190416 (29141056)
OCW Patch Set Update : 11.2.0.4.190416 (29141201)
ACFS PATCH SET UPDATE : 11.2.0.4.190115 (28729245)
Oracle Grid Infrastructure Patch Set Update 11.2.0.4.190416 (Includes Database PSU 11.2.0.4.190416)
-------------------------------------
GRID_HOME, ORACLE_HOME 을 개별로 각각 할때
(root 유저)
$GRID_HOME/crs/install/rootcrs.pl -unlock (CRS 가 떠 있으면 script로 자동으로 내려버림)
(grid 유저)
export GRID_HOME=/oragrid/product/11.2.0.4
cd
$GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local ./29255947/29141201
$GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local ./29255947/28729245
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29255947/29141056
(oracle 유저)
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4
cd
./29255947/23054319/custom/server/23054319/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME (권한체크)
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local ./29255947/29141201/custom/server/29141201
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./29255947/29141056
./29255947/23054319/custom/server/23054319/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME (권한체크)
(root 유저)
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.pl -patch (script로 자동으로 CRS를 올려 버림)
### [롤백하는 경우] ###########
GI Home
(root로)
$GRID_HOME/crs/install/rootcrs.pl -unlock
(grid 유저로)
$GRID_HOME/OPatch/opatch rollback -local -id 29141201 -oh $GRID_HOME
$GRID_HOME/OPatch/opatch rollback -local -id 28729245 -oh $GRID_HOME
$GRID_HOME/OPatch/opatch rollback -local -id 29141056 -oh $GRID_HOME
(oracle 유저로)
cd
./29255947/29141201/custom/server/29141201/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME (권한체크)
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local ./29255947/29141201/custom/server/29141201
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./29255947/29141056
./29255947/29141201/custom/server/29141201/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME (권한체크)
Run post script
(root로)
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.pl -patch
2019. 5. 13. 14:49 오라클
Oracle 패치작업 12.2.0.1.190416
====================================================================
2019.5월 7일 작성
패치작업 12.2.0.1.190416 (GI PSU 29301687 )
DB RU : 12.2.0.1.190416 (29314339)
OCW RU : 12.2.0.1.190416 (29314424)
ACFS RU : 12.2.0.1.190416 (29301676)
DBWLM : 12.2.0.1.170913 (26839277)
TOMCAT : 12.2.0.1.0 (28566910)
Oracle Grid Infrastructure Patch Set Update 12.2.0.1.190416 (Includes Database PSU 12.2.0.1.190416)
-------------------------------------
GRID_HOME, ORACLE_HOME 을 개별로 각각 할때
- grid
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1
$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/29314339
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/29314424
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/29301676
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/26839277
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/28566910
- oracle
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/29314339
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /29301687/29314424
- oracle
$/bin/srvctl stop home -o -s -n
(root)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/crs/install/rootcrs.sh -prepatch
$GRID_HOME/crs/install/rootcrs.sh -prepatch -nonrolling (롤링으로 하고자 할때)
(grid)
export OPATCH_DEBUG=true
export GRID_HOME=/u01/app/12.2.0.1/grid
cd /home/oracle
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29301687/29314424 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29301687/29301676 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29301687/26839277 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29301687/29314339 -silent
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./29301687/28566910 -silent
(oracle)
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1
cd
./29301687/29314424/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./29301687/29314424 -silent
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./29301687/29314339 -silent
./29301687/29314424/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
(root)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.sh -postpatch
$GRID_HOME/crs/install/rootcrs.sh -postpatch -nonrolling (롤링으로 하고자 할때)
(oracle)
$ /bin/srvctl start home -o -s -n
- Loading Modified SQL Files into the Database
sqlplus /nolog
SQL> conect / as sysdba
SQL> startup
SQL> quit
cd $ORACLE_HOME/OPatch
./datapatch -verbose
-----------------------------
### [롤백하는 경우] ###########
(oracle)
$ /bin/srvctl stop home -o -s -n
(root)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/crs/install/rootcrs.sh -prepatch -rollback
(grid)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/OPatch/opatch nrollback -local -id 29314424,29301676,29314339,26839277,28566910 -oh $GRID_HOME
(oracle)
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/dbhome_1
cd
./29301687 /29314424/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch nrollback -local -id 29314424,29314339 -oh /oracle/product/12.2.0.1/dbhome_1
./29301687 /29314424/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
Run post script
(root)
export GRID_HOME=/u01/app/12.2.0.1/grid
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.sh -postpatch -rollback
(oracle)
$ /bin/srvctl start home -o -s -n
sqlplus /nolog
SQL> conect / as sysdba
SQL> startup
SQL> quit
cd $ORACLE_HOME/OPatch
./datapatch -verbose
