Skip to content

Latest:

ORA-12842: Cursor invalidated during parallel execution on Exadata
OPatch failed with error code 73 | Prerequisite check “CheckActiveFilesAndExecutables” failed During Opatch apply 30698487
OPatch failed with error code 73, The Central Inventory is corrupted and The oraInst.loc file specified is not valid Error Solution
How to Shutdown and Startup Exadata and Oracle Databases
ORA-31693 ORA-02354 ORA-01555 snapshot too old During Export backup via expdp

IT Tutorials

Latest Tutorials About Database, Application, Operating System, Network, Artifical Intelligence, Programming Languages Tutorials & Useful Scripts & Tips and Tricks

Oracle
SQL Server
Application
Database
OS
Engineering
Programming
- C
- C++
- C#
- Oracle SQL
- Android
- PL/SQL
- Java
- Javascript
- HTML
- XML
About Us
Join Us

ORA-ERRORS

ORA-12842: Cursor invalidated during parallel execution on Exadata

March 27, 2020 Mehmet Salih Deveci 0 Comments : Cursor invalidated during parallel execution, ALTER SESSION SET, ALTER SYSTEM SET, ORA-12842, ora-12842 cursor invalidated during parallel, ORA-12842: Cursor invalidated during parallel execution, _FIX_CONTROL

Hi, I got ORA-12842: Cursor invalidated during parallel execution error during parallel execution on Exadata.

OPatch failed with error code 73 | Prerequisite check “CheckActiveFilesAndExecutables” failed During Opatch apply 30698487

March 26, 2020 Mehmet Salih Deveci 0 Comments attach grid home to central inventory, caused by: java.lang.runtimeexception: prerequisite check "checkactivefilesandexecutables" failed, create oracle inventory 11g, error: this oracle home does not seem to be registered, exception occured : fuser could not be located, following active executables are not used by opatch process, following active executables are not used by opatch process bin/oracle, following active executables are used by opatch process, following active files are not used by opatch process, following active files are used by opatch process, OPatch failed with error code 73, opatch failed with error code 73 following active files are not used by opatch process, opatch failed with error code 73 getting pre run patch inventory failed, opatch failed with error code 73 lsinventory, opatch failed with error code 73 while rollback, opatch failed with error code = 73 windows 2016, opatchauto failed with error code 73, oracle 12.2 opatch failed with error code = 73, oracle home inventory file, oracle inventory corrupted, oraevrus12.dll active, orainventory corrupted, prerequisite check checkactivefilesandexecutables'' failed error code 73, prerequisite check checkactivefilesandexecutables'' failed error code 73 windows, recreate oracle inventory 12c, The Central Inventory is corrupted, the database software home is already registered in the central inventory, the home at is invalid or corrupt. unable to continue cloning, The oraInst.loc file specified is not valid

Hi, I got OPatch failed with error code 73 | Prerequisite check “CheckActiveFilesAndExecutables” failed During Opatch apply 30698487.

OPatch failed with error code 73, The Central Inventory is corrupted and The oraInst.loc file specified is not valid Error Solution

March 25, 2020March 25, 2020 Mehmet Salih Deveci 0 Comments attach grid home to central inventory, create oracle inventory 11g, error: this oracle home does not seem to be registered, OPatch failed with error code 73, opatch failed with error code 73 following active files are not used by opatch process, opatch failed with error code 73 getting pre run patch inventory failed, opatch failed with error code 73 lsinventory, opatch failed with error code 73 while rollback, opatch failed with error code = 73 windows 2016, opatchauto failed with error code 73, oracle 12.2 opatch failed with error code = 73, oracle home inventory file, oracle inventory corrupted, orainventory corrupted, prerequisite check checkactivefilesandexecutables'' failed error code 73, recreate oracle inventory 12c, The Central Inventory is corrupted, the database software home is already registered in the central inventory, the home at is invalid or corrupt. unable to continue cloning, The oraInst.loc file specified is not valid

Hi, When I query the Patch details of Oracle, I got ” OPatch failed with error code 73, The Central

ORA-31693 ORA-02354 ORA-01555 snapshot too old During Export backup via expdp

