24Ai OEM installation on standalone database server 19.30 version

-

After installing OLE 7.9, install below things at OS level , then create Oracle Database 19c and Apply 19.26 or later patch.  ..


[oracle@oemrepo soft]$ /u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch version

OPatch Version: 12.2.0.1.49

OPatch succeeded.

[oracle@oemrepo soft]$

[oracle@oemrepo soft]$

[oracle@oemrepo soft]$

[oracle@oemrepo soft]$ ps -ef|grep smon

oracle    3750     1  0 13:13 ?        00:00:00 ora_smon_orcl

oracle    5258  4890  0 13:27 pts/1    00:00:00 grep --color=auto smon

[oracle@oemrepo soft]$ . oraenv

ORACLE_SID = [oracle] ? orcl

The Oracle base has been set to /u01/app/oboseracle

[oracle@oemrepo soft]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 7 13:27:32 2026

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0


SQL> shut immediate


orcl:/u01/app/oracle/product/19.3.0/dbhome_1:N

[oracle@oemrepo soft]$ export ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1

[oracle@oemrepo soft]$ export PATH=$PATH:$ORALE_HOME/OPatch

[oracle@oemrepo soft]$ pwd

/u01/soft

[oracle@oemrepo soft]$ ls -ltr

total 2298392

-rwxrwxr-x. 1 oracle oinstall   72896144 Feb  7 05:58 p6880880_190000_Linux-x86-64.zip

-rwxrwxr-x. 1 oracle oinstall 2280656539 Feb  7 13:23 p38632161_190000_Linux-x86-64.zip

[oracle@oemrepo soft]$ unzip p38632161_190000_Linux-x86-64.zip


[oracle@oemrepo ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH

[oracle@oemrepo ~]$ cd /u01/soft/38632161/

[oracle@oemrepo 38632161]$ ls

custom  etc  files  README.html  README.txt

[oracle@oemrepo 38632161]$ opatch version

OPatch Version: 12.2.0.1.49


OPatch succeeded.

[oracle@oemrepo 38632161]$ opatch apply

Oracle Interim Patch Installer version 12.2.0.1.49

Copyright (c) 2026, Oracle Corporation.  All rights reserved.



Oracle Home       : /u01/app/oracle/product/19.3.0/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/19.3.0/dbhome_1/oraInst.loc

OPatch version    : 12.2.0.1.49

OUI version       : 12.2.0.7.0

Log file location : /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2026-02-07_13-35-58PM_1.log


Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   38632161


Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.


Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/oracle/product/19.3.0/dbhome_1')



Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files...

Applying interim patch '38632161' to OH '/u01/app/oracle/product/19.3.0/dbhome_1'

ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.crypto.rsf, 19.0.0.0.0 ] , [ oracle.datamining, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.pg4appc, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.precomp.companion, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 19.0.0.0.0 ] , [ oracle.sdo.companion, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 19.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 19.0.0.0.0 ] , [ oracle.options.olap.api, 19.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.options.olap, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.pg4mq, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.java.sqlj.sqljruntime, 19.0.0.0.0 ] , [ oracle.datamining, 19.0.0.0.0 ] , [ oracle.xdk.companion, 19.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 19.0.0.0.0 ] , [ oracle.ldap.ztk, 19.0.0.0.0 ] , [ oracle.ons.cclient, 19.0.0.0.0 ] , [ oracle.oid.client, 19.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 19.0.0.0.0 ] , [ oracle.jdk, 1.8.0.191.0 ] , [ oracle.jdk, 1.8.0.391.11 ]  not present in the Oracle Home or a higher version is found.


Patching component oracle.rdbms.rsf, 19.0.0.0.0...


Patching component oracle.rdbms, 19.0.0.0.0...


Patching component oracle.rdbms.util, 19.0.0.0.0...


Patching component oracle.assistants.acf, 19.0.0.0.0...


Patching component oracle.assistants.deconfig, 19.0.0.0.0...


Patching component oracle.assistants.server, 19.0.0.0.0...


Patching component oracle.blaslapack, 19.0.0.0.0...


Patching component oracle.buildtools.rsf, 19.0.0.0.0...


Patching component oracle.ctx, 19.0.0.0.0...


Patching component oracle.dbdev, 19.0.0.0.0...


Patching component oracle.dbjava.ic, 19.0.0.0.0...


Patching component oracle.dbjava.jdbc, 19.0.0.0.0...


Patching component oracle.dbjava.ucp, 19.0.0.0.0...


Patching component oracle.duma, 19.0.0.0.0...


Patching component oracle.javavm.client, 19.0.0.0.0...


Patching component oracle.ldap.client, 19.0.0.0.0...


