Tuesday, March 31, 2009

R12 EBS Post-Installation Tips and Tricks: Fixing issues with AD Utilities

After a successful Oracle R12 EBS installation on Linux platform for E-Business R12 and Oracle Enterprise Linux (OEL 5) 32 bit OS, there are a number of post-install steps that may need to be performed in order to make full use of the E-Business suite of tools. In my case, as an Oracle Apps and RAC DBA, I needed to relink the adadmin utilities since when I tried to fire up the adadmin suite of tools, Oracle slapped me with a nasty error complaining about yet another missing library! The details are shown in the sample output below.


[applmgr@ebs bin]$ adadmin
adadmin: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory


OK, so I did some digging around Oracle Metalink and various Oracle forums as well as Google to figure out why this happened after the install.

Root cause analysis and Solution


1. Environment variables and permissions for the APPLMGR user are not correct. Since E-Business is HUGE compared to just a normal Oracle database, we had to do some hunting. One key issue that causes this error with relinking of the E-Business AD utilities is the incorrect setting for PLATFORM variable. My good friend Daryle Karnes who also happens to be a top Apps DBA was kind enough to find this tidbit of information the other day. Either this environment variable has not been set, or it is wrong. The Oracle Metalink Support note ML #267113.1 Relink of modules fails with Error addresses this issue. So, let's check out what we have set in our Linux environment post-install for this environment variable.

[applmgr@ebs admin]$ cat adpltfrm.txt
LINUX


[applmgr@ebs appl]$ source APPSPROD_ebs.env


[applmgr@ebs admin]$ echo $PLATFORM
LINUX


Below are the corrected entries for my test single node R12 EBS Environment on OEL 5 Linux (32 bit OS):


[root@ebs install]# su - applmgr
[applmgr@ebs ~]$ id
uid=501(applmgr) gid=500(dba) groups=500(dba)
[applmgr@ebs ~]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

AD_TOP=/d01/app/oracle/apps/apps_st/appl/ad/12.0.0; export AD_TOP
APPL_TOP=/d01/app/oracle/apps/apps_st/appl; export APPL_TOP
COMMON_TOP=/d01/app/oracle/apps/apps_st/comn; export COMMON_TOP
ORACLE_HOME=/d01/app/oracle/apps/tech_st/10.1.2; export ORACLE_HOME
IAS_ORACLE_HOME=/d01/app/oracle/apps/tech_st/10.1.3; export IAS_ORACLE_HOME

PATH=$PATH:$HOME/bin

export PATH




2. Next, source the .bash_profile.sh file for APPLMGR to make sure the new and corrected environment variables for the above take affect.

3. Grant correct ownership and file permissions to APPL_TOP filesystem. As root, I used chown on the APPL_TOP filesystem and chmod to fix this problem.

[root@ebs inst]# chown -R applmgr:dba /d01/app/oracle/apps/tech_st/10.1.2

Now the real fun begins! We need to relink the adadmin utility to APPLMGR account so that we can use adadmin. A useful note can be found on Oracle Metalink Support. The reference is called How to relink an Applications Installation of Release 11i and Release 12 available as Metalink Note #356878.1.


4. Relink the adadmin with adrelink.sh script as shown in the below example for R12 EBS:

[applmgr@ebs ~]$ adrelink.sh force=y "ad adadmin"

Make sure to check status from the make log files to ensure no errors occur:

[root@ebs install]# pwd
/d01/app/oracle/inst/apps/PROD_ebs/logs/ora/10.1.2/install
[root@ebs install]# ls -altr
total 416
-rwxr-xr-x 1 applmgr dba 131506 Mar 31 08:57 make_03310857.log
drwxr-xr-x 6 applmgr dba 4096 Mar 31 10:33 ..
-rw-r--r-- 1 applmgr dba 131506 Mar 31 17:24 make_03311723.log
drwxr-xr-x 2 applmgr dba 4096 Mar 31 17:25 .
-rw-r--r-- 1 applmgr dba 131506 Mar 31 17:26 make_03311725.log

$ cat make_03311725.log

