Autoconfig On Db Tier Fails With Error – SP2-1503: Unable to initialize Oracle call interface

Oracle Applications 11.5.10.2 on Solaris 5.10 64bit SPARC

Oracle Application Database 10gR2 (10.2.0.4) upgraded to Oracle Database 11.2.0.3 using Interoperability Notes Oracle EBS 11i with Oracle Database 11gR2 (11.2.0) [ID 881505.1].

Issue encountered while executing adconfig in the end:

$>./adconfig.sh
Enter the full path to the Context file: /oracle01/myinstance/r12/db/product/11.2.0/dbhome_1/appsutil/myinstance_myserver.xml
Enter the APPS user password:
The log file for this session is located at: /oracle01/myinstance/r12/db/product/11.2.0/dbhome_1/appsutil/log/myinstance_myserver/07300952/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /oracle01/myinstance/r12/db/product/11.2.0/dbhome_1
Classpath                   : /oracle01/myinstance/r12/db/product/11.2.0/dbhome_1/jdk/jre/lib/rt.jar:/oracle01/myinstance/r12/db/product/11.2.0/dbhome_1/jdk/lib/dt.jar:/oracle01/myinstance/r12/db/product/11.2.0/dbhome_1/jdk/lib/tools.jar:/oracle01/myinstance/r12/db/product/11.2.0/dbhome_1/jdbc/lib/ojdbc5.jar:/oracle01/myinstance/r12/db/product/11.2.0/dbhome_1/appsutil/java/xmlparserv2.zip:/oracle01/myinstance/r12/db/product/11.2.0/dbhome_1/appsutil/java:/oracle01/myinstance/r12/db/product/11.2.0/dbhome_1/jlib/netcfg.jar

Using Context file          : /oracle01/myinstance/r12/db/product/11.2.0/dbhome_1/appsutil/myinstance_myserver.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed with errors.

adconfig.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>

[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /oracle01/myinstance/r12/db/product/11.2.0/dbhome_1/appsutil/install/myinstance_myserver
afdbprf.sh              INSTE8_PRF         1

[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /oracle01/myinstance/r12/db/product/11.2.0/dbhome_1/appsutil/install/myinstance_myserver
adcrobj.sh              INSTE8_APPLY       1
AutoConfig is exiting with status 2

Cause:
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

Solution:

The issue is related to ORA_TZFILE env variable in 11GR2 this env variable is no longer needed.

In Oracle Database server to fix this issue Unset the env varaible ORA_TZFILE and try to connect.

In Oracle Applications Database to fix this issue Perform the below.

The ORA_TZFILE is set while at 11gR2 this should not be set.

The  $ORACLE_HOME/appsutil/template/ad8idbux.env is from the wrong version  (ad8idbux.env 120.8)

The wrong file includes the  following:

ORA_TZFILE="$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat"

export  ORA_TZFILE

While for 11gr2 it should be:

if test "%s_database%" =  "db112" ;  then

ORA_TZFILE=""

else

ORA_TZFILE="$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat"

fi

export  ORA_TZFILE

Source the environment variable and executed autoconfig in Database Node, completed without issue

Reference: Autoconfig On Db Tier Fails With Error – SP2-1503: Unable to initialize Oracle call interface (Doc ID 1187616.1)

The issue is also resolved when you upgrade the applications 11i to Release 12 (12.1.1) or higher version on 11gR2 Database.

Advertisements

libclntsh.so.10.1: wrong ELF class: ELFCLASS64 Killed

I was upgrading to Oracle Applications 11.5.10.2. to R12 (12.1.1) on Solaris 10 64-bit Operating System.

While invoking adadmin utility after sourcing the R12 apps environment, I faced the following error:

bash-3.00$ adadmin
ld.so.1: adadmin: fatal: /oracle02/appsdev/R12/apps/tech_st/10.1.2/lib/libclntsh.so.10.1: wrong ELF class: ELFCLASS64
Killed

Tried doing the below:

bash-3.00$ $ORACLE_HOME/bin/genclntsh -32
cat: cannot open /oracle02/appsdev/R12/apps/tech_st/10.1.3/lib32/ldflags
Undefined                       first referenced
 symbol                             in file
nnfhboot                            /oracle02/appsdev/R12/apps/tech_st/10.1.3/lib32/libn10.a(nnfgt.o)
nnflboot                            /oracle02/appsdev/R12/apps/tech_st/10.1.3/lib32/libn10.a(nnfgt.o)
nnflgapc                            /oracle02/appsdev/R12/apps/tech_st/10.1.3/lib32/libnl10.a(nlpa.o)
nnftboot                            /oracle02/appsdev/R12/apps/tech_st/10.1.3/lib32/libn10.a(nnfgt.o)
nnflgav                             /oracle02/appsdev/R12/apps/tech_st/10.1.3/lib32/libnl10.a(nlol.o)
nnflfrm                             /oracle02/appsdev/R12/apps/tech_st/10.1.3/lib32/libnl10.a(nlol.o)
nnflrne                             /oracle02/appsdev/R12/apps/tech_st/10.1.3/lib32/libnl10.a(nlol.o)
ntusini                             /oracle02/appsdev/R12/apps/tech_st/10.1.3/lib32/libn10.a(ntcontab.o)
ntpini                              /oracle02/appsdev/R12/apps/tech_st/10.1.3/lib32/libn10.a(ntcontab.o)
nttini                              /oracle02/appsdev/R12/apps/tech_st/10.1.3/lib32/libn10.a(ntcontab.o)
ntzini                              /oracle02/appsdev/R12/apps/tech_st/10.1.3/lib32/libn10.a(ntcontab.o)
ld: fatal: Symbol referencing errors. No output written to /oracle02/appsdev/R12/apps/tech_st/10.1.3/lib32/libclntsh.so.10.1

@Per ‘unpublished’ Bug 5665338 – This issue is due to the libclntsh.so.10.1 library not being present under the 10.1.2 ORACLE_HOME/lib32 folder.

To fix the issue,  I did the following:

1.  Created a symbolic link

bash-3.00$ rm $ORACLE_HOME/lib32/ldflags
bash-3.00$ ln -s $ORACLE_HOME/lib/ldflags $ORACLE_HOME/lib32/ldflags
bash-3.00$ ls -ltr $ORACLE_HOME/lib32/ldflags
lrwxrwxrwx   1 appsdev  oracle         53 Apr  4 09:17 /oracle02/appsdev/R12/apps/tech_st/10.1.2/lib32/ldflags -> /oracle02/appsdev/R12/apps/tech_st/10.1.2/lib/ldflags

2. As root user, created a soft link

bash-3.00$ which make
/usr/css/bin/make
bash-3.00$  ln -s /usr/css/bin/make /usr/bin/make

2.  Tested the fix

bash-3.00$ $ genclntsh

3.  The above genclntsh command completed without error, then relinked all of the software

bash-3.00$ relink all

Check if libclntsh.so.10.1 library has been created under the 10.1.2 ORACLE_HOME/lib32 folder.

bash-3.00$  ls -ltr $ORACLE_HOME/lib32/libclntsh.so.10.1
-rwxr-xr-x   1 appsdev  oracle    18681000 Apr  4 09:23 /oracle02/appsdev/R12/apps/tech_st/10.1.2/lib32/libclntsh.so.10.1

Invoked ad utlilities now:

bash-3.00$ 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 '/oracle02/appsdev/R12/apps/apps_st/appl'.
Is this the correct APPL_TOP [Yes] ?

The problem got fixed for me.

References: 413109.1, 395731.1

APP-FND-01926 ORA-06508

I was upgrading Oracle Apps 11.5.10.2 to R12 and faced an issue with forms soon after applying Pre-requisite patches

APP-FND-01926:The custom event WHEN-LOGON-CHANGED raised unhandled exception:
ORA-06508: PL/SQL: could not find program unit being called

The issue can be reproduced at will with the following steps:

1. Login to http://hostname.domain:port/OA_HTML/AppsLocalLogin.jsp
2. Navigate to any forms-based application

After applying new patches, the forms and pl/sql libraries were not regenerated.

  1. Tried copying source CUSTOM.pll from backup
  2. re-compiling existing $AU_TOP/resource/CUSTOM.pll
  3. Copy and re-compile CUSTOM.pll
None of the above three helped in my case.

Finally, I did the following

1. Use adadmin and generate JAR files with force option.
2. Use adadmin and run Generate Form Files and PL/SQL Library Files

Forms started working!

MO Operating Unit

Multiple Organizations (Multi-Org)

In Oracle Applications R12, Multiple Organizations Access Control (MOAC) has made significant enhancements to the Release 11i Multiple Organizations architecture. If your company has implemented a Shared Services operating model, Multi-Org Access Control allows you to process business transactions more efficiently. You can access, process, and report on data across multiple operating units from a single responsibility without compromising data security or system performance.

Multi-Org Security Profile

The Multi-Org Security Profile allows you to access, process, and report on data for an unlimited number of operating units from a single applications responsibility. To take advantage of Multi-Org Access Control, you should set the following profile options:

  • MO: Security Profile: Assign your Security Profile to this profile option for each application responsibility to allow that responsibility to access multiple operating units.
  • MO: Default Operating Unit: If the MO: Security Profile is set, then you can assign a default operating unit for defaulting purposes.

The Release 11i MO: Operating Unit profile option setting is preserved, and applies if MO: Security Profile is not set.

Enhanced Cross-organization Reporting

Cross-organization reporting has been enhanced to be more consistent with the new Multi-Org Access Control. You can run reports across multiple operating units that belong to a user’s security profile that share the same ledger. You can also run reports for any operating unit that belongs to a user’s security profile.

Setting Up Operating Units

Setting up operating units is more streamlined with the integration with Accounting Setup Manager, a new feature in General Ledger that centralizes the setup and maintenance of common financial components, such as legal entities, operating units, and ledgers within an accounting setup.

All Release 11i HR Organizations classified as Operating Units are preserved during the upgrade. If operating units are assigned to a set of books, they are associated to a primary ledger in an accounting setup. You can now view all operating units assigned to an upgraded primary ledger using Accounting Setup Manager.

INST_TOP

Oracle Application R12