Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
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 »Upgrade Time Zone File And Timestamp With Time Zone Data
ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old
ERROR ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old
Read More »unable to spawn jobq slave process, slot 0, error 1089
ERROR kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
Read More »How To Find Oracle Database 32 bit or 64 bit
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?
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 »ORA-01157: cannot identify/lock data file 206 – see DBWR trace file
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
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 »ORA-01442: column to be modified to NOT NULL is already NOT NULL
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
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 »ORA-16038: log cannot be archived ORA-19809: limit exceeded forrecovery files
ERROR ARC3: Error 19809 Creating archive log file to ‘+DISKS’ Errors in file /u01/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc1_6598.trc: ORA-19815: WARNING: db_recovery_file_dest_size of 42687547752 bytes is 100.00% used, and has 0 remaining bytes available. …
Read More »