Select Page

Blog

Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.

Category: All
Browse All Categories

Why should I properly close my Oracle E-Business Suite session?

We’ve all been there before.  It’s noon, and you’re co-worker is telling you to tidy up – it’s time to go to lunch.  Your E-Business Suite session is idle, and in your haste you simply click the ‘X’ at the top of your browser.  You know it’s not the proper thing to do, but you’re […]

R Harwood | March 10, 2009

ORA-12154: TNS:could not resolve the connect identifier specified

Most people will encounter this error when their application tries to connect to an Oracle database service, but it can also be raised by one database instance trying to connect to another database service via a database link.

Jeremiah Wilton | March 4, 2009

Proactive support

We all know proactive service when we see it. A couple of examples: Proactive is when you are shopping for a new gadget, but just before you buy it the clerk tells you a special battery is required (even though the box fails to mention it) but is not included. “Would you like one of those as well?”

Chuck Edwards | February 20, 2009

Art of BI: OBIEE on the iPhone! So, What?

I have to confess, that yes, I gave into the all appealing glow of the Apple iTunes, iStore, iPod, all things “i” machine and purchased an iPhone about 6-months ago. Fortunately for me, its a 3G and I love it.  It was a great price at $199 and has all of the functionality that my […]

Christian Screen | February 12, 2009

When is remote DBA the right solution?

A remote DBA service can provide access to experts in performance tuning, backup and recovery, replication, or a host of other database focus areas for a fraction of the cost of a full-time resource, but not everyone sees the value.  That’s OK.  This post will hopefully illuminate a few common problems that may be solved […]

Chuck Edwards | February 10, 2009

ORA-04031 and ASMM

Oracle E-Business Suite customer was reporting ORA-04031 errors being returned by the database. There were a number of ORA-04031 shared pool errors generated in the alert by background processes: ORA-04031: unable to allocate 168 bytes of shared memory (“shared pool”,”select t.ts#,t.file#,t.block…”,”Heap0: KGL”,”kglob”) I checked the shared pool and saw that the majority of it was used by KGH: NO ACCESS, which according to oracle Metalink note 451960.1 is.

Steven Kolev | January 28, 2009

Monitor the X display for E-Business Suite

Those running Oracle’s E-Business Suite on Linux/UNIX environments are probably familiar with a dependency on some X display technology to render graphics.  One could use a VNC Server or Xvfb, for example, to fill this need.  XML Publisher and OPP depend on an X display to create rich reports/documents with images & graphics such as […]

R Harwood | January 28, 2009

Using Checksums to Ensure Table Consistency in MySQL

If you’re using MySQL replication, chances are your master and slave databases aren’t entirely consistent. There are a number of reasons for this. Some MySQL functions like UUID() don’t replicate properly with statement based replication. Poor network connectivity can sometimes result in corrupted relay logs. Misconfigured software can accidently write to the slave database.

Mike Hamrick | January 26, 2009

Phase in the Sun JRE plug-in

By now you probably know error correction support ends for JInitiator for E-Business Suite on July 31, 2009 (see Metalink note 552692.1). There has been a lot of strong encouragement from Oracle to migrate to the Sun JRE Native plug-in prior to the de-support date: Note 393931.1: Deploying Sun JRE (Native Plug-in) for Windows Clients […]

Chuck Edwards | January 24, 2009

Request for simpler E-Business Suite diagnostics

A few weeks ago Steven Chan posted an open question on his blog asking how support for the E-Business Suite techstack could be improved.  Specifically, he wanted to know how interaction with Oracle Support could improve.  I sent a suggestion, but it didn’t make the cut; he didn’t post it.  🙁 Since I spent a bit of […]

Chuck Edwards | January 19, 2009

Proactive Maintenance for Oracle E-Business Suite

As a remote services provider, often we are often asked to provide proactive maintenance support for clients. For the purposes of this discussion, I’m going to separate operational support form maintenance support.

Chuck Edwards | December 8, 2008

Exploring Oracle 11g Tablespace Encryption

Tablespace encryption encrypts data at the datafile level to keep people from being able to peek at the oracle datafiles directly. Oracle 10 allowed us to encrypt certain columns, and starting in Oracle 11, tablespace encryption is made available. First we’ll need to setup oracle wallet.

Mark Hammingh | December 2, 2008
1 2 95 96

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS