Original Post can be viewed at Limiting I/O and CPU resources using 11g Oracle Resource Manager
Recently I was working on using Oracle DBMS_RESOURCE_MANAGER to limit resources usage by read-only queries. This was required to prevent long running ad-hoc and poorly written queries.Instead of writing custom sql /script to kill long running session, we decided to utilize Oracle Database Resource Manager. We decided using elapsed_time as criteria for cancelling sql.But during [...]
Gone are the day when cleartext passwords had to be stored in scripts for Oracle database access. The solution to this requirement is “Oracle Secure External Password Store (SEPS)”. This article will give a short introduction and a practical example of the solution.
no Advanced Security Option (License) necessary
every unix-account, who has access to the wallet can use it to log on to the contained databases without a password! Therefore prevent other unix-accounts from accessing your wallet! (chmod, chown)
: Unix-Account, who wishes to connect to the database without providing a password needs to (more...)
In case you have not heard all the buzz about the Oracle SCN flaw, which was published by Infoworld after the release of January CPU, I summarize the essentials.
- There is a risk that the SCN reaches it´s maximum value and this could lead to an outage of the database.
- There is a bug in “ALTER DATABASE BEGIN BACKUP”, which increases the SCN dramatically. (Bug 12371955 – fixed in 18.104.22.168.4 and others)
- When you query a remote database via database link from a database with elevated SCN, the remote SCN gets increased to the higher value (more...)
When you have multiple Oracle APEX environments, e.g., development, test, UAT and production, and for multiple groups, one of the confusing things is that sometimes developers are lost on which environment they’re working on. Most of technically proficient developers can make a distinction easily from the URLs they’re currently using. However, most of less technically proficient (e.g., business users) sometimes cannot.
A quick and simple solution here is to make a visual distinction on the APEX workspace pages especially on the logo area. Instead of using plain vanilla logo images, they are replaced with more distinct (more...)
The journey for the Fusion CRM development team has been a long one. What a great feeling for all of us when Fusion Applications was officially released this year as Generally Available. During his keynote speech at this year's Oracle OpenWorld
Steve Miranda reiterates that statement. Also during his session (more...)
Oracle Real Application Cluster (RAC) becomes the technology of choice for highly available and highly scalable deployment of enterprise Oracle database environment. With its innovative technology it comes with no surprise its complexity. The complexity is not only with the underlying database technology itself, but also how well you design and implement it to work with other components including operating system, storage subsystem, etc. In order to setup and maintain a successful RAC environment, it not only requires technical knowledge of database administrator (DBA), but also well collaboration and extended planning between all IT and business partners.
Few years (more...)
Something I discovered recently is that the DEFAULT profile for Oracle 11g sets the PASSWORD_LIFE_TIME to 180 instead of UNLIMTED by default. Applications will encounter an "ORA-28002: the password will expire within X days" error message if you keep the default value.
To change the PASSWORD_LIFE_TIME, you:
ALTER PROFILE default LIMIT password_life_time UNLIMITED;
One thing to keep in mind is
We had a fair number of problems related to bind variable peeking in our 10.2.0.3 and 10.2.0.4 dbs. In fact, the plans became so erratic that we decided to just turn bind variable peeking off by setting _optim_peek_user_binds=false in all the init.ora files.
Flash forward to Oracle 11g (22.214.171.124) and the optimizer has been enhanced to use bind variable peeking much better. After converting to
I've run into my first issue with 126.96.36.199. After one of my dbs was upgraded, every time I try to purge the recyclebin, I get an ORA-00600 error:
SQL> purge dba_recyclebin;
ERROR at line 1:
ORA-00600: internal error code, arguments: [ktcdso-1], , , , , , , , , , , 
It doesn't matter if the recyclebin is on or off.
I have done about six upgrades and
By default, the listener logging is not turned on in 11r2. You have to turn it on by specifying:
in your listener.ora file.
If you're just beginning to implement Oracle 11g, you need to be aware of the Automatic Diagnostic Repository (ADR). It has nothing to do with AWR, ADDM, ASM, ASSM, or any of the other acronyms Oracle has come up with over the last two releases.
In terms of the database, ADR could be a great thing. It's integration with Enterprise Manager is probably one of the best parts about the feature.
I've been off exploring Oracle 11g for a little bit trying to figure out a strategy to upgrade my environment. Oracle 11g has a ton of new features, most of which are now "options" (in other words they cost more money).
When Oracle came out with compression at the segment level in 9i, I thought it was a great feature, at least in theory. But as I got to use compression, I found out that DDL
When getting two or more systems working together, the making a connection part is generally the easiest, identity propagation is a bit trickier, but many times, the syntax and semantics of one system is at odds with another one. Over the decades this has been manifest in many ways and (more...)
In this posting I will describe how you can integrate Oracle B2B 11g
and Oracle Service Bus 10gR3
to send messages to Oracle B2B 11g from an OSB 10gR3 service.
The most easy way to integrate Oracle B2B 11g and OSB 10gR3 is by using JMS. Oracle B2B 11g supports JMS as protocol for its internal inbound and outbound delivery channels out-of-the-box.To enable JMS set the Use JMS Queue as default
property to true (more...)
In Oracle Fusion Middleware B2B 11g
enhanced procedures are introduced to archive and/or purge the B2B 11g run-time data.
The procedures that take care of archiving/purging live in the SOAINFRA database schema of your FMW 11g database repository:
procedure does the actual archiving and is invoked from the B2B_ARCHIVE_PROCEDURE
procedure. The B2B_EXPORT_JOB
procedure uses a data pump
to archive the run-time data to a file on the file system.
To make (more...)
Currently, the BPEL transport in OSB is not supporting FMW 11g. However, I just found a way, although it still is proven in theory based on my knowledge, to enable transaction propagation between OSB and FMW 11g SCA composites. The basic idea is that you have to communicate between OSB and FMW 11g SCA composites using the SDO - EJB binding
in 11g. The t3 protocol used as the communication protocol between the ejb client (more...)
In Oracle FMW B2B 11g
the Java callout functionality makes it possible to add Java hooks to an inbound or oubound message flow. Callouts van be written and configured per agreement or per delivery channel (transport callouts). More info about managing callouts can be found here
In this blog posting, I will show how you how an agreement callout can be used to collect HTTP headers from an inbound message, which is received by the (more...)
In this blog-posting, I share some first tips on Oracle FMW 11g (188.8.131.52/PS1) cluster-wide deployment and cluster configuration based on my first experiences with setting up such an environment.
Most tips come from these two documents:
- Enterprise Deployment Guide for Oracle SOA Suite
- Oracle FMW 11g High-Availability GuideCluster-wide deployment tips
On Oracle Metalink
there is now a Note available that describes the usage of the FMW 11g purge scripts. Note 815896.1
contains all the details.
An OPatch patch 8328187 is available for download that contains all the scripts that are required to create the purging functionality in the SOA_INFRA schema
Inspired by this
great blog posting about how to use the FMW Ant tasks to deploy a SOA composite, I started to use that example to set up my own Ant project for B2B management purposes.
In this blog-posting, I will give an example project that is capable of importing and exporting CPAs to and from Oracle FMW 11g B2B.Setup the build project
In JDeveloper, create an empty project and name it fmw-build