Question: How much time do you spend/lose? Answer: Well, how much time I gain? :) I mentioned in my previous blog post that I will share some of the interesting cases here. Erman Arslan's Oracle Blog / Forum has 350 subscribers asking questions regularly and here I 'm sharing the interesting ones. You asked: We have an Oracle 12.2.6 EBS system. Run FS is fs1 As soon as system started, all the services are running on fs1 , except oracle.apps.fnd.cp.gsm.GSMSvcComponentContainer GSM starts on fs2. Concurrent Managers are using binaries from fs2. If we run an empty ADOP patching cycle, afte ..read more

Educability.. We all need it, and here in this blog and in my forum, I think we are taking steps in this regard. Educability is defined with 3 basic things.  1) Learning from experience ( PAC - Probably approximately correct learning) 2) Chaining together what we've learned in different contexts.  3) Taking from someone else, their experience. It is actually the combination of those 3.. We, humans have this unique capability. So why not we use it in every way that we can? :) So you encounter some problems, you ask them, I try to shed some light on them and offer some solution ..read more

Following is based on a real life performance problem, which was encountered on a very critical Oracle Database 19C Production System. While the headings given below summarize how these performance problems should be approached from scratch, those written things under the headings provide case-specific details. Determining the current status of the environment, motivations in determining the direction of analysis, quick actions and suggestions for the future (Oracle specific).. Of course, the details are included in the analysis report. With this approach, we solve problems while ensuring cust ..read more

This is a hot topic for the EBS customers and wanted to clarify something about this upgrade process.. That is, the in-place OS upgrade for Oracle EBS from Linux 7 to Linux 8 is not certified.  So , if we want to switch to Oracle Linux 8  a  Oracle Linux 8 must be installed to a new machine and then all the requirements in the MOS Doc ID 1330701.1 document must be met. Afterwards, EBS system needs to be moved to the new machine/OS using the cloning method. This was already documented for Oracle Linux 7 upgrades (as shared below). But I also wanted to clarify this for the Or ..read more

For 19C customers, currently Latest RU is 19.22.  However, 19C's premier support will end on April 30. Then this will happen -> “Premier Support (PS) ends April 30, 2024, two years of waived Extended Support (ES) fees will be in effect from May 1, 2024 until April 30, 2026.” Error correction continues until 2026. In any case, we should be on 19C and be ready for the future  23C upgrades. (considering, 23C is the latest long term support release and will be available for on-premises starting 1H CY2024) Additional information for 19C: Premier Support (PS) ends: April 30, 2024 W ..read more

Forms 12C customers should know this. The jar files/the standard code delivered by Oracle is signed with the Digicert certificates and these certificates, which are there for the code signing, are used ensure the security on the client side. I won't go into the details of how code signing works, and I suppose most of my followers already know this. Here, I want to share something interesting.. This is based on a true story, on an issue escalated to me. The environment was a clustered Forms 12C (12.2.1.3). It was highly critical and very crowded.(3000 active users) The issue appeared suddenly a ..read more

I want to remind you something important regarding the Engineered systems. That is, as you may already know, the Oracle Supercluster M8 reached its End of Life (EOL) on June 30th, 2019. End of Life (EOL) signifies that Oracle no longer sells the hardware for the Supercluster M8. In addition to that, end of Support (EOS) status is also important.. EOS indicates that Oracle no longer provides guaranteed support for the system, including hardware replacement, bug fixes, and security patches. Well, last ship day of Supercluster M8 is Jun 2019. So, the premier support will end in June 2024. Afte ..read more

You may be hitting this bug even if your Oracle database version is 19C (even if it is 19.14..) You have a workaround (setting statistics_level to ALL), but it is not recommended.. (due to the fact that, you may end up collecting too much data for the  AWR snapshots) Note that, your AWR snapshot related data collection tasks may also take too much time to complete, if you set statistics_level to ALL.. especially if you have a large buffer cache... At the first glance, this problem seems addressed with the patch 22048821 TABLESPACE IO STATISTICS MISSING FROM AWR REPORT (Patch).. But it is ..read more

Remember, you can ask questions and get remote support using my forum. Just click on the link named "Erman Arslan's Oracle Forum is available now". Click here to ask a question", which is available on the main page of Erman Arslan's Oracle Blog. More than 2000 questions were asked, almost 10000 comments have been made and here is the links to the latest questions from the last period; -- or just use the direct link: http://erman-arslan-s-oracle-forum.124.s1.nabble.com Supporting the Oracle users around the world. Let's check what we have in the last few weeks.. Bursting Emails R1 ..read more

Remember, you can ask questions and get remote support using my forum. Just click on the link named "Erman Arslan's Oracle Forum is available now". Click here to ask a question", which is available on the main page of Erman Arslan's Oracle Blog. More than 2000 questions were asked, almost 10000 comments have been made and here is the links to the latest questions from the last period; -- or just use the direct link: https://ermanarslan.blogspot.com/p/forum.html Supporting the Oracle users around the world. Let's check what we have in the last few weeks.. APPS DBA Course&nb ..read more