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.