foalabs

How to Move PDB datafiles  to ASM Disk Group Moving PDB related data files to ASM diskgroup.  PDB name: FUAT CDB name: funcdb The PDB will be moved to a ASM disk group called EBS_PDB. 1. Run a RMAN backup as copy to create data files copies in the destination diskgroup. RMAN> backup as copy pluggable database FUAT format '+EBS_PDB'; Starting backup at 22-MAR-22 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=141 device type=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: SID=877 device type=DISK allocated channel: ORA_DISK_3 channel ORA_DISK_3: SID=13 device type=DISK allocated channel: ORA_DISK_4 channel ORA_DISK_4: SID=137 device type=DISK channel ORA_DISK_1: starting datafile copy input datafile file number=00045 name=+DATA/FUNCDB/9CBA2DF91A8C7012E053F4071FAC36E9/DATAFILE/system.301.1063988727 channel ORA_DISK_2: starting datafile copy input datafile file number=00046 name=+DATA/FUNCDB/9CBA2DF91A...

Updating Linux Kernel and Security fixes Determine security-related updates or notices available ========================================================= [root@funebs122 ~]# yum updateinfo Last metadata expiration check: 2:44:27 ago on Sun 27 Mar 2022 09:17:43 PM +08. Updates Information Summary: available     202 Security notice(s)           4 Critical Security notice(s)          78 Important Security notice(s)         103 Moderate Security notice(s)          17 Low Security notice(s)     404 Bugfix notice(s)      67 Enhancement notice(s) or  On Linux 8 where dnf is available [root@funebs122 ~]# dnf updateinfo Last metadata expiration check: 2:47:11 ago on Sun 27 Mar 2022 09:17:43 PM +08. Updates Information Summary: available     202 Security notice(s)           4 Critical Security notice(s)       ...

What to do when Create Pluggable Database Using txkCreatePDB.pl PDB conversion failed Check the log file and solve the issue then perform below  Run convert_noncdb_to_pdb.sql and confirm it completes successfully    $ sqlplus /nolog @/oraapps122/DATABASE/FUAT/19c/appsutil/log/TXK_CREATE_PDB_Sun_Mar_20_18_16_48_2022/convert_noncdb_to_pdb.sql Once completed convert_noncdb_to_pdb.sql successfully, execute txkPostPDBCreationTasks.pl script as mentioned in Doc ID 2580629.1 or Doc ID 2552181.1 Note - Do not execute txkCreatePDB.pl again. If you like please follow and comment

Important Things to Know when working with EBS R12 on Multitenant Architecture 19c DB (CDB/PDB)   How does Oracle E-Business Suite support the multitenant architecture? Oracle E-Business Suite supports the multitenant architecture with a single CDB containing a single pluggable Oracle E-Business Suite database (PDB) in the following combinations: Oracle E-Business Suite 12.2.3 and later with Oracle Database 19c on-premises Oracle E-Business Suite 12.2.3 and later with Oracle Database 12cR1 VM DB Systems or Oracle Database 12cR1 in an Exadata DB System Oracle E-Business Suite 12.1.3 with Oracle Database 19c on-premises Oracle E-Business Suite 12.1.3 with Oracle Database 12cR1 VM DB Systems or Oracle Database 12cR1 in an Exadata DB System How many PDBs are supported in a CDB that is running Oracle E-Business Suite? At present, Oracle E-Business Suite supports a single PDB (single tenant) in a CDB. Are there additional licensing requirements? Oracle E-Business Suite currently supports...