CDB Database creation using template on RAC 12c
RAC - Change OCR Vote disk and ASM Spfile location to new disk group
RAC - Convert one Node to Standard 2 node RAC database
RAC - Online Relocation |Cold Failover of One node RAC database
RAC - Scale Down 2 node RAC to 1 node RAC example
RAC - Relocate RAC service from Available to Preferred Instance Example
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x10] [PC:0xCE518CE, qerixGetKey()+782] [flags: 0x0, count: 1
ACFS-9459: ADVM/ACFS is not supported on this OS version: '4.12.14-120-default SP5'
RAC - ORA-15025: could not open disk |WARNING: FAILED to load library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so
RAC : [INS-13001] Environment does not meet minimum requirements.
RAC [INS-06003] Failed to setup passwordless SSH connectivity with the following node(s)
RAC _Patch _Failed_scenario : CRS-6706: Oracle Clusterware Release patch level ('966527961') does not match Software patch level ('2919480821'). Oracle Clusterware cannot be started.
RAC - CRS-2403: The Cluster Time Synchronization Service on host 02 is in observer mode.
RAC - Take TAR level binary backup of grid_home, db_home and orainventory_home
ACFS-9459: ADVM/ACFS is not supported on this OS version: '4.12.14-120-default SP5'
ACFS Error - ORA-15032: not all alterations performed || ORA-15477: cannot communicate with the volume driver
Operating System Kernel Upgrade SLES 12 SP4 to 12 SP5 on 2 Node RAC 12.1.0.2.0
12c RAC 2 node RMAN Backup Restoration to standalone database archivelog log recovery
Creation of 2 Node RAC to non RAC DR (12c)
[PRCF-2030 : Parallel transfer workload distribution error. 12c (12.1.0.2.0)
RAC : Add Failed cluster on 2nd node 12c R1 (12.1.0.2.0)
Check ssh date on both 2 node RAC Server
RAC - Restore RAC RMAN Backup linux to Single Instance Window database 12c
[INS-41112] Specified network interface doesnt maintain connectivity across cluster nodes.
RAC - Grid Installation steps error - VIP IP Address conflict INS-40912] : Virtual host name assigned to another system on the network.
(RAC -PATCHING) - Patch 24412235 - Oracle Grid Infrastructure Patch Set Update 12.1.0.2.161018 (Oct2016)
(RAC -PATCHING) - Patch 24412235 - Oracle Grid Infrastructure Patch Set Update 12.1.0.2.161018 (Oct2016)
RAC - GPNP Command check
RAC : Node connectivity check failed (PRVG-11138, PRVG-11352 - HAS a disk HB, but no network HB)
Device "/dev/sdb1" is already labeled for ASM disk "CRS1"
oracle 12.1.0.2.0 RAC file initrac2.ora
Remove oracle RAC database version 12c STEPS
Oracle RAC 12c grid De Install Steps ---
DNS configuration for RAC setup 12 R1
Starting up and Stopping Oracle RAC -Commands
Parameters that Require Identical Settings in All the Instances
srvctl modify database -db rac -policy AUTOMATIC | MANUAL | NORESTART
Reference data is not available for release "12.1" on Linux x86-64 SLES-12 (Doc ID 2127760.1)
Connection Load Balancing and TAF
Configure server-side Load Balancing Advisory for connect-time load balancing
Configure server-side Load Balancing Advisory for connect-time load balancing
Configure TAF Basic Configuration on Server-side
Drop ASM DISKGROUP and RAW Partitions and Re create partions
Create Database Service on RAC 12c R1 and Preferred RAC Service examples
Configure TAF Basic Configuration on Client-side
Configure TAF PRECONNECT configuration on server-side
Configure TAF PRECONNECT Configuration on Client-side
Application Continuity on a Java Application
Change listener , mgmtlsnr on RAC 12c R1 1521 to 1522
opatchauto apply -analyze 12c Grid
PSU OJVM Combo Patch Grid - RAC 12c R1 -- 28980120 PART1
PSU OJVM Combo Patch Grid - RAC 12c R1 -- 28980120 PART2
ACFS
Virtual IP Address commands
GPNP PROFILE Location
Add Oracle Cluster Registry (OCR) file commands
Check Master node on Grid 12c R1
RAC - WARNING: failed to online diskgroup resource ora.CRS.dg (unable to communicate with CRSD/OHASD
RAC - Rconfig convert single instance to 2 node RAC 12.1.0.2.0
·
ASM Disk Location
grid@sgdcplm02:~> /usr/sbin/oracleasm listdisks
NEWCRS2
NEWCRS3
NEWDATA1
NEWFRA1
NEWFRA2
grid@sgdcplm02:~>
OCR and OLR Information
OLR Backup location details :
grid@sgdcplm02:~> ocrconfig -local -showbackup
sgdcplm02 2021/05/03
09:07:18
/u01/app/12.1.0/grid/cdata/sgdcplm02/backup_20210503_090718.olr 2919480821
sgdcplm02
2019/09/26 16:15:10
/u01/app/12.1.0/grid/cdata/sgdcplm02/backup_20190926_161510.olr 2919480821
sgdcplm02
2019/09/22 16:46:59 /u01/app/12.1.0/grid/cdata/sgdcplm02/backup_20190922_164659.olr 2919480821
OLR Location :
/u01/app/12.1.0/grid/cdata
grid@sgdcplm02:~> cd /u01/app/12.1.0/grid/cdata/
grid@sgdcplm02:/u01/app/12.1.0/grid/cdata> ll
total 1376
drwxr-xr-x 2 grid oinstall 6 Sep 22 2019 localhost
drwxr-xr-x 2 grid oinstall 108 May
3 2021 sgdcplm02
-rw------- 1 root oinstall 503484416 Feb 4 07:20 sgdcplm02.olr
drwxrwxr-x 2 grid oinstall 198 Feb
4 07:17 smrrac
grid@sgdcplm01:~> cat /etc/oracle/olr.loc
olrconfig_loc=/u01/app/12.1.0/grid/cdata/sgdcplm01.olr
crs_home=/u01/app/12.1.0/grid
OCR Location :
grid@sgdcplm01:~> cat /etc/oracle/ocr.loc
ocrconfig_loc=+CRS/smrrac/OCRFILE/registry.255.1019666555
local_only=FALSE
grid@sgdcplm01:~>
OCR Backup Location :
grid@sgdcplm01:~> ocrconfig -showbackup
sgdcplm02
2021/12/08 03:18:51
/u01/app/12.1.0/grid/cdata/smrrac/backup00.ocr 2919480821
sgdcplm02
2021/12/07 23:18:50
/u01/app/12.1.0/grid/cdata/smrrac/backup01.ocr 2919480821
sgdcplm02
2021/12/07 19:18:50
/u01/app/12.1.0/grid/cdata/smrrac/backup02.ocr 2919480821
sgdcplm02
2021/12/06 15:18:44
/u01/app/12.1.0/grid/cdata/smrrac/day.ocr 2919480821
sgdcplm02
2021/11/28 11:17:59 /u01/app/12.1.0/grid/cdata/smrrac/week.ocr 2919480821
sgdcplm02
2019/09/27 08:11:08
/u01/app/12.1.0/grid/cdata/smrrac/backup_20190927_081108.ocr 2919480821
sgdcplm02
2019/09/26 15:42:54
/u01/app/12.1.0/grid/cdata/smrrac/backup_20190926_154254.ocr 2919480821
No comments:
Post a Comment