Category: DBA Oracle
Much has been written on how to trace database sessions through a java application in all sort of different techniques. Since Oracle 10g a new technique is added to …
AMIS is proud to announce our next AMIS Query (free technical seminar), targeted at Oracle Database Architects and Database Administrators How the Middle Tier is Slowing Down Your Database …
After configuring the Oracle EBS 11.5.10 environment in OEM10G, it was time to also configure the new Oracle EBS R12 environment in OEM10G. Before I could configure R12 in …
I know, it’s a little bit of an aggressive statement, but if you think about it, it gets to you… Regarding performance and “best practices”. Let’s do this, a …
As soon as EBS Release 12 became available, I started with the installation, eager to find out what the differences were compared to 11i. I had had the opportunity …
I got up at 5 o’clock (CET) in the morning on Saturday and made my way to Schiphol airport, so Gerwin and I could take our plane to Dallas, …
I will be attending HOTSOS 2007 next week; and to be honest, I am not really into it yet. Despite, I guess and hope the great presentations, keynotes and …
During OPP 2007, two presentations by Ken Atkins where given regarding XML(DB) items, featues and best practices. My collegae Alex Nuijten was also attending, and presenting, and hinted me …
This morning I downloaded my first patch for the new Oracle EBS R12. Already there are 2 high priority patches for the new EBS, and I downloaded one of …
Assume you have a table with contaminated data (in this example: non-unique values on col1 and col2), for instance because no unique key was implemented. col1 col2 value 2 …
I wanted to find out how ‘big’ the new Oracle EBS 12i release really is. So, I downloaded the software from Edelivery and created a stage area. From the …
FNDCPASS is an EBS tool to change passwords of database schema’s within the Oracle EBS. For example, you can change the APPS password using FNDCPASS, but also any other …
I have upgraded my EBS 11.5.10 database (9.2.6.0) to release 10gR2 (10.2.0.2.0). I have followed note 362203.1 from Metalink to perform the upgrade. Here are some tips or problems I …
Thursday 14 december 2006, we had here at AMIS a Query called "High Availability: RAC vs. Data Guard" the Query was lead by Oak Table Network members Carel Jan …
From time to time, people on the OTN XMLDB forum, ask if it is possible to connect via the Oracle Protocol Server (aka the Oracle Listener), for instance in …
I have written this article over and over again, looking for a way to keep the depth of technical information leveled for the intended audience. I found it almost …
A couple of weeks ago I was at a MasterClass from Jonathan Lewis about the Cost Based Optimizer. It was a very interesting two days and I like to …
As you can see in the announcement on the top of this page – tomorrow we will host the most exciting DBA event of the year: the AMIS Query …
A short time ago I was asked to checkout the performance of an 4 node 64 bit linux RAC cluster on 9.2.0.7 RDBMS. After a short investigation I found …
Recently, Oracle announced and released it’s Enterprise linux. Time to check out what’s it all about! While downloading the software from OTN, I was surprised to see there were …
AMIS is proud to announce our next AMIS Query (free technical seminar), targeted at Oracle Database architects en DBAs: Oracle Database High Availability – RAC and Data Guard go …
In one of the previous blog-articles a colleague of mine described how to start an OC4J-container on the command line. Which was and is correct, but… I’m a database …
Most of the Keynotes and Presentations of Oracle Open World 2006 can be found here: http://www28.cplan.com/cc139/catalog.jsp As it says in smaller lettertype just below…easy to overlook… To download presentations, …
Oracle Enterprise Linux is now available from the Oracle unbreakable 2 program and ISO’s can be downloaded for free – see Sergio’s blog here: http://www.orablogs.com/sergio/archives/001838.html. I heared from Dimitri …
Unbreakable Linux and updates on upcoming 11g release Mr. Larry Ellison's keynote blew everything of the table for today; at least it did for me and let's be honest, …
Tuesday - Getting into the spirit I am just joking, so far I haven't seen an Elvis look-a-like in town, but I would be very interested how Thomas Kyte …
It's amazing how much Lucas already put to "paper", despite all the mishaps we already encountered. The last two days I lost track on Lucas because he has completely …
It's almost Friday, a day before our flight. Lucas and I will be off to San Francisco on Saturday morning. Lucas will give some lectures on OOW 2006; I …
After you have read the blog posts the websites of Sergio Leunissen, Eddie Awad or the "Ask Mr. Ed" website, you may wonder, if that was all you could …
Apparently it is still out there, the RBO in 10g. I saw the following post of Eric Jenkinson in a OTN forum...
It looks like that the upcoming Oracle 11 release will be certified on SUSE Linux Enterprise 10. As a Novell / SUSE communique (Novell news - 3 oct) says …
Even though we keep telling ourselves that iron these days is cheap, I was having difficulties with my laptop’s hard disk. It was almost full – to the brim. …
When you use VMware Server software to move or clone VMware Linux guest machines, you are asked by the VMware software if it should update the configuration file. When …
Yesterday I needed to apply a patch to my Oracle E-Business Suite 11.5.10.2 environment. This environment consist of a 10G release 2 RAC database and two application tiers. I …
I signed up a while ago for the SUSE Cool Solutions mailling list and I saw a very good step-by-step from Michel Bluteau regarding "Installing Oracle 10g R2 Database …
AMIS has been proven worthy to test the upcoming release of the 11gR1 database. After entering a lot of data in questionnaires and filling in project plans, AMIS got …
or How to deploy into an application-specific OCJ4-container on Oracle AS 10.1.3 without JBOExecption during deployment when your application uses ADF Lately our developers were working on an application …
Automatic continuous compilation of webforms on linux without X-terminal In the webforms world you it is not uncommon to compile a webforms application on a linux/unix application server, after …
With Java EE 5 being final, application servers need to be upgraded to support features like EJB 3.0. In some cases, loading the Java EE 5 jars may be …
Using CLOBs, conversion to and from VARCHAR2 may give you a headache.