Generated by All in One SEO v5.0.0.1, this is an llms.txt file, used by LLMs to index the site.

# alfredokriegdba.com

IT Blog

## Sitemaps

- [XML Sitemap](https://alfredokriegdba.com/sitemap.xml): Contains all public & indexable URLs for this website.

## Posts

- [Blog Feed](https://alfredokriegdba.com/blog-feed/)
- [EM Database Job Error After Upgrade to 24ai](https://alfredokriegdba.com/2026/05/13/em-database-job-error-after-upgrade-to-24ai/) - Today I want to talk about an error that I haven't seen before until I upgraded my demo Enterprise Manager environment to the latest 24ai version. I went through the standard process of upgrading the OMs and then upgraded the agents. Everything went fine expect that any jobs executed against a database or a host
- [Patch & Protect Your Oracle Database From AI-Enabled Threats](https://alfredokriegdba.com/2026/05/04/patch-protect-your-oracle-database-from-ai-enabled-threats/) - We hear more and more about the benefits of using AI models in terms of efficiency and speed innovation for the software industry. One thing that we also started hearing last month is that new models also offer new ways to exploit security vulnerabilities by bad actors. Oracle Database Engineering is actively working with leading
- [From AWR to Answers: Building a Local RAG Assistant with Ollama and Oracle AI Database 26ai](https://alfredokriegdba.com/2026/03/11/from-awr-to-answers-building-a-local-rag-assistant-with-ollama-and-oracle-database-26ai/) - Oracle's database instrumentation generates a huge amount of performance telemetry and AWR reports can still feel like a wall of text when you just want clear, targeted answers. In this post, I show how I turned a 24‑hour AWR report into an interactive performance tuning assistant using a local LLM (via Ollama on Windows 11) and Oracle
- [OEM Incidents and AI Vector Search](https://alfredokriegdba.com/2025/10/28/oem-incidents-and-ai-vector-search/) - In this post I want to provide a practical use of the AI Vector search functionality in the Oracle database. The use case is to be able to use AI Vector search on data that Oracle Enterprise Manager (EM) produces. In this case incidents data. The idea is to be able to search incidents using
- [Oracle EM Agent Preferred Connect Descriptor](https://alfredokriegdba.com/2025/10/10/oracle-em-agent-preferred-connect-descriptor/) - The USE_SID_AS_SERVICE_LISTENER=ON saga If you are migrating to multi-tenant architecture of the Oracle database, you'll find out that in order to connect to the pluggable database (PDB) you must use the service name for the PDB. But, what if you have a legacy application that can only use SID instead of the service name? For
- [Monitor Oracle DBs in RDS With Enterprise Manager](https://alfredokriegdba.com/2025/08/21/monitor-oracle-dbs-in-rds-with-enterprise-manager/) - In this blog I want to provide some important steps if you want to monitor Oracle databases running on AWS RDS. The first step is to have an Oracle Enterprise Manager (EM) installation. This can be on-prem or running on EC2. If you need to setup EM in EC2 you can use one of the
- [Upgrade Enterprise Manager to 24ai](https://alfredokriegdba.com/2025/04/16/upgrade-enterprise-manager-to-24ai/) - In this post I want to share my experience while executing the upgrade of Oracle Enterprise Manager from 13.5 to 24ai. As always. Please go ahead and read the Oracle documentation on how to upgrade EM to 24ai. click here... My EM demo environment was running EM 13.5 RU21 and the EM repository database 19c
- [Oracle Enterprise Manager 24AI - New Features](https://alfredokriegdba.com/2025/02/06/oracle-enterprise-manager-24ai-new-features/) - Oracle Enterprise Manager 24AI was announced on December 2024 during the Oracle Enterprise Manager Technology Forum 2024. If you would like to see all the Forum's recordings please register below. click here... In this post, I want to provide a quick overview of the most interesting new features of EM 24AI to you. Oracle EM
- [Extract OCI Resource Status Using APIs](https://alfredokriegdba.com/2024/10/25/extract-oci-resource-status-using-apis/) - #In this blog, I want to show you a way to extract every resource in a compartment along with their status using a Python script and OCI APIs. There are several pre-reqs that you need to fulfil in order to be able to connect using APIs to OCI. Follow the same pre-reqs as in my
- [How to remove OEM agent in the release 3 of the Oracle Enterprise Manager.](https://alfredokriegdba.com/2013/11/15/how-to-remove-oem-agent-in-the-release-3-of-the-oracle-enterprise-manager/) - OEM 12c R3 has a very useful Perl script which allows removing an installed OEM agent in the host. The process is quite straightforward just by invoking the AgentDeinstall.pl script located under: $AGENT_HOME/sysman/install/AgentDeinstall.pl [oracle@ol6-112 12.1.0.3.0]$ /u01/app/oracle/agent12cr3/core/12.1.0.3.0/perl/bin/perl /u01/app/oracle/agent12cr3/core/12.1.0.3.0/sysman/install/AgentDeinstall.pl -agentHome $AGENT_HOME Agent Oracle Home: /u01/app/oracle/agent12cr3/core/12.1.0.3.0 NOTE: The agent base directory: /u01/app/oracle/agent12cr3 will be removed after successful deinstallation
- [Send OCI Alerts Notifications To 3rd Party Systems (Object Storage)](https://alfredokriegdba.com/2024/08/30/send-oci-alerts-notifications-to-3rd-party-systems-object-storage/) - Hi there! In this blog, I want to show how you can send an OCI Alert Notification to a 3rd party system. The way I describe this tutorial is by sending the notification to an OCI Storage bucket so you can ingest it using the tool of preference. First of all I would describe the
- [Monitor MySQL HeatWave with OCI Database Management](https://alfredokriegdba.com/2024/07/17/monitor-mysql-heatwave-with-oci-database-management/) - In this post I want to show you how you can monitor your MySQL Heatwave databases with OCI Database Management Cloud Service. Is worth to mention that this Cloud Service provides this functionality free of cost and is automatically enabled for below configurations: Standalone High Availability Let's start by creating a new Heatwave instance. You
- [Integrate EM Metrics With Third-Party Tools Using REST APIs](https://alfredokriegdba.com/2024/06/04/integrate-em-metrics-with-third-party-tools-using-rest-apis/) - I want to share how to use Enterprise Manager's (EM) REST APIs to query metric data and integrate with 3rd party tools. First of all, always follow the documentation. Below is the link to the EM's REST API functionality. click here... Using the EM's REST API functionality we can query the EM repository using a
- [Extend Your Oracle Monitoring With Configuration Extensions](https://alfredokriegdba.com/2024/04/23/extend-your-oracle-monitoring-with-configuration-extensions/) - As soon as you enable the Database Lifecycle Management Pack; Oracle Enterprise Manager will automatically collect hundreds of configuration items of your database estate. However if you need to customize this collection, Configuration Extensions provide a way to identify files and other configuration data that Cloud Control does not already collect. In this blog, I'll
- [How To Discover ExaCC/ExaCS in Enterprise Manager - Detailed](https://alfredokriegdba.com/2024/02/06/how-to-discover-exacc-exacs-in-enterprise-manager-detailed/) - In this post I want to share the required steps to discover ExaCC or ExaCS in Oracle Enterprise Manager (EM). I'll provide as much detail as possible. Make sure your EM is at least on 13.5 RU 16. If not, please apply RU 16 to EM. Follow this link if you want to know how
- [Extract OCI Monitoring Metrics Using REST APIs](https://alfredokriegdba.com/2023/10/12/extract-oci-monitoring-metrics-using-rest-apis/) - In my previous post I showed you how you can create custom metrics in order to monitor a Standby database. Those steps detailed how to ingest (post) metrics to the OCI Monitoring service. click here... In this post I'll show you how you can list metric definitions and how you can extract metric data from
- [Monitor Oracle Standby Databases In OCI With Custom Metrics](https://alfredokriegdba.com/2023/07/11/monitor-oracle-standby-databases-in-oci-with-custom-metrics/) - Monitoring Oracle Standby Database (Data Guard) has been always a tricky task. Just by the nature of them (the fact that the instance is not open in read-write mode) is hard to gather information about them. Even using specialized tools like Oracle Enterprise Manager requires SYSDBA credentials in order to effectively monitor them. But what
- [Maximize Your Exadata Cloud at Customer Efficiency Using Oracle Enterprise Manager 13.5](https://alfredokriegdba.com/2023/04/21/maximize-your-exadata-cloud-at-customer-efficiency-using-oracle-enterprise-manager-13-5/) - Oracle Enterprise Manager (EM) it's been the go-to tool to monitor and manage on-premises Exadata deployments for quite some time. By doing a quick search in this blog I found presentations dated back from 2019 about choosing EM 12c or 13c to monitor and manage Exadata. Time has gone quick and now it's time to
- [How To Monitor Oracle DBs On Docker Containers With EM 13c](https://alfredokriegdba.com/2023/01/26/how-to-monitor-oracle-dbs-on-docker-containers-with-em-13c/) - This post continues the thread of DevOps and automation for the Oracle Database. During the last couple of months I've seen more interest in deploying Oracle Databases on Docker containers. Even more now that Oracle released full support of RAC Databases running on Docker. click here... After you deploy your first Oracle Database on Docker,
- [Oracle Enterprise Manager 13c Series – Patching](https://alfredokriegdba.com/2022/11/08/oracle-enterprise-manager-13c-series-patching/) - I wanted to create a video series covering the basics of Oracle Enterprise Manager 13c. These series are designed to provide insights on how to install, configure and manage Oracle Enterprise Manager 13.5. This week we are going to cover the patching of Oracle Enterprise Manager 13.5. Hope this is useful. Thanks,Alfredo
- [Oracle Enterprise Manager 13c Series - Installation](https://alfredokriegdba.com/2022/09/23/oracle-enterprise-manager-13c-series-installation/) - I wanted to create a video series covering the basics of Oracle Enterprise Manager 13c. These series are designed to provide insights on how to install, configure and manage Oracle Enterprise Manager 13.5. This week we are going to cover the installation phase of Oracle Enterprise Manager 13.5. Hope this is useful. Thanks,Alfredo
- [Oracle Enterprise Manager 13c: Extensibility and Interoperability for DevOps](https://alfredokriegdba.com/2021/10/18/oracle-enterprise-manager-13c-extensibility-and-interoperability-for-devops/) - DevOps adoption helps customers to automate and standardize processes, accelerate software delivery while keeping control of the operations, monitoring and lifecycle management of the environment. Enterprises select a tool or toolset in order to support desired business goals. However, these selected tools often require deeper automation from specialized management tools like Oracle Enterprise Manager 13c.
- [Patch Oracle Databases With Ansible and Enterprise Manager 13c](https://alfredokriegdba.com/2022/09/22/patch-oracle-databases-with-ansible-and-enterprise-manager-13c/) - In a previous post I show you how you can integrate DevOps automation and orchestration tools to provision Oracle databases by leveraging Enterprise Manager (EM) and the Cloud Management Pack (CMP). Once provisioned, databases need to be fully maintained in terms of monitoring but most precisely patching. Patching databases decreases the risk of breach by
- [Oracle Enterprise Manager 13.5 RU7 Now Available!](https://alfredokriegdba.com/2022/06/06/oracle-enterprise-manager-13-5-ru7-now-available/) - Before I start this post I want to give a big shoutout to FeedSpot for ranking my blog in the Top 100 Best Oracle Blogs and Websites. It's honestly an honor. Since the start of this blog the main goal was and still is to share knowledge with the community. Being an Oracle ACE Alumni
- [Improve Oracle Database Security  With Enterprise Manager 13c](https://alfredokriegdba.com/2022/05/20/improve-oracle-database-security-with-enterprise-manager-13c/) - IT Security is popular topic nowadays! We constantly hear news about data breaches, ransomware, malware, unauthorized access to IT systems, etc. IT organizations are constantly looking to keep their systems, networks and data safe and secure. Today's blog is about how Oracle Enterprise Manager (EM) can help Database Administrators to secure and harden the Oracle
- [Provision Oracle Databases With Ansible and Enterprise Manager 13c](https://alfredokriegdba.com/2022/05/02/provision-oracle-databases-with-ansible-and-enterprise-manager-13c/) - In this post I want to show you how Oracle Enterprise Manager 13c using the Cloud Management pack, can be easily integrated with DevOps automation and orchestration tools like Ansible in order to provision Oracle Databases. These can be either single instance, multi-tenant container databases, pluggable databases, schemas or databases running on high availability clusters
- [DevOps, Ansible and Oracle Enterprise Manager](https://alfredokriegdba.com/2020/06/26/devops-ansible-and-oracle-enterprise-manager/) - As IT moves towards virtualization, cloud and hybrid environments, containers, agile developments, etc. Automation and orchestration tools are gaining popularity to build and deliver environments faster and efficiently. In this post, I want to show how Oracle Enterprise Manager (EM) interacts with 3rd party tools and how this can be used to integrate EM's functionality
- [How To Patch Oracle Enterprise Manager 13.5 RU1](https://alfredokriegdba.com/2021/10/11/how-to-patch-oracle-enterprise-manager-13-5-ru1/) - Oracle Enterprise Manager (EM) 13.5 RU1 was released last week. Click here... In this post, I want to show you how to apply this RU to your Oracle Enterprise Manager environment. Let me start by describing the environment that I’m using for this. Oracle Enterprise Manager 13.5 can be deployed both on-premises or in the
- [Dallas Oracle User Group 2021 - Oracle EM 13c Snap Clone](https://alfredokriegdba.com/2021/10/07/dallas-oracle-user-group-2021-oracle-em-13c-snap-clone/) - We had a wonderful conference this year. Thank you for attending "Clone Oracle Databases In Minutes Without Risk Using Oracle Enterprise Manager 13c" session. Below is the link for the slide deck. Thanks,Alfredo
- [Oracle Enterprise Manager 13c Snap Clone Demo](https://alfredokriegdba.com/2021/09/09/oracle-enterprise-manager-13c-snap-clone-demo/) - The database cloning process can be often time consuming, resource intensive and expensive especially for large multi-terabyte databases. This can lead to miss project deadlines or to cause that storage costs grow out of control. Enterprise Manager 13c Snap Clone instant database cloning allows administrators to create fully functional copies of databases using the capabilities
- [Oracle Database Performance Diagnostics, Tuning and Validation with Oracle Enterprise Manager 13c Workshops](https://alfredokriegdba.com/2021/08/31/oracle-database-performance-diagnostics-tuning-and-validation-with-oracle-enterprise-manager-13c-workshops/) - Last month we held 2 workshops where we went through some capabilities of Oracle Enterprise Manager 13c that help with performance diagnostics, tuning and validation for the Oracle Database. If you were not able to attend and you want to learn about these capabilities, I recommend you take a look at the recording using the
- [Upgrade Your DB to 19c As A PDB using Enterprise Manager 13c](https://alfredokriegdba.com/2021/06/29/upgrade-your-db-to-19c-as-a-pdb-using-enterprise-manager-13c/) - With Oracle Database 19c being the long term release, makes sense to start planning the upgrade of the DBs running on previous releases. Even better, what about converting Non-CDB databases into PDBs at the same time? Using Oracle Enterprise Manager (EM) 13c, we can kill two birds with one stone. That is upgrade our DBs
- [Upgrade Oracle Enterprise Manager to 13.5](https://alfredokriegdba.com/2021/05/18/upgrade-oracle-enterprise-manager-to-13-5/) - Oracle Enterprise Manager 13.5 (EM) was just recently announced. The installation files along with the documentation are now available in the Oracle portal. The upgrade process is very similar to the one followed for 13.4. You can find the process I followed to upgrade EM to 13.4 here: Click HERE... Let's now get into the
- [Applying Oracle Enterprise Manager 13.4 RU 8](https://alfredokriegdba.com/2020/12/09/applying-oracle-enterprise-manager-13-4-ru-8/) - Oracle Enterprise Manager (EM) Release Update (RU) 8 for 13.4 version was released at the end of last month. Follow the link below to find out what's included in this RU. more info here... In this post, I want to show you how to apply this RU to your Oracle Enterprise Manager environment. Let me
- [Adobe Flash End-Of-Life and Oracle Enterprise Manager](https://alfredokriegdba.com/2020/12/02/adobe-flash-end-of-life-and-oracle-enterprise-manager/) - Adobe announced the End-Of-Life (EOL) for the Flash technology and this is happening December 31, 2020. As a result, most of the popular Web browsers also announced that Flash will be blocked the same day. I've been blogging about this for more than a year now, explaining how this impacts Oracle Enterprise Manager's (EM) database
- [Oracle Database Consolidation Workbench](https://alfredokriegdba.com/2020/11/23/oracle-database-consolidation-workbench/) - During database migrations, Oracle Database Administrators (DBA) face a series of challenges that could make the migration success unpredictable. Oracle Real Application Testing pack combined with Oracle Enterprise Manager 13c offers a tool that simplifies and predicts the database migration and consolidation process. Oracle Database Consolidation Workbench enables DBA's to create consolidation projects and scenarios
- [Oracle Enterprise Manager 13c - Connection to MOS not working](https://alfredokriegdba.com/2020/10/12/oracle-enterprise-manager-13c-connection-to-mos-not-working/) - Oracle Enterprise Manager (EM) 13c has the ability to connect to My Oracle Support (MOS) in order to download patch recommendations, information about new plugins and versions. This is pretty useful in terms of keeping your EM up to date. There was an issue early this year that prevented the connection from EM to the
- [Oracle Enterprise Manager Webcast Series](https://alfredokriegdba.com/2020/08/31/oracle-enterprise-manager-webcast-series/) - This year we started a series of deep dive Webcasts related to Oracle Enterprise Manager 13c including all the monitoring, tuning and manageability tools that the Database Management Packs offer. I want to condense a list of resources for you so you can take advantage of these Webcasts either live or watching the recorded session.
- [Oracle Enterprise Manager App for Grafana](https://alfredokriegdba.com/2020/07/08/oracle-enterprise-manager-app-for-grafana/) - Oracle Enterprise Manager 13c provides out-of-box dashboard functionality, so you can see the status of all your targets on a single screen. You also have information about target's fatal, critical, warning and escalated incidents along with detailed information about them. But what about additional data that EM is already collecting? What if you create Metric
- [Finding the Weblogic Password for the Oracle Enterprise Manager Marketplace Image](https://alfredokriegdba.com/2020/06/30/finding-the-weblogic-password-for-the-oracle-enterprise-manager-marketplace-image/) - Oracle Enterprise Manager (EM) 13.4 is available in the Oracle Cloud Infrastructure Marketplace. This image is very flexible and allows you to choose between different EM Deployment sizes ranging from Simple (Single node) to Large (Multi-node) setups. I decided to deploy a Simple configuration in order to test it out. The deployment wizard prompts you
- [Applying Oracle Enterprise Manager 13.4 RU 3](https://alfredokriegdba.com/2020/06/09/applying-oracle-enterprise-manager-13-4-ru-3/) - Oracle Enterprise Manager (EM) Release Update (RU) 3 for 13.4 version was released early this month. MORE INFO... In this post, I want to show you how to apply this RU to your Oracle Enterprise Manager environment. Let me start by describing the environment that I'm using for this. Oracle Enterprise Manager 13.4 can be
- [Oracle Enterprise Manager Performance Hub](https://alfredokriegdba.com/2020/06/01/oracle-enterprise-manager-performance-hub/) - Oracle Enterprise Manager (EM) 13.4 RU 2 has just been released this month. You may noticed that starting from EM 13.3 PG, the Top Activity page has been decommissioned. The Performance Hub page is the one that is available and yes, is not using Flash. If you have concerns about no longer having access to
- [Using SPA To Validate Changes](https://alfredokriegdba.com/2020/04/22/using-spa-to-validate-changes/) - Oracle SQL Performance Analyzer (SPA) is part of Real Application Testing pack. We can use SPA to validate changes made to the database system. Some of these changes include gathering statistics, creating SQL Profiles or making parameter changes. In one of my previous posts I provided detailed information on how to use SPA. Using SPA
- [Upgrade EM to 13.4](https://alfredokriegdba.com/2020/02/06/upgrade-em-to-13-4/) - I've been getting many questions about the upgrade process of Enterprise Manager (EM). EM upgrade process is a out-of-place upgrade, this means that you need to install a new Oracle Home (OH) and then perform the upgrade of your EM. EM 13.4 was just released last week and this is the perfect time to start
- [Do You Trust SQL Tuning Advisor?](https://alfredokriegdba.com/2020/01/28/do-you-trust-sql-tuning-advisor/) - Today's post is about SQL tuning. During my more than 14 years of experience as a Database Administrator I haven't found a better tool than Enterprise Manager (EM) to monitor Oracle's DB performance. The "Top Activity" graph has been a constant during all these years. Note: The EM's Top Activity page has been deprecated in
- [How's Your Data Center Configuration?](https://alfredokriegdba.com/2020/01/23/hows-your-data-center-configuration/) - Oracle Enterprise Manager 13c (EM) Lifecycle Management pack offers a set of tools to help you manage all your data canter targets from a single pane of glass. All these tools are listed on my previous post. Click here One of this tools is Configuration and Drift Management. What is it and how it works?
- [Lifecycle Management Automation Series](https://alfredokriegdba.com/2020/01/21/lifecycle-management-automation-series/) - Today's infrastructure management is getting complex. We now have hybrid datacenters, multi-cloud solutions, virtual machines and so on. With all this complexity is difficult to manage configuration consistency, changes and to keep up with security vulnerabilities and patches. Enterprises realize that is not possible to engage more human resources to overcome these issues that easy.
- [Oracle DB Patching with EM 13.3](https://alfredokriegdba.com/2019/11/07/oracle-db-patching-with-em-13-3/) - I got several interesting questions last week during my presentation about Oracle Enterprise Manager (EM) 13.3 and Exadata at the East Coast Oracle Conference 2019. One of them was related on how to patch a DB home using EM 13.3 and I'll try to show it on this post. First, keep in mind that in
- [OEM 13c Database Plugin 13.3.2 Caveat](https://alfredokriegdba.com/2019/10/12/oem-13c-database-plugin-13-3-2-caveat/) - I have done some testing on the OEM 13c DB Plugin 13.3.2 (PG) for the last several months. I highlighted some of the changes in this new version in a previous post: Click Here! During the last Dallas Oracle User Group (DOUG) conference I got couple of questions though. I will try to answer them
- [The Strange Case Of A Missing Agent Gold Image](https://alfredokriegdba.com/2019/10/01/the-strange-case-of-a-missing-agent-gold-image/) - If you are running Oracle Enterprise Manager (OEM) 13c, you should (must) be using Agent Gold Images (GI). They provide an easy way to manage the lifecycle of you OEM agents from a fancy dashboard. The problem came while removing a Gold Image Versions in OEM 13.3PG. Guess what? The whole Gold Image disappeared!!! This
- [Bye Bye Flash!](https://alfredokriegdba.com/2019/09/15/bye-bye-flash/) - Formerly named Macromedia Flash (now Adobe Flash) player was really popular in the 2000's. I remember learning it to add animation to Web Sites I was developing during my college years. Flash has also been the target of hackers to insert viruses, hence posing several security concerns to enterprises and home users. In the IT
- [OEM 13c - Summer 2019 Announcements. You can manage ATP and more!!](https://alfredokriegdba.com/2019/08/01/oem-13c-summer-2019-announcements-you-can-manage-atp-and-more/) - Here are some exciting announcements for OEM 13c. First, keep in mind that you should upgrade your OEM 13c to the latest version (13.3PG). I discussed some new features of this version in a previous post. Previous post Now to the good news. 1. Oracle Database 19c has been certified as a OEM Repository
- [Oracle Enterprise Manager 13.3 problems discovering Exadata targets](https://alfredokriegdba.com/2019/07/12/oracle-enterprise-manager-13-3-problems-discovering-exadata-targets/) - If you are on the latest Exadata plugin for EM 13.3 (well, even the 13.2 version of the plugin). Be aware that there’s a bug where if the Exadata nodes’ names are longer than 7 characters, you cannot discover them. EM just throws a weird error with below legend: SEVERE: makeTargetsXml for each rack#: 1
- [Oracle Enterprise Manager 13.3.2 Database Plugin New Features (Flash and JET)](https://alfredokriegdba.com/2019/05/29/oracle-enterprise-manager-13-3-2-database-plugin-new-features-flash-and-jet/) - Oracle EM 13.3 PG was released April 28th 2019. This new (plugin only) release contains 8 new plugins including a new version of the DB plugin. After installing these plugins we noticed several changes in behavior for the DB targets. All pages that used Adobe Flash now use Oracle JavaScript Extension Toolkit (JET) Top
- [Unable to Extend OEM 13.3 Domain to Add an Additional OMS](https://alfredokriegdba.com/2019/05/27/unable-to-extend-oem-13-3-domain-to-add-an-additional-oms/) - While trying to add an additional OMS to the current OEM 13.3 GCDomain using the provisioning console there’s an error in the Install homes step. The error contains the following message: Caused by: oracle.sysman.oii.oiif.oiifb.OiifbEndIterateException: oracle.sysman.oii.oiif.oiifb.OiifbEndIterateException: SEVERE:Values for the following variables could not be obtained from the command line or response file(s): MYORACLESUPPORT_USERNAME(MyOracleSupportUsername) Silent install
- [Oracle Autonomous Data Warehouse – What is it?](https://alfredokriegdba.com/2019/04/19/oracle-autonomous-data-warehouse-what-is-it/) - Oracle Autonomous Data Warehouse (ADW) is one of the so-called DB as a Service (DBaaS) or probably we should call it Data Warehouse as a Service (DWaaS) with the difference that this service is completely automatic and autonomous. This service is comprised by an Oracle Database (of course) already pre-configured for analytics, data lakes
- [Collaborate 2019 - Exadata SMART Monitoring - OEM 13c](https://alfredokriegdba.com/2019/04/09/collaborate-2019-exadata-smart-monitoring-oem-13c/) - Below is the 2019 Collaborate presentation on Exadata SMART Monitoring using OEM 13c. Click here! Thanks, Alfredo
- [Collaborate 2019 - How to Understand an AWR Report](https://alfredokriegdba.com/2019/04/08/collaborate-2019-how-to-understand-an-awr-report/) - Below is the 2019 Collaborate presentation on How to Understand an AWR Report. Click here! Thanks, Alfredo
- [Collaborate 2019 - Simplifying EBS 12.2 ADOP](https://alfredokriegdba.com/2019/04/07/collaborate-2019-simplifying-ebs-12-2-adop/) - Below is the 2019 Collaborate presentation for EBS 12.2 ADOP session. Click here! Thanks, Alfredo
- [Collaborate 2019 Presentations](https://alfredokriegdba.com/2019/03/18/collaborate-2019-presentations/) - Collaborate 2019 will take place April 7-11 in San Antonio this year. This time I have 3 presentations accepted and ready to roll starting April 7th. Simplifying EBS 12.2 ADOP In this session I’ll talk about basic ADOP concepts, how to us them and real-life problems and best practice recommendations. Listen to your Database. How
- [Configure Oracle Cloud Infrastructure's VCN Network](https://alfredokriegdba.com/2019/03/18/configure-oracle-cloud-infrastructures-vcn-network/) - Oracle Cloud Infrastructure requires a VCN (Virtual Cloud Network) to be created in order to connect to DB Systems (Bare Metal and VM). There are basically tow options to configure this VCN. · Public Subnet with Internet Gateway · Private Subnet The Public Subnet with Internet Gateway will expose the network to the Internet. The
- [Avoid Transaction Errors Due To Tablespace Shortage](https://alfredokriegdba.com/2019/03/11/avoid-transaction-errors-due-to-tablespace-shortage/) - How many times we have had a call from application teams regarding a session error due to a tablespace (either DATA, TEMP or UNDO) getting 100% full? How many times we had ask for an estimate of space used by a process, session or transaction? There are several options that can help us overcome this
- [Create a Linux VM on Azure](https://alfredokriegdba.com/2019/02/23/create-a-linux-vm-on-azure/) - In this post I’ll show you how easy is to create a Linux VM in Microsoft’s Azure cloud. Once you login to Azure using your account you will be presented with the main dashboard. Click on Virtual Machines and then click Add. The first section contains the basic information of your VM. Select a subscription.
- [Oracle Cloud Infrastructure – Database Service - Bare Metal](https://alfredokriegdba.com/2019/02/15/oracle-cloud-infrastructure-database-service-bare-metal/) - The Database service part of the Oracle Cloud Infrastructure offers the autonomous and user-managed database options. The user-managed can be customized and you can choose between using Bare Metal, Virtual Machine or Exadata systems. These are called DB Systems. The autonomous database cannot be customized as they come pre-configured. You can choose between Autonomous Transaction
- [Oracle 19c Available for Exadata On-Premises](https://alfredokriegdba.com/2019/02/14/oracle-19c-available-for-exadata-on-premises/) - Oracle just released Oracle 19c for Exadata On-Premises. This is just close to a year when they released the 18c version for Exadata On-Premises on February 16th 2018. If they follow the same schedule, we may expect 19c for the Database Cloud Service early next month. Release dates can be found in the MOS Doc
- [OEM 12c/13c Metric Extension - Collection Result Maximum Flood Control](https://alfredokriegdba.com/2019/02/14/oem-12c-13c-metric-extension-collection-result-maximum-flood-control/) - I recently had an issue in OEM 12c while creating a Metric Extension that was returning more than 5000 records. In OEM 12c versions 12.1.0.4 and 12.1.0.5 there a flood control mechanism in order to limit the maximum number of rows for a metric. You can also verify this in the agent_inst/sysman/log/gcagent.log file: 2018-10-08 13:38:50,330
- [Install VirtualBox on MacOS using HomeBrew](https://alfredokriegdba.com/2019/01/11/install-virtualbox-on-macos-using-homebrew/) - I’m fairly new on using MacOS. I’ve been struggling finding shortcuts and keys that I was very comfortable with in Windows. I friend of mine helped me with tips and also mentioned to install HomeBrew in order to install VirtualBox. Here’s a short post on how to do it. First you need to install Xcode.
- [OEM 13c - AMP EBS Discovery Error Due To Lack Of Privileges](https://alfredokriegdba.com/2019/01/04/oem-13c-amp-ebs-discovery-error-due-to-lack-of-privileges/) - We recently had to enable monitoring for an EBS 11i system using the Application Management Pack. Even though the EM_MONITOR user was already provisioned by the EBS patch, the discovery was failing due to lack of privileges on several FND tables. My Oracle Support shows several bugs related to missing privileges like the one below,
- [Using SQL Patch To Inject Hints](https://alfredokriegdba.com/2018/12/24/using-sql-patch-to-inject-hints/) - In my previous post (Execution Plans, Hints and Outlines in Oracle 18c) we saw how to use a SQL Hint to modify the order in which the CBO joins the tables. Today I want to show you a cool feature to inject this change without re-writing your SQL statement. Let's use the same SQL statement:
- [Execution Plans, Hints and Outlines in Oracle 18c](https://alfredokriegdba.com/2018/12/22/execution-plans-hints-and-outlines-in-oracle-18c/) - Today's post is about execution plans. This quick example using the HR sample schema, highlights the importance of using SQL Hints to influence the execution path. Let me use below SQL as an example: SELECT COUNT(*) FROM hr.employees a, hr.departments b, hr.locations c WHERE a.department_id = b.department_id AND b.location_id
- [Exdata's Cell Server Crashing](https://alfredokriegdba.com/2018/12/21/exdatas-cell-server-crashing/) - "RS-7445 [Serv CELLSRV hang detected] [It will be restarted] [] [] [] [] [] [] [] [] [] []" "A kernel crash has caused the system to reboot." This ended up to be related to bug 25374245. The workaround is to monitor the cell offload server resident memory and manually restart it before it gets
- [EBS ADOP Phase Failing Due to ORA-600 Error](https://alfredokriegdba.com/2018/11/30/ebs-adop-phase-failing-due-to-ora-600-error/) - There’s an issue in EBS 12.2 and database 12.1.0.2 versions related to Materialized Views. While executing ADOP (prepare, apply, finalize or cutover) phases, the cycle could fail due to an ORA-600 : internal error code, arguments: [kqllod:no stub for dependency parent] error. After working with Oracle, they provided information about BUG 27883586 related to MView Refresh
- [OEM 13c Reporting Incorrect Tablespace Space Usage (%) After July 2018 PSU](https://alfredokriegdba.com/2018/10/26/oem-13c-reporting-incorrect-tablespace-space-usage-after-july-2018-psu/) - The topic for today is Tablespace monitoring. OEM 13c started reporting inaccurate values for the Space Usage (%) metric after applying either the April 2018 or the July 2018 Database PSU's. The way this was detected, is that OEM 13c Corrective Actions started firing here and there after the patches. Oracle confirmed this is tracked
- [RMAN Recovery Catalog Issues after 12.2 Upgrade](https://alfredokriegdba.com/2018/09/30/rman-recovery-catalog-issues-after-12-2-upgrade/) - Well, after the upgrade of the DB to 12.2 the next step is to upgrade the RMAN Recovery Catalog to the same version in order to be able to run backups using it. The process is pretty straight forward.. Connect to RMAN using target and catalog. Execute upgrade catalog RMAN> upgrade catalog; This finishes correctly.
- [Exadata/Exacloud CellServer health using AWR report](https://alfredokriegdba.com/2018/08/31/exadata-exacloud-cellserver-health-using-awr-report/) - Exadata’s unique sauce relies on the fact that the DB instance can offload work to the CellServers to speed up I/O bound queries. But how do you monitor the health of the CellServers? A quick and dirty way, especially if you don’t have access to the CellServers is to use AWR in a database that’s
- [Exalogic Agents being automatically deleted from OEM 13c](https://alfredokriegdba.com/2018/08/10/exalogic-agents-being-automatically-deleted-from-oem-13c/) - Oracle Enterprise Manager (OEM) 13c is capable of monitoring virtual guest hosts running on Exalogic (virtual configuration). OEM will connect (read-only) to the Oracle VM Manager and get the configuration and status of the VM’s running there. Then you can deploy an agent to those VM hosts and you have a complete monitoring solution for
- [Manage Your Oracle Cloud Database - SQL Developer](https://alfredokriegdba.com/2018/06/01/manage-your-oracle-cloud-database-sql-developer/) - In my previous post (How To Connect To The Oracle Cloud Instance) we reviewed the steps to connect using SQL Developer. Now we will see what DBA tasks we can perform using SQL Developer.First click on the View menu, then click on the DBA sub menu. This is going to open the DBA pane in
- [How To Connect To The Oracle Cloud DB Instance?](https://alfredokriegdba.com/2018/05/31/how-to-connect-to-the-oracle-cloud-db-instance/) - In my previous post (How To Create An Oracle Cloud Instance) I showed you create your first Oracle Cloud DB instance. Now that the instance is there the question is, how to connect to it?Let's say you want to connect using SQL Developer to start creating objects and inserting data. First you need to enable
- [How To Create An Oracle Cloud Instance](https://alfredokriegdba.com/2018/05/29/how-to-create-an-oracle-cloud-instance/) - In my previous post (Thinking on trying the Oracle Cloud? My 30 day experience) I showed you how to subscribe to the Oracle Cloud and how to get to the main dashboard. From here we are going to click on the Create Instance button. After that you are going to be prompted on what kind
- [Thinking on trying the Oracle Cloud? My 30 day experience.](https://alfredokriegdba.com/2018/05/29/thinking-on-trying-the-oracle-cloud-my-30-day-experience/) - Although I already had some exposure to the Oracle Cloud (thanks to other Oracle ACEs that put an awesome workshop last year at Collaborate 2017) , I decided to sign up for a free 30 day ($300 dollars credit) and test the Cloud out. The sing up process was kind of weird. You first go
- [ORA-04045 When Running ADOP PHASE=ACTUALIZE_ALL](https://alfredokriegdba.com/2018/05/28/ora-04045-when-running-adop-phaseactualize_all/) - Oracle’s documentation recommends to execute actualize_all inorder to purge old editions in the DB accumulated during previous patchingcycles.There’s a problem with EBS version 12.2.4 that when running adopphase=actualize_all you get an ORA-04045 errors duringrecompilation/revalidation of .You can try to manually recompile objects but all of them failwith the same error. This is documented under bug
- [TXK patch failing with ORA-600](https://alfredokriegdba.com/2018/05/25/txk-patch-failing-with-ora-600/) - I got an error during an TXK patch in a 12.2 EBS instance. This happened while executing file xdotmgen.ldt. Error: FAILED: file xdotmgen.ldt on worker 1 for product fnd username APPS. Uploading from the data file .... Uploading from staging tables Error during uploading. ORA-00600: internal error code, arguments: [17273], [0x13C88677A0], [0], [7], [], [], [],
- [OEM 12c Agent Crashing on Solaris](https://alfredokriegdba.com/2018/05/24/oem-12c-agent-crashing-on-solaris/) - I recently had an issue with an OEM agent 12.1.0.4 version running on Solaris. Looks like there’s a Java related bug which causes the agent to consume high amounts of CPU in the box. But the interesting part is this only happens when Listeners are being monitored. If you blackout the Listener targets this stops.
- [OEM 13c – Unable to find agent in a patch plan](https://alfredokriegdba.com/2018/05/21/oem-13c-unable-to-find-agent-in-a-patch-plan/) - If you have an issue to find an agent using a patch plan from OEM 13c, then you are likely facing a bug. Oracle explains the rationale in the MOS Id 2240307.1. You need to apply patch 25604219 in order to fix this issue. After this you can search your agent and add it to
- [OEM 13c and Amazon’s RDS](https://alfredokriegdba.com/2018/05/21/oem-13c-and-amazons-rds/) - Amazon released a note late last year about Amazon’s RDS is now supporting Oracle Enterprise Manager Agents. Amazon RDS supports agent version 12 (12.1.0.5), 13R1 and 13R2 (13.2.0.0). You can use this to monitor your DB instances running on Amazon’s RDB but there are some limitations, like the fact you cannot execute jobs against those
- [OEM 13C Useful EMCTL Agent Commands](https://alfredokriegdba.com/2018/05/18/oem-13c-useful-emctl-agent-commands/) - Here’s a list of some useful emctl commands to manage your OEM 13c agent. Get the status of the agent: $ emctl status agent Oracle Enterprise Manager Cloud Control 13c Release 2 Copyright (c) 1996, 2016 Oracle Corporation. All rights reserved. --------------------------------------------------------------- Agent Version : 13.2.0.0.0 OMS Version : 13.2.0.0.0 Protocol Version : 12.1.0.1.0 ...
- [Oracle EBS 12.2 EBS Technology Codelevel Checker ETCC](https://alfredokriegdba.com/2018/05/16/oracle-ebs-12-2-ebs-technology-codelevel-checker-etcc/) - Looks like this is my first post about Oracle EBS. Yeah, looks like now I’m more on the dark side of the force. This is the time for ETCC. ETCC is a set of 2 scripts. One is going to check the recommended patches for the DB stack and the other one is going to
- [Enable NFS mount point monitoring in OEM 13c](https://alfredokriegdba.com/2018/05/15/enable-nfs-mount-point-monitoring-in-oem-13c/) - OEM doesn’t monitor NFS mount points by default. In case you need to monitor NFS mount points you have 2 options. Either create a metric extension using an OS script or to enable a property called EM_MONITOR_ALL_DISKS in the agent’s configuration file. There are two ways to accomplish the second option. You can go and
- [Exclusion not working in OEM 13c Rule Sets](https://alfredokriegdba.com/2018/05/15/exclusion-not-working-in-oem-13c-rule-sets/) - While setting up Rules and RuleSets you may want to exclude either target types or alert categories from your notifications. Well, there’s an issue if you try to do this in OEM 13c. If you configure a Rule that has the exclusion and contains more than one category, then you will keep receiving alerts from
- [Install OMC Data Collector To Harvest Oracle Enterprise Manager Target’s Metric Data](https://alfredokriegdba.com/2018/05/14/install-omc-data-collector-to-harvest-oracle-enterprise-manager-targets-metric-data/) - In order to make use of the data you already have in your Oracle Enterprise Manager (OEM) in Oracle’s Management Cloud (OMC) you need to install and configure the OMC’s Data Collector agent. Here’s how you do it. Login to OMC and navigate to Administration -> Agents -> Download In the Agent Type box, select
- [_optimizer_distinct_placement](https://alfredokriegdba.com/2018/05/11/_optimizer_distinct_placement/) - I remember seeing this hidden parameter in the past (11.2.0.3) and that had an issue when querying v$temp_extent_map view. This view returned wrong results if this parameter was set to true. Now is a different story in 12.1.0.2. We started to see many ORA-600 [kkqcscpopnWithMap: 0] errors. Turns out is because of the same parameter.
- [This patch is non-Data Guard Standby-First Installable](https://alfredokriegdba.com/2018/05/11/this-patch-is-non-data-guard-standby-first-installable/) - During a DB patching I found this note in the patch README file. This patch is non-Data Guard Standby-First Installable - Please read My Oracle Support Note 1265700.1 https://support.us.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1265700.1 This is the first time I see this, so I was curious about this as Oracle recommends to apply the patches first to the standby database
- [Oracle Database 12.2 New Features - SQL* Plus Enhancements](https://alfredokriegdba.com/2018/01/07/oracle-database-12-2-new-features-sql-plus-enhancements/) - I want to start a series of posts about Oracle Database 12.2 new features this new year 2018. There’s no better start of this series than to start with SQL*Plus. SQL*Plus is probably one of the most utilized tools by DBA’s (sqlcl is gaining steam) and here I show some really cool new features. SQL*Plus
- [Upload the OPatch that is of version "13.8.0.0.0" and platform "226" to the Software Library](https://alfredokriegdba.com/2017/09/17/upload-the-opatch-that-is-of-version-13-8-0-0-0-and-platform-226-to-the-software-library/) - I was having an issue trying to deploy a patch to an agent due to the version of OPatch available in the software library. The error I got was “Upload the OPatch that is of version "13.8.0.0.0" and platform "226" to the Software Library” The solution was to run the “OPatch Update” job available from
- [“Failed to find the OPatch patch directory” while applying patch 25105555 ( 13.2.0.0.161231) from OEM console](https://alfredokriegdba.com/2017/09/17/failed-to-find-the-opatch-patch-directory-while-applying-patch-25105555-13-2-0-0-161231-from-oem-console/) - While applying patch 25105555 ( 13.2.0.0.161231) to an agent using the "provisioning and Patching" console from OEM 13.2 and choosing the "Upgrade OPatch" option, got this error: ---------- Error Message ---------- Error: 010 Failed to find the OPatch patch directory "/tmp/p6880880_600000000057471_2000_0/oracle/OPatch". If you chose "No" for the "StagePatches" option, ensure that you manually place the
- [RMAN restore slow due to ASMB process from ASM to filesystem](https://alfredokriegdba.com/2017/08/31/rman-restore-slow-due-to-asmb-process-from-asm-to-filesystem/) - I was restoring a database running on ASM to an instance running on filesystem. The step for cataloging files was extremely slow and after taking a look at the alertlog file, I noticed tons of errors related to ASMB process. Well, turns out this is an unpublished bug explained in more detail on the below
- [2017 April PSU - OEM sending tablespace related alerts every collection schedule](https://alfredokriegdba.com/2017/07/14/2017-april-psu-oem-sending-tablespace-related-alerts-every-collection-schedule/) - I noticed that several alerts related to tablespace full were sent from OEM every collection schedule. At first sight I thought this may be related to OEM itself but after spending some significant time in MOS found a bug note stating that the 2017 April PSU patch was responsible. The issue is that dba_tablespace_usage_metrics is not
- [Oracle Management Cloud – Setup Entities in Log Analytics](https://alfredokriegdba.com/2017/04/13/oracle-management-cloud-setup-entities-in-log-analytics/) - In order to gather Weblogic’s Admin Server and Managed Server log files, you need first to install and configure the OMC Cloud Agent. Oracle Management Cloud – Cloud Agent Install Then you need to verify that the Cloud Agent is up and running. Refer to my previous post on how to manage the Cloud
- [Collaborate 2017 - Where did my day go?: Oracle Enterprise Manager 12c/13c Administration](https://alfredokriegdba.com/2017/04/06/collaborate-2017-where-did-my-day-go-oracle-enterprise-manager-12c-13c-administration/) - Here are the slides of my yesterday’s presentation. Click here!
- [Oracle Management Cloud - Managing the Oracle Cloud Agent](https://alfredokriegdba.com/2017/04/01/oracle-management-cloud-managing-the-oracle-cloud-agent/) - This post is about some useful commands to administer the OMC’s Cloud agent. The very first step is to install the OMC Cloud agent. You may refer to my previous post on how to install it here. The omcli command is located at /agent_inst/bin. I’m skipping these 3 basic commands start, stop and status. Here
- [Oracle Management Cloud - Install the Cloud Agent](https://alfredokriegdba.com/2017/03/23/oracle-management-cloud-install-the-cloud-agent/) - This is my first experience with the Oracle Cloud, in particular with Oracle Management Cloud (OMC). In this first post I will guide you through the installation of the Cloud Agent in a Linux host. First you have to login to OMC and click on the navigation icon below. It' going to open the navigation
- [OMS responded illegally [ERROR- Failed to Update Target Type Metadata] in 13c R2](https://alfredokriegdba.com/2017/01/25/oms-responded-illegally-error-failed-to-update-target-type-metadata-in-13c-r2/) - I want to discuss about this OMS error coming from the agent’s heartbeat status. The agent shows with an unreachable status but is actually up and running. $: emctl status agent Oracle Enterprise Manager Cloud Control 13c Release 2 Copyright (c) 1996, 2016 Oracle Corporation. All rights reserved. --------------------------------------------------------------- Agent Version : 13.2.0.0.0 OMS Version
- [Upgrade OPatch for OEM 13c R2 Agents](https://alfredokriegdba.com/2017/01/23/upgrade-opatch-for-oem-13c-r2-agents/) - Opatch utility has to be updated often as Oracle delivers regular updates to it. I was used to version 12 and it only required an overwrite of the OPatch directory. Well, not anymore with version 13c R2. I will walk you through an OPatch upgrade from 13.8 to 13.9 version. First export your agent ORACLE_HOME:
- [ORA-01503: CREATE CONTROLFILE failed on RMAN duplicate between RAC databases](https://alfredokriegdba.com/2017/01/10/ora-01503-create-controlfile-failed-on-rman-duplicate-between-rac-databases/) - It was while since I performed an RMAN duplicate from a RAC database to another RAC database. You may find this post useless as there’s a lot of information out there about the error I faced, but all my posts are kind of my own little diary. So, basically. In order to successfully duplicate one
- [OEM 13c New Features - Corrective Actions](https://alfredokriegdba.com/2017/01/04/oem-13c-new-features-corrective-actions/) - Today’s post is about another new feature of Oracle Enterprise Manager (OEM) 13c. Well, not a new feature itself but some awesome enhancements to Corrective Actions (CA). In this new release 13c several new CA types were added, including “Add Space To Tablespace”, “Chef Recipe” for those who like automation and now can be added
- [OEM 13c New Features - System Broadcast](https://alfredokriegdba.com/2016/12/31/oem-13c-new-features-system-broadcast/) - I can’t finish the year without a post about OEM 13c. I finally had some time to install it and from first hand go through its new features. I find this “System Broadcast” feature so useful, especially when you have tons of users using OEM. You can try to email users, give them a call
- [ORA-01555 query duration 0 seconds with Dataguard](https://alfredokriegdba.com/2016/12/18/ora-01555-query-duration-0-seconds-with-dataguard/) - How many times we have calls from users complaining about their process that failed due to an ORA-01555 error? We know that if the queries are not well tuned and they modify a lot of data, the image held in the UNDO Tablespace could not be consistent with the real data. But have you ever
- [CRS-2632: There are no more servers to try to place resource ‘resource_name’ on that would satisfy its placement policy](https://alfredokriegdba.com/2016/11/21/crs-2632-there-are-no-more-servers-to-try-to-place-resource-resource_name-on-that-would-satisfy-its-placement-policy/) - I just got this error from CRS while trying to start a database using srvctl. I find this error kind of missleading as the error doesn’t tell what is really happening with the resource. I suggest you to manually check the logs of the resource. In this case it had to do with a cluster
- [Tim Gorman is our guest speaker for September 30th NEOOUG's quarterly meeting.](https://alfredokriegdba.com/2016/09/22/tim-gorman-is-our-guest-speaker-for-september-30th-neoougs-quarterly-meeting/) - Tim currently works as a Technical Consultant at Delphix. Oracle ACE Director, Oak Table member and an advocate of the North East Ohio Oracle Users Group for many years. This time Tim brings two interesting sessions, “Split Brain Syndrome” and “Scaling To Infinity”. Join us for these sessions, have lunch and learn from one of
- [WAIT_FOR_GAP. How to restore missing archivelogs from backup?](https://alfredokriegdba.com/2016/09/17/wait_for_gap-how-to-restore-missing-archivelogs-from-backup/) - In a Dataguard configuration, Oracle’s RFS (Remote File Server) writes redo data to the standby. When for any reason it can’t write this data, MRP (Managed Recovery Process) will wait for the archivelog to be applied and have the status “WAIT_FOR_LOG”. This will lead the standby to be out-of-sync with the primary database. Sometimes some
- [OEM Agent Plug-in Testing](https://alfredokriegdba.com/2016/05/27/oem-agent-plug-in-testing/) - Today I want to write about Oracle Enterprise Manager (OEM) 12c plug-ins and how to test them. OEM is divided into two logical parts, the EM Platform and the EM Plug-ins. The EM Platform basically consists of the UI console, job system, metrics, EM agent, etc. The EM Plug-ins are modules that you can attach to
- [How to upgrade the RMAN recovery catalog to 12c?](https://alfredokriegdba.com/2016/04/15/how-to-upgrade-the-rman-recovery-catalog-to-12c/) - Some days back I faced an issue while trying to upgrade the RMAN recovery catalog to support 12c databases. RMAN> upgrade catalog; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-07539: insufficient privileges to create or upgrade the catalog schema The problem is that for 12c the catalog owner requires additional privileges.
- [ALTER SYSTEM in a RAC environment](https://alfredokriegdba.com/2016/04/10/alter-system-in-a-rac-environment/) - Few weeks ago I had to modify an instance parameter to a different value. In this case, I just wanted to modify it for only one instance and leave the other instance as it was. I thought that if I didn’t specify the instance name using the SID clause, the default is going to be
- [Why You Should Attend GLOC 2016?](https://alfredokriegdba.com/2016/03/31/why-you-should-attend-gloc-2016/) - This year’s Great Lakes Oracle Conference (GLOC) is going to be huge! I had the privilege to attend the GLOC 2014 and present in the GLOC 2015. The conference continues to bring most of the best Oracle experts to the Midwest, helping professionals and organizations to keep up to-date on products plus a great networking
- [Compression Advisor killed my database!](https://alfredokriegdba.com/2015/08/14/compression-advisor-killed-my-database/) - Over the weekend one of the databases hung due to the flash recovery area was 100% full. I noticed one J001 process consuming significant CPU and I/O resources. Turns out this process was the automatic segment advisor job that runs on the weekend maintenance window. The SQL executed was something like: CREATE TABLE .dbms_tabcomp_temp_uncmp TABLESPACE
- [Using repvfy to find problems in the OEM 12c repository](https://alfredokriegdba.com/2015/08/01/using-repvfy-to-find-problems-in-the-oem-12c-repository/) - The repvfy Kit is very useful when you are trying to diagnose a problem in OEM Cloud Control 12c. I noticed that some of the tasks from the dbms_scheduler weren’t running on time, hence creating a backlog in the repository. In order to get more information about this issue, you can make use of the
- [How do I open the pluggable database (PDB) when I start the container database (CDB)?](https://alfredokriegdba.com/2015/07/10/how-do-i-open-the-pluggable-database-pdb-when-i-start-the-container-database-cdb/) - If you’re running pluggable databases (multitenant) in Oracle 12c, you may wonder; how do I open the pluggable database (PDB) when I start the container database (CDB)? Well, really it depends on the 12c version you are running on. I will show you the options you have depending the version you are running. If you
- [Deploy multiple plug-ins at once using OEM 12.1.0.4 console](https://alfredokriegdba.com/2015/06/09/deploy-multiple-plug-ins-at-once-using-oem-12-1-0-4-console/) - Today’s post is about a neat Oracle EM 12c feature. I spoke in the past Collaborate 2015 about deploying multiple plug-ins at once using emcli to save time. I used emcli because the console didn’t have the option to do that. Guess what? the new release 12.1.0.4 has the option to do it from the
- [ORA-21780: Maximum number of object durations exceeded.](https://alfredokriegdba.com/2015/05/18/ora-21780-maximum-number-of-object-durations-exceeded/) - I noticed that the Oracle Enterprise Manager (OEM) repository database was throwing ORA-21780 errors every 10 seconds. This is what I found in the alertlog file: Mon May 11 17:51:56 2010 Errors in file /oracle_binaries/app/diag/rdbms/oem/OEM1/trace/OEM1_smon_12465.trc: ORA-21780: Maximum number of object durations exceeded. Errors in file /oracle_binaries/app/diag/rdbms/oem/OEM1/trace/OEM1_smon_12465.trc: ORA-21780: Maximum number of object durations exceeded. Now looking
- [Oracle Enterprise Manager Webinar](https://alfredokriegdba.com/2015/04/30/oracle-enterprise-manager-webinar/) - This is the recorded presentation of the Oracle Enterprise Manager 12c @JoinSQL seminar held in Romania last month. Hope you find it interesting. Click Here!
- [Where did my day go?: Oracle Enterprise Manager 12c Administration. IOUG Collaborate 2015 slides](https://alfredokriegdba.com/2015/04/14/where-did-my-day-go-oracle-enterprise-manager-12c-administration-ioug-collaborate-2015-slides/) - I uploaded the slides of my IOUG's Collaborate presentation about OEM 12c. Click Here! Thanks, Alfredo
- [Stabilize Your Plans with SQL Plan Management Including 12c. IOUG Collaborate 2015 slides](https://alfredokriegdba.com/2015/04/14/stabilize-your-plans-with-sql-plan-management-including-12c-ioug-collaborate-2015-slides/) - I uploaded the slides of my IOUG's Collaborate presentation. Click here! Thanks, Alfredo
- [Free Database Seminar in Timisoara, Romania](https://alfredokriegdba.com/2015/04/02/free-database-seminar-in-timisoara-romania/) - Today I want to talk about a free Database Seminar that ACI is sponsoring in Timisoara, Romania. A friend of mine and former co-worker asked me to speak in the seminar about Oracle Enterprise Manager Administration. Because of the Time zone’s differences, I’m going to make a recording of the presentation and upload it to
- [RMAN jobs not working after OEM upgrade to 12.1.0.4](https://alfredokriegdba.com/2015/04/01/rman-jobs-not-working-after-oem-upgrade-to-12-1-0-4/) - If you are planning to upgrade your OEM to 12.1.0.4 and you have RMAN jobs scheduled in Cloud Control, you should consider applying patch 19519190 to the OMS. I noticed that most of the RMAN jobs were having issues and even worst, some steps were empty!!! Obviously, the jobs were succeeding as the step is
- [Using OMS DEBUG mode to troubleshoot OEM 12c problems](https://alfredokriegdba.com/2015/03/26/using-oms-debug-mode-to-troubleshoot-oem-12c-problems/) - This time, I want to show you how to troubleshoot OEM problems by enabling DEBUG mode in the OMS. The virtual machine (VM) running my sandbox installation of OEM 12c 12.1.0.4 crashed during the night. After restarting the VM and all the OEM components, I wasn’t able to login using the SYSMAN account. The error
- [OEM 12c very slow after upgrade to 12.1.0.4](https://alfredokriegdba.com/2015/03/22/oem-12c-very-slow-after-upgrade-to-12-1-0-4/) - I noticed that OEM 12c console was very slow a few hours after the upgrade to 12.1.0.4 version. Looking at the repository DB, found several OMS sessions consuming significant CPU resources. Bug 19199023 explains that some SQL queries executed against the repository consume high CPU on the servers. This bug affects the DB plug-in 12.1.0.6
- [Cannot start ASM - ORA-15063: ASM discovered an insufficient number of disks for diskgroup “DATA”](https://alfredokriegdba.com/2015/03/11/cannot-start-asm-ora-15063-asm-discovered-an-insufficient-number-of-disks-for-diskgroup-data/) - Today, I faced and issue with an ASM instance. After bouncing the server, CRS went up along with the ASM instance, but the diskgroups were offline. $ crsctl status resource -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE OFFLINE hosta ora.FRA.dg ONLINE OFFLINE hosta ora.LISTENER.lsnr ONLINE ONLINE
- [Understanding Oracle SQL Plan Management SPM – Part 3](https://alfredokriegdba.com/2015/02/27/understanding-oracle-sql-plan-management-spm-part-3/) - This is the third post of SQL Plan Management. In the previous post, Understanding SQL Plan Management– Part 2, I described the three main components of SPM, this time I want to show you how to manually capture plans from the cursor cache. In other words, manually capture plans that reside in memory. In order to
- [Understanding Oracle SQL Plan Management SPM – Part 2](https://alfredokriegdba.com/2015/02/18/understanding-oracle-sql-plan-management-spm-part-2/) - In my previous post Understanding SQL Plan Management – Part 1, I tried to cover some basic concepts of SQL Plan Management (SPM). This post will show you the main components of SPM and how they work in the different versions of Oracle. SQL plan management framework has three main components, plan capture, plan
- [Understanding Oracle SQL Plan Management SPM – Part 1](https://alfredokriegdba.com/2015/02/16/understanding-oracle-sql-plan-management-spm-part-1/) - This time I want to talk about SQL Plan Management, explain how this feature works and how to make the best use of it. As is a very extensive topic I will split it in three posts. Introduction The Oracle Cost Based Optimizer (CBO) introduced in Oracle version 7. It determines the most efficient way
- [Why you should attend to IOUG Collaborate 2015?](https://alfredokriegdba.com/2015/02/13/why-you-should-attend-to-ioug-collaborate-2015/) - Today I want to share a personal story about IOUG’s Collaborate, a great conference that supports products from Engineered Systems, Oracle Databases to Fusion Middleware and Siebel. Last year was my first time as a speaker and was one of kind experience as I was able to share my knowledge in Oracle Database performance tuning
- [Oracle Enterprise Manager Security– Disable SYSMAN access](https://alfredokriegdba.com/2014/12/31/oracle-enterprise-manager-security-disable-sysman-access/) - In Enterprise Manager 12c SYSMAN user is the schema owner and as a best practice all the users should log in using their own individual accounts. To enforce this you can prevent SYSMAN from login into the console and/or emcli by setting SYSTEM_USER to -1 in the MGMT_CREATED_USERS table: UPDATE MGMT_CREATED_USERS SET SYSTEM_USER=’-1’ WHERE user_name=’SYSMAN’
- [Oracle Enterprise Manager – Reducing the noise, Part 1](https://alfredokriegdba.com/2014/07/27/oracle-enterprise-manager-reducing-the-noise-part-1/) - Enterprise Manager 12c is a great monitoring tool, with it you can monitor a wide range of target types from databases to middleware; although out-of-the-box metrics can suit your monitoring requirements they can generate a considerable amount of white noise. In order to reduce this noise first you have to identify which are the top
- [Upgrade Oracle Enterprise Manager to 12.1.0.4](https://alfredokriegdba.com/2014/06/14/upgrade-oracle-enterprise-manager-to-12-1-0-4/) - Enterprise Manager 12.1.0.4 was just released and now is time to test and document the process. The official documentation can be obtained from here (http://docs.oracle.com/cd/E24628_01/upgrade.121/e22625/upgrading_12101_PS1_gtgstrtd.htm) and this document cover the steps I followed and may not work on yours (I’m not responsible of any issues/problems caused to your system). This document covers Oracle Enterprise Manager
- [Oracle Recursive Sessions ORA-00018](https://alfredokriegdba.com/2014/06/02/oracle-recursive-sessions-ora-00018/) - Today I want to talk about Oracle Database session usage; last week there was a problem with a database reporting ORA-00018: maximum number of sessions exceeded, but the number of sessions from v$session was much less than the one specified in SESSIONS parameter. So, what was going on? Turns out this is explained by internal
- [IOUG Collaborate 2014, final presentation](https://alfredokriegdba.com/2014/04/09/ioug-collaborate-2014-final-presentation/) - Today I want to share with you the final presentation of session 553 that I'm going to hold tomorrow morning in the IOUG Collaborate 2014. Hope you enjoy it! 2014_553_Krieg_ppt.pdf
- [Extract AWR data to build Response Time graphs (awrrtsys.sql)](https://alfredokriegdba.com/2014/02/17/extract-awr-data-to-build-response-time-graphs-awrrtsys-sql/) - This SQL script extract AWR data required to perform Response Time analysis for Oracle Databases. All information about it will be presented in the IOUG Collaborate 2014 session “553: Oracle Database Performance: Are Database Users Telling Me The Truth?” --#******************************************************************** --#-- Filename : awrrtsys.sql --#-- Author : Alfredo Krieg --#-- Original : 17-Oct-12 --#-- Last
- [Oracle Enterprise Manager 12c Release 3 New Features](https://alfredokriegdba.com/2013/09/09/oracle-enterprise-manager-12c-release-3-new-features/) - Today I will talk about some new features in the release 3 of the Oracle Enterprise Manager. All Metrics Chart Enhancements This new feature show more data in the metrics page, like minimum and maximum values, it will highlight periods when the agent was unreachable or target was down, it will also show the period
- [Understanding Oracle Histograms](https://alfredokriegdba.com/2013/08/30/understanding-oracle-histograms/) - Histograms are a feature of the Cost Based Optimizer (CBO) that helps to know the data distribution in a column. Histograms should be created in columns with highly skew data and are included in the filter clause (WHERE) of a SQL statement. Histograms play a very important role in the creation of the execution plan
- [MRP0: Background Media Recovery terminated with error 1237](https://alfredokriegdba.com/2013/08/26/mrp0-background-media-recovery-terminated-with-error-1237/) - Some days back checking an Oracle physical standby database found that the DB was some hours back than the primary database. alter session set nls_date_format='DD-MM-yyyy HH24:MI:SS'; show parameter dest select thread#,max(sequence#) from gv$log_history group by thread#; select (a.amct-b.bmct)*24 "Hours Standby is Behind: " from (select max(completion_time) amct from v$archived_log) a, (select max(completion_time) bmct from v$archived_log
- [Testing user calls](https://alfredokriegdba.com/2013/08/06/testing-user-calls/) - In the performance tuning world specially talking about Response Time Analysis (RTA), user calls is often used as a workload metric; however this instance statistic was not yet completely clear. When this metric is incremented?, How this metric is instrumented?, Why sometimes user calls is less with the same SQL statement?; these were some questions
- [Oracle 12c ASM new features](https://alfredokriegdba.com/2013/07/26/oracle-12c-asm-new-features/) - Today I will talk about some new features for ASM on 12c version. Oracle Flex ASM Oracle Flex ASM is a set of new features that provide critical capabilities required for cloud computing. Oracle Flex ASM redefines the traditional ASM cluster architecture of having one ASM instance on every node in the cluster; this means
- [Why my new Disk Group is not getting mounted automatically when ASM instance starts?](https://alfredokriegdba.com/2013/06/13/why-my-new-disk-group-is-not-getting-mounted-automatically-when-asm-instance-starts/) - Today I faced the issue that a new ASM Disk Group created in instance +ASM1 is not getting automatically mounted in instance +ASM2. The first step was to check DB dependencies: [oracle@ol5-112-rac2 trace]$ srvctl config database -d RAC Database unique name: RAC Database name: RAC Oracle home: /u01/app/oracle/product/11.2.0/db_1 Oracle user: oracle Spfile: +DATA/RAC/spfileRAC.ora Domain: localdomain
- [ORA-15097: cannot SHUTDOWN ASM instance with connected client](https://alfredokriegdba.com/2013/06/13/ora-15097-cannot-shutdown-asm-instance-with-connected-client/) - In 11g R2 Clusterware configurations the OCR is located in ASM disk, that’s why ASM can’t be shutdown while the cluster is running. You have to shutdown your cluster in order to shutdown ASM instance. Oracle support note 984663.1 Here’s a good blog about this: http://divakarmehta.wordpress.com/2012/04/19/how-crs-accesses-ocr-in-oracle-asm-during-11-2-grid-infra-rac-startup/ Example, how to shutdown ASM instance on node ol5-112-rac1: [oracle@ol5-112-rac1 ~]$
- [Hands on practice ASM](https://alfredokriegdba.com/2013/06/10/hands-on-practice-asm/) - Today I want to share with you an ASM exercise which includes how to add an additional disk to our VM RAC nodes, prepare the disk, add the disk to ASM configuration and create a new diskgroup using this disk.The very first step is to have our VM machines turned off. Then go into your
- [GoldenGate 11G Install on Linux x86](https://alfredokriegdba.com/2013/06/08/goldengate-11g-install-on-linux-x86/) - Today I will show you how to install GoldenGate under Linux 5.5 following the recipe of my teammate Gleb. (http://www.pythian.com/blog/oracle-goldengate-installation-part-1/) Prerequisites: · Oracle Linux 5.5 installed in 2 VM using VirtualBox, I have used one pre-built VM from Oracle (http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html) · Download Oracle GoldenGate software from (http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html) · Start both VM machines and change the
- [Why the execution plan changed? Case study](https://alfredokriegdba.com/2013/05/03/why-the-execution-plan-changed-case-study/) - Overview At some point in time the execution plan of the SQL_ID etp65bryqtd2d changed. The new execution plan drops on performance from an Avg. of 0.01 seconds per execution to an Avg. of 1.5 seconds per execution. This increase on elapsed time per execution provoke that the application can’t process work orders fast enough, the
- [CRSCTL command examples](https://alfredokriegdba.com/2013/04/13/crsctl-command-examples/) - CRSCTL is an interface between you and Oracle Clusterware, parsing and calling Oracle Clusterware APIs for Oracle Clusterware objects. Oracle Clusterware 11g release 2 (11.2) introduces cluster-aware commands with which you can perform check, start, and stop operations on the cluster. You can run these commands from any node in the cluster on another node
- [Basic Clusterware Administration Commands](https://alfredokriegdba.com/2013/04/08/basic-clusterware-administration-commands/) - In the previous blog we talk about Oracle Clusterware basics and definitions. Now let's talk about basic administration commands. olsnodes The OLSNODES command provides the list of nodes and other information for all nodes participating in the cluster. The syntax for the OLSNODES command is: olsnodes [-n] [-i] [-l] [-v] [-g] [-p] If you issue the
- [Oracle Clusterware 11gR2 Basics](https://alfredokriegdba.com/2013/04/08/oracle-clusterware-11gr2-basics/) - In this blog will talk about Oracle Clusterware basics. It is really needed to know the basics before we can start talking about Clusterware installation, configuration and administration. The below information is an extract from the Oracle Clusterware, Administration and Deployment Guide 11g Release 2 (11.2) (http://docs.oracle.com/cd/E14072_01/rac.112/e10717.pdf).What is Oracle Clusterware?Oracle Clusterware enables servers to communicate
- [Cleanup After Failed Installation Oracle Clusterware 11gR2](https://alfredokriegdba.com/2013/04/07/cleanup-after-failed-installation-oracle-clusterware-11gr2/) - In this blog I will talk about how to cleanup a failed installation of the Oracle Clusterware 11gR2 in one particular node. I was installing the new Oracle Clusterware 11.2.0.1 in my home lab by follwing Tom Kyte's instructions (http://www.oracle-base.com/articles/11g/oracle-db-11gr2-rac-installation-on-oel5-using-virtualbox.php#install_grid_infrastructure), then went through the part that the installer GUI needs us to run the root.sh
- [Historical SQL Statistics And Execution Plan Change](https://alfredokriegdba.com/2013/03/12/historical-sql-statistics-and-execution-plan-change/) - How many times have you received user's phone call stating that the DB is slow?, well sometimes this has nothing to do with the DB's overall performance itself, but with a user's query. Now the question is, is this query really slow?, the best way to find this out is comparing the actual execution time
- [Estadísticas históricas de SQL](https://alfredokriegdba.com/2012/10/10/estadisticas-historicas-de-sql/) - ¿Cuántas veces hemos recibido la llamada de un usuario indicando que la base de datos está lenta?, la mayoría de las veces no tiene que ver con el desempeño general de la base de datos, sino con la consulta que el usuario ha lanzado al RDBMS.De aquí surge la pregunta, ¿está la consulta (SELECT) lenta
- [Bienvenid@,](https://alfredokriegdba.com/2012/10/10/bienvenid/) - "hello, world" Utilizando la salida del famoso programa en C de Brian Kernighan, doy vida a este Blog, el cual abarcará temas interesantes sobre problemas cotidianos y otros no tantos sobre la administración y configuración del RDBMS de Oracle. ¿Quién soy yo? Mi nombre es Alfredo Krieg, llevo más de 6 años administrando bases de

## Pages

- [Welcome to my blog!](https://alfredokriegdba.com/) - IT Blog
- [About Me...](https://alfredokriegdba.com/about-me/) - Disclaimer: "The views expressed on this blog are my own and do not necessarily reflect the views of Oracle." Howdy, y'all! I still remember those old days at college. Trying to figure it out how to install Oracle 8i on Linux for a final project, spending endless nights reading for a test. Many, many moons
- [Sample Page](https://alfredokriegdba.com/sample-page/) - This is an example page. It's different from a blog post because it will stay in one place and will show up in your site navigation (in most themes). Most people start with an About page that introduces them to potential site visitors. It might say something like this: Hi there! I'm a bike messenger
- [Sample Page](https://alfredokriegdba.com/sample-page-2/) - This is an example page. It's different from a blog post because it will stay in one place and will show up in your site navigation (in most themes). Most people start with an About page that introduces them to potential site visitors. It might say something like this: Hi there! I'm a bike messenger

## Categories

- [Uncategorized](https://alfredokriegdba.com/category/uncategorized/)
- [Oracle Enterprise Manager](https://alfredokriegdba.com/category/oracle-em/) - Oracle Enterprise Manager related posts
- [Oracle Observability & Management](https://alfredokriegdba.com/category/oracle-observability-management/)
- [AI](https://alfredokriegdba.com/category/ai/)

## Tags

- [10053](https://alfredokriegdba.com/tag/10053/)
- [11g](https://alfredokriegdba.com/tag/11g/)
- [12.1.0.4](https://alfredokriegdba.com/tag/12-1-0-4/)
- [12.2](https://alfredokriegdba.com/tag/12-2/)
- [12.2 features](https://alfredokriegdba.com/tag/12-2-features/)
- [12.2.4](https://alfredokriegdba.com/tag/12-2-4/)
- [12c](https://alfredokriegdba.com/tag/12c/)
- [13c](https://alfredokriegdba.com/tag/13c/)
- [19c](https://alfredokriegdba.com/tag/19c/)
- [25105555](https://alfredokriegdba.com/tag/25105555/)
- [ADOP](https://alfredokriegdba.com/tag/adop/)
- [ADW](https://alfredokriegdba.com/tag/adw/)
- [Agent](https://alfredokriegdba.com/tag/agent/)
- [alerts](https://alfredokriegdba.com/tag/alerts/)
- [ALTER](https://alfredokriegdba.com/tag/alter/)
- [Amazon's RDS](https://alfredokriegdba.com/tag/amazons-rds/)
- [AMP](https://alfredokriegdba.com/tag/amp/)
- [Ansible](https://alfredokriegdba.com/tag/ansible/)
- [April](https://alfredokriegdba.com/tag/april/)
- [ASM](https://alfredokriegdba.com/tag/asm/)
- [ASMB](https://alfredokriegdba.com/tag/asmb/)
- [ATP](https://alfredokriegdba.com/tag/atp/)
- [Automation](https://alfredokriegdba.com/tag/automation/)
- [Autonomous](https://alfredokriegdba.com/tag/autonomous/)
- [AWR](https://alfredokriegdba.com/tag/awr/)
- [Azure](https://alfredokriegdba.com/tag/azure/)
- [Bare Metal](https://alfredokriegdba.com/tag/bare-metal/)
- [bind variable](https://alfredokriegdba.com/tag/bind-variable/)
- [Bitkode](https://alfredokriegdba.com/tag/bitkode/)
- [bug](https://alfredokriegdba.com/tag/bug/)
- [CATALOG](https://alfredokriegdba.com/tag/catalog/)
- [CBO](https://alfredokriegdba.com/tag/cbo/)
- [Cell Server](https://alfredokriegdba.com/tag/cell-server/)
- [Cloud](https://alfredokriegdba.com/tag/cloud/)
- [Cloud Agent](https://alfredokriegdba.com/tag/cloud-agent/)
- [Clusterware](https://alfredokriegdba.com/tag/clusterware/)
- [Collaborate](https://alfredokriegdba.com/tag/collaborate/)
- [Collaborate 2019](https://alfredokriegdba.com/tag/collaborate-2019/)
- [commands](https://alfredokriegdba.com/tag/commands/)
- [Conference](https://alfredokriegdba.com/tag/conference/)
- [Consolidation](https://alfredokriegdba.com/tag/consolidation/)
- [corrective actions](https://alfredokriegdba.com/tag/corrective-actions/)
- [CRS](https://alfredokriegdba.com/tag/crs/)
- [CRS-2632](https://alfredokriegdba.com/tag/crs-2632/)
- [CRSCTL](https://alfredokriegdba.com/tag/crsctl/)
- [cursor](https://alfredokriegdba.com/tag/cursor/)
- [Dashboards](https://alfredokriegdba.com/tag/dashboards/)
- [Data Collector](https://alfredokriegdba.com/tag/data-collector/)
- [Database](https://alfredokriegdba.com/tag/database/)
- [dataguard](https://alfredokriegdba.com/tag/dataguard/)
- [DB](https://alfredokriegdba.com/tag/db/)
- [DB Plugin](https://alfredokriegdba.com/tag/db-plugin/)
- [DBA](https://alfredokriegdba.com/tag/dba/)
- [DBLM](https://alfredokriegdba.com/tag/dblm/)
- [DBMS_STATS](https://alfredokriegdba.com/tag/dbms_stats/)
- [DevOps](https://alfredokriegdba.com/tag/devops/)
- [Diskgroup](https://alfredokriegdba.com/tag/diskgroup/)
- [DOUG](https://alfredokriegdba.com/tag/doug/)
- [duplicate](https://alfredokriegdba.com/tag/duplicate/)
- [EBS](https://alfredokriegdba.com/tag/ebs/)
- [education](https://alfredokriegdba.com/tag/education/)
- [EM 13c](https://alfredokriegdba.com/tag/em-13c/)
- [EM12c](https://alfredokriegdba.com/tag/em12c/)
- [emcli](https://alfredokriegdba.com/tag/emcli/)
- [EMCTL](https://alfredokriegdba.com/tag/emctl/)
- [ETCC](https://alfredokriegdba.com/tag/etcc/)
- [Exadata](https://alfredokriegdba.com/tag/exadata/)
- [Exalogic](https://alfredokriegdba.com/tag/exalogic/)
- [Exdata](https://alfredokriegdba.com/tag/exdata/)
- [execution](https://alfredokriegdba.com/tag/execution/)
- [Execution Plan](https://alfredokriegdba.com/tag/execution-plan/)
- [explain plan](https://alfredokriegdba.com/tag/explain-plan/)
- [Extent](https://alfredokriegdba.com/tag/extent/)
- [Flash](https://alfredokriegdba.com/tag/flash/)
- [Flex](https://alfredokriegdba.com/tag/flex/)
- [GLOC](https://alfredokriegdba.com/tag/gloc/)
- [GoldenGate](https://alfredokriegdba.com/tag/goldengate/)
- [Grafana](https://alfredokriegdba.com/tag/grafana/)
- [Hints](https://alfredokriegdba.com/tag/hints/)
- [histograms](https://alfredokriegdba.com/tag/histograms/)
- [HomeBrew](https://alfredokriegdba.com/tag/homebrew/)
- [Index selectivity](https://alfredokriegdba.com/tag/index-selectivity/)
- [Install](https://alfredokriegdba.com/tag/install/)
- [Instance](https://alfredokriegdba.com/tag/instance/)
- [IOUG](https://alfredokriegdba.com/tag/ioug/)
- [JET](https://alfredokriegdba.com/tag/jet/)
- [Jobs](https://alfredokriegdba.com/tag/jobs/)
- [Linux](https://alfredokriegdba.com/tag/linux/)
- [log analytics](https://alfredokriegdba.com/tag/log-analytics/)
- [MacOS](https://alfredokriegdba.com/tag/macos/)
- [metrics](https://alfredokriegdba.com/tag/metrics/)
- [Migration](https://alfredokriegdba.com/tag/migration/)
- [Monitoring](https://alfredokriegdba.com/tag/monitoring/)
- [MRP](https://alfredokriegdba.com/tag/mrp/)
- [Multi-tenant](https://alfredokriegdba.com/tag/multi-tenant/)
- [MView](https://alfredokriegdba.com/tag/mview/)
- [NEOOUG](https://alfredokriegdba.com/tag/neooug/)
- [Network](https://alfredokriegdba.com/tag/network/)
- [new features](https://alfredokriegdba.com/tag/new-features/)
- [OCI](https://alfredokriegdba.com/tag/oci/)
- [OCR](https://alfredokriegdba.com/tag/ocr/)
- [OEM](https://alfredokriegdba.com/tag/oem/)
- [OEM 12c](https://alfredokriegdba.com/tag/oem-12c/)
- [OEM 13.3](https://alfredokriegdba.com/tag/oem-13-3/)
- [OEM 13.3 PG](https://alfredokriegdba.com/tag/oem-13-3-pg/)
- [OEM 13c](https://alfredokriegdba.com/tag/oem-13c/)
- [Ohio](https://alfredokriegdba.com/tag/ohio/)
- [OMC](https://alfredokriegdba.com/tag/omc/)
- [omcli](https://alfredokriegdba.com/tag/omcli/)
- [opatch](https://alfredokriegdba.com/tag/opatch/)
- [ORA-01503](https://alfredokriegdba.com/tag/ora-01503/)
- [ORA-01555](https://alfredokriegdba.com/tag/ora-01555/)
- [ORA-04045](https://alfredokriegdba.com/tag/ora-04045/)
- [ORA-15063](https://alfredokriegdba.com/tag/ora-15063/)
- [ORA-15097](https://alfredokriegdba.com/tag/ora-15097/)
- [ORA-21780](https://alfredokriegdba.com/tag/ora-21780/)
- [ORA-600](https://alfredokriegdba.com/tag/ora-600/)
- [Oracle](https://alfredokriegdba.com/tag/oracle/)
- [Oracle 12](https://alfredokriegdba.com/tag/oracle-12/)
- [Oracle Cloud](https://alfredokriegdba.com/tag/oracle-cloud/)
- [Oracle EM 13.5](https://alfredokriegdba.com/tag/oracle-em-13-5/)
- [Oracle EM 13c](https://alfredokriegdba.com/tag/oracle-em-13c/)
- [Oracle. performance](https://alfredokriegdba.com/tag/oracle-performance/)
- [oradebug](https://alfredokriegdba.com/tag/oradebug/)
- [Outlines](https://alfredokriegdba.com/tag/outlines/)
- [Passthru](https://alfredokriegdba.com/tag/passthru/)
- [Patch](https://alfredokriegdba.com/tag/patch/)
- [patching](https://alfredokriegdba.com/tag/patching/)
- [PDB](https://alfredokriegdba.com/tag/pdb/)
- [PDM](https://alfredokriegdba.com/tag/pdm/)
- [Performance](https://alfredokriegdba.com/tag/performance/)
- [plan](https://alfredokriegdba.com/tag/plan/)
- [plugins](https://alfredokriegdba.com/tag/plugins/)
- [presentation. collaborate](https://alfredokriegdba.com/tag/presentation-collaborate/)
- [PSU](https://alfredokriegdba.com/tag/psu/)
- [RAC](https://alfredokriegdba.com/tag/rac/)
- [repvfy](https://alfredokriegdba.com/tag/repvfy/)
- [Response Time](https://alfredokriegdba.com/tag/response-time/)
- [resumable](https://alfredokriegdba.com/tag/resumable/)
- [RMAN](https://alfredokriegdba.com/tag/rman/)
- [RU 3](https://alfredokriegdba.com/tag/ru-3/)
- [security](https://alfredokriegdba.com/tag/security/)
- [Seminar](https://alfredokriegdba.com/tag/seminar/)
- [sessions](https://alfredokriegdba.com/tag/sessions/)
- [SID](https://alfredokriegdba.com/tag/sid/)
- [SMART IO](https://alfredokriegdba.com/tag/smart-io/)
- [Snap Clone](https://alfredokriegdba.com/tag/snap-clone/)
- [SPA](https://alfredokriegdba.com/tag/spa/)
- [SPM](https://alfredokriegdba.com/tag/spm/)
- [SQL](https://alfredokriegdba.com/tag/sql/)
- [SQL Developer](https://alfredokriegdba.com/tag/sql-developer/)
- [SQL ID](https://alfredokriegdba.com/tag/sql-id/)
- [SQL Patch](https://alfredokriegdba.com/tag/sql-patch/)
- [standby](https://alfredokriegdba.com/tag/standby/)
- [statistics](https://alfredokriegdba.com/tag/statistics/)
- [system_broadcast](https://alfredokriegdba.com/tag/system_broadcast/)
- [Tablespace](https://alfredokriegdba.com/tag/tablespace/)
- [trace](https://alfredokriegdba.com/tag/trace/)
- [Tuning](https://alfredokriegdba.com/tag/tuning/)
- [TXK](https://alfredokriegdba.com/tag/txk/)
- [upgrade](https://alfredokriegdba.com/tag/upgrade/)
- [user calls](https://alfredokriegdba.com/tag/user-calls/)
- [Validation](https://alfredokriegdba.com/tag/validation/)
- [VCN](https://alfredokriegdba.com/tag/vcn/)
- [VirtualBox](https://alfredokriegdba.com/tag/virtualbox/)
- [VM](https://alfredokriegdba.com/tag/vm/)
- [webinar Oracle](https://alfredokriegdba.com/tag/webinar-oracle/)
- [LiveLabs](https://alfredokriegdba.com/tag/livelabs/)
- [DBaaS](https://alfredokriegdba.com/tag/dbaas/)
- [docker](https://alfredokriegdba.com/tag/docker/)
- [ExaCC](https://alfredokriegdba.com/tag/exacc/)
- [Monitor](https://alfredokriegdba.com/tag/monitor/)
- [O&M](https://alfredokriegdba.com/tag/om/)
- [Custom Metric](https://alfredokriegdba.com/tag/custom-metric/)
- [REST APIs](https://alfredokriegdba.com/tag/rest-apis/)
- [MySQL](https://alfredokriegdba.com/tag/mysql/)
- [24ai](https://alfredokriegdba.com/tag/24ai/)
- [what's new](https://alfredokriegdba.com/tag/whats-new/)
- [EM 24ai](https://alfredokriegdba.com/tag/em-24ai/)
- [vector](https://alfredokriegdba.com/tag/vector/)
- [AI](https://alfredokriegdba.com/tag/ai/)
- [LangChain](https://alfredokriegdba.com/tag/langchain/)
- [Ollama](https://alfredokriegdba.com/tag/ollama/)