Tag Archive | "oracle architecture"

MySQL and SQL Server - Oracle CONNECT BY PRIOR for Recursive, Hierarchical Data

Recursive queries are something I have used many, many times over the years to build dynamic, n-tiered hierarchies. Oracle’s CONNECT BY PRIOR is awesome.

Does anyone know if this is possible in SQL Server or MySQL?

From what I understand, stored procedures would need to be used in MySQL and SQL Server to accomplish what Oracle does in one SQL statement with CONNECT BY PRIOR. I need to dig into the other databases a bit further to verify, but I am interested in any elegant solutions people have come up with if you would like to share.

SSL with Oracle Application Server WebCache and iPhone

The latest iPhone update appears to have broken some SSL-enabled OracleAS sites. We have been working through finding a solution for an Oracle Portal customer of ours and it has been fairly hairy. On at least one of the environments, we have found a solution. We can likely help if you have been having an issue with your SSL handshakes.

SQL to Query Oracle, Return XML - with SQLX

Like many days, I had a need to query data stored in Oracle. But today was different. I needed to return the data in an XML format. I started with a very simple need and generated the XML brute-force while traversing my cursor. However, I realized the data would not be escaped properly and knew/assumed Oracle has created built-in functionality to accomplish what I was trying to do.

I then recreated my logic using DBMS_XMLGEN. This worked well, in that it created the desired result set, but I hate the idea of storing SQL in a string to be passed into a function, which is precisely what DBMS_XMLGEN was having me do. I had a hard time figuring out the precise technique recommended by Oracle, or even the “latest” technique. My client’s environment was 9i, so I knew I wasn’t going to get to play with anything interesting 11g might have to offer.

My brief research showed that SQL/XML (SQLX) appeared to be the best option. A few hours later, it really has been nice. I have been able to create both simple and complex XML results. Once you have the syntax down, you can generate just about any XML structure you desire.

Let me know if you come across anything more interesting/useful than SQLX for querying Oracle RDBMS tables (not XML data stored natively in the DB), and I’ll be interested in checking it out.

OID Install in Oracle Enterprise Linux (OEL) 5 - Shared Libraries Error

When installing 10g OID on OEL5, if you run into the following error, you can run the below commands to address the issue:

Error:

OPMN HTTP process fails to start.  When you look in the log file, it says:
/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file:  No such file or directory





To fix, run the following commands:

# ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2
# chmod 755 /usr/lib/libgdbm.so.2.0.0
# chmod 755 /usr/lib/libdb.so.2

Complete Fusion Middleware 11g environment setup

We have recently been working on and completed an entire Oracle Fusion Middleware 11g environment setup for a customer:

  • Identity Management
  • WebCenter (Framework and Services)
  • SOA Suite
  • UCM

This article is part of the recent work short blurb series.

Deciding where to use BPEL vs ESB

I just had a discussion with an M&S SOA Architect about the advantages and disadvantages of BPEL vs ESB, and more importantly, where to use which in practical business scenarios.

This article is part of the recent work short blurb series.

OBIEE for the iPhone

We recently had a customer request help with configuring OBIEE for use on both PCs and mobile devices (specifically, the iPhone). Of course, this is possible, but Oracle does not have a clearly documented approach. You might think that a separate server is required to accomplish this. However, the fact is that you can actually use a single server to deliver OBIEE reports for both PCs and the iPhone.

This article is part of the recent work short blurb series.

Oracle IdM - SAML SSO with Google Apps

We recently integrated Oracle IdM with the SAML SSO Service from Google Apps. Now customers can continue to authenticate against OID even while accessing Google Apps assets!

Oracle Application Server Startup and Shutdown Script Generator - FREE

Complete the below to receive scripts to automatically startup and shutdown your Oracle Application Server 10.1.2.x or 10.1.3.x midtier environment.

We have implemented and maintain many Oracle Application Server environments, so we are simply sharing some of the knowledge.

Read Oracle Application Server Startup and Shutdown Script Generator - FREE...

Move Oracle Linux VM to New Machine - Static IP

I just copied an Oracle Enterprise Linux VM from one Windows machine to another and the IP address for the guest Linux machine changed. I had a feeling that this might happen, but wasn’t quite sure why it did nor how to get it back to the old IP address. As we all know, an IP address changing in an Oracle environment is best avoided.

Read Move Oracle Linux VM to New Machine - Static IP...


Archives

Recent Comments

  • ashok.aggarwal said: Thank you for your comment, Stuart. I’m glad this helped you.
  • Stuart said: I’d really like to thank you for your post. It was really that simple.
  • ashok.aggarwal said: Your specific question is not very clear, however, in the context of implementing a LIKE...
  • Jonas said: Finally in print that a user is required to show the email option. Thanks.
  • syut.sa said: Thank you.

Calendar

March 2010
M T W T F S S
« Feb    
1234567
891011121314
15161718192021
22232425262728
293031  

Featured Testimonial

"M&S has taken 'partnership' to a new level. They are not only a deeply skilled service provider, the M&S team is actually a mission critical component to our operations, taking on new initiatives as well as maintaining custom, open source, and COTS solutions."

CEO, MedPivot

Free SQL Service