Patching component oracle.ldap.owm, 19.0.0.0.0...


Patching component oracle.ldap.rsf, 19.0.0.0.0...


Patching component oracle.ldap.security.osdt, 19.0.0.0.0...


Patching component oracle.marvel, 19.0.0.0.0...


Patching component oracle.network.rsf, 19.0.0.0.0...


Patching component oracle.odbc.ic, 19.0.0.0.0...


Patching component oracle.ons, 19.0.0.0.0...


Patching component oracle.ons.ic, 19.0.0.0.0...


Patching component oracle.oracore.rsf, 19.0.0.0.0...


Patching component oracle.perlint, 5.28.1.0.0...


Patching component oracle.precomp.common.core, 19.0.0.0.0...


Patching component oracle.precomp.rsf, 19.0.0.0.0...


Patching component oracle.rdbms.crs, 19.0.0.0.0...


Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...


Patching component oracle.rdbms.deconfig, 19.0.0.0.0...


Patching component oracle.rdbms.install.common, 19.0.0.0.0...


Patching component oracle.rdbms.oci, 19.0.0.0.0...


Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0...


Patching component oracle.rdbms.scheduler, 19.0.0.0.0...


Patching component oracle.rhp.db, 19.0.0.0.0...


Patching component oracle.rsf, 19.0.0.0.0...


Patching component oracle.sdo, 19.0.0.0.0...


Patching component oracle.sdo.locator.jrf, 19.0.0.0.0...


Patching component oracle.sqlj.sqljruntime, 19.0.0.0.0...


Patching component oracle.sqlplus, 19.0.0.0.0...


Patching component oracle.sqlplus.ic, 19.0.0.0.0...


Patching component oracle.tfa.db, 19.0.0.0.0...


Patching component oracle.wwg.plsql, 19.0.0.0.0...


Patching component oracle.xdk.rsf, 19.0.0.0.0...


Patching component oracle.xdk.parser.java, 19.0.0.0.0...


Patching component oracle.rdbms.lbac, 19.0.0.0.0...


Patching component oracle.ldap.ssl, 19.0.0.0.0...


Patching component oracle.network.aso, 19.0.0.0.0...


Patching component oracle.xdk, 19.0.0.0.0...


Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0...


Patching component oracle.odbc, 19.0.0.0.0...


Patching component oracle.rdbms.rat, 19.0.0.0.0...


Patching component oracle.rdbms.dv, 19.0.0.0.0...


Patching component oracle.oraolap.dbscripts, 19.0.0.0.0...


Patching component oracle.rdbms.hs_common, 19.0.0.0.0...


Patching component oracle.ldap.rsf.ic, 19.0.0.0.0...


Patching component oracle.oraolap, 19.0.0.0.0...


Patching component oracle.install.deinstalltool, 19.0.0.0.0...


Patching component oracle.mgw.common, 19.0.0.0.0...


Patching component oracle.rdbms.rman, 19.0.0.0.0...


Patching component oracle.xdk.server, 19.0.0.0.0...


Patching component oracle.oraolap.api, 19.0.0.0.0...


Patching component oracle.rdbms.hsodbc, 19.0.0.0.0...


Patching component oracle.ctx.atg, 19.0.0.0.0...


Patching component oracle.nlsrtl.rsf, 19.0.0.0.0...


Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0...


Patching component oracle.nlsrtl.rsf.ic, 19.0.0.0.0...


Patching component oracle.sqlj.sqljruntime, 19.0.0.0.0...


Patching component oracle.wwg.plsql, 19.0.0.0.0...


Patching component oracle.network.client, 19.0.0.0.0...


Patching component oracle.dbtoolslistener, 19.0.0.0.0...


Patching component oracle.rdbms.install.plugins, 19.0.0.0.0...


Patching component oracle.ctx.rsf, 19.0.0.0.0...


Patching component oracle.nlsrtl.rsf.lbuilder, 19.0.0.0.0...


Patching component oracle.rdbms.drdaas, 19.0.0.0.0...


Patching component oracle.sdo.locator, 19.0.0.0.0...


Patching component oracle.rdbms.locator, 19.0.0.0.0...


Patching component oracle.network.listener, 19.0.0.0.0...


Patching component oracle.ovm, 19.0.0.0.0...


Patching component oracle.javavm.server, 19.0.0.0.0...


Patching component oracle.xdk.xquery, 19.0.0.0.0...


Patching component oracle.precomp.common, 19.0.0.0.0...


Patching component oracle.precomp.lang, 19.0.0.0.0...


Patching component oracle.jdk, 1.8.0.201.0...

Patch 38632161 successfully applied.

Sub-set patch [29517242] has become inactive due to the application of a super-set patch [38632161].

