I was looking at the RMAN DEBUG options and came across the CHECKSYNTAX function which I had not used before.
Firstly a quick recap on the DEBUG option.
This can be called using the following syntax
rman target / catalog rman12g1/xxxx@rmancat debug trace=rmantrace.log cmdfile=backup.rcv
rman target / catalog rman12g1/xxxx@rmancat debug trace=rmantrace.log then run RMAN> @backup.rcv (or just type in your run block of commands)
There are a number of options (more...)
When creating a Database Cloud Service, you have an option to select “cloud storage” as a backup destination. In this case, the database backups will be stored in “storage containers”. As I see, lots of Oracle Cloud users have problem with setting up storage containers as backup destination.
It’s possible to create a storage container before you create the database service or you can create it while provisioning the DB service. Whichever method you chose, (more...)
December 2016 top tweets by soaCommunity
Send your tweets @soacommunity #soaCommunity and follow us at http://twitter.com/soacommunity. Make sure you share your content with the community!
SOA & BPM Partner Community
regular information on Oracle SOA Suite become a member in the SOA
& BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.
Sometimes in test conditions in rules, there may be a need
to test for sums or averages of a collection of values, and these kinds
of aggregated values may not be directly available as input facts. For
example, in an expense report, you may want to test if the total
expenses are above a certain value and then take some action. This is
easy if the total value is available directly in the expense report
While visiting a customer, we had a conversation about the correct way to stop users from writing to code tables. The customer described his ancient logic: when he wanted to move table to a read only state, he removed the write (insert/update/delete) permissions from all of his users. That was good enough for him for years – since he started using this method way back in Oracle 8. All was well, util this week he (more...)
In case you missed this webinar, here’s a 1.5h holiday video about how Gluent “turbocharges” your databases with the power of Hadoop – all this without rewriting your applications :-)
Also, you can already sign up for the next webinar here:
- GNW06 – Modernizing Enterprise Data Architecture with Gluent, Cloud and Hadoop
- January 17 @ 12:00pm-1:00pm CST
- Register here.
See you soon!
NB! If you want to move to the "New World" - offload (more...)
Today I came across an exception while trying to load one of my task details (v12.2.1).
Error: OracleJSP error: oracle.jsp.parse.JavaCodeException: Line # 14, oracle.jsp.parse.JspParseTagScriptlet@66e50889
Error: Java code in jsp source files is not allowed in ojsp.next mode
What was really strange to me was that I did not do anything different from what I used to do with previous versions.
After some research I found out (more...)
Recently in a discussion with colleague, on what entries do MLOG$ have, the following was agreed to :-
1. “I” for insert
2. “D” for delete
3. “D” + “I” for update.
Along with the above entries, you might notice “U” also. The “U” entry is for update. But then, on what condition do we get “U” and when do we get “D” and “I” entries.
I have used “EMP” table as master table in (more...)
I’ve been playing around with some more of the new JSON features in Oracle Database 12c Release 2 (12.2).
The first thing I tried was the new PL/SQL support for the JSON functions and conditions that were introduced for SQL in 12.1. That was all pretty obvious.
Next I moved on to the new PL/SQL objects for JSON. These are essentially a replacement for APEX_JSON as far as generation and parsing of JSON data (more...)
often than not, you will want your processes to interact with other
services or processes inside or outside your enterprise. Since
integration options are rather typical in Oracle Process Cloud Service,
this article will help you to apply best practices for creating and
managing your connections in a sustainable fashion.
Process Cloud integration points
say you have modelled a process in Oracle Process Cloud Service (PCS)
for a private home loan application. Chances (more...)
The Oracle TRUNCATE TABLE statement is a useful statement for removing data in Oracle SQL. I’ll explain what the statement does and show you some examples in this article. What Does the Oracle TRUNCATE TABLE Statement Do? The Oracle TRUNCATE statement, or TRUNCATE TABLE statement, removes all data from a table. It’s similar to the […]
When we add a new datafile to the primary environment of a dataguard setup, we need to add the datafile to the standby environment as well if we want the manged recover to continue working. We can do that manually if we want – but fortunately for us Oracle comes with a built in feature for automatically creating the file in the standby as well. All we need to do to set it up is (more...)
Enabling flashback on 220.127.116.11 database can take minutes and cause multiple database wait events degrading database performance.
On a quite busy system, during the low peak hours, I tried to enable flashback on 18.104.22.168.6 version database and multiple sessions waited on
1. buffer exterminate
2. enq: SQ – contention
3. latch: cbc contention
4. SGA: allocation forcing component growth
PRAKANAN_DBA@:1> show parameter sga_target
NAME TYPE VALUE
------------------------------ ----------- (more...)
can you create custom XPath functions in Oracle Service Bus 12c? And
how can you use these in both XSLT and XQuery? Let’s find it out. I
like to show you how they’re different in behaviour.
of my post comes from one of my projects, where we were migrating quite
some (stateless) services from the SOA (BPEL) platform to Service Bus.
Since our clients were already ‘virtualized’ to our clients (i.e.
APEX 5.1 was released for download a few days ago. I tried doing an upgrade against an installation on a VM at home and it worked fine, which was hardly surprising.
Officially I’m on holiday, but I figured I would upgrade all our Dev/Test installations while everything is quiet. Major version upgrades, changes in either of the first two numbers, require a full installation. There was no major difference between this and what I (more...)
the last weeks I had the privilege to test some of our upcoming PaaS
middleware solutions by myself. One of the results a full integration
scenario developed by drag and drop - you can see above. It is amazing
how fast, easy, nice and rich integrations, can be built by a citizen
developer like myself. Hope to see you all at the PaaS Partner Community Forum 2017! #jkwc
SOA & BPM Partner (more...)
On a particular Oracle 2 node cluster (12.1) we faced random instances failing. Servicerequests at Oracle were open with limited result, as it was quite random and we could not link it to any trigger.
As it looked somehow like a communication problem between the 2 nodes, network team has checked the switches involved - without any outcome.
Even crashing instances were a problem already, it get worse one day when one node rebooted (more...)
In this article, I’ll explain what the Oracle MEDIAN function is, and show you some examples. Purpose of the Oracle MEDIAN Function The MEDIAN function returns the median of the set of provided values. The MEDIAN is the middle value in a set of values. So, for example, you had these five values: 10, 15, […]
When inserting data into the database, it is occasionally forgotten (especially by English-speakers) that we need to take steps to ensure we are inserting data correctly and without unexpected character translation.
For example, in SQL*Plus we need to ensure we set the NLS_LANG environment variable to the correct setting for our database before we initiate SQL*Plus.
Here’s a quick example showing what can go wrong:
[oracle@ORA122 ~]$ echo $NLS_LANG
[oracle@ORA122 ~]$ sqlplus neil/neil
SQL*Plus: Release (more...)