ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr] error

PROBLEM:
----------------


ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr] error



SOLUTION:
-----------------

You have to drop UNDO tablespace then recreate it.


SQL>create pfile='/tmp/pfile' from spfile;

SQL> startup restrict pfile='/tmp/pfile';
ORACLE instance started.

Total System Global Area 1970864128 bytes
Fixed Size                  2183896 bytes
Variable Size            1543507240 bytes
Database Buffers          419430400 bytes
Redo Buffers                5742592 bytes
Database mounted.
Database opened.
SQL> select tablespace_name, status, segment_name from dba_rollback_segs where status != 'OFFLINE';

TABLESPACE_NAME                STATUS           SEGMENT_NAME
------------------------------ ---------------- ------------------------------
SYSTEM                         ONLINE           SYSTEM

SQL> select tablespace_name, status, segment_name from dba_rollback_segs
  2  ;

TABLESPACE_NAME                STATUS           SEGMENT_NAME
------------------------------ ---------------- ------------------------------
SYSTEM                         ONLINE           SYSTEM
UNDOTBS02                      OFFLINE          _SYSSMU27_3348079370$
UNDOTBS02                      OFFLINE          _SYSSMU26_2631850070$
UNDOTBS02                      OFFLINE          _SYSSMU25_2645117195$
UNDOTBS02                      OFFLINE          _SYSSMU24_1824861410$
UNDOTBS02                      OFFLINE          _SYSSMU23_1673528659$
UNDOTBS02                      OFFLINE          _SYSSMU22_999122355$
UNDOTBS02                      OFFLINE          _SYSSMU21_1258748744$
UNDOTBS02                      OFFLINE          _SYSSMU20_858158107$
UNDOTBS02                      OFFLINE          _SYSSMU19_3999658247$
UNDOTBS02                      OFFLINE          _SYSSMU18_2525182416$

11 rows selected.

SQL> create undo tablespace UNDOTBS1 datafile '/u02/oradata/NECODB1/NECODB1/undotbs01.dbf' size 2000M;(You created new undo tablespace)

Tablespace created.

SQL> drop tablespace UNDOTBS2  including contents and datafiles;(you have to drop old undo tablespace)

Tablespace dropped.




SQL> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1970864128 bytes
Fixed Size                  2183896 bytes
Variable Size            1543507240 bytes
Database Buffers          419430400 bytes
Redo Buffers                5742592 bytes
SQL> shu abort;
ORACLE instance shut down.
SQL> create spfile from pfile='/tmp/pfile';

File created.

SQL> startup
ORACLE instance started.

Total System Global Area 1970864128 bytes
Fixed Size                  2183896 bytes
Variable Size            1543507240 bytes
Database Buffers          419430400 bytes
Redo Buffers                5742592 bytes
Database mounted.
Database opened.
SQL> shu abort;
ORACLE instance shut down.
SQL> startuo

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1970864128 bytes
Fixed Size                  2183896 bytes
Variable Size            1543507240 bytes
Database Buffers          419430400 bytes
Redo Buffers                5742592 bytes
Database mounted.
SQL> alter system set undo_tablespace = 'UNDOTBS1 ' scope=spfile;

System altered.

SQL> alter database open;

Database altered.




Reference:
-----------
Step by step to resolve ORA-600 4194 4193 4197 on database crash (Doc ID 1428786.1)

ORA-00245: control file backup failed; target is likely on a local file system

PROBLEM:
---------------------

executing command: SET COMMAND ID
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script cdtprod_backup_arch
RMAN-03002: failure of set command at 08/24/2014 21:38:42
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 08/24/2014 21:38:42
ORA-00245: control file backup failed; target is likely on a local file system





SOLUTION:
------------------

The controlfile is shared on RAC database and having the backup from anyone node to the shared mountpoint would meet the requirement.

configure snapshot controlfile name to '/<shared location>/snapcf_NEPRO0.f';


The reason for the error is clear ORA-00245 - in a RAC environment the location of the Snapshot Controlfile must be on a shared location.


Example:
-------

before
-------
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_NEPRO1.f'; # default


after:
-------

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/NEPRO/snapcf_NEPRO1.f'; # default

Database Sysdate Isn't Increasing

PROBLEM:
-----------------

If you have difference current_timestamp with sysdate My database sysdate is not working,not increasing.Sysdate doesn't change.


SOLUTION:
-----------------

Check the parameter fixed_date.If you see any value,you have to reset parameter.


SQL>show parameter fixed_date

SQL>ALTER SYSTEM SET FIXED_DATE=NONE;




If the parameter also 'NONE'.

Check the timezone!!!!!

WHY ARE MY ORACLE JOBS NOT RUNNING

SOLUTION:
-----------------

check the job_queue_process parameter,may be "0"

Then set the parameter

alter system set job_queue_processes=200;

This parameter dynamic,you don't need to restart the database

ORA-27206: requested file not found in media management catalog

PROBLEM:
----------------


RMAN-03002: failure of backup plus archivelog command at 06/05/2014 17:37:10

RMAN-03009: failure of backup command on ORA_SBT_TAPE_10 channel at 06/05/2014 15:33:00
ORA-19513: failed to identify sequential file
ORA-27206: requested file not found in media management catalog

Recovery Manager complete.


SOLUTION:
-----------------


Full backup and archive backup started same time

Start again the full backup,it will finish successfully :)

ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist SVR4 Error:2:No such file directory

PROBLEM:
----------------
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
SVR4 Error:2:No such file directory


SOLUTION:
------------------
There is two probability:

1)The database is down

2)The listener has been restarted in another home

ora-20000 oru-10027 buffer overflow

Problem:
------------

ora-20000 oru-10027 buffer overflow


Solution:
------------
There is two solutions:

1. If you are working in SQL*PLUS prompt, type the following where

SET SERVEROUTPUT ON SIZE n

where n is an integer between 2,000 and 1,000,000.

SQL> SET SERVEROUTPUT ON SIZE 10000


2. If you are working in PL/SQL block type

DBMS_OUTPUT.ENABLE(n)

where n is an integer between 2,000 and 1,000,000.

DBMS_OUTPUT.ENABLE(10000);