Completed linking target isqlldr on Tue Mar 31 17:26:17 PDT 2009...
/d01/app/oracle/apps/tech_st/10.1.2/procbuilder/lib
rm -f /d01/app/oracle/apps/tech_st/10.1.2/lib//libdeb.a /d01/app/oracle/apps/tech_st/10.1.2/lib//libde.so.0 /d01/app/oracle/apps/tech_st/10.1.2/lib//libdeb.so.0
cp /d01/app/oracle/apps/tech_st/10.1.2/lib//libde.a /d01/app/oracle/apps/tech_st/10.1.2/lib//libdeb.a
chmod 664 /d01/app/oracle/apps/tech_st/10.1.2/lib//libdeb.a;
ar t /d01/app/oracle/apps/tech_st/10.1.2/lib//libdeb.a | grep "^deo" > list
ar t /d01/app/oracle/apps/tech_st/10.1.2/lib//libdeb.a | grep "^deu" >> list
ar t /d01/app/oracle/apps/tech_st/10.1.2/lib//libdeb.a | grep "^dez" >> list
echo "sdehf.o sdeqt.o sdesp.o sdesc.o sdeu.o sdeue.o " >> list
paste -s -d" " list > newlist
ar d /d01/app/oracle/apps/tech_st/10.1.2/lib//libdeb.a `cat newlist`
for libs in /d01/app/oracle/apps/tech_st/10.1.2/lib//libde.so.0 /d01/app/oracle/apps/tech_st/10.1.2/lib//libdeb.so.0 ; do \
/d01/app/oracle/apps/tech_st/10.1.2/bin/genshlib $libs; \
done
Completed linking targets sharedlibs on Tue Mar 31 17:26:18 PDT 2009...

Error found while relinking
return code = .46

Why did the first relink fail with adrelink.sh ? It was because the wrong .env file was used! So we had to find and source the correct .env file which is APPSPROD.env and NOT PROD.env!!! Somehow during the installation, the Rapid Installer (rapidwiz) created the wrong env file. Fortunately, the fix is easy. Login as APPLMGR and source the env file to get things corrected.



5. Now source the corrected .env file from the APPL_TOP directory as the APPLMGR user:

[applmgr@ebs ~]$ echo $APPL_TOP
/d01/app/oracle/apps/apps_st/appl

[applmgr@ebs ~]$ cd $APPL_TOP


[applmgr@ebs appl]$ . APPSPROD_ebs.env


6. Do the relink which should work this time as shown in the below output:


[applmgr@ebs appl]$ adrelink.sh force=y "ad adadmin"
**********************************************************
You are running adrelink, version 120.36.12000000.5

Start of adrelink session
Date/time is Tue Mar 31 17:40:19 PDT 2009
Log file is /d01/app/oracle/apps/apps_st/appl/admin/log/adrelink.log
Command line arguments are
"force=y" "ad adadmin"


Operating System Information (output of 'uname -a'):

Linux ebs.sandiego.com 2.6.18-92.el5 #1 SMP Fri May 23 22:17:30 EDT 2008 i686 i686 i386 GNU/Linux


Backup Mode is "file"

Removing extra variables from the environment...
adrelink will save the following variables (if set):
- Generic:
"PATH ORACLE_HOME TMPDIR TZ APPL_TOP APPLFENV PLATFORM LD_LIBRARY_PATH COBDIR LIBPATH NLS_LANG JAVA_TOP PERL5LIB"
- Shell-Specific: "PS1 PS2 PS3 PS4 IFS MAILCHECK _ LOGNAME A__z"
Beginning pass 1.
Processing 343 environment variables...
333 removed; 10 saved.
Beginning pass 2.
Processing 10 environment variables...
0 removed; 10 saved.
Done removing extra environment variables.

Removing Application products' bin directories from PATH ...
Done removing Application products' bin directories from PATH

Reading Oracle Applications environment file
Your Oracle Applications environment file is /d01/app/oracle/apps/apps_st/appl/PROD_ebs.env

Removing $FND_TOP/$APPLBIN from PATH ...
Done removing $FND_TOP/$APPLBIN from PATH

Removing extra variables from the environment (again)...
adrelink will save the following variables (if set):
- Generic:
"PATH ORACLE_HOME TMPDIR TZ LD_LIBRARY_PATH COBDIR LIBPATH NLS_LANG JAVA_TOP PERL5LIB"
- Shell-Specific: "PS1 PS2 PS3 PS4 IFS MAILCHECK _ LOGNAME A__z"
Beginning pass 1.
Processing 325 environment variables...
318 removed; 7 saved.
Beginning pass 2.
Processing 7 environment variables...
0 removed; 7 saved.
Done removing extra environment variables (again).


Re-reading critical environment variables ...
Done re-reading critical environment variables


ORACLE RDBMS Version 10.1.0.5.0
Oracle Reports Version 10.1.2

Oracle Applications Release 12


Current product is AD
LADLIB is set to /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/lib/libad.a

Current product is ALR
LALRLIB is set to /d01/app/oracle/apps/apps_st/appl/alr/12.0.0/lib/libalr.a

Current product is AP
LAPLIB is set to /d01/app/oracle/apps/apps_st/appl/ap/12.0.0/lib/libap.a

Current product is AR
LARLIB is set to /d01/app/oracle/apps/apps_st/appl/ar/12.0.0/lib/libar.a
LARSRW is set to /d01/app/oracle/apps/apps_st/appl/ar/12.0.0/lib/xirar.o $(LARLIB)

Current product is BOM
LBOMLIB is set to /d01/app/oracle/apps/apps_st/appl/bom/12.0.0/lib/libbom.a

Current product is CRP
LCRPLIB is set to /d01/app/oracle/apps/apps_st/appl/crp/12.0.0/lib/libcrp.a

Current product is CZ
LCZLIB is set to /d01/app/oracle/apps/apps_st/appl/cz/12.0.0/lib/libcz.a

Current product is DT
LDTLIB is set to /d01/app/oracle/apps/apps_st/appl/dt/12.0.0/lib/libdt.a

Current product is ENG
LENGLIB is set to /d01/app/oracle/apps/apps_st/appl/eng/12.0.0/lib/libeng.a

Current product is FA
LFALIB is set to /d01/app/oracle/apps/apps_st/appl/fa/12.0.0/lib/libfa.a
LFASRW is set to /d01/app/oracle/apps/apps_st/appl/fa/12.0.0/lib/xirfa.o $(LFALIB)

Current product is FEM
LFEMLIB is set to /d01/app/oracle/apps/apps_st/appl/fem/12.0.0/lib/libfem.a

Current product is FF
LFFLIB is set to /d01/app/oracle/apps/apps_st/appl/ff/12.0.0/lib/libff.a

Current product is FND
LFNDLIB is set to /d01/app/oracle/apps/apps_st/appl/fnd/12.0.0/lib/libfnd.a
LFNDSRW is set to /d01/app/oracle/apps/apps_st/appl/fnd/12.0.0/lib/xirfnd.o $(LFNDLIB)

Current product is FTP
LFTPLIB is set to /d01/app/oracle/apps/apps_st/appl/ftp/12.0.0/lib/libftp.a

Current product is GL
LGLLIB is set to /d01/app/oracle/apps/apps_st/appl/gl/12.0.0/lib/libgl.a

Current product is GMA
LGMALIB is set to /d01/app/oracle/apps/apps_st/appl/gma/12.0.0/lib/libgma.a

Current product is GMF
LGMFLIB is set to /d01/app/oracle/apps/apps_st/appl/gmf/12.0.0/lib/libgmf.a

Current product is GML
LGMLLIB is set to /d01/app/oracle/apps/apps_st/appl/gml/12.0.0/lib/libgml.a

Current product is IBY
LIBYLIB is set to /d01/app/oracle/apps/apps_st/appl/iby/12.0.0/lib/libiby.a

Current product is INV
LINVLIB is set to /d01/app/oracle/apps/apps_st/appl/inv/12.0.0/lib/libinv.a

Current product is IZU
adrelink: Warning: not setting LIZULIB
since /d01/app/oracle/apps/apps_st/appl/izu/12.0.0/lib/libizu.a does not exist
or cannot be read.

Current product is MRP
LMRPLIB is set to /d01/app/oracle/apps/apps_st/appl/mrp/12.0.0/lib/libmrp.a

