Introduction : A deadlock is a situation in which two or more sessions are waiting for each other to release locks, creating a circular dependency. Unlike simple blocking, where one …
Read More »
Upgrade Time Zone File And Timestamp With Time Zone Data Upgrading the time zone file and timestamp with time zone (TSTZ) data in an Oracle database is indeed necessary …
Read More »
ERROR ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old
Read More »
ERROR kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
Read More »
How To Find Oracle Database 32 bit or 64 bit Finding Oracle Database Version on your system through Operating System $ cd $ORACLE_HOME $ cd bin $ file oracle oracle: …
Read More »
How to rename a Datafile with Extension .dbf? For example we have added a datafile but we forgot to give the extension .dbf Step 1. Shut down the Database SQL> …
Read More »
ERROR ORA-01157: cannot identify/lock data file 206 – see DBWR trace file ORA-01110: data file 206: ‘+DATA’ SOLUTION If you are using XML in your database and you are trying …
Read More »
How to Find and repair Corrupt block in database Step 1: Below query will show if there is any corrupted block SELECT * FROM v$database_block_corruption — will show if any corruped block Step 2: Below query can give you …
Read More »
ERROR Solution : ORA-01442: column to be modified to NOT NULL is already NOT NULL sql> alter table HR.employees modify UID not null; ORA-01442: column to be modified to NOT …
Read More »
RAC Files and Directories $ORA_CRS_HOME/cdata/<cluster_name> OCR backups (default location) $ORA_HOME/log/<hostname>/client/ocrconfig_<pid>.log OCR command log file $ORA_CRS_HOME/crs/log contains trace files for the CRS resources $ORA_CRS_HOME/crs/init contains trace files for the CRS …
Read More »
Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner