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