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)
22 Haziran 2014 Pazar
WARNING OGG-01931 Oracle GoldenGate Manager for Oracle, mgr.prm: Datastore 'dirbdb' cannot be opened. Error 2 (No such file or directory)
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 :)
-----------
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 :)
20 Haziran 2014 Cuma
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:)
Kaydol:
Kayıtlar (Atom)