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

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!

mod_jserv.log’ can’t be opened

This applies to Oracle Applications 11.5.10, any platform.

The Apache Web listener fails to start, however the “adstrtal.sh” script does not show any errors.

Syntax error on line 60 of $IAS_ORACLE_HOME/Apache/Jserv/etc/jserv.conf:
ApJServLogFile: file '$IAS_ORACLE_HOME/Apache/Jserv/logs/mod_jserv.log' can't be opened
./apachectl start: httpd could not be started

Check $COMMON_TOP/admin/log/$CONTEXT_NAME/adapcctl.txt and you will find the above error.

Users cannot see the login page.

$ telnet localhost 8000 
will give network error.

Alternatively, you can run the below command

$ cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME
$ ./adapcctl.sh: configtest

It will return the same error as above.

This is due to the log file mod_jserv.log file is very large <2G> and therefore the log file could not be opened.

Clear out the contents of mod_jserv.log then restart the Apache Listener.

Now, check the config

$ ./adapcctl.sh configtest

adapcctl.sh version 115.55

Checking the Apache Web Server Dedicated HTTP Listener configuration file..
Syntax OK
Checking the Apache Web Server Dedicated PLSQL  Listener configuration file..
Syntax OK

adapcctl.sh: exiting with status 0

$ telnet localhost 8000
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.

Cannot complete applications logon. You may have entered an invalid applications password, or there may have been a database connect error.

This applies to Oracle Applications 11.5.10.2

Resolved.

Node ID does not exist for the current application server ID

This applies to Oracle Applications version 11.5.10.2 or higher

resolved

Req IMPORT slow

Oracle Financials : Oracle Purchasing : 11.5.10.2

Requisition Import is very slow.