Please refer to Doc ID 2161861.1 for any possible further required actions.

Log file location: /u01/app/oracle/product/19.3.0/dbhome_1/cfgtoollogs/opatch/opatch2026-02-07_13-35-58PM_1.log


OPatch succeeded.

[oracle@oemrepo 38632161]$ ll

[oracle@oemrepo 38632161]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 7 13:40:25 2026
Version 19.30.0.0.0

Copyright (c) 1982, 2025, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 6207565976 bytes
Fixed Size                  9191576 bytes
Variable Size            1056964608 bytes
Database Buffers         5133828096 bytes
Redo Buffers                7581696 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.30.0.0.0

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB                            READ WRITE YES
SQL>
SQL>
SQL>  alter pluggable database PDB save state;

Pluggable database altered.


[oracle@oemrepo 38632161]$
[oracle@oemrepo 38632161]$
[oracle@oemrepo 38632161]$
[oracle@oemrepo 38632161]$
[oracle@oemrepo 38632161]$ cd $ORACLE_HOME/
[oracle@oemrepo dbhome_1]$ cd OPatch/
[oracle@oemrepo OPatch]$ pwd
/u01/app/oracle/product/19.3.0/dbhome_1/OPatch
[oracle@oemrepo OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.30.0.0.0 Production on Sat Feb  7 13:41:29 2026
Copyright (c) 2012, 2026, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_10703_2026_02_07_13_41_29/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done

Note:  Datapatch will only apply or rollback SQL fixes for PDBs
       that are in an open state, no patches will be applied to closed PDBs.
       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
       (Doc ID 1585822.1)

Warning: PDB PDB is in mode MOUNTED and will be skipped.
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
  No interim patches found

Current state of release update SQL patches:
  Binary registry:
    19.30.0.0.0 Release_Update 260126024251: Installed
  PDB CDB$ROOT:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 07-FEB-26 11.05.02.675444 AM
  PDB PDB$SEED:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 07-FEB-26 11.10.06.375766 AM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED
    No interim patches need to be rolled back
    Patch 38632161 (Database Release Update : 19.30.0.0.260120(REL-JAN260130) (38632161)):
      Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.30.0.0.0 Release_Update 260126024251
    No interim patches need to be applied

Installing patches...



----------------------------------------------------------------------------------------------------------------------------


ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oemrepo.oracle.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

PDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oemrepo.oracle.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = PDB)
    )
  )

[oracle@oemrepo admin]$ lsnrctl reload ORCL

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 07-FEB-2026 14:03:21

Copyright (c) 1991, 2025, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oemrepo.oracle.com)(PORT=1521)))
The command completed successfully
[oracle@oemrepo admin]$ tnsping ORCL

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 07-FEB-2026 14:03:31

Copyright (c) 1997, 2025, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oemrepo.oracle.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (0 msec)
[oracle@oemrepo admin]$ tnsping PDB

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 07-FEB-2026 14:03:36

Copyright (c) 1997, 2025, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oemrepo.oracle.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = PDB)))
OK (0 msec)
[oracle@oemrepo admin]$

Before install 24AI ..

wget http://www.netgull.com/gcc/releases/gcc-4.8.0/gcc-4.8.0.tar.bz2
wget https://buildlogs.centos.org/c7.00.02/gcc/20140529185856/4.8.2-16.el7.x86_64/gcc-c++-4.8.2-16.el7.x…
wget https://www.pbone.net/results_srodzaj_1_search_gcc.html
yum -y install gcc-c++
yum install -y glibc-devel.i686 krb5-devel
yum install compat-libstdc++-33.x86_64

vi /etc/sysctl.conf
    net.ipv4.ip_local_port_range = 11000 65000
:wq!

sysctl -p 

 

Below Parameters need to be updated at Database level

 

alter system set "_allow_insert_with_update_check"=true scope=both; 
alter system set session_cached_cursors=500 scope=spfile; 
alter system set shared_pool_size=1600M scope=spfile; 
alter system set processes=600 scope=spfile; 
alter system set sga_max_size=8G scope=spfile; 
alter system set sga_target=8G scope=spfile; 
alter system set pga_aggregate_target=1G scope=spfile;

 


[oracle@oemrepo 24AI-OEM]$ ./em24100_linux64.bin
Launcher log file is /tmp/OraInstall2026-02-07_02-12-25PM/launcher2026-02-07_02-12-25PM.log.
Extracting the installer . . . . . . . . . . . . . . . . . Done
Checking monitor: must be configured to display at least 256 colors.   Actual 16777216    Passed
Checking swap space: must be greater than 512 MB.   Actual 38145 MB    Passed
Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (-d64 flag is not required)
Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2026-02-07_02-12-25PM








