Check out how easy Oracle Grid Infrastructure is to install on #NFS with @OracleDatabase #18c @oracleace
On-line migration of Oracle 18c/19c filesystem datafiles to Oracle ASM
Background Prior to Oracle 12c moving non-ASM data files required taking data files ‘offline’ and negotiating an outage with the business, since Oracle 12c this is has no longer been the case. I was recently challenged with moving a good size filesystem 19c Oracle database from an existing storage platform to a new storage array. Prepare ASM... Continue Reading →
Creating new Oracle 18c ASM Disk Groups
Creating New Volumes Create the new ASM volume(s) using your storage platform, for this blog I have created 3 volumes on a Pure FlashArray, simply providing names and sizes. Note the Volume serial numbers, these will be used in the multipath configuration wwid (World Wide Identifier) SCSI storage device serial numbers are universally unique. Each... Continue Reading →
Oracle 18c disable / enable Archive Log Mode
Disable Archive Log Mode [oracle@z-fbhost2 ~]$ sqlplus / as sysdba SQL*Plus: Release 18.0.0.0.0 - Production on Wed Aug 8 10:17:47 2018 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to an idle instance. # Open database in mount state SQL> startup mount ORACLE instance started. Total System Global Area 1.4227E+11 bytes Fixed... Continue Reading →
Oracle 18c install DBCA failure – PRCR-1006 PRCR-1071 CRS-2566
Oracle 18c install #DBCA failure PRCR-1006 #fixed @oracleace
Oracle 18c Grid Infrastructure installation
. @oracle #18c on-premises is now #GA, check-out my first #18c #Grid #Installation how-to-blog #OracleASM @oracleACE