Apps DBA Workshop

  Oracle Enterprise Manager 24ai  introduces powerful AI-driven capabilities that transform how organizations monitor and manage their Oracle environments. With integrated machine learning and AIOps , it enables intelligent anomaly detection, predictive analytics, and automated root cause analysis, reducing manual effort and improving operational efficiency. The addition of a natural language interface allows users to query system performance and issues conversationally, making management more accessible. Enterprise Manager 24ai also enhances observability, security, and hybrid cloud support , offering a unified platform to manage databases, middleware, applications, and infrastructure across on-premises and multi-cloud environments. The following are the key notable features provided by the OEM 24 ai release: OCI AI Cloud Extensions : Seamless integration with Oracle Cloud Infrastructure's Operations Insights services, including Capacity Planning and SQL Insights, enables p...

 The following Error was encountered when we tried starting up the database manually:   SQL> startup ORACLE instance started.   Total System Global Area 4.8694E+11 bytes Fixed Size                 37521640 bytes Variable Size            5.5298E+10 bytes Database Buffers         4.3111E+11 bytes Redo Buffers              499347456 bytes Database mounted. Database opened.         " was non-numeric Usage: { EXIT | QUIT }e [ SUCCESS | FAILURE | WARNING | n |        <variable> | :<bindvariable> ]  [ COMMIT | ROLLBACK ] Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.18.0.0...

I was Installing Oracle Database 12c on Oracle Solaris 11.2 and the pre-requisites for database Installation failed for SWAP memory requirement. The configured swap memory on the server is 1GB and the Physical memory of the server is 4GB. There should be at least 4GB of SWAP memory configured to avoid this error. This is article will help to Increase the SWAP memory of the system without any downtime. We can add additional SWAP memory online using zfs commands. - Identify the current volume using for SWAP: root@soltest1:~# swap -l swapfile dev swaplo blocks free /dev/zvol/dsk/rpool/swap 303,1 8 2097144 2097144 - Identify the size of the current SWAP space: root@soltest1:~# zfs get volsize rpool/swap NAME PROPERTY VALUE SOURCE rpool/swap volsize 1G local - Set new size for SWAP volume root@soltest1:~# zfs set volsize=5g rpool/swap root@soltest1:~# zfs get volsize rpool/swap NAME PROPERTY VAL...

I was installing Oracle 12.1.0.1 Database  software in a preparation of upgrading Oracle EBS R12.2 Database from version 11.2.0.3 to 12.1.0.1. When i started Installer from the stage location then it encountered error related to Inventory "[INS-21003] Installer has detected that an invalid inventory pointer location file was specified.." Error Stack from the Installation log file: INFO: Setting value for the property:id in the bean:configcmd INFO: Setting value for the property:platformcmdmap in the bean:configcmd INFO: Setting value for the property:id in the bean:configcmd INFO: Setting value for the property:platformcmdmap in the bean:configcmd INFO: Setting value for the property:id in the bean:configcmd INFO: Setting value for the property:platformcmdmap in the bean:configcmd INFO: Setting value for the property:id in the bean:configcmd INFO: Setting value for the property:platformcmdmap in the bean:configcmd INFO: Setting value for the property:configcmds in t...

Oracle Solaris 11.2 introduced new package in IPS  "oracle-rdbms-server-12cR1-preinstall". Users need to check all packages exists on the system before starting the Installation. This preinstall package was first introduced in Oracle Enterprise Linux and now available in Oracle Solaris 11.2. In Oracle Solaris 11.2  its very easy for administrators to install this package and they are not required to check dependencies/version of each and every package. For Installing "oracle-rdbms-server-12cR1-preinstall"  package your solaris IPS repository should be configured. IPS can be configured via Internet or can be configured on your local file system. For more information on configuring IPS locally please refer my earlier blogpost: Configure IPS on Oracle Solaris11.2 Locally Check for IPS repository publisher root@solaris11-2:~# pkg publisher PUBLISHER TYPE STATUS P LOCATION solaris origin online F file:///IPS/ roo...