This information is also available at: 

/u01/OMS/middleware/oms_home/install/setupinfo.txt

See the following for information pertaining to your Enterprise Manager installation:


Use the following URL to access:

1. Enterprise Manager Cloud Control URL: https://oemrepo.oracle.com:7803/em
2. Admin Server URL: https://oemrepo.oracle.com:7102/console

The following details need to be provided while installing an additional OMS:

1. Admin Server Host Name: oemrepo.oracle.com
2. Admin Server Port: 7102

You can find the details on ports used by this deployment at : /u01/OMS/middleware/oms_home/install/portlist.ini


 NOTE:
 An encryption key has been generated to encrypt sensitive data in the Management Repository. If this key is lost, all encrypted data in the Repository becomes unusable. 

 A backup of the OMS configuration is available in /u01/OMS/middleware/gc_inst/em/EMGC_OMS1/sysman/backup on host oemrepo.oracle.com. See Cloud Control Administrators Guide for details on how to back up and recover an OMS.

 NOTE: This backup is valid only for the initial OMS configuration. For example, it will not reflect plug-ins installed later, topology changes like the addition of a load balancer, or changes to other properties made using emctl or emcli. Backups should be created on a regular basis to ensure they capture the current OMS configuration. Use the following command to backup the OMS configuration:
/u01/OMS/middleware/oms_home/bin/emctl exportconfig oms -dir <backup dir> 









Comments

Post a Comment

Popular posts from this blog

MY NOTEPAD

-
set lines 200 pages 200; col END_TIME for a20; col ELAPSED_TIME for a25; col START_TIME for a20 SELECT T.SESSION_KEY, T.INPUT_TYPE, T.STATUS, T.SUM_BACKUP_PIECES_IN_GB, T.START_TIME, T.END_TIME, T.SECONDS ELAPSED_TIME FROM ( SELECT SESSION_KEY, INPUT_TYPE, STATUS, OUTPUT_BYTES/1024/1024/1024 SUM_BACKUP_PIECES_IN_GB, TO_CHAR (START_TIME, 'dd/mm/yyyy hh24:mi') START_TIME, TO_CHAR (END_TIME, 'dd/mm/yyyy hh24:mi') END_TIME, TIME_TAKEN_DISPLAY SECONDS FROM V$RMAN_BACKUP_JOB_DETAILS WHERE INPUT_TYPE='ARCHIVELOG' ORDER BY SESSION_KEY DESC) T WHERE ROWNUM <= 1; ================ ASM disk group free space ============== set sqlblanklines on set lines 180 set pages 999le col "Group Name" form a25 col "Disk Name" form a30 col "State" form a15 ...
Read more

Oracle OEM Holistic Patch

-
  Oracle OEM Holistic Patch  The Concept Starting with Oracle Enterprise Manager (OEM) 13.5 RU24 (October 2024), Oracle introduced the Holistic Patch for OEM — a unified patching model that consolidates several separate updates into a single coordinated package. Previously, administrators had to patch: * The OMS and Agents with the quarterly Release Update (RU). * OEM Application via the System Patch Bundle (SPB). * WebLogic CPU and JDK manually. There was an element of complication because of the need to keep the solution homogeneous. With the Holistic Patch, the last two steps are merged into a single patch bundle. Now we have a new Holistic patch for OEM that is released with each new OMS Release Update. Prerequisites Apply RU 24 Patch  PATCH 36761595  /later on all OMSes before applying Oct Holistic Patch   PATCH 37305292             (OR) Apply RU 25 Patch  PATCH 37057635  /later on all OMSes before applying ...
Read more

Upgrade Oracle 19c DB to 21c using Auto Upgrade utility inprogress

-
Image
  Upgrade Oracle 11g to 21c using AutoUpgrade utility: How do I upgrade Oracle database to 21c?  install the 21c oracle binaries into the server . Oracle Virtual Bix  Oracle Linux 7 Oracle Database 19c currently running Upgrading 19c database to 21c directly Oracle Database 19c on premises is available – and one of the key features is the new Auto Upgrade utility. In the following days I will publish several blog posts explaining and showcasing the new Auto Upgrade. What is the Auto Upgrade? The Oracle Database Auto Upgrade utility is a new tiny little command line tool which allows you to upgrade your databases in an unattended way. I call it the Hands-Free Upgrade. The new Auto Upgrade utility in Oracle 19che idea of the tool is to run the prechecks against multiple databases, fix 99% of the potential issues, set a restore point in case something goes wrong – and then upgrade your databases. And of course, do the post upgrade, recompilation and time zone adjustment. The...
Read more