Parameter used to get this warning error is TransportDisconnectedThreshold Parameter. It value defined in seconds. Default value : 30 seconds, We can also set the parameter to zero value to …
Category:
Troubleshoot
-
-
Error ORA-31641: unable to create dump file “C:employee.dmp” ORA-27038: created file already exists C:\windows\system32>expdp directory=dbbackup dumpfile=employee.dmp logfile=employee.log Export: Release 18.0.0.0.0 – Production on Mon Apr 13 09:33:27 2020 Version 18.4.0.0.0 …
-
In one of the DR system, we are getting the following Warning ORA-16855:transport lag exceeded specific threshold On Oracle check ORA error: ORA-16855 Description: transport lag has exceeded specified threshold …
-
ORA-31650: timeout waiting for master process response Error During execution of EXPDP or IMPDP, we are getting the following error: Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 …
-
DataguardOracleTroubleshoot
ORA-19527: physical standby redo log must be renamed
by tuanlpby tuanlpORA-19527: physical standby redo log must be renamed Error:ORA-19527: physical standby redo log must be renamedORA-00312: online log 7 thread 0: ‘G:ORACLEORADATASTANDBY05.LOG’ At DR site, we got the error …
-
Step to resize standby redolog files In Data-guard, if we recreate or add the standby redolog files due to thread number issue or Size mentioned wrong then in that …
-
Error in Alert Log Sun Nov 25 02:14:17 2018Unable to allocate memory for new incident error in file E:ORACLE12Cdiagrdbmsicictraceic_m001_6448.trc:ORA-04030: out of process memory when trying to allocate 20520 bytes (pga …
-
OracleTroubleshoot
ORA-01154: database busy. Open, close, mount, and dismount not allowed
by tuanlpby tuanlpNormal database environment If database is giving following message then you can use shutdown abort and startup it again. If not fixed then you can use shutdown abort commandShutdown abort …
-
OracleTroubleshoot
ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n
by tuanlpby tuanlpError: When i tried to set the log_archive dest value then i got the following error:SQL> ALTER SYSTEM SET log_archive_dest=’D:oraclexe’;ALTER SYSTEM SET log_archive_dest=’D:oraclexe’*ERROR at line 1:ORA-02097: parameter cannot be modified …
-
OracleTroubleshoot
ORA-00257: archiver error. Connect internal only, until freed.
by tuanlpby tuanlpError: On checking the alert log we found the following error in alert log: ORA-00257: archiver error. Connect internal only, until freed.ORORA-19809: limit exceeded for recovery filesORA-19804: cannot reclaim 904507904 …