A question popped up, which I thought was interesting. How can you create a
DB_LINK in Oracle without the DBA changing the
tnsnames.ora file? It’s actually quite easy, especially if the DBA sets the TNS address name the same as the instance’s service name or in older databases SID value.
- Do the following with the
It should return this when the server’s
mohawk and domain name is
Time-out. Time for me.
A Guest Post By Dr. Patricia Dues, president of the OAUG
With such a jam-packed agenda full of quality sessions at Oracle OpenWorld, it’s hard to imagine having any down time to escape the confines of the convention center and the overload of information assailing your brain. But remember, you are in beautiful San Francisco, and it’s important to take a moment to rejuvenate. Here are three, quick time-outs to (more...)
Last week, the quarterly PSU came out, and just a few hours later I tried to apply it to a Oracle Restart + DB system under OL 6.7. This would have run smoothly if it wasn’t for the fact that this was the first patch for this system and therefore I needed to create a OCM […]
I'm pleased to announce that Oracle E-Business Suite 12.1 inbound,
outbound, and loopback connections are now certified with TLS 1.2, 1.1,
and 1.0. If you have not already migrated from SSL to TLS, you should begin planning the migration for your environment.
For more information on patching and configuration
requirements when migrating to TLS 1.2 from TLS 1.0 or SSL or enabling TLS for the first time, (more...)
a few years cloud computing has become more and more popular. The main
types of cloud computing are Infrastructure as a Service (IaaS),
Platform as a Service (PaaS) and Software as a Service (SaaS). In the
past, several subareas have been established in the market and pushed by
research companies. One subarea is Integration PaaS (IPaaS) and a
variety of vendors have provided solutions. One advantage of IPaaS
solutions is the simplified integration. Furthermore, (more...)
This note models one feature of a problem that came from a client site recently from a system running 18.104.22.168 – a possible bug in the way the optimizer handles a multi-column in-list that can lead to extremely bad cardinality estimates.
The original query was a simple three table join which produced a bad plan with extremely bad cardinality estimates; there was, however, a type-mismatch in one of the predicates (of the (more...)
Attend our July edition of the SOA & BPM Partner Community Webcast live on July 26th 2016 at 16:00 CET.
What’s new in Oracle BPM and Process Cloud Service? Digital Process Apps made Simple
this session, we will be joined by Sujan Balachandran, Product Manager
for Oracle BPM and Process Cloud Service (PCS). The session will cover
· Empower Business User using BPM Composer
· What is Business Architecture? How can it help (more...)
Oracle E-Business Suite Release 12.1.3 and 12.2.4 or higher are now certified with Apple Mac OS X with the following desktop configurations:
- Mac OS X 10.11 ("El Capitan" version 10.11.5 or later 10.11 updates)
- Mac OS X 10.10 ("Yosemite" version 10.10.2 or later 10.10 updates)
- Safari version 9 (9.1.1 or later 9.x updates)
- Oracle JRE 8 plugin (1.8.0_91 (more...)
Integration Cloud Service (ICS) is another powerful yet simple Cloud
platform offering by Oracle that simplifies the development of cloud and
hybrid integrations (applications in the cloud and on premises).
entire integration development and operational lifecycle is managed
through a web based service console offering a point and click
integration and monitoring experience without having to write a single
line of code.
Furthermore Oracle ICS supports various industry
standards like SOAP and REST (more...)
This is essentially a revamp of a previous post on API Manager,
albeit for the SOA CS environment.
You can read the original post here
I created an API Manager instance on SOA CS -
Let's look at the Fusion Middleware Control -
Here we can create API Manager users.
I have covered this is a previous API Manager post, but to save you time,
here are the screenshots - Read the complete article here.
Controlling Connections Established by Database Links
Tracing can be done using – ALTER SYSTEM SET EVENTS ‘2049 trace name ERRORSTACK level 3’;
Nice note from MOS.
How to Obtain a System State Trace BEFORE the Error ORA-2049 Occurs, While Still Experiencing the Contention (Doc ID 789517.1)
Commit after select from dblink – blocking lock.
04:45:30 ARROW:(DEMO@leo):PRIMARY> select name from v$pdbs@mdinh_april;
04:45:36 ARROW:(DEMO@leo):PRIMARY> commit;
businesses adopting more and more cloud applications, mobile apps, and
devices, integration has never been more important. Integrating these
apps and tools with the rest of the systems is the key to a connected
enterprise— one that supports real-time responsiveness, instant
collaboration, and streamlined innovation. To keep up with these new
integration demands, a new breed of solution has emerged—cloud-based
integration platforms (also called integration platform as a service, or
iPaaS for short). For (more...)
This blogpost is about using the linux ftrace kernel facility. If you are familiar with ftrace and specifically the function_graph tracer, you might already be aware of this functionality. This is Linux specific, and this facility is at least available in kernel 2.6.39 (Oracle’s UEK2 kernel).
What is a ‘kernel dive’? Whenever a process is running, it should mostly be in ‘user mode’, executing the program it is supposed to run. However, during (more...)
You know a major new release is going to be rapidly followed by a bunch of fixes, so about 9 days after the release of VirtualBox 5.1 we now have VirtualBox 5.1.2.
I have got it running on my Windows 7 desktop and work and it seems fine. I’ll try OSX El Crapitan and Oracle Linux 6 hosts when I get home.
was first posted on July (more...)
Innovate Quickly and Confidently with Public Platform as a Service
See how Platform as a Service solutions can help you:
- Accelerate business innovation
- Improve business agility and insight
- Reduce IT cost and complexity
- Increase productivity and collaboration
Get the free eBook here.
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 (more...)
Truthfully, I am feeling a little lazy to write a nice blog.
Configuring listener.ora and tnsnames.ora, varying names for database, connecting to database.
db_name string tmnt
db_unique_name string tmnt_a
instance_name string tmnt01
ADR Home /u01/app/oracle/diag/rdbms/tmnt_a/tmnt
Service "april" has 1 instance(s).
Instance "tmnt01", status READY, has 1 handler(s) for this service...
Service "tmnt" has 1 instance(s).
Instance "tmnt", status UNKNOWN, has 1 handler(s) for this service...
Service "tmnt_a" has 1 instance(s).
· Larry Ellison Announces Oracle Private Cloud Machine for PaaS and IaaS
New cloud platform allows enterprises to combine the cloud benefits of
agility, simplicity, and low cost with the control and security of their
own data centers
· Oracle Cloud Day: Transforming Your Tomorrow
Join us for Oracle Cloud Day to explore a range of industry-leading
cloud solutions suited to the specific needs of your job role. Discover
why Oracle is considered the cloud (more...)
I’ve been using standby databases, on and off, since Oracle 8i. I first wrote about Data Guard for Oracle 9i. I’ve had an article on 11gR2 Data Guard for ages, but up until recently I’ve always used the manual setup.
We’ve got a project coming up that *may* use Data Guard and *may* be installed by a 3rd party, so I figured I better get up to speed with the Data Guard Broker, in case they (more...)