Errors/Workarounds11g

ERROR ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old

ERROR kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089

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:         …

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> …

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 …

ERROR ORA-07445: exception encountered: core dump  [kglic0()+756] [SIGSEGV] [ADDR:0x430000010B8AE910] [PC:0x107AB7474] [Address not mapped to object] []   SOLUTION SQL> ALTER SYSTEM SET “_cursor_stats_enabled”=false SCOPE=SPFILE; Caution : This recommendation can be applied …

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 …

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 …

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 …

  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. …