Current product is MSC
LMSCLIB is set to /d01/app/oracle/apps/apps_st/appl/msc/12.0.0/lib/libmsc.a

Current product is MSO
LMSOLIB is set to /d01/app/oracle/apps/apps_st/appl/mso/12.0.0/lib/libmso.a

Current product is MSR
LMSRLIB is set to /d01/app/oracle/apps/apps_st/appl/msr/12.0.0/lib/libmsr.a

Current product is MST
LMSTLIB is set to /d01/app/oracle/apps/apps_st/appl/mst/12.0.0/lib/libmst.a

Current product is MWA
LMWALIB is set to /d01/app/oracle/apps/apps_st/appl/mwa/12.0.0/lib/libmwa.a

Current product is PA
LPALIB is set to /d01/app/oracle/apps/apps_st/appl/pa/12.0.0/lib/libpa.a

Current product is PAY
LPAYLIB is set to /d01/app/oracle/apps/apps_st/appl/pay/12.0.0/lib/libpay.a

Current product is PO
LPOLIB is set to /d01/app/oracle/apps/apps_st/appl/po/12.0.0/lib/libpo.a
LPOSRW is set to /d01/app/oracle/apps/apps_st/appl/po/12.0.0/lib/xirpo.o $(LPOLIB)

Current product is PON
LPONLIB is set to /d01/app/oracle/apps/apps_st/appl/pon/12.0.0/lib/libpon.a

Current product is RG
LRGLIB is set to /d01/app/oracle/apps/apps_st/appl/rg/12.0.0/lib/librg.a

Current product is WIP
LWIPLIB is set to /d01/app/oracle/apps/apps_st/appl/wip/12.0.0/lib/libwip.a

Current product is WPS
LWPSLIB is set to /d01/app/oracle/apps/apps_st/appl/wps/12.0.0/lib/libwps.a

Current product is WSM
LWSMLIB is set to /d01/app/oracle/apps/apps_st/appl/wsm/12.0.0/lib/libwsm.a

Current product is XDP
LXDPLIB is set to /d01/app/oracle/apps/apps_st/appl/xdp/12.0.0/lib/libxdp.a

LUSRLIB is /d01/app/oracle/apps/apps_st/appl/fnd/12.0.0/usrxit/libusr.a

Not linking Oracle Applications with any Oracle mail product

LALRSTUB is now set to /d01/app/oracle/apps/apps_st/appl/alr/12.0.0/lib/alstub.o
MAILLNK is now set to /d01/app/oracle/apps/apps_st/appl/alr/12.0.0/lib/alstub.o

Creating prefix makefiles ...
Done creating prefix makefiles

Starting link of product 'ad' on Tue Mar 31 17:40:51 PDT 2009
Current product is ad
Current product _TOP is $AD_TOP
Current prodarea is /d01/app/oracle/apps/apps_st/appl/ad/12.0.0

Backing up or removing executables...

rm -f /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadminnew

Done backing up or removing executables.


Relinking module 'adadmin' in product ad ...

make -f /d01/app/oracle/apps/apps_st/appl/admin/out/link_ad_23310.mk /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadmin

Starting link of ad executable 'adadmin' on Tue Mar 31 17:40:52 PDT 2009
gcc -s -L/d01/app/oracle/apps/tech_st/10.1.2/lib/stubs -L/d01/app/oracle/apps/tech_st/10.1.2/lib -ldl -o /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadmin.new \
/d01/app/oracle/apps/apps_st/appl/ad/12.0.0/lib/adadmin.o \
/d01/app/oracle/apps/apps_st/appl/ad/12.0.0/lib/libad.a /d01/app/oracle/apps/apps_st/appl/fnd/12.0.0/lib/libfnd.a -lsql10 -lclntsh `cat /d01/app/oracle/apps/tech_st/10.1.2/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /d01/app/oracle/apps/tech_st/10.1.2/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lmm -lcore10 -lxml10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /d01/app/oracle/apps/tech_st/10.1.2/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /d01/app/oracle/apps/tech_st/10.1.2/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lcore10 -lxml10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lcore10 -lxml10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /d01/app/oracle/apps/tech_st/10.1.2/lib/sysliblist` -ldl -lm -lpthread
echo mcs /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadmin.new
mcs /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadmin.new
chmod 755 /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadmin.new
echo -nologo -manifest /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadmin.new.manifest -outputresource:/d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadmin.new;#1
-nologo -manifest /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadmin.new.manifest -outputresource:/d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadmin.new
echo /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadmin.new.manifest
/d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadmin.new.manifest
rm -f /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadmin.old
if test -f /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadminnew; then \
mv /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadminnew /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadmin.old; \
fi; \
mv /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadmin.new /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadminnew
Done with link of ad executable 'adadmin' on Tue Mar 31 17:40:53 PDT 2009

Done relinking module adadmin in product ad
Done with link of product 'ad' on Tue Mar 31 17:40:53 PDT 2009

copying /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adshell.pl to /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bintmp/adshell.pl
copying /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/aducsifm.pm to /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bintmp/aducsifm.pm
copying /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/aducssp.pl to /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bintmp/aducssp.pl
copying /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adutils.pl to /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bintmp/adutils.pl
copying /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adpatchnew to /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bintmp/adpatchnew
copying /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adadminnew to /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bintmp/adadminnew
copying /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adworker to /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bintmp/adworker
copying /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bin/adctrlnew to /d01/app/oracle/apps/apps_st/appl/ad/12.0.0/bintmp/adctrlnew

Swapping bintmp and binstage.
Stage preparation complete.

adrelink is exiting with status 0

End of adrelink session
Date/time is Tue Mar 31 17:40:54 PDT 2009
**********************************************************

Line-wrapping log file for readability ...
Done line-wrapping log file.



Finally, we can run ADADMIN as shown below:


[applmgr@ebs appl]$ . APPSPROD_ebs.env
[applmgr@ebs appl]$ adadmin

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

Oracle Applications AD Administration

Version 12.0.0

NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.

Your default directory is '/d01/app/oracle/apps/apps_st/appl'.
Is this the correct APPL_TOP [Yes] ?

AD Administration records your AD Administration session in a text file
you specify. Enter your AD Administration log file name or press [Return]
to accept the default file name shown in brackets.

Filename [adadmin.log] :

************* Start of AD Administration session *************
AD Administration version: 12.0.0
AD Administration started at: Tue Mar 31 2009 18:20:10

APPL_TOP is set to /d01/app/oracle/apps/apps_st/appl

You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?

Please enter the batchsize [1000] :


Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.

The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.

Sample Applications System names are: "prod", "test", "demo" and
"Development_2".

Applications System Name [PROD] : PROD *


NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.

Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.

Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.

Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.


Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *


Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *


Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *


Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *


Please enter the name Oracle Applications will use to identify this APPL_TOP.

The APPL_TOP name you select must be unique within an Oracle Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.

Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".

APPL_TOP Name [ebs] : ebs *



You are about to use or modify Oracle Applications product tables
in your ORACLE database 'PROD'
using ORACLE executables in '/d01/app/oracle/apps/tech_st/10.1.2'.

Is this the correct database [Yes] ?

AD Administration needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.

Enter the password for your 'SYSTEM' ORACLE schema:

...Unable to connect.

AD Administration error:
The following ORACLE error:

ORA-01017: invalid username/password; logon denied


occurred while executing the SQL statement:

