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

WARNING OGG-01931 Oracle GoldenGate Manager for Oracle, mgr.prm: Datastore 'dirbdb' cannot be opened. Error 2 (No such file or directory)

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

WARNING OGG-01931  Oracle GoldenGate Manager for Oracle, mgr.prm:  Datastore 'dirbdb' cannot be opened. Error 2 (No such file or directory)

Solution:
-----------

This is bug,Workaround is below.



#########################################################
WORK AROUND
-----------
cd $OGG_HOME

rm -rf dirbdp

ggsci>stop mgr

ggsci>create datastore

ggsci> start mgr
#########################################################






Reference:
--------------
How To Fix OGG-01934 Datastore repair failed, OGG-01931Datastore 'dirbdb' cannot be opened. Error 2 (No such file or directory) Errors when OGG Is Installed On Shared Disk? (Doc ID 1670885.1)

TNS:listener could not find available handler with matching protocol stack

Problem:
-----------
TNS:listener could not find available handler with matching protocol stack


Solution:
-----------
Your current process is max procecess.

You have to kill some session.

After you kill,sessions continue coming.If this case happen,

You can kill LOCAL=NO via awk.

After this issue completed.

bash$>ps -ef | grep LOCAL=NO | awk '{print "kill -9 " $2}' > kill.ksh

bash$>ksh kill.ksh

When you are available,you have to increase max processes parameter

SQL>alter system set processes=3000 scope=spfile;

Then you have to restart the database.Because this parameter is static.

Note:In my case processes parameter is 1500,so I should set bigger than 1500.

Pry and try :)

Probe job had unrecoverable failure(s), this job is being abandoned.

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

Probe job had unrecoverable failure(s), this job is being abandoned.

Solution:
-----------

Sometimes if backup cartridge is busy this error will generate

In fact backup hasn't been started yet:)

Try again,it gets successfully:)

ORA-19706: invalid SCN

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

select 1 from dual@NECODB;

ORA-19706: invalid SCN dblink

Solution:
-----------
alter system set "_external_scn_rejection_threshold_hours" = 24 scope=spfile;

Then restart the database.