DBA Support

 Environment Details ---------------------------- Oracle Real Application Cluster 02 Nodes Oracle Solaris 11.3 SPARC Oracle version 19.6.1.0.0 Problem Description --------------------------- Above error continuously reported in the database alert. In that case we have to check certain logs instead to database alert. Before that, we must find for any firewall rule changes or any IP filter changes in between application server IP and database IPs with the internal network team. So the error reported in the db alert as follows. 2021-11-23T15:20:09.766518+05:30 opiodr aborting process unknown ospid (9758) as a result of ORA-609 2021-11-23T15:20:09.770202+05:30 Errors in file /u01/app/oracle/diag/rdbms/db/db1/trace/db1_ora_9758.trc : ORA-00609: could not attach to incoming connection ORA-12547: TNS:lost contact Considering the alert log error we must check listener logs as well. This can be done finding and comparing the similar timestamp in the listener logs. 23-NOV-2021 15:...

ORA-01555 caused by SQL statement below (SQL ID: 6pfwn5k98dywk, Query Duration=0 sec, SCN: 0x000000070377b986) in the DB alert log Environment Details  ------------------------- Oracle Real Application Cluster Multitenant Oracle Solaris 11.3 SPARC Oracle version 19.12.0.0.0 Problem Description -------------------------- Above error was continuously occurring daily in a specific time period. Basically when there is an error like above in the db alert we must check if any task has been performed during the incident time period. ORA-01555 is an error which occurs due to insufficient rollback segments or UNDO_RETENTION parameter value [Default Value is 900]. Therefore increasing this value as you want will not solve the issue. You must find why does this error occur?. In this scenario, expdp was executing during the incident time using the parameter value  FLASHBACK_SCN which means CONSISTENT=Y.  So the flashback method depends on the UNDO data. Therefore the UNDO must retain...