Oracle Database/ERP/Cloud/RAC/Misc Solutions

Tuesday, 31 January 2023

Exception in thread "main" java.lang.UnsatisfiedLinkError: /u01/soft/ebs/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory

Error while launching rapidwiz during EBS 12.2 Installation

Exception in thread "main" java.lang.UnsatisfiedLinkError: /u01/soft/ebs/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory

[oracle@oel76 rapidwiz]$ Exception in thread "main" java.lang.UnsatisfiedLinkError: /u01/soft/ebs/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory

at java.lang.ClassLoader$NativeLibrary.load(Native Method)

at java.lang.ClassLoader.loadLibrary0(Unknown Source)

at java.lang.ClassLoader.loadLibrary(Unknown Source)

at java.lang.Runtime.load0(Unknown Source)

at java.lang.System.load(Unknown Source)

at java.lang.ClassLoader$NativeLibrary.load(Native Method)

at java.lang.ClassLoader.loadLibrary0(Unknown Source)

at java.lang.ClassLoader.loadLibrary(Unknown Source)

at java.lang.Runtime.loadLibrary0(Unknown Source)

at java.lang.System.loadLibrary(Unknown Source)

at sun.security.action.LoadLibraryAction.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)

at sun.awt.DebugHelper.<clinit>(Unknown Source)

at java.awt.Component.<clinit>(Unknown Source)

Could not find the main class: oracle.apps.ad.rapidwiz.RIWizard. Program will exit.

Soltuion:

Mount the Linux CD Rom and then replace the below packages from the CDROM

cd /run/media/root/OL-7.6 Server.x86_64/Packages

rpm -Uhv libXtst-* libXi-* --replacepkgs --force

This worked

Additionally, if it doen't work.. please try to replace the below packages also.

cd /run/media/root/OL-7.6 Server.x86_64/Packages

rpm -Uhv libXext-1.1-3.el7* libXext-devel-1.1-3.el7* libX11-*.rpm libxcb-*.rpm libXau-*.rpm --replacepkgs

/lib/ld-linux.so.2: bad ELF interpreter: No such file or directory - while building stage during 12.2

/lib/ld-linux.so.2: bad ELF interpreter: No such file or directory

Cause

The Linux box is on a 64-bit system, and does not have 32-bit library support installed.
Resolution
Make sure glibc.i686 and glibc.x86_64 is installed on the system.
If glibc.i686 is not available on the Centos-6, try glibc.i386
To list all the package with prefix "glibc"
Run:
yum list glibc.

To install the package:
Run
sudo yum install glibc.i686
or
sudo yum install glibc.i386

If you do not have sudo setup in the environment, type "su" to accquire superuser authority first.
Then run:
yum install glibc.i686

Friday, 18 November 2022

ORA-12777: A non-continuable error encountered.

ORA-12777: A non-continuable error encountered. Check the error stack for additional information [ksm_check_ob_paths:1], [ORACLE_BASE], [], [].

After moving the 19c Database Oracle Home to new location, i relinked the binaries and then tried to start up the database. Got the below error:

ORA-12777: A non-continuable error encountered. Check the error stack for additional information [ksm_check_ob_paths:1], [ORACLE_BASE], [], [].

Solution:

Correct the path of Oracle Home in the orabasetab file under $ORACLE_HOME/Install location

e.g

oraprod@erpdbpreprod1:/u01/app/oracle/product/19.0.0/dbhome_3/install$ cat orabasetab

#orabasetab file is used to track Oracle Home associated with Oracle Base

/u01/app/oracle/product/19.0.0/dbhome_3:/u01/app/oracle/product/19.0.0:SPROD_DB__u01_app_oracle_product_19_0_0_dbhome_3:N:

Note: dbhome_1 was corrected to dbhome_3

Friday, 30 September 2022

19c RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

19c RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Before doing an RMAN DUPLICATE DATABASE from an Active Database, we need to set up listener on the target environment with static registration. Else when the RMAN shuts down the auxiliary database for creating spfile or making changes in it, it will not be able to connect the auxiliary and start the database (nomount) and throw the error :

RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

To Solve this issue ensure that listener is configured with static registration using the below syntax :

========= LISTENER.ORA==================

EBSUPG=

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST =<hostname>)(PORT = 1536))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1536))

)

SID_LIST_EBSUPG=

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = EBSUPG)

(ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)

(SID_NAME = EBSUPG)

)

ADR_BASE_LISTENER_EBSUPG = /u01/app/oracle

=================================================================

When we check the listener status, it should show as UNKNOWN instead of BLOCKED

-bash-4.4$ lsnrctl status EBSUPG

LSNRCTL for Solaris: Version 19.0.0.0.0 - Production on 30-SEP-2022 13:57:46

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.92.27.104)(PORT=1536)))

STATUS of the LISTENER

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

Alias EBSUPG

Version TNSLSNR for Solaris: Version 19.0.0.0.0 - Production

Start Date 30-SEP-2022 13:35:31

Uptime 0 days 0 hr. 22 min. 14 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/STDBY4BKP/ebsupg/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=1536)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1536)))

Services Summary...

Service "EBSUPG" has 1 instance(s).

Instance "EBSUPG", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

This solved my issue and it started with the ACTIVE DUPLICATE.

Tuesday, 12 April 2022

ORA-01111: name for data file 975 is unknown - rename to correct file MRP0: Background Media Recovery terminated with error 1111

Issue:

Standby database throws below errors and stops the MRP.

MRP0: Background Media Recovery terminated with error 1111

Errors in file /u01/app/oraprod/diag/diag/rdbms/sprod/SPROD1/trace/SPROD1_pr00_23061.trc:

ORA-01111: name for data file 975 is unknown - rename to correct file

ORA-01110: data file 975: '/u01/app/oraprod/11.2.0.4/dbs/UNNAMED00975'

ORA-01157: cannot identify/lock data file 975 - see DBWR trace file

ORA-01111: name for data file 975 is unknown - rename to correct file

ORA-01110: data file 975: '/u01/app/oraprod/11.2.0.4/dbs/UNNAMED00975'

Recovery Slave PR00 previously exited with exception 1111

Solution:

- Please cancel the managed recovery by

SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

- Set standby_file_management=manual

SQL>ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL;

If the physical standby database is RAC, then please make the change to all standby instances.

SQL>ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL SID='*';

alter database create datafile '/u01/app/oraprod/11.2.0.4/dbs/UNNAMED00975' as '+DATA_DG' size 30g;

- Set standby_file_management=auto

SQL>ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;

If the physical standby database is RAC, then please make the change to all standby instances.

SQL>ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO SID='*';

- Start managed recovery by

SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;

Friday, 4 March 2022

Fatal Error: TXK Install Service RW-50010: Error: - script has returned an error: /bin/sh: error importing function definition for `which'

Description: R12.2 Installation fails during Install web Tier.

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

Fatal Error: TXK Install Service

oracle.apps.fnd.txk.config.ProcessStateException: OUI process failed : Exit=1 See log for details. CMD= /u01/soft/ebs/TechInstallMedia/ohs11119/Disk1/runInstaller -waitForCompletion -ignoreSysPrereqs -force -silent -responseFile /u01/oracle/tstebs/fs2/inst/apps/tstebs_ebs22/temp/cfgHome/response/APPS_OHS_HOME/txkOHS_11119.rsp

at oracle.apps.fnd.txk.config.OUIPatchActionNode.processState(OUIPatchActionNode.java:159)

at oracle.apps.fnd.txk.config.PatchActionNode.processState(PatchActionNode.java:187)

at oracle.apps.fnd.txk.config.PatchNode.processState(PatchNode.java:338)

at oracle.apps.fnd.txk.config.PatchesNode.processState(PatchesNode.java:79)

at oracle.apps.fnd.txk.config.InstallNode.processState(InstallNode.java:68)

at oracle.apps.fnd.txk.config.TXKTopology.traverse(TXKTopology.java:594)

at oracle.apps.fnd.txk.config.InstallService.doInvoke(InstallService.java:224)

at oracle.apps.fnd.txk.config.InstallService.invoke(InstallService.java:237)

at oracle.apps.fnd.txk.config.InstallService.main(InstallService.java:291)

Cannot install Web Tier Utilities

RW-50010: Error: - script has returned an error: 1

RW-50004: Error code received when running external process. Check log file for details.

Running APPL_TOP Install Driver for tstebs instance

In the install log under /u01/app/oraInventory/*install*log

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

/usr/bin/make -f ins_net_client.mk mkldflags ORACLE_HOME=/u01/oracle/tstebs/fs2/FMW_Home/webtier//bin/sh: which: line 1: syntax error: unexpected end of file

/bin/sh: error importing function definition for `which'

/bin/sh: which: line 1: syntax error: unexpected end of file

/bin/sh: error importing function definition for `which'

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

Solution

This is due to the missing rpm of glibc

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

yum install glibc-*.i686

Last metadata expiration check: 5:19:11 ago on Fri 04 Mar 2022 03:33:24 PM +03.

Package glibc-devel-2.28-164.0.1.el8.i686 is already installed.

Package glibc-headers-2.28-164.0.1.el8.i686 is already installed.

Dependencies resolved.

==================================================================================================================================================================================================

Package Architecture Version Repository Size

==================================================================================================================================================================================================

Upgrading:

glibc i686 2.28-164.0.4.el8 ol8_baseos_latest 3.4 M

glibc x86_64 2.28-164.0.4.el8 ol8_baseos_latest 3.6 M

glibc-common x86_64 2.28-164.0.4.el8 ol8_baseos_latest 1.3 M

glibc-devel i686 2.28-164.0.4.el8 ol8_baseos_latest 1.0 M

glibc-devel x86_64 2.28-164.0.4.el8 ol8_baseos_latest 1.0 M

glibc-headers i686 2.28-164.0.4.el8 ol8_baseos_latest 481 k

glibc-headers x86_64 2.28-164.0.4.el8 ol8_baseos_latest 481 k

glibc-langpack-en x86_64 2.28-164.0.4.el8 ol8_baseos_latest 829 k

libnsl x86_64 2.28-164.0.4.el8 ol8_baseos_latest 104 k

Transaction Summary

==================================================================================================================================================================================================

Upgrade 9 Packages

Total download size: 12 M

Is this ok [y/N]: y

Downloading Packages:

(1/9): glibc-2.28-164.0.4.el8.i686.rpm 518 kB/s | 3.4 MB 00:06

(2/9): glibc-common-2.28-164.0.4.el8.x86_64.rpm 195 kB/s | 1.3 MB 00:06

(3/9): glibc-devel-2.28-164.0.4.el8.i686.rpm 1.7 MB/s | 1.0 MB 00:00

(4/9): glibc-headers-2.28-164.0.4.el8.i686.rpm 1.3 MB/s | 481 kB 00:00

(5/9): glibc-headers-2.28-164.0.4.el8.x86_64.rpm 1.0 MB/s | 481 kB 00:00

(6/9): glibc-langpack-en-2.28-164.0.4.el8.x86_64.rpm 1.7 MB/s | 829 kB 00:00

(7/9): glibc-devel-2.28-164.0.4.el8.x86_64.rpm 568 kB/s | 1.0 MB 00:01

(8/9): libnsl-2.28-164.0.4.el8.x86_64.rpm 502 kB/s | 104 kB 00:00

(9/9): glibc-2.28-164.0.4.el8.x86_64.rpm 267 kB/s | 3.6 MB 00:13

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

Total 911 kB/s | 12 MB 00:13

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

Preparing : 1/1

Upgrading : glibc-common-2.28-164.0.4.el8.x86_64 1/18

Upgrading : glibc-langpack-en-2.28-164.0.4.el8.x86_64 2/18

Running scriptlet: glibc-2.28-164.0.4.el8.x86_64 3/18

Upgrading : glibc-2.28-164.0.4.el8.x86_64 3/18

Running scriptlet: glibc-2.28-164.0.4.el8.x86_64 3/18

Running scriptlet: glibc-headers-2.28-164.0.4.el8.i686 4/18

Upgrading : glibc-headers-2.28-164.0.4.el8.i686 4/18

Upgrading : glibc-devel-2.28-164.0.4.el8.x86_64 5/18

Running scriptlet: glibc-devel-2.28-164.0.4.el8.x86_64 5/18

Running scriptlet: glibc-headers-2.28-164.0.4.el8.x86_64 6/18

Upgrading : glibc-headers-2.28-164.0.4.el8.x86_64 6/18

Upgrading : libnsl-2.28-164.0.4.el8.x86_64 7/18

Running scriptlet: glibc-2.28-164.0.4.el8.i686 8/18

Upgrading : glibc-2.28-164.0.4.el8.i686 8/18

Running scriptlet: glibc-2.28-164.0.4.el8.i686 8/18

Upgrading : glibc-devel-2.28-164.0.4.el8.i686 9/18

Running scriptlet: glibc-devel-2.28-164.0.4.el8.i686 9/18

Running scriptlet: glibc-devel-2.28-164.0.1.el8.i686 10/18

Cleanup : glibc-devel-2.28-164.0.1.el8.i686 10/18

Running scriptlet: glibc-devel-2.28-164.0.1.el8.x86_64 11/18

Cleanup : glibc-devel-2.28-164.0.1.el8.x86_64 11/18

Cleanup : glibc-2.28-164.0.1.el8.i686 12/18

Running scriptlet: glibc-2.28-164.0.1.el8.i686 12/18

Cleanup : glibc-headers-2.28-164.0.1.el8.x86_64 13/18

Cleanup : glibc-headers-2.28-164.0.1.el8.i686 14/18

Cleanup : libnsl-2.28-164.0.1.el8.x86_64 15/18

Cleanup : glibc-2.28-164.0.1.el8.x86_64 16/18

Running scriptlet: glibc-2.28-164.0.1.el8.x86_64 16/18

Cleanup : glibc-langpack-en-2.28-164.0.1.el8.x86_64 17/18

Cleanup : glibc-common-2.28-164.0.1.el8.x86_64 18/18

Running scriptlet: glibc-common-2.28-164.0.1.el8.x86_64 18/18

Running scriptlet: glibc-common-2.28-164.0.4.el8.x86_64 18/18

Verifying : glibc-2.28-164.0.4.el8.i686 1/18

Verifying : glibc-2.28-164.0.1.el8.i686 2/18

Verifying : glibc-2.28-164.0.4.el8.x86_64 3/18

Verifying : glibc-2.28-164.0.1.el8.x86_64 4/18

Verifying : glibc-common-2.28-164.0.4.el8.x86_64 5/18

Verifying : glibc-common-2.28-164.0.1.el8.x86_64 6/18

Verifying : glibc-devel-2.28-164.0.4.el8.i686 7/18

Verifying : glibc-devel-2.28-164.0.1.el8.i686 8/18

Verifying : glibc-devel-2.28-164.0.4.el8.x86_64 9/18

Verifying : glibc-devel-2.28-164.0.1.el8.x86_64 10/18

Verifying : glibc-headers-2.28-164.0.4.el8.i686 11/18

Verifying : glibc-headers-2.28-164.0.1.el8.i686 12/18

Verifying : glibc-headers-2.28-164.0.4.el8.x86_64 13/18

Verifying : glibc-headers-2.28-164.0.1.el8.x86_64 14/18

Verifying : glibc-langpack-en-2.28-164.0.4.el8.x86_64 15/18

Verifying : glibc-langpack-en-2.28-164.0.1.el8.x86_64 16/18

Verifying : libnsl-2.28-164.0.4.el8.x86_64 17/18

Verifying : libnsl-2.28-164.0.1.el8.x86_64 18/18

Upgraded:

glibc-2.28-164.0.4.el8.i686 glibc-2.28-164.0.4.el8.x86_64 glibc-common-2.28-164.0.4.el8.x86_64 glibc-devel-2.28-164.0.4.el8.i686 glibc-devel-2.28-164.0.4.el8.x86_64

glibc-headers-2.28-164.0.4.el8.i686 glibc-headers-2.28-164.0.4.el8.x86_64 glibc-langpack-en-2.28-164.0.4.el8.x86_64 libnsl-2.28-164.0.4.el8.x86_64

Complete!

[root@ebs122 1220]#

Oracle E-Business Suite Preinstallation RPM (Oracle Linux 8)

To install the Oracle E-Business Suite Preinstallation RPM (Oracle Linux 8), please follow below steps:

For Oracle Linux 8, review the documentation on DNF and repository configurations, perform the following commands to install the preinstallation rpm using the DNF utility, and then skip to Step 4:

# dnf install oraclelinux-release -y 
# dnf config-manager --set-enabled ol8_addons
# dnf install oracle-ebs-server-R12-preinstall.x86_64
Ref: Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1) 

Oracle Database/ERP/Cloud/RAC/Misc Solutions

Tuesday, 31 January 2023

Exception in thread "main" java.lang.UnsatisfiedLinkError: /u01/soft/ebs/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory

/lib/ld-linux.so.2: bad ELF interpreter: No such file or directory - while building stage during 12.2

Resolution

Friday, 18 November 2022

ORA-12777: A non-continuable error encountered.

ORA-12777: A non-continuable error encountered. Check the error stack for additional information [ksm_check_ob_paths:1], [ORACLE_BASE], [], [].

Solution:

Friday, 30 September 2022

19c RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Tuesday, 12 April 2022

ORA-01111: name for data file 975 is unknown - rename to correct file MRP0: Background Media Recovery terminated with error 1111

ORA-01111: name for data file 975 is unknown - rename to correct file MRP0: Background Media Recovery terminated with error 1111

Friday, 4 March 2022

Fatal Error: TXK Install Service RW-50010: Error: - script has returned an error: /bin/sh: error importing function definition for `which'

Fatal Error: TXK Install Service RW-50010: Error: - script has returned an error: /bin/sh: error importing function definition for `which'

Oracle E-Business Suite Preinstallation RPM (Oracle Linux 8)

Oracle E-Business Suite Preinstallation RPM (Oracle Linux 8)

XX_XXXXXXX is not a valid responsibility for the current user. Please contact your System Administrator.

Report Abuse