During your DBA career lifetime, how many times you faced a problem on a database and you tried to find out the recent implemented changes on this DB? It is crucial for DBAs –whether they work separately or in a team to track their own technical activities in one journal; this not only sounds professional, […]

The following technical steps illustrate the cleanup of Oracle logs on Oracle Cluster system (Grid Infrastructure 12c and above). Before actioning these steps, make sure that logs are no more required for troubleshooting errors neither required for auditing purposes. Cleanup Database related logs: The following commands should be executed against each database installed on the […]

18c is the new name of 12.2.0.2, In 2018 Oracle started to name the new DB versions represent the year the product was released on. I’ve already covered the top remarkable new features of 12.1 and 12.2.0.1 in a previous post: http://dba-tips.blogspot.com/2019/11/a-summary-of-remarkable-new-features-in.html In this post I’ll cover the top new features of 18c which are […]

Problem: While executing root.sh during a 19c Grid Infrastructure on a two RAC nodes I experienced this error: 2020/05/18 10:22:47 CLSRSC-594: Executing installation step 18 of 19: ‘ConfigNode’. 2020/05/18 10:22:59 Oracle Clusterware infrastructure error in CLSECHO (OS PID 27328): ADR home path /u01/oracle/diag/crs/clssrv1-vip2/crs does not exist; ADR initialization will try to create it CLSRSC-594: Executing […]

Problem: After patching an Oracle 19.3 GRID_HOME on Oracle Restart setup with 19.5 RU patch [30125133], I was not able to start up Oracle Restart HAS due to this error: #  $GRID_HOME/bin/crsctl start has CRS-6706: Oracle Clusterware Release patch level (‘3291738383’) does not match Software patch level (‘724960844’). Oracle Clusterware cannot be started. CRS-4000: Command […]

On a19c cluster node I got this error when trying to start one RAC node: [root@fzppon05vs1n ~]# crsctl start crsCRS-41053: checking Oracle Grid Infrastructure for file permission issuesPRVG-11960 : Set user ID bit is not set for file “/u01/grid/12.2.0.3/bin/extjob” on node “fzppon05vs1n”.PRVG-2031 : Owner of file “/u01/grid/12.2.0.3/bin/extjob” did not match the expected value on node […]

Just thought to share the major points of the Maximum Availability Architecture I’m following. It will be difficult to provide references as I’ve gathered/developed these points throughout a decade! I’m sharing it with the hope it will be helpful for you without any warranty.

I intended to post about 19c new features, but thought that most of the DBAs have their productions on 11g and it will be informative if I cover 12c [12.1 & 12.2] new features first “with the implementation steps as possible“, before I jump to 18 & 19c features which I’ll cover in the next […]

Problem: While restarting the clusterware on one cluster node I got this error: [root@fzppon06vs1n~]# crsctl start cluster CRS-2679: Attempting to clean ‘ora.ctssd’ on ‘fzppon06vs1n’ CRS-2672: Attempting to start ‘ora.drivers.acfs’ on ‘fzppon06vs1n’ CRS-2672: Attempting to start ‘ora.evmd’ on ‘fzppon06vs1n’ CRS-2680: Clean of ‘ora.ctssd’ on ‘fzppon06vs1n’ failed CRS-2676: Start of ‘ora.evmd’ on ‘fzppon06vs1n’ succeeded CRS-2674: Start of […]

Introduction: Starting from 12c TAF can failover DMLs to the available nodes on a RAC environment in case of any interruption happens to it including node/service/network failure. This feature is called  Application Continuity or Transaction Guard. Pre-requisites: [For 19c] The applications should use Oracle Client 19c. Although the Oracle note Doc ID 2011697.1 mentioning that any 12.1+ […]