Hi, When I startup any instance in the Full exadata, i got ” ORA-39511: Start of CRS resource for instance ‘223’ failed with error:[CRS-5702: Resource, ORA-32004 CRS-0223 ” errors.
Read More »ORA-ERRORS
ORA-12842: Cursor invalidated during parallel execution on Exadata
Hi, I got ORA-12842: Cursor invalidated during parallel execution error during parallel execution on Exadata.
Read More »OPatch failed with error code 73 | Prerequisite check “CheckActiveFilesAndExecutables” failed During Opatch apply 30698487
I got OPatch failed with error code 73 | Prerequisite check “CheckActiveFilesAndExecutables” failed During Opatch apply 30698487.
Read More »OPatch failed with error code 73, The Central Inventory is corrupted and The oraInst.loc file specified is not valid Error Solution
When I query the Patch details of Oracle, I got ” OPatch failed with error code 73 The Central Inventory is corrupted and The oraInst.loc file specified is not valid …
Read More »ORA-31693 ORA-02354 ORA-01555 snapshot too old During Export backup via expdp
Hi, I will explain how to solve ORA-31693 ORA-02354 ORA-01555 During Export backup error.
Read More »ORA-016340: cannot drop a user that is currently connected
Hi, You can get ” ORA-016340: cannot drop a user that is currently connected ” error during the drop any user.
Read More »ORA-04021: timeout occurred while waiting to lock object during truncate table or alter table
Hi, Sometimes you can get ” ORA-04021: timeout occurred while waiting to lock object ” during truncate table or alter table.
Read More »PRVG-1261 : Required Oracle patch “21255373” in home during Oracle 12c R2 (12.2.0.1.0) Grid Infrastructure Upgrade
Hi, When I upgrade Grid Insfrastructure from Oracle 11g to Oracle 12c R2, I got ” PRVG-1261 : Required Oracle patch “21255373” in home ” error in the Install step.
Read More »OGG-02028 Failed to attach to logmining server Error code 27144, error message: ORA-27144: attempt to kill process failed
Hi, Goldengate Extract process is abended with ” OGG-02028 Failed to attach to logmining server Error code 27144, error message: ORA-27144: attempt to kill process failed ” error.
Read More »ORA-00020: maximum number of processes (%s) exceeded
How to increase PROCESSES initialization parameter : Check Current Setting of Parameters 1)show parameter sessions 2)show parameter processes 3)show parameter transactions A basic formula for determining these parameter values …
Read More »
IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial