Best Of
Re: Oracle database 19c libraries are installed but throwing error on sqlplus
Can you confirm that Oracle 19c installed successfully on RHEL 8 without any issues/errors?
Below are the basic steps for performing an install of Oracle 19c on OL8 / RHEL8, complete with the latest quarterly patches (APR2025 "19.27.0.0.0" at the time of this writing):
=====================
= Performed as root user =
1 - Install Prerequisite RPMs:
Oracle Linux 8 <<>> # dnf install oracle-database-preinstall-19c
Red Hat Enterprise Linux 8 <<>> # dnf install bc binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel libxcb libibverbs make smartmontools sysstat
Alternatively, the RPM can be installed with older YUM utility if not comfortable with the new DNF utility for RPM installations:
Oracle Linux 8 <<>> # yum install oracle-database-preinstall-19c
Red Hat Enterprise Linux 8 <<>> # yum install bc binutils elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libXrender libX11 libXau libXi libXtst libgcc libnsl librdmacm libstdc++ libstdc++-devel libxcb libibverbs make smartmontools sysstat
2 - Ensure "/dev/shm" & "/tmp" are mounted without "noexec":
Check if "/dev/shm" & "/tmp" are mounted with "noexec":
mount | grep tmp | grep noexec
If need to remount without "noexec":
mount -o remount,exec /dev/shm
mount -o remount,exec /tmp
======================
= Performed as oracle user =
1 - Download & Extract Oracle 19c into the directory you want as the Oracle Home:
Oracle Database 19c Download for Linux x86-64
https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html
LINUX.X64_193000_db_home.zip
$ cd $ORACLE_HOME
$ unzip <parent dir>/LINUX.X64_193000_db_home.zip -x OPatch*
2 - Update the OPatch Utility in the extracted Oracle Home:
Patch 6880880 version OPatch 19.0.0.0.0
https://updates.oracle.com/download/6880880.html
p6880880_190000_Linux-x86-64.zip
$ cd $ORACLE_HOME
$ rm -rf OPatch
$ unzip <parent dir>/p6880880_190000_Linux-x86-64.zip
3 - Download & Extract the OJVMRU + GIRU Bundle:
Patch 37591516: COMBO OF OJVM COMPONENT 19.27.0.0.250415 + GI RU 19.27.0.0.250415
https://updates.oracle.com/download/37591516.html
p37591516_190000_Linux-x86-64.zip
4 - Execute Oracle 19c Installer:
$ cd $ORACLE_HOME
$ ./runInstaller -applyRU <extracted patch 37591516>/37641958 -applyOneOffs <extracted patch 37591516>/37499406
--
Requirements for Installing Oracle Database/Client 19c on OL8 or RHEL8 64-bit (x86-64) (Doc ID 2668780.1)
Re: Oracle database 19c libraries are installed but throwing error on sqlplus
This typically indicates that the libsqlplus.so library is missing, inaccessible, or not resolvable due to incomplete installation, incorrect environment variables, missing system prerequisites, or permissions issues. To resolve, first verify and set environment variables in ~/.bash_profile (e.g., export ORACLE_HOME=/oracle/app/oracle/product/19.0.0/dbhome_1; export PATH=$ORACLE_HOME/bin:$PATH; export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH), then source the profile and check if $ORACLE_HOME/lib/libsqlplus.so exists using ls -l; if missing, relink binaries with cd $ORACLE_HOME/bin; ./relink all and review logs for errors. Ensure RHEL 8 prerequisites are installed via yum (e.g., libaio, libaio-devel, libnsl, etc.), diagnose dependencies with ldd $ORACLE_HOME/bin/sqlplus, and check SELinux status with getenforce—set to Permissive temporarily if Enforcing. If unresolved, reinstall Oracle 19c.
Cheers
Arsalan
Re: Version number of expense PO (conversion PO) is not changing, after changes in the PO
Hi @User_RC567
Record missing in Archive table could be possible cause
please check for the working case it might be having a record in archive table
Possible cause during the time of import the Archive on option might be COMMUNICATE
Option 1
for testing
- Change the Archive On option to communicate
- Now query the Approved PO in PO summary form → Tools → Communicate → please check the archive table has records if it got populated
- (Also run PO output for communication) program for one PO with regenerate
Now the archive table should get populated once its done then you can change to approve and create a revision and validate
If Archive table is the cause
I think do have a data fix we will check the owning engineer
Thanks
Nirmal
Re: Version number of expense PO (conversion PO) is not changing, after changes in the PO
We got datafix from Oracle to upload data in Archive tables, and then is working fine for standard PO and BPA
Waiting for datafix for BPA releases
Re: Purchase Order Approval Issue – Record Not Appearing in Approval Screen
Hi Mahesh,
Thank you for the input. The issue is resolved by following the steps you mentioned.
Regards,
Vaibhav
Re: Credit Card Payments - Customer - Recurring
Hello,
Please review below notes for the complete setup:
- Note 745996.1 > section 4 > a. Assign default payment details at the customer account or site level for the Customer setup needed to default the Credit Card Payment Method while creating AR Invoices
- Note 1098583.1 to review the defaulting logic of the payment instrument when importing Invoices through Autoinvoice.
Regards
Re: MasterCard CDF3 Transaction Loader program is now populating Billed Date after upgrade to 12.2.13.
Hi Sharla,
Your query/ question would be better served in a Service Request (SR) opened in My Oracle Support (https://support.oracle.com/).
Detailed logging and/or specific customer details may be required for resolution, and for your protection we ask that this sort of information be transmitted only via a secure SR.
When creating your SR, you can reference the URL of this community post.
Regards
George
Re: Purchase Order Approval Issue – Record Not Appearing in Approval Screen
Hi @User_UKCQA,
Please review the checklist below for troubleshooting the approval processing issue:
- Check the Processing Options of Purchase Order Entry (P4310) to ensure the Override Next Status (Defaults tab, option #4) is blank.
- Verify that the Route Code (Approvals tab, option #1) is not blank. This field must contain a valid value for the approvals to function correctly.
- There is a possibility that the reported version is corrupt. In such cases, create a new version and re-test the scenario.
If the issue still persists, I recommend raising a Service Request, so we can review your configuration in detail and investigate further.
Regards,
Mahesh
Re: Enter Feedback Here for the EBS Support Analyzer Bundle Menu Tool - Note 1939637.1
Hi MarianaDBA and Steven Spooner-Lloyd
Thank you for the feedback, you are correct, I confirmed the 2025 July Bundle v200.158 had some missing files in the MENU/perLib/MENU folder.
I have created a new "Known Issue and Solutions" item #19 in the Analyzer Bundle Doc ID 1939637.1 and corrected the problem in an updated 2025 July Bundle v200.159 (bundle_2025-Jul-02.zip) which is available on the Analyzer Bundle Menu Tool Doc ID 1939637.1.
If you encountered the error when starting the Analyzer Bundle :
Can't locate MENU/Analyzer.pm in @INC
Please unzip the updated bundle_2025-Jul-02.zip in the parent directory of your MENU folder and replace all the MENU files.
You should now be able to start the Analyzer Bundle Menu Tool using :
$ cd MENU
$ perl Menu.pl
Remember, it is recommended to update all your analyzers in the Bundle MENU Tool by using the
Analyzer Bundle Menu "Update Analyzer Bundle" option.
1) Download the latest Analyzer Bundle zip file v200.159 (July 2nd 2025) from Doc ID 1939637.1
2) Place the bundle zipfile (bundle_2025-Jul-02.zip) into the MENU/update folder (do not unzip)
3) Run the Bundle Menu Tool
$ cd ~MENU <--location of the Bundle MENU folder
$ perl Menu.pl apps/<apps_pwd> <--Start the Bundle Menu Tool
Select from the Main Menu
[U] Update, AutoUpdate, Uninstall
[2] Update Analyzer Bundle
[U]se <--Use the zipfile you put in the MENU/update folder
Follow the prompts, and be sure to restart the Bundle Menu Tool to complete the analyzer updates
4) Once complete, Navigate back to the Bundle Main Menu, and run the
[S] Show Installed Analyzers
to verify current installed analyzer versions match the changes in the Analyzer Bundle Change Log for Bundle Zip.
1939637.1#aref_section130