CONNECT SYSTEM/*****

AD Administration error:
Unable to connect to 'SYSTEM'; password may be invalid.

AD Administration needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.

Enter the password for your 'SYSTEM' ORACLE schema:

...Unable to connect.

AD Administration error:
The following ORACLE error:

ORA-01017: invalid username/password; logon denied


occurred while executing the SQL statement:

CONNECT SYSTEM/*****

AD Administration error:
Unable to connect to 'SYSTEM'; password may be invalid.

AD Administration needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.

Enter the password for your 'SYSTEM' ORACLE schema:


The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS

Enter the ORACLE password of Application Object Library [APPS] :

AD Administration is verifying your username/password.
The status of various features in this run of AD Administration is:

<-Feature version in->
Feature Active? APPLTOP Data model Flags
------------------------------ ------- -------- ----------- -----------
CHECKFILE Yes 1 1 Y N N Y N Y
PREREQ Yes 6 6 Y N N Y N Y
CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N
PATCH_TIMING Yes 2 2 Y N N Y N Y
PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y
SCHEMA_SWAP Yes 1 1 Y N N Y Y Y
JAVA_WORKER Yes 1 1 Y N N Y N Y
CODELEVEL Yes 1 1 Y N N Y N Y



Identifier for the current session is 8747

Reading product information from file...

Reading language and territory information from file...

Reading language information from applUS.txt ...

AD Administration warning:
Product Data File
/d01/app/oracle/apps/apps_st/appl/admin/zfaprod.txt
does not exist for product "zfa".
This product is registered in the database but the
above file does not exist in APPL_TOP. The product
will be ignored without error.


AD Administration warning:
Product Data File
/d01/app/oracle/apps/apps_st/appl/admin/zsaprod.txt
does not exist for product "zsa".
This product is registered in the database but the
above file does not exist in APPL_TOP. The product
will be ignored without error.


AD Administration warning:
Product Data File
/d01/app/oracle/apps/apps_st/appl/admin/jtsprod.txt
does not exist for product "jts".
This product is registered in the database but the
above file does not exist in APPL_TOP. The product
will be ignored without error.


Reading database to see what industry is currently installed.

Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:

Code Language Status
---- --------------------------------------- ---------
US American English Base

Your base language will be AMERICAN.

Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...

Saving product information.

AD code level : [A.4]

AD Administration Main Menu
--------------------------------------------------

1. Generate Applications Files menu

2. Maintain Applications Files menu

3. Compile/Reload Applications Database Entities menu

4. Maintain Applications Database Entities menu

5. Change Maintenance Mode

6. Exit AD Administration




Enter your choice [6] :



And presto! Our Apps tools work for R12 EBS on Unbreakable Linux! Stay tuned as yours truly will keep the tips and tricks coming fast and furious for all things Oracle.

Cheers,
Ben

R12 EBS Installation Tips and Tricks: Failed Installation Solutions for RW-50015 Errors

After countless hours of frustrations with attempts to get a test Oracle EBS R12 installed on my Macbook Pro laptop running VMWare Fusion and Linux, I found a solution recently to a problem with installing a test Oracle R12 EBS environment on Oracle Enterprise Linux 5 (OEL 5- 32 bit) with VMWare Fusion. There is a bug in R12 EBS for Linux platforms that will cause the installation to fail on the Apache HTTP server process.

What happens is that you will receive an RW-50015 Error message during the Rapidwiz install process.


RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button.


Also at same time, the Rapid Install window will show many errors for HTTP.


I then used adapcctl.sh status to check on these services and sure enough the http server would not start:

[oracle@ebs scripts]$ ./adapcctl.sh status

You are running adapcctl.sh version 120.6.12000000.2

Checking status of OPMN managed Oracle HTTP Server (OHS) instance ...

Processes in Instance: PROD_ebs.ebs.sandiego.com
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
OC4J | oafm | 21168 | Alive
OC4J | forms | 21078 | Alive
OC4J | oacore | 20943 | Alive
HTTP_Server | HTTP_Server | N/A | Down


adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /d01/app/oracle/inst/apps/PROD_ebs/logs/appl/admin/log/adapcctl.txt for more information ...



According to the release notes from Oracle Metalink Support (Note #402310.1)
Oracle Applications Installation and Upgrade Notes Release 12 (12.0.4) for Linux (32-bit)
Oracle HTTP Server Patch (on OEL 5 and RHEL 5 only)

There is an issue with the Oracle HTTP Server that comes with the R12 EBS Suite that causes the linking process to fail for Apache. The solution is to exit the Rapid Install program, shutdown the OC4J and web services and apply the patch. Actually, it is really a library called libdb.so.2 which is missing from the default OEL 5 and RHEL 5 operating system. Even after I ran the up2date oracle-validated command to install all of the fixes for Oracle on Linux, it was still missing. So the patch really is to download the patch which contains this essential missing library file and copy it over to the /usr/lib directory structure.


Download and apply the patch 6078836 from OracleMetaLink to fix an issue with the Oracle HTTP Server bundled with the E-Business Suite technology stack. We unzip the patch:

[oracle@ebs oracle]$ unzip p6078836_101330_LINUX.zip
Archive: p6078836_101330_LINUX.zip
creating: 6078836/
inflating: 6078836/libdb.so.2
inflating: 6078836/README.txt
[oracle@ebs oracle]$ ls
6078836 apps db inst p6078836_101330_LINUX.zip StageR12
[oracle@ebs oracle]$ cd 6078836/

[oracle@ebs 6078836]$ ls
libdb.so.2 README.txt


Then we copy to /usr/lib.

[root@ebs 6078836] $ cp libdb.so.2 /usr/lib

[root@ebs lib]# cd /usr/lib

[root@ebs lib]# pwd
/usr/lib


[root@ebs lib]# ls libdb.so*
libdb.so libdb.so.2



After we apply the patch, we need to restart the web services using the adapcctl.sh utility. Actually, just re-run the Rapid Installer program which will do this step for us. After it is successful and Apache comes up, we can verify status for R12 EBS by running the adapcctl.sh command again as listed in the below example:

[oracle@ebs scripts]$ ./adapcctl.sh status

You are running adapcctl.sh version 120.6.12000000.2

Checking status of OPMN managed Oracle HTTP Server (OHS) instance ...

Processes in Instance: PROD_ebs.ebs.sandiego.com
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
OC4J | oafm | 21168 | Alive
OC4J | forms | 21078 | Alive
OC4J | oacore | 20943 | Alive
HTTP_Server | HTTP_Server | 28519 | Alive

We then re-start rapidwiz and voila! It works!




Now, we can access the R12 EBS Webportal main logon page as shown below:





We can now login to R12 EBS as SYSADMIN user using default sysadmin password as shown below to verify that all is working for our new R12 EBS installation:





Cheers,
Ben

Thursday, March 19, 2009

Fun with Oracle EBS R12 Installation

I am setting up a new test environment with Oracle EBS R12 release on OEL 5 with VMWare Fusion on a new Macbook Pro.

To install Oracle E-Business, we have two main options to stage the more than 20 DVDs that are part of a normal 11i or R12 EBS implementation. The first is to manually feed each DVD into the drive during the Rapid Install program for EBS installation. As you can imagine, this is very tedious and not convenient. The second option is far more convenient, use the perl script called adautostg.pl that comes with the Rapid Install DVD. The adautostg.pl script is on the Oracle R12 EBS Applications Rapid Install Start Here DVD and located under the /startCD/Disk1/rapidwiz directory on the DVD. However, there is a problem that may cause the autostage feature to fail with your R12 EBS installation. I ran into this problem today when I was trying to stage my R12 EBS test environment by running adautostg.pl. It appears that sometimes adautostg.pl cannot find the correct disk label and fails to access the automounted DVD. Since my new firm just became an Oracle partner, it still is a week or two before I can open a new iTar to resolve
this issue. However, suffice it to say, this issue with adautostg.pl has been around since 11i EBS release. My solution? Either load the DVDs one at a time during the Rapid Install process or copy over the 20 DVDs to a manually created staging area.

Stay tuned as we will cover how to implement RAC with single instance R12 EBS in an upcoming post!

Cheers,
Ben

Wednesday, March 11, 2009

A new chapter

Yesterday afternoon, I was let go from my job. Fortunately, it gives me desire now to build my own successful consulting firm. I have launched a new business and technical site to complement blogs on database technology called Ben Prusinski and Associates.

Please visit us for the best onsite and remote Oracle services possible for your budget as well as future white papers and tips on database technology.

Ben Prusinski and Associates
We are an Oracle practice with a focus on customer quality service and affordable solutions compared to larger firms.

I am also adding a second blog to host additional tips and tricks as the business site as I will have more space and room to add more detailed posts than in the past. Next month I will be presenting on more black magic for Oracle 11g at the Oracle conference in Santiago, Chile in April for CLOUG

They say that in every cloud is a silver lining. As a new Oracle ACE, I look forward to making even bigger contributions to the Oracle community this year and into the future!