Problem: ora_lms process is consuming too much memory in 19c RAC database leading to memory resource starvation and heavily swapping ends up with having Nodes to evict from the cluster.   Analysis: This issue is an unknown Bug.31969719 being currently worked by Oracle’s Development team . Facts: – Don’t try to kill the ora_lms process […]

Problem: While importing data on a 19.5 database, Data pump terminated with this error: ORA-39002: invalid operation ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version 33 into a target database with TSTZ version 32.   Analysis: This happened because the target database (where the data is getting imported […]

Problem: Duplicate of a database fails with this error: ORA-32015: unable to restore SPFILE ORA-17502: ksfdcre:4 Failed to create file +DATA/ORCLDR/PARAMETERFILE/spfile.273.1040900343 ORA-15046: ASM file name ‘+DATA/ORCLDR/PARAMETERFILE/spfile.273.1040900343’ is not in single-file creation form ORA-19660: some files in the backup set could not be verified ORA-19685: SPFILE could not be verified ORA-19849: error while reading backup piece […]

Problem: On a 19c RAC DB when shutting down any instance gracefully using srvctl command it throws this error: $ srvctl stop instance -d proto -i proto2 PRCD-1131 : Failed to stop database proto and its services on nodes r6ttnode2 PRCR-1133 : Failed to stop database proto and its running services PRCR-1132 : Failed to […]

 Few months back: I’ve shared a script to rebuild tables in Oracle using online rebuild options like [(DBMS_REDEFINITION (9i+) & ALTER TABLE MOVE ONLINE (12.2+)] if those features are not available in the database (i.e. database edition is Standard Edition) the script will utilize the legacy “ALTER TABLE MOVE” command along with rebuilding indexes. The […]

 Problem: As of a sudden one critical application connecting to a 19c database crashed and kept throwing the following error in its logs: ORA-13831: SQL profile or patch name specified is invalid   Analysis: A quick search revealed that we’re hitting Bug 29942554  Because I had to get the application up and running quickly I’ve […]

Introduction: Private Temporary Tables (PTT) is a new feature in Oracle 18c, they have the similar characteristics of global temp tables but instead of being created under the TEMPORARY tablespace, they get created in the session’s PGA, which is a great feature for boosting the performance (if your PGA is big enough to host this […]

Problem: When connecting from Oracle Client 11g to an 18c DB or higher it throws this error: ORA-28040: No matching authentication protocol Analysis: Starting from 18c SQLNET.ALLOWED_LOGON_VERSION_SERVER parameter is defaulted to 12, which means; if your applications is using Oracle Client 11g to connect to the DB server they will get ORA-28040 unless you set […]

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+ […]

Problem:On a Linux 7, after system reboot I have an 11.2.0.3 RAC Database failed to start due to this error in the alertlog: USER (ospid: 13324): terminating the instance due to error 119Instance terminated by USER, pid = 13324 Cause:While investigating I figured out that the SCAN name “rac1-scan” which is used in “remote_listener” initialization […]