March 20, 2020 Mehmet Salih Deveci 0 Comments impdp ora-01555, impdp ora-01555: snapshot too old: rollback segment number, ora 02351 internal error kupdcrdgrandir nogranuleoffset, ora 39374 statistics failed to export failing error is, ora-01555 snapshot too old informatica, ora-01555 snapshot too old on standby database, ORA-01555 solution, ORA-01555: snapshot too old, ora-01555: snapshot too old: rollback segment number 13 with name _syssmu13 too small, ora-01555: snapshot too old: rollback segment number 3 with name _syssmu3$'' too small, ora-01555: snapshot too old: rollback segment number 9 with name "_syssmu9$" too small, ora-22924: snapshot too old, ora-31693 ora-02354 impdp, ora-31693 ora-02354 ora-01466, ORA-31693 ORA-02354 ORA-01555, ora-31693 ora-29913 ora-01555 expdp, ora-31693 table data object failed to load/unload expdp, sap ora-01555: snapshot too old

Hi, I will explain how to solve ORA-31693 ORA-02354 ORA-01555 During Export backup error.

ORA-016340: cannot drop a user that is currently connected

March 18, 2020 Mehmet Salih Deveci 0 Comments ALTER SYSTEM KILL SESSION, cannot drop a user that is currently connected oracle 12c, cannot drop a user that is currently connected sql, drop all users in oracle, drop user cascade, drop user oracle, ora 42298 cannot rename a user that is currently connected, ORA-016340 oracle, ORA-016340: cannot drop a user that is currently connected, ora-28014: cannot drop administrative users, ora-28050: specified user or role cannot be dropped

Hi, You can get ” ORA-016340: cannot drop a user that is currently connected ” error during the drop any

ORA-04021: timeout occurred while waiting to lock object during truncate table or alter table

March 18, 2020 Mehmet Salih Deveci 0 Comments ALTER SESSION SET DDL_LOCK_TIMEOUT, ALTER SYSTEM KILL SESSION, alter table, DDL_LOCK_TIMEOUT, ora 04021 timeout occurred while waiting to lock object, ora 04021 timeout occurred while waiting to lock object sql begin sys ad_grants cleanup end, ora 04021 timeout occurred while waiting to lock object sys _next_pdb, ora 20000 ora 04021 timeout occurred while waiting to lock object error in ad_grants give_privilege, ora-04021 timeout occurred while waiting to lock object during import, ora-04021: timeout occurred while waiting to lock object blog, ora-04021: timeout occurred while waiting to lock object library cache pin

Hi, Sometimes you can get ” ORA-04021: timeout occurred while waiting to lock object ” during truncate table or alter

PRVG-1261 : Required Oracle patch “21255373” in home during Oracle 12c R2 (12.2.0.1.0) Grid Infrastructure Upgrade

March 16, 2020 Mehmet Salih Deveci 0 Comments 21255373, 21255373 gridSetup.sh -skipPrereqs, 21255373 patch, gridSetup.sh -skipPrereqs, gridSetup.sh -skipPrereqs 21255373, PRVG-1261, PRVG-1261 : Required Oracle patch "21255373", PRVG-1261 : Required Oracle patch "21255373" in home

Hi, When I upgrade Grid Insfrastructure from Oracle 11g to Oracle 12c R2, I got ” PRVG-1261 : Required Oracle

ORA-ERRORS Oracle Oracle DBA Scripts Oracle SQL Oracle SQL Türkçe Oracle Türkçe

ORA-00020: maximum number of processes (%s) exceeded

March 5, 2020 baranyildiz 0 Comments maaximum number of processes (%s) exceeded, ORA-00020, 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

ORA-ERRORS Oracle Oracle SQL Oracle SQL Türkçe Oracle Tutorials

ORA-01950: no privileges on tablespace

March 4, 2020 baranyildiz 0 Comments no privileges on tablespace, ORA-01950

Hi , Grant the user the appropriate system privileges or grant the user space resource on the tablespace. GRANT UNLIMITED

← Previous

Categories

Categories

Search in IT Tutorial

Ask a Question

Most Popular Post

Oracle DBA Scripts All in One -2 – Dataguard Monitoring Scripts
SQL Server AlwaysOn Architecture and Step by Step Installation -2
Oracle DBA Scripts All in One -1 – RAC Scripts
Oracle E-Business Suite ( EBS ) Tutorials for Junior Oracle Apps DBA
How to Shutdown and Startup Exadata and Oracle Databases
Oracle Database Tutorials for Beginners
SQL Server AlwaysOn Architecture and Step by Step Installation -1
Oracle Database 19c on Linux 7.6 Step by Step Installation -1
Oracle DBA Scripts All in One -3 – Blocking Sessions and Lock Kill Scripts
ORA-28040: No matching authentication protocol

Copyright © 2020 IT Tutorials. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.