Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.
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.
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?”
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 […]
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 […]
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.
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 […]
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.
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 […]
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 […]
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.