As you know, since 11g we have a Automatic Diagnostic Repository (ADR). To better manage it, we also have a Command-line Interface, called ADRCI.
ADR contains all diagnostic information for database (logs, traces, incidents, problems, etc).
More“ADRCI Retention Policy and Ad-Hoc Purge Script for all Bases”
Hi people,
We’re almost there to finish this Flashback Tutorial 🙂
To check the previous posts, please go through:
Flashback – Part 1 (Flashback Drop)
Flashback – Part 2 (Flashback Query)
Flashback – Part 3 (Flashback Versions Query)
Flashback – Part 4 (Flashback Transaction Query)
Flashback – Part 5 (Flashback Table)
Flashback – Part 7 (Flashback Data Archive)
Today’s post is gonna be about Flashback Database, a pretty good feature for non-production levels of your structure, I would say.
It’s very unlikely that you are going to rollback your entire production database to a point-in-time in the past, right? But if you need to, this facility is there.
Why do I say that it is great for non-production environments?
More“Flashback – Part 6 (Flashback Database)”
Hi all!
Do you know the difference between “tail -f” and “tail -F”?
Ok, don’t feel bad. It’s very difficult to find someone who knows… And with a reason, I can’t find any link explaining this by Googling.
It’s possible that I don’t know how to search it too. But I searched as I’d search if I didn’t know that… And couldn’t find anything about…
Let’s take a look on –help, so:
A few months ago, i had a problem in Persistence Store of JMS queues, soon after perform server restart, I get error from persistence store to recover message:
weblogic.store.PersistentStoreFatalException: [Store:280064]invalid handle 55981 (server="EVENTS01" store="JDBCStore_3022" table="JDBCStore_3022WLStore"),
To resolve this problem, just add this parameter on server startup arguments:
-Dweblogic.store.StoreBootOnError = true
With this parameter, the server starts with OK status in WebLogic 11g and with FAILED status in Weblogic 12c, but in both the processing of the messages continues when active,
to remove FAILED status in Weblogic 12c, just need to truncate persistence table in database and restart server (This solution can be found in Oracle Docs).
This solution did not solved my problem, because I can’t lost or delete messages.
Let’s go analyse the problem:
More“Avoiding lost messages in JDBC Persistent Store, when processing Global Transactions with JMS.”
Hi everyone!
Just passing by to remmember you about the GUOB Tech Day 2016, part of LA OTN Tour, next saturday!
See our first post about: GUOB Tech Day 2016 Coming soon!
If you haven’t make your confirmation, access here!
For more info about the event, access here!
More“GUOB Tech Day is Next Week!”
According Oracle guys, Apache 2.4 its is a vanila module to Weblogic 12c and same module runs with Weblogic 11g.
Modules are available to download: https://blogs.oracle.com/WebLogicServer/entry/announcing_web_socket_proxy_and
# httpd -version Server version: Apache/2.4.6 (Red Hat Enterprise Linux) Server built: Mar 21 2016 02:33:00
On httpd.conf is necessary to load Apache 2.4 module
LoadModule weblogic_module modules/lib/mod_wl_24.so
Hi all,
What if your arch processes hangs or get killed? How to keep archive going without restart database?
Take a look…
Hello guys,
Today I’m going to introduce the Coherence Server Out-of-Process configuration.
Once this configuration has changed a lot between versions 11G to 12C, the post will be a little bit more detailed (than usual).
The table below summarize these changes:
| From | To |
| osb-coherence-cache-config.xml | Coherence Cache Config resource |
| osb-coherence-override.xml | Coherence Cluster resoruce |
| Out-Of-Process Cache Server | New WLS node/cluster |
Follow the steps:
More“Configuration Coherence Server Out-of-Process in OSB 12C”
Hi everybody,
Today we are going to discuss about FLASHBACK TABLE. As usual, first, I am tagging here the previous posts about Flashback Technology, so feel free to check it out if you want:
Flashback – Part 1 (Flashback Drop)
Flashback – Part 2 (Flashback Query)
Flashback – Part 3 (Flashback Versions Query)
Flashback – Part 4 (Flashback Transaction Query)
Flashback – Part 6 (Flashback Database)
Flashback – Part 7 (Flashback Data Archive)
So let’s do it people.
On the last July 6th, happened at Pontifícia Universidade Católica – RS (PUCRS), the first Oracle users Group GUORS (Grupo de Usuários Oracle do Rio Grande do Sul) event of the year.
It is such a nice initiative from the hosts to gather a lot of Oracle Professionals from different areas to discuss about different subjects.
For this one we had the following schedule: