OracleApps/DB/OS Administration Solutions: December 2014

Tuesday 30 December 2014

DB : OPatch failed with make ioracle

Error:

[Dec 30, 2014 6:05:42 PM] OUI-67200:Make failed to invoke "/usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/d01/UAT/db/tech_st/11.2.0.3"....'/usr/libexec/gcc/x86_64-redhat-linux/4.4.7/cc1: error while loading shared libraries: libmpfr.so.1: cannot open shared object file: No such file or directory
/usr/bin/ar: /d01/UAT/db/tech_st/11.2.0.3/rdbms/lib/config.o: No such file or directory
make: *** [/d01/UAT/db/tech_st/11.2.0.3/rdbms/lib/config.o] Error 1
'
[Dec 30, 2014 6:05:42 PM] Re-link fails on target "ioracle".
[Dec 30, 2014 6:05:42 PM] --------------------------------------------------------------------------------
Failed to run make commands. They are stored in file '/d01/UAT/db/tech_st/11.2.0.3/.patch_storage/12834800_Jan_27_2012_21_14_30/make.txt'
Invoke these commands manually to restore the binaries in the Oracle Home.
[Dec 30, 2014 6:05:42 PM] OUI-67115:OPatch failed to restore OH '/d01/UAT/db/tech_st/11.2.0.3'. Consult OPatch document to restore the home manually before proceeding.
[Dec 30, 2014 6:05:42 PM] --------------------------------------------------------------------------------
[Dec 30, 2014 6:05:42 PM] The following warnings have occurred during OPatch execution:
[Dec 30, 2014 6:05:42 PM] 1) OUI-67200:Make failed to invoke "/usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/d01/UAT/db/tech_st/11.2.0.3"....'/usr/libexec/gcc/x86_64-redhat-linux/4.4.7/cc1: error while loading shared libraries: libmpfr.so.1: cannot open shared object file: No such file or directory
/usr/bin/ar: /d01/UAT/db/tech_st/11.2.0.3/rdbms/lib/config.o: No such file or directory
make: *** [/d01/UAT/db/tech_st/11.2.0.3/rdbms/lib/config.o] Error 1
'
[Dec 30, 2014 6:05:42 PM] 2) OUI-67124:Re-link fails on target "ioracle".
[Dec 30, 2014 6:05:42 PM] 3) OUI-67200:Make failed to invoke "/usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/d01/UAT/db/tech_st/11.2.0.3"....'/usr/libexec/gcc/x86_64-redhat-linux/4.4.7/cc1: error while loading shared libraries: libmpfr.so.1: cannot open shared object file: No such file or directory
/usr/bin/ar: /d01/UAT/db/tech_st/11.2.0.3/rdbms/lib/config.o: No such file or directory
make: *** [/d01/UAT/db/tech_st/11.2.0.3/rdbms/lib/config.o] Error 1
'

Solution:

11.2.0.3 Installation failed on RHEL 6 with the error libraries: libmpfr.so.1: cannot open shared object file: No such file or directory (Doc ID 1543787.1)

1. Check if library file exist

$cd /usr/lib64

$ls -la libmpfr*

Expected output:

lrwxrwxrwx 1 root root 16 Jul 6 2012 libmpfr.so.1 -> libmpfr.so.1.2.0*

-rwxr-xr-x 1 root root 321064 Jul 24 2010 libmpfr.so.1.2.0*

2. Check for missing mpfr package by below

$rpm -q --whatprovides /usr/lib64/libmpfr.so.1

$rpm -q mpfr-2.4.1-6.el6.x86_64

Expected output is as below

$ rpm -q --whatprovides /usr/lib64/libmpfr.so.1

mpfr-2.4.1-6.el6.x86_64

$ rpm -q mpfr-2.4.1-6.el6.x86_64

mpfr-2.4.1-6.el6.x86_64

3. If the output is not as expected then Install package mpfr by below and retry the installation.

$yum install mpfr-2.4.1-6.el6.x86_64

DB : oracle installation failed

Error:

INFO: rm -f ntcontab.*

INFO: (if [ "compile" = "compile" ] ; then \
/PS/app/oracle/product/11.2.0/db_1/bin/gennttab > ntcontab.c ;\
gcc -m64 -c ntcontab.c ;\
rm -f /PS/app/oracle/product/11.2.0/db_1/lib/ntcontab.o ;\
mv ntcontab.o /PS/app/oracle/product/11.2.0/db_1/lib/ ;\
/usr/bin/ar rv /PS/app/oracle/product/11.2.0/db_1/lib/libn11.a /PS/app/oracle/product/11.2.0/db_1/lib/ntcontab.o ; fi)

INFO: gcc: error trying to exec 'cc1': execvp:
INFO: Permission denied

INFO: mv: cannot stat `ntcontab.o': No such file or directory

INFO: /usr/bin/ar: /PS/app/oracle/product/11.2.0/db_1/lib/ntcontab.o: No such file or directory

INFO: make: *** [ntcontab.o] Error 1

INFO: End output from spawned process.
INFO: ----------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'mkldflags ntcontab.o nnfgt.o' of makefile '/PS/app/oracle/product/11.2.0/db_1/network/lib/ins_net_client.mk'. See '/PS/app/oraInventory/logs/installActions2014-12-30_02-01-46PM.log' for details.
Exception Severity: 1

Solution:

check the pre-reqs rpms are installed refer the following note id

Master Note of Linux OS Requirements for Database Server (Doc ID 851598.1)

Monday 29 December 2014

DB : Oracle runInstaller failed with no protocol specified

Error:

[oracle@localhost database]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 80 MB. Actual 7440 MB Passed
Checking swap space: must be greater than 150 MB. Actual 2527 MB Passed
Checking monitor: must be configured to display at least 256 colors
>>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<<

Some requirement checks failed. You must fulfill these requirements before

continuing with the installation,

Continue? (y/n) [n] y

Ignoring required pre-requisite failures. Continuing...
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-05-12_01-26-43PM. Please wait ...[oracle@localhost database]$ No protocol specified
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at java.awt.Toolkit$2.run(Toolkit.java:821)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Toolkit.getDefaultToolkit(Toolkit.java:804)
at com.jgoodies.looks.LookUtils.isLowResolution(Unknown Source)
at com.jgoodies.looks.LookUtils.<clinit>(Unknown Source)
at com.jgoodies.looks.plastic.PlasticLookAndFeel.<clinit>(PlasticLookAndFeel.java:122)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:242)
at javax.swing.SwingUtilities.loadSystemClass(SwingUtilities.java:1783)
at javax.swing.UIManager.setLookAndFeel(UIManager.java:480)
at oracle.install.commons.util.Application.startup(Application.java:758)
at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:164)
at oracle.install.commons.flow.FlowApplication.startup(FlowApplication.java:181)
at oracle.install.commons.base.driver.common.Installer.startup(Installer.java:265)
at oracle.install.ivw.db.driver.DBInstaller.startup(DBInstaller.java:114)
at oracle.install.ivw.db.driver.DBInstaller.main(DBInstaller.java:132)

Solution:
Check the DISPLAY variable is set
Give xhost + in the VNC session as root user and retry the installation

DB : Oracle database installation failed Error in invoking target 'links proc gen_pcscfg' of makefile

ERROR:

INFO: /bin/chmod: cannot access `/PS/app/oracle/product/11.2.0/db_1/product/11.2.0/db_1/precomp/lib/proc'
INFO: : No such file or directory

INFO: make[1]: *** [/PS/app/oracle/product/11.2.0/db_1/product/11.2.0/db_1/precomp/lib/proc] Error 1

INFO: make[1]: Leaving directory `/PS/app/oracle/product/11.2.0/db_1/product/11.2.0/db_1/precomp/lib'

INFO: make: *** [proc] Error 2

INFO: End output from spawned process.
INFO: ----------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'links proc gen_pcscfg' of makefile '/PS/app/oracle/product/11.2.0/db_1/product/11.2.0/db_1/precomp/lib/ins_precomp.mk'. See '/PS/app/oracle/product/11.2.0/oraInventory/logs/installActions2014-12-29_04-15-27PM.log' for details.
Exception Severity: 1

Solution:

Make sure you are installing 64 bit oracle on your 64 bit linux; 32 bit oracle software on your 32 bit linux software. If you don't do "Error in invoking target 'client_sharedlib' of makefile" will likely be the problem. So before proceed ensure your hardware platform, linux platform and oracle software. Identified these things are discussed detail in

Tuesday 23 December 2014

EBS : View the concurrent output files .pdf .excel in the clone instance

The solution to view the output files is to update the tables fnd_conc_req_outputs, fnd_concurrent_requests.

1. Create the backup of both the tables fnd_conc_req_outputs, fnd_concurrent_requests

create table fnd_conc_req_outputs_bkp as select * from fnd_conc_req_outputs;

create table fnd_concurrent_requests_bkp as select * from fnd_concurrent_requests;

2. Update the columns in both the tables listed below accordingly.

fnd_concurrent_requests
Column Name	Value
file_name	OS file path for output logfile
file_node_name	node name
fnd_conc_req_outputs
Column Name	Value
logfile_name	OS file path for request logfile
logfile_node_name	node name
outfile_node_name	node name
outfile_name	OS file path for output logfile

3. Update statements:

update fnd_conc_req_outputs set file_name=replace(file_name,'/oraapps/prod/prodcomn','/oraapps/dev/devcomn'), file_node_name='DEV';

commit;

update fnd_concurrent_requests set

logfile_name=replace(logfile_name,'/oraapps/prod/prodcomn','/oraapps/dev/devcomn'),

logfile_node_name='DEV', outfile_node_name='DEV',

outfile_name=replace(outfile_name,'/oraapps/prod/prodcomn','/oraapps/dev/devcomn') where logfile_name like '%prod%';

commit;

Saturday 20 December 2014

EBS : Database Tier (perl adcfgclone.pl dbTier/dbTechStack) fails with RC-00110

Error:

APPS Password : Log file located at /d01/PREPROD/oradb/11.2.0.3/appsutil/log/PREPROD_rgovis/ApplyDBTechStack_12201105.log
\ 0% completed RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack

ERROR while running Apply...
Sat Dec 20 11:06:07 2014

ERROR: Failed to execute /d01/PREPROD/oradb/11.2.0.3/appsutil/clone/bin/adclone.pl

Please check logfile.

Detail log : /d01/PREPROD/oradb/11.2.0.3/appsutil/log/PREPROD_rgovis/ApplyDBTechStack_12201105.log
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>

[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /d01/PREPROD/oradb/11.2.0.3/perl/bin/perl -I /d01/PREPROD/oradb/11.2.0.3/perl/lib/5.8.3 -I /d01/PREPROD/oradb/11.2.0.3/perl/lib/site_perl/5.8.3 -I /d01/PREPROD/oradb/11.2.0.3/appsutil/perl /d01/PREPROD/oradb/11.2.0.3/appsutil/clone
ouicli.pl INSTE8_APPLY 255

AutoConfig is exiting with status 1

RC-50013: Fatal: Instantiate driver did not complete successfully.
/d01/PREPROD/oradb/11.2.0.3/appsutil/driver/regclone.drv

Solution:

Set the perl to point to the <ORACLE_HOME>/perl/bin
Eg:
export PATH=<ORACLE_HOME>/perl/bin:$PATH

Linux : /var/lib/mlocate/mlocate.db': Permission denied

Solution:

Run the below command as root user

chmod 711 /usr/bin/locate
chmod g+s /usr/bin/locate

Then run locate command as other user

EBS : oracle apps r12 username,password field doesn't appear in arabic interface

Solution:

1) Log into the application as the "System administrator" responsibility
2) Choose Profile > System
3) Click in the USER field and add the username GUEST
4) Set the following profile options at user level

Personalize Self-Service Defn = No

5) Save the changes
6) Bounce the E-Business suite web tier services
7) Re-test the login issue

Reference

Main Login Page Layout Issue In BIDI Languages such as Arabic and Hebrew (Doc ID 453279.1)

Monday 1 December 2014

EBS : ERROR: OUI files not found at their expected location.

ERROR:

[oraprod@drebsdb01 TEST_drebsdb01]$ perl adpreclone.pl appsTier

Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA

Oracle Applications Rapid Clone

Version 12.0.0

adpreclone Version 120.20.12010000.5

Enter the APPS User Password:
Running:
perl /oradb/oracle/11.2.0.3/appsutil/bin/adclone.pl java=/oradb/oracle/11.2.0.3/jdk/jre mode=stage stage=/oradb/oracle/11.2.0.3/appsutil/clone component=appsTier method=CUSTOM dbctx=/oradb/oracle/11.2.0.3/appsutil/TEST_drebsdb01.xml showProgress
APPS Password :
You must define an applications context to use
appctx=<applications context file>

ERROR: OUI files not found at their expected location. Please make sure that the pre-requisite OUI patch was applied correctly: patch should be unzipped directly at the ORACLE_HOME root level so that OraInstaller.jar exists in either
/oui/jlib/
or
/oui/lib/
Restart adclone.pl after performing required corrections.

ERROR while running perl /oradb/oracle/11.2.0.3/appsutil/bin/adclone.pl java=/oradb/oracle/11.2.0.3/jdk/jre mode=stage stage=/oradb/oracle/11.2.0.3/appsutil/clone component=appsTier method=CUSTOM dbctx=/oradb/oracle/11.2.0.3/appsutil/TEST_drebsdb01.xml showProgress ...
Mon Dec 1 09:28:49 2014

Soultion:

Check in which tier you are running the perclone and pass the parameter correctly as dbTier for DatabaseTier and appsTier for ApplicationTier

OracleApps/DB/OS Administration Solutions