2021. 2. 10. 13:58 오라클
'오라클'에 해당되는 글 502건
- 2021.02.10 12.2 RAC GIMR 구성 안하기
- 2021.02.02 Oracle CRS Crash Dump Enable 하기
- 2021.01.22 패치작업 19.10.0.0.210119 (GI PSU 32226239)
- 2021.01.13 Error 4 opening dom ASM/Self
- 2020.12.22 Oracle 21c 가 릴리즈 되었다.
- 2020.12.22 19c 3node 이상 구성시 engine 복사 안되는 현상 (Doc ID 2662954.1)
- 2020.11.19 패치작업 19.9.0.0.201020 (GI PSU 31750108)
- 2020.11.10 ASM에 위치한 ocr 백업화일을 로컬로 복사
- 2020.11.10 11.2.0.4 deconfig 후 root.sh 실행시 VP 관련 에러날때
- 2020.10.29 Oracle CRS 권한 원복방법 rootcrs.pl -init
2021. 2. 2. 21:43 오라클
Oracle CRS Crash Dump Enable 하기
리눅스 플랫폼에서 클러스터웨어가 리부팅되는 동안 OS Crash Dump 를 활성화하는 방법
Bug 11866171 - Linux: Enable Crashdump when rebooting the machine (Doc ID 11866171.8)
- Crash Dump Enable (root)
crsctl modify type ora.cssd.type -attr "ATTRIBUTE=REBOOT_OPTS, TYPE=string, DEFAULT_VALUE=,FLAGS=CONFIG" -init
crsctl modify type ora.cssdmonitor.type -attr "ATTRIBUTE=REBOOT_OPTS, TYPE=string, DEFAULT_VALUE=,FLAGS=CONFIG" -init
crsctl modify res ora.cssd -attr "REBOOT_OPTS=CRASHDUMP" -init
crsctl modify res ora.cssdmonitor -attr "REBOOT_OPTS=CRASHDUMP" -init
- Crash Dump Disable (root)
crsctl modify res ora.cssd -attr "REBOOT_OPTS=" -init
crsctl modify res ora.cssdmonitor -attr "REBOOT_OPTS=" -init
2021. 1. 22. 12:33 오라클
패치작업 19.10.0.0.210119 (GI PSU 32226239)
패치작업 19.10.0.0.210119 (GI PSU 32226239)
OCW Patch Set Update : 19.10.0.0.210119 (32222571)
ACFS Patch Set Update : 19.10.0.0.210119 (32218663)
Database Patch Set Update : 19.10.0.0.210119 (32218454)
DBWLM Release Update : 19.0.0.0.0 (29340594)
Tomcat Release Update : 19.0.0.0.0 (32240590)
Oracle Grid Infrastructure Patch Set Update 19.10.0.0.210119
-------------------------------------
GRID_HOME, ORACLE_HOME 을 개별로 각각 할때
- grid 유저
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/32226239/32218454
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/32226239/32222571
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/32226239/32218663
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/32226239/29340594
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/32226239/32240590
- oracle 유저
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/32226239/32218454
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/32226239/32222571
(oracle)
$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>
(root 유저)
export GRID_HOME=/u01/app/19.3.0.0/grid
$GRID_HOME/crs/install/rootcrs.sh -prepatch -nonrolling
(grid 유저)
export GRID_HOME=/u01/grid/19.3.0.0
cd <UNZIPPED_PATCH_LOCATION>
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./32226239/32222571
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./32226239/32218663
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./32226239/32218454
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./32226239/29340594
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./32226239/32240590
(oracle 유저)
export ORACLE_HOME=$ORACLE_BASE/product/19.3.0.0
cd <UNZIPPED_PATCH_LOCATION>
./32226239/32222571/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./32226239/32222571
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./32226239/32218454
./32226239/32222571/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
(root 유저)
export GRID_HOME=/u01/grid/19.3.0.0
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.sh -postpatch
(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>
GI Home
(root로)
$GRID_HOME/crs/install/rootcrs.sh -prepatch -rollback
(grid 유저로)
$GRID_HOME/OPatch/opatch nrollback -local -id 32222571,32218663,32218454,29340594,32240590 -oh $GRID_HOME
(oracle 유저로)
cd <UNZIPPED_PATCH_LOCATION>
./32226239/32222571/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME (권한체크)
$ORACLE_HOME/OPatch/opatch nrollback -local -id 32222571,32218454 -oh /oracle/product/19.3.0.0
./32226239/32222571/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME (권한체크)
Run post script
(root로)
$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
2021. 1. 13. 18:17 오라클
Error 4 opening dom ASM/Self
19C: While Executing Root.sh on Remote Nodes HIT UNEXPECTED "ERROR 4 OPENING DOM ASM/SELF IN 0x57f7d60" (Doc ID 2571719.1)
19c rac 설치시 root.sh 실행시 1번노드 정상 수행후 Remote node 에서 아래와 같은 에러 발생!!
2021/01/13 16:23:15 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2021/01/13 16:24:09 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2021/01/13 16:24:54 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
2021/01/13 16:25:45 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2021/01/13 16:25:46 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
2021/01/13 16:25:57 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
2021/01/13 16:26:54 CLSRSC-343: Successfully started Oracle Clusterware stack
2021/01/13 16:26:54 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
2021/01/13 16:27:21 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2021/01/13 16:27:47 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
Error 4 opening dom ASM/Self in 0x9b596c0
Domain name to open is ASM/Self
Error 4 opening dom ASM/Self in 0x9b596c0
알려진 버그로 무시가능..
2020. 12. 22. 21:35 오라클
Oracle 21c 가 릴리즈 되었다.
https://blogs.oracle.com/database/introducing-oracle-database-21c
소리소문 없이 2020년 12월 8일 Oracle 21c 버전이 릴리즈 되었다. 이전에 Preview버전으로 나왔었지만 아마도 20c 버전은 건너뛰는 듯 하다.
현재 발표된 21c의 Patching End Date 는 2023년 6월30일 까지 이다.
(21c는 Innovation Release 로 나왔기 때문에 통상적으로 지원기간이 2년정도밖에 되지 않기에 이점을 유의해야 한다.(마치 이전의 18c버전처럼) 안정적인 지원을 받기 위해서는 Long Term Release 버전인 19c를 사용해야만 한다. 19c는 Extended Supoort 기간이 2027년 4월30일 까지이다.)
해당 URL에서 New Features 및 Enhancement 등에 대한 정보를 확인할수 있다.
현재는 클라우드 상에서만 이용가능하며 On-Premise 버전은 2021년 내로 나온다고 한다.
2020. 12. 22. 20:33 오라클
19c 3node 이상 구성시 engine 복사 안되는 현상 (Doc ID 2662954.1)
19c [INS-10113] And PRCF-2041 When Installing 3 Nodes RAC (Doc ID 2662954.1)
19c 버전으로 3node 이상 구성시 과정중 1node -> 2node,3node 로 grid 및 db 엔진이 Copy 가 안되는 증상이 있다함.
Unpublished Bug 29530156 - INSTALL OF 18.5 GRID INFRASTRUCTURE ON OL 7.6 HANGS ON COPY STAGE WHEN 3 NODES
해결방법은 각각 작업전 아래와 같이 환경변수 지정후 작업할 것.
- Gird 설치시
export SRVM_DISABLE_MTTRANS=true
./gridSetup.sh
- Database 설치시
export SRVM_DISABLE_MTTRANS=true
./runInstaller
2020. 11. 19. 16:51 오라클
패치작업 19.9.0.0.201020 (GI PSU 31750108)
===========================================================================
패치작업 19.9.0.0.201020 (GI PSU 31750108)
OCW Patch Set Update : 19.9.0.0.201020 (31772784)
ACFS Patch Set Update : 19.9.0.0.201020 (31773437)
Database Patch Set Update : 19.9.0.0.201020 (31771877)
Tomcat Release Update : 19.0.0.0.0 (31780966)
Oracle Grid Infrastructure Patch Set Update 19.9.0.0.201020
-------------------------------------
GRID_HOME, ORACLE_HOME 을 개별로 각각 할때
- grid 유저
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31750108/31772784
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31750108/31773437
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31750108/31771877
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31750108/31780966
- oracle 유저
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31750108/31772784
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31750108/31771877
(oracle)
$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>
(root 유저)
export GRID_HOME=/u01/app/19.3.0.0/grid
$GRID_HOME/crs/install/rootcrs.sh -prepatch -nonrolling
(grid 유저)
export GRID_HOME=/u01/grid/19.3.0.0
cd <UNZIPPED_PATCH_LOCATION>
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31750108/31772784
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31750108/31773437
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31750108/31771877
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31750108/31780966
(oracle 유저)
export ORACLE_HOME=$ORACLE_BASE/product/19.3.0.0
cd <UNZIPPED_PATCH_LOCATION>
./31750108/31772784/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./31750108/31772784
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./31750108/31771877
./31750108/31772784/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
(root 유저)
export GRID_HOME=/u01/grid/19.3.0.0
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.sh -postpatch
(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>
GI Home
(root로)
$GRID_HOME/crs/install/rootcrs.sh -prepatch -rollback
(grid 유저로)
$GRID_HOME/OPatch/opatch nrollback -local -id 31772784,31773437,31771877,31780966 -oh $GRID_HOME
(oracle 유저로)
cd <UNZIPPED_PATCH_LOCATION>
./31750108/31772784/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME (권한체크)
$ORACLE_HOME/OPatch/opatch nrollback -local -id 31772784,31771877 -oh /oracle/product/19.3.0.0
./31750108/31772784/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME (권한체크)
Run post script
(root로)
$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
===========================================================================
===========================================================================
패치작업 19.8.0.0.200714 (GI PSU 31305339)
OCW Patch Set Update : 19.8.0.0.200714 (31305087)
ACFS Patch Set Update : 19.8.0.0.200714 (31304218)
Database Patch Set Update : 19.8.0.0.200714 (31281355)
Tomcat Release Update : 19.0.0.0.0 (31335188)
Oracle Grid Infrastructure Patch Set Update 19.8.0.0.200714
-------------------------------------
GRID_HOME, ORACLE_HOME 을 개별로 각각 할때
- grid 유저
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31305087
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31304218
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31281355
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31335188
- oracle 유저
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31305087
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/31305339/31281355
(oracle)
$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>
(root 유저)
export GRID_HOME=/u01/app/19.3.0.0/grid
$GRID_HOME/crs/install/rootcrs.sh -prepatch -nonrolling
(grid 유저)
export GRID_HOME=/u01/grid/19.3.0.0
cd <UNZIPPED_PATCH_LOCATION>
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31305339/31305087
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31305339/31304218
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31305339/31281355
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local ./31305339/31335188
(oracle 유저)
export ORACLE_HOME=$ORACLE_BASE/product/19.3.0.0
cd <UNZIPPED_PATCH_LOCATION>
./31305339/31305087/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./31305339/31305087
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local ./31305339/31281355
./31305339/31305087/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
(root 유저)
export GRID_HOME=/u01/grid/19.3.0.0
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/crs/install/rootcrs.sh -postpatch
(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>
GI Home
(root로)
$GRID_HOME/crs/install/rootcrs.sh -prepatch -rollback
(grid 유저로)
$GRID_HOME/OPatch/opatch nrollback -local -id 31305087,31304218,31281355,31335188 -oh $GRID_HOME
(oracle 유저로)
cd <UNZIPPED_PATCH_LOCATION>
./31305339/31305087/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME (권한체크)
$ORACLE_HOME/OPatch/opatch nrollback -local -id 31305087,31281355 -oh /oracle/product/19.3.0.0
./31305339/31305087/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME (권한체크)
Run post script
(root로)
$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
===========================================================================
2020. 11. 10. 16:59 오라클
ASM에 위치한 ocr 백업화일을 로컬로 복사
ASM에 위치한 ocr 백업화일을 로컬로 복사해 놓기
ocrconfig -copy +DATA/dbSys4ar6e5zq/OCRBACKUP/backup00.ocr.273.1056122679 /tmp/ocr/backup00.ocr.273.1056122679
ls -al
total 2268
drwxr-xr-x 2 grid oinstall 4096 Nov 10 16:52 .
drwxrwxrwt 16 root root 4096 Nov 10 16:55 ..
-rw------- 1 root root 2314240 Nov 10 16:52 backup00.ocr.273.1056122679
2020. 11. 10. 15:09 오라클
11.2.0.4 deconfig 후 root.sh 실행시 VP 관련 에러날때
11.2.0.4 deconfig 후 root.sh 실행시 VP 관련 에러날때
root.sh Fails With "Unable to get VIP info for new node at" (Doc ID 1454413.1)
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 11g Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Unable to get VIP info for new node at /oragrid/product/11.2.0.4/crs/install/crsconfig_lib.pm line 9000.
양 노드에서 해당 화일 rename 후 다시 root.sh 시도
cd $GRID_HOME/crs/install
mv crsconfig_addparams crsconfig_addparams.bak
2020. 10. 29. 22:54 오라클
Oracle CRS 권한 원복방법 rootcrs.pl -init
CRS 의 권한이 뭔가 잘못 건드려 꼬였을 경우 아래와 같이 조치해 볼수 있다.
CRS 권한 원복 rootcrs.pl -init
How to check and fix file permissions on Grid Infrastructure environment (문서 ID 1931142.1)
방법 1
<GRID_HOME> 확인
# cluvfy comp software -n all -verbose
방법 2
- 해당위치의 2개화일에 directory 및 permission 정보가 들어있으므로 확인가능
$GRID_HOME/crs/utl (for 11.2 and 12.1.0.1)
$GRID_HOME/crs/utl/<hostname> (for 12.1.0.2)
crsconfig_dirs
crsconfig_fileperms
- 11.2.0.3.6 부터 -init 옵션으로 권한 원복할수 있음
11.2 (as root) RAC 인 경우
# cd <GRID_HOME>/crs/install/
# ./rootcrs.pl -init
11.2 (as root) Standalone 인경우
cd <GRID_HOME>/crs/install/
# ./roothas.pl -init
12c (as root) RAC 인 경우
# cd <GRID_HOME>/crs/install/
# ./rootcrs.sh -init
12c (as root) Standalone 인경우
# cd <GRID_HOME>/crs/install/
# ./roothas.sh -init
