Cloud Premigration Advisor Tool (CPAT) Analyzes Databases for Suitability of Cloud Migration (Doc ID 2758371.1)
Monday, 22 August 2022
Sunday, 21 August 2022
19c DB clone DBTechSTack - error - Exception String: Error in invoking target 'libasmclntsh19.ohso libasmperl19.ohso client_sharedlib' of makefile
Issue during ApplyTechStack in db tier during clone - While runnning DBTechSTack
Error in inventory log
make: *** [/vijapp/VIJ4/oracle/product/19c/rdbms/lib/ins_rdbms.mk:56: client_sharedlib] Error 1
Exception String: Error in invoking target 'libasmclntsh19.ohso libasmperl19.ohso client_sharedlib' of makefile '/vijapp/VIJ4/oracle/product/19c/rdbms/lib/ins_rdbms.mk'. See '/vijapp/VIJ4/oraInventory/logs/InstallActions2021-05-24_02-29-33AM/installActions2021-05-24_02-29-33AM.log' for details.
1) Below verified and was correct
rpm -q --whatprovides /usr/lib64/crti.o
glibc-devel-2.28-189.1.el8.x86_64
rpm -q --whatprovides /usr/lib64/libpthread_nonshared.a
glibc-devel-2.28-189.1.el8.x86_64
2) Check in make.log
running genclntsh...
genclntsh: genclntsh: Could not locate /vijapp/VIJ4/oracle/product/19c/network/admin/shrept.lst
Failed to generate client shared library on
Solutiton ;
/vijapp/VIJ4/oracle/product/19c/network/admin/shrept.lst file did not exist , restored from backcup or from source and issue is resolved.
---------------------------------------Other references-----
19c Database Installation fails with :"Error in invoking target 'libasmclntsh19.ohso libasmperl19.ohso client_sharedlib' of makefile ins_rdbms.mk " (Doc ID 2760289.1)
E-Business Suite Applications Manager RapidClone Attempts Fail With Error 'RC-00110 Fatal: Error occurred while relinking of ApplyDBTechStack' Running adlnkoh.sh ( Doc ID 330469.1 )
Findings: In this case the problem is a missing file from "$ORACLE_HOME/rdbms/admin/shrept.lst", this file is used by the "genclntsh", a shell script that builds the shared libraries. The "genclntsh" requires "shrept.lst" so when it is missing that will cause adlnkoh.sh to fail, which in turn causes the clone to fail.
Rapid Clone for 19c DB Tier Failed by RC-50013 in ApplyDBTechStack_<MMDDYYMI>.log and "make: *** [/u10/EBS12/XXX/db/tech_st/19.0.0/rdbms/lib/drdactl] Error 1" in installActionsYYYY-MM-DD_HH-MI-SSPM.log ( Doc ID 2729752.1 )
Findings: $ORACLE_HOME(19c)/network/admin/shrept.lst was not perfect.
--other queries
SQL> select * from v$version where banner like 'Oracle Database%';
SQL> select INSTANCE_NUMBER ,INSTANCE_NAME ,DATABASE_TYPE from v$instance;
SQL> select release_name from apps.fnd_product_groups;
SQL> select abbreviation, codelevel FROM AD_TRACKABLE_ENTITIES WHERE abbreviation in ('txk','ad','atg_pf','fwk');
SQL> select platform_name from v$database;
SQL> select * from v$version where banner like 'Oracle Database%';
BANNER
--------------------------------------------------------------------------------
BANNER_FULL
-----------------------------------------------------------------------------------------------------------------------------BANNER_LEGACY CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.13.0.0.0
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production 0
SQL> select INSTANCE_NUMBER ,INSTANCE_NAME ,DATABASE_TYPE from v$instance;
INSTANCE_NUMBER INSTANCE_NAME DATABASE_TYPE
--------------- ---------------- ---------------
1 CVIJ41 RAC
SQL> select platform_name from v$database;
PLATFORM_NAME
-----------------------------------------------------------------------------------------------------
Linux x86 64-bit
12c to 19c RAC Upgrade with EBS R12.2 - Linux
EBS R12.2 supports single pluggable database (PDB) under CDB architecture.
Requirements for Installing Oracle Database/Client 19c on OL8 or RHEL8 64-bit (x86-64) (Doc ID 2668780.1)
-Download the Oracle Database 19c software from OTN -
https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html
Database Pre-Install RPM Download Links(External & Internal Repositories)
https://public-yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
https://public-yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el8.x86_64.rpm
The download for the oracle-database-preinstall-19c RPM can be done with below commands (without the need to provide version numbers)
# dnf update -y
# dnf install oracle-database-preinstall-19c -y
The Oracle ORAchk utility provides system checks that can help to prevent issues before and after installation. These checks include kernel requirements, operating system resource allocations, and other system requirements.
Before you perform a fresh database installation:
./orachk -profile preinstall
Ensure that OpenSSH is installed on your servers. OpenSSH is the required SSH software.
Create the Oracle home directory and extract the image files that you have downloaded in to this Oracle home directory. For example:
$ mkdir -p /u01/app/oracle/product/19c/dbhome_1
$ chgrp oinstall /u01/app/oracle/product/19c/dbhome_1
$ cd /u01/app/oracle/product/19c/dbhome_1
$ unzip -q /tmp/db_home.zip
Apply Latest RU and one-offs
$ export CV_ASSUME_DISTID=OL7
$ ./runInstaller -applyRU <Latest 19c DBRU Patch unzip location> -applyOneOffs <Latest 19c OJVM RU Patch unzip location>,<Latest 19c OCWRU Patch unzip location>
For eg-
$ ./runInstaller -applyRU /u01/app/30557433 -applyOneOffs /u01/app/30484981,/u01/app/30501910/30489227
Note -
a. EM Express One-Off Patch 30150710 is fixed in October 2020 19.9 DBRU Patch 31771877
b. OCW RU Patches are not separately available for download from MOS Patches & Updates.Download latest GI RU & then unzip to locate the OCWRU Patch
c. EM Express One-Off Patch 30150710 is fixed in October 2020 19.9 DBRU Patch 31771877. If DB RU earlier than 19.9 is being applied,then Patch 30150710 needs to be downloaded separately & applied as shown below-
$ ./runInstaller -applyRU <Latest 19c DBRU Patch unzip location> -applyOneOffs <Latest 19c OJVM RU Patch unzip location>,<Latest 19c OCWRU Patch unzip location>,<Oneoff patch 30150710 unzip location>
For eg -
$ ./runInstaller -applyRU /u01/app/30557433 -applyOneOffs /u01/app/30484981,/u01/app/30501910/30489227,/u01/app/30150710
d. Latest RU Patch Numbers can be obtained from the below MOS Note -
Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2)
Below steps mentions 12c 12102 to 19c (19.13) RAC Upgrade latest steps - OEL8
Step 1 )
Setup ssh password less between RAC nodes node1 and node2
Step 2)
export ORACLE_BASE=/oraapp/VIJ/oracle/product/
export ORACLE_HOME=/oraapp/VIJ/oracle/product/19c
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$ORACLE_HOME/OPatch:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export PERL5LIB=/oraapp/VIJ/oracle/product/19c/perl/bin/perl5.28.1:/oraapp/VIJ/oracle/product/19c/perl/lib/site_perl/5.28.1
export CV_ASSUME_DISTID=OL7
[oracle@vijidb01 ~]$ cd $ORACLE_HOME
[oracle@vijidb01 19c]$ pwd
/oraapp/VIJ/oracle/product/19c
--runInstaller and install CDB without PDB
Oracle Data Guard per Pluggable Database is available today! - July 19, 2022
https://blogs.oracle.com/maa/post/dgpdb-available-today
DGPDB is available in 21c today, with the July 2022 release update (21.7).
Tuesday, 16 August 2022
Backup Based RMAN DUPLICATE Without Connecting To Target Database For Both Disk & Tape Backups
Perform Backup Based RMAN DUPLICATE Without Connecting To Target Database For Both Disk & Tape Backups (Doc ID 1375864.1)
Monday, 15 August 2022
OCI Network Firewall - Palo Alto VM Series - Transit Routing Using DRG2
https://docs.oracle.com/en/solutions/oci-network-firewall/#GUID-875E911C-8D7D-4205-952B-5E8FAAD6C6D3
https://docs.oracle.com/en-us/iaas/Content/Network/Tasks/transitrouting.htm
Friday, 12 August 2022
Migrating 12102 to 19c - exacs
Migrating Oracle E-Business Suite Release 12.2 with Oracle Database 12.1.0.2 to Oracle Exadata Cloud@Customer Gen 2 (Doc ID 2758998.1)
Subscribe to:
Posts (Atom)