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);