DB_LINK w/o tnsnames.ora

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.

  1. Do the following with the tnsping utility:
    tnsping mohawk

    It should return this when the server’s hostname is mohawk and domain name is techtinker. (more...)

Why Choose Oracle University for IT Training & Certification?

Career Growth: our training courses are designed to teach you skills that directly align with real-life IT jobs; empower yourself with in demand skills in a competitive job market.

Salary Advancement: Certification magazine found that Oracle Certified Professionals earn higher salaries when compared to other DBA or Developer professionals. Earning this well-respected IT credential could make a positive impact on your wallet.

Expert Instruction: learn Oracle from the same team involved in Oracle product development. (more...)

Mix a Little Pleasure with Business at Oracle OpenWorld

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...)

OPatch 12c: emocmrsp gone missing

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 […]

TLS 1.2 Certified with E-Business Suite 12.1

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...)

Integration with new Oracle Integration Cloud Service (ICS) by ec4u

clip_image002Since 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...)

Lost Concatenation

This note models one feature of a problem that came from a client site recently from a system running 12.1.0.2 – 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...)

What’s new in Oracle BPM and Process Cloud Service? SOA & BPM Partner Community Webcast – tormorrow July 26th 2016

image


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

During 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...)

EBS Release 12.x certified with Safari 9 on Apple OS X

Apple logoOracle 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...)

ICS Integration Patterns (Part 1 of 3): Map My Data by Antonis Antoniou

clip_image001

Oracle 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).
The 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...)

SOA CS –> API Manager Flavour by Niall Commiskey

clip_image002This 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.

(more...)

Dot Qualify Everything?

Troubleshooting ORA-02049: timeout: distributed transaction waiting for lock

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.

Session 1:
++++++++++
04:44:51 ARROW:(DEMO@leo):PRIMARY>
04:45:30 ARROW:(DEMO@leo):PRIMARY> select name from v$pdbs@mdinh_april;

NAME
------------------------------
APRIL

Elapsed: 00:00:00.01
04:45:36 ARROW:(DEMO@leo):PRIMARY> commit;

Commit  (more...)

https://paascommunity.com/2016/07/23/five-ways-cloud-based-integration-is-driving-innovation-whitepaper/

clip_image001With 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...)

Investigating kernel dives using ftrace.

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...)

VirtualBox 5.1.2

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.

Cheers

Tim…


VirtualBox 5.1.2 was first posted on July (more...)

Public PaaS free eBook

clip_image002

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

For 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...)

Different names for 12c CDB

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.

Summary:

db_name                              string      tmnt
db_unique_name                       string      tmnt_a
instance_name                        string      tmnt01

ADR Home /u01/app/oracle/diag/rdbms/tmnt_a/tmnt

Services Summary...
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).
   (more...)

Additional new content SOA & BPM Partner Community

clip_image001

· 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...)

Data Guard Broker : 11g and 12c

vault-154023_640I’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...)