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.

ORA-01595: error freeing extent (3) of rollback segment

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

SMON: following errors trapped and ignored:
ORA-01595: error freeing extent (3) of rollback segment (198))
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [12], [2], [], [], [], [


Solution:
-----------
Adding more undo space should solve the problem.


Following link explain add undo tablespace:
-------------------------------------------

http://dbafix.blogspot.com.tr/2010/08/how-to-drop-and-recreate-undo.html

ORA-21561: OID generation failed

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

ORA-21561: OID generation failed


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


Check that there is client machine fully qualified name and short name in the client machine hosts file. If these are missing you’ll get ORA-21561 errors when trying to connect server.

old           /etc/hosts   file
-------------------------
127.0.0.1            localhost.localdomain      localhost

new           /etc/hosts   file
-------------------------

127.0.0.1            localhost.localdomain      localhost
10.160.116.10   dbachannel.oracle.com     dbachannel-----this line added

sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

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


./sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory



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


vi .bash_profile

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

save and quit.

Then relogin

Problem will solve.