Tag Archives: Patching - Page 3

Could not start Service Manager

Posted by on December 10, 2008 No comments

Problem:

Concurrent manager not starting on ebusinesstest. Checked Metalink Doc ID:  Note:104452.1 (Subject:  Troubleshooting Concurrent Manager (Unix specific). Changed to /u0/oracle/testcomn/admin/log/TEST_ebusinesstest ($APPLCSF/$APPLLOG) and check last .mgr file (TEST_0424.mgr). It showed the following error message:

Starting PASMGR Concurrent Manager                 : 24-APR-2009 12:29:17
Spawned Process 18408
Could not start Service Manager FNDSM_EBUSINESSTEST_TEST. The TNS alias could not be located, the listener process on EBUSINESSTEST could not be contacted, or the listener failed to spawn the Service Manager process.
Routine AFPEIM encountered an error while starting concurrent manager PASMGR with library /u0/oracle/testappl/pa/11.5.0/bin/PALIBR.
Check that your system has enough resources to start a concurrent manager process. Contact your system admi : 24-APR-2009 12:29:17
                     Process monitor session ended : 24-APR-2009 12:29:17

Solution:

Checked Metalink for message ‘Could not start Service Manager’. Checked Metalink Doc ID:  423170.1 (Subject:  Concurrent Manager Fails to Start Because of a ‘Could not start Service Manager FNDSM__’ Error)

To implement the solution, please execute the following steps:

1. Download and apply patch 3830807: ” PATCH 3293983 NEEDS TO INCLUDE ALL THE MAKEFILES UNDER THE 8.0.6 ORACLE_HOME”.

2. Launch adadmin and choose the task to relink all product executables.

3. Startup the Concurrent Manager.

The Concurrent Manager should start without any errors. There should be no errors in the 8.0.6 listener log file.

Error updating master archive

Posted by on December 7, 2008 No comments

Problem:

When applying patch 4104924, the following error appears:

AutoPatch error:
ERROR
[code language="1"][/code]
[/code]
 Running adjopy.class
AutoPatch error:
Error updating master archive

Solution:

LD_ASSUME_KERNEL not set

export LD_ASSUME_KERNEL=2.4.19

PSEM Agents Not Starting

Posted by on November 27, 2008 No comments

Problem:

When the StartAgent.bat command is executed, the following appears:

E:PSOFTFS900PSEMAgent>StartAgent.bat

ERROR main EMF_CATEGORY – Error while connecting to ‘http://glwebapp:8001/PSEMHUB/hub’.
ERROR main EMF_CATEGORY – Error: Internal Exception: – Error registering peer
ERROR main EMF_CATEGORY – Error while connecting to server – retrying attempt 1
ERROR main EMF_CATEGORY – Error while connecting to ‘http://glwebapp:8001/PSEMHUB/hub’.
ERROR main EMF_CATEGORY – Error: Internal Exception: – Error registering peer
ERROR main EMF_CATEGORY – Error while connecting to server – retrying attempt 2

Troubleshooting:

In Command Prompt, stopped the PSEMHUB profile with the following commands:

set PATH=%PATH%;E:PSOFTFS900webservPSOL_fsdmoinstalledAppsPSOL_fsdmoNodeCellPSOL.earPSOL.warWEB-INFlibwinx86;E:PSOFTFS900veritywinx86_nti40bin

cd /d E:PSOFTFS900webserv

PSEMHUB_fsdmobinstopServer.bat server1 -profileName PSEMHUB_fsdmo

Moved all the files in E:PSOFTFS900webservPSEMHUB_fsdmologsserver1 to backup_20081127a.

Then restarted the PSEMHUB profile:

set PATH=%PATH%;E:PSOFTFS900webservPSOL_fsdmoinstalledAppsPSOL_fsdmoNodeCellPSOL.earPSOL.warWEB-INFlibwinx86;E:PSOFTFS900veritywinx86_nti40bin

cd /d E:PSOFTFS900webserv

PSEMHUB_fsdmobinstartServer.bat server1 -profileName PSEMHUB_fsdmo

The E:PSOFTFS900webservPSEMHUB_fsdmologsserver1SystemOut.log contains the following error:

************ Start Display Current Environment ************
WebSphere Platform 6.1 [ND 6.1.0.3 cf30646.29] running with process name PSEMHUB_fsdmoNodeCellPSEMHUB_fsdmoNodeserver1 and process id 260
Host Operating System is Windows Server 2003, version 5.2 build 3790 Service Pack 1
Java version = J2RE 1.5.0 IBM J9 2.3 Windows Server 2003 x86-32 j9vmwi3223-20061001 (JIT enabled)
J9VM – 20060915_08260_lHdSMR
JIT – 20060908_1811_r8
GC – 20060906_AA, Java Compiler = j9jit23, Java VM name = IBM J9 VM
was.install.root = E:IBMWebSphereAppServer
user.install.root = E:PSOFTFS900webservPSEMHUB_fsdmo
Java Home = E:IBMWebSphereAppServerjavajre
ws.ext.dirs = E:IBMWebSphereAppServer/java/lib;E:PSOFTFS900webservPSEMHUB_fsdmo/classes;E:IBMWebSphereAppServer/classes;E:IBMWebSphereAppServer/lib;E:IBMWebSphereAppServer/installedChannels;E:IBMWebSphereAppServer/lib/ext;E:IBMWebSphereAppServer/web/help;E:IBMWebSphereAppServer/deploytool/itp/plugins/com.ibm.etools.ejbdeploy/runtime
Classpath = E:PSOFTFS900webservPSEMHUB_fsdmo/properties;E:IBMWebSphereAppServer/properties;E:IBMWebSphereAppServer/lib/startup.jar;E:IBMWebSphereAppServer/lib/bootstrap.jar;E:IBMWebSphereAppServer/lib/j2ee.jar;E:IBMWebSphereAppServer/lib/lmproxy.jar;E:IBMWebSphereAppServer/lib/urlprotocols.jar;E:IBMWebSphereAppServer/deploytool/itp/batchboot.jar;E:IBMWebSphereAppServer/deploytool/itp/batch2.jar;E:IBMWebSphereAppServer/java/lib/tools.jar
Java Library path = E:IBMWebSphereAppServerjavajrebin;.;E:IBMWebSphereAppServerbin;E:IBMWebSphereAppServerjavabin;E:IBMWebSphereAppServerjavajrebin;E:PSOFTFS900binclientwinx86;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;E:beaTuxedo9.1bin;E:PSOFTFS900webservPSOL_fsdmoinstalledAppsPSOL_fsdmoNodeCellPSOL.earPSOL.warWEB-INFlibwinx86;E:PSOFTFS900veritywinx86_nti40bin;C:PS_HOMEbinclientwinx86;C:Program FilesMicrosoft SQL Server80ToolsBinn;C:Program FilesMicrosoft SQL Server90Toolsbinn;C:Program FilesMicrosoft SQL Server90DTSBinn;C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDE;E:PSOFTFS900webservPSOL_fsdmoinstalledAppsPSOL_fsdmoNodeCellPSOL.earPSOL.warWEB-INFlibwinx86;E:PSOFTFS900veritywinx86_nti40bin
************* End Display Current Environment *************
[11/27/08 11:14:53:265 VET] 0000000a ModuleManifes E UTLS0002E: The shared library psSharedLibrary contains a classpath entry which does not resolve to a valid jar file, the library jar file is expected to be found at E:PSOFTFS900webservPSEMHUB_fsdmoinstalledAppsPSEMHUB_fsdmoNodeCellPSEMHUB.earPSIGW.warWEB-INFlibmail.jar.
[11/27/08 11:14:53:390 VET] 0000000a ModuleManifes E UTLS0002E: The shared library psSharedLibrary contains a classpath entry which does not resolve to a valid jar file, the library jar file is expected to be found at E:PSOFTFS900webservPSEMHUB_fsdmoinstalledAppsPSEMHUB_fsdmoNodeCellPSEMHUB.earPSIGW.warWEB-INFlibactivation.jar.
[11/27/08 11:16:00:546 VET] 0000000a TCPPort E TCPC0003E: TCP Channel TCP_4 initialization failed. The socket bind failed for host * and port 8500. The port may already be in use.
[11/27/08 11:16:00:546 VET] 0000000a WSChannelFram E CHFW0034W: The Transport Channel Service detected transport chain WCInboundDefaultSecure failed. The service will retry to start chain WCInboundDefaultSecure every 5000 milliseconds for up to 60 attempts.
[11/27/08 11:16:00:562 VET] 0000000a TCPPort E TCPC0003E: TCP Channel TCP_4 initialization failed. The socket bind failed for host * and port 8500. The port may already be in use.
[11/27/08 11:16:00:562 VET] 0000000a WSChannelFram E CHFW0034W: The Transport Channel Service detected transport chain SOAPAcceptorChain3 failed. The service will retry to start chain SOAPAcceptorChain3 every 5000 milliseconds for up to 60 attempts.

Netstat showed the following output:

E:PSOFTFS900webservPSEMHUB_fsdmo>netstat -na|more

Active Connections

Proto Local Address Foreign Address State
TCP 0.0.0.0:86 0.0.0.0:0 LISTENING
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1025 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2809 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2810 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2811 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING
TCP 0.0.0.0:8000 0.0.0.0:0 LISTENING
TCP 0.0.0.0:8001 0.0.0.0:0 LISTENING
TCP 0.0.0.0:8002 0.0.0.0:0 LISTENING
TCP 0.0.0.0:8500 0.0.0.0:0 LISTENING
TCP 0.0.0.0:8502 0.0.0.0:0 LISTENING
TCP 0.0.0.0:8880 0.0.0.0:0 LISTENING
TCP 0.0.0.0:8881 0.0.0.0:0 LISTENING
TCP 0.0.0.0:8882 0.0.0.0:0 LISTENING
TCP 0.0.0.0:9043 0.0.0.0:0 LISTENING
TCP 0.0.0.0:9044 0.0.0.0:0 LISTENING
TCP 0.0.0.0:9045 0.0.0.0:0 LISTENING
TCP 0.0.0.0:9060 0.0.0.0:0 LISTENING
TCP 0.0.0.0:9061 0.0.0.0:0 LISTENING
TCP 0.0.0.0:9062 0.0.0.0:0 LISTENING
TCP 0.0.0.0:9100 0.0.0.0:0 LISTENING
TCP 0.0.0.0:9101 0.0.0.0:0 LISTENING
TCP 0.0.0.0:9102 0.0.0.0:0 LISTENING
TCP 10.18.14.30:139 0.0.0.0:0 LISTENING
Note that port 8501 is not used.

Check ports of PIA: pointed web browser to http://glwebapp:9060/ibm/console/. Logged on as admin. On the left pane, navigated to Servers > Application Servers. Click server1, and under Communications, click Ports.

Note that the WC_defaulthost_secure is 8500.

Check ports of PSEM: pointed web browser to http://glwebapp:9061/ibm/console/. Logged on as admin. On the left pane, navigated to Servers > Application Servers. Click server1, and under Communications, click Ports.

Note that the WC_defaulthost_secure is also 8500. It should be 8501(?)

Click WC_default_secure, and then change the port number from 8500 to 8501. The following message appears:

One or more virtual hosts match the previous host name and port combination of “*:8500” and do not match the new combination of “*:8501.” You might need to update the host aliases.
Changes have been made to your local configuration. You can:

• Save directly to the master configuration.
• Review changes before saving or discarding.

The server may need to be restarted for these changes to take effect.

The PSEM profile is stopped and started using the steps shown above.

After stopping PSEM web profile and restarting, the following error appears:

Recover prior changes

Your prior session timed out before the changes could be published to the master configuration. Would you like to recover the changes made in the prior session or work with the master configuration?

Work with the master configuration
Recover changes made in prior session View items with changes

Changed Items Status
cells / PSEMHUB_fsdmoNodeCell / nodes / PSEMHUB_fsdmoNode / serverindex.xml Updated

Also:

Enterprise Applications > Save
Save your workspace changes to the master configuration.

Click Save to update the master repository with your changes.
Click Discard to discard your changes and begin work again using the master repository configuration.
Click Cancel to continue working with your changes.

Total changed documents: 2

Changed Items Status
cells / PSEMHUB_fsdmoNodeCell / nodes / PSEMHUB_fsdmoNode / serverindex.xml Updated
cells / PSEMHUB_fsdmoNodeCell / applications / PSEMHUB.ear / deployments / PSEMHUB / deployment.xml

After saving the master configuration, PSEM was stopped and restarted. The file E:PSOFTFS900webservPSEMHUB_fsdmologsserver SystemOut.log showed:

************ Start Display Current Environment ************
WebSphere Platform 6.1 [ND 6.1.0.3 cf30646.29] running with process name PSEMHUB_fsdmoNodeCellPSEMHUB_fsdmoNodeserver1 and process id 2580
Host Operating System is Windows Server 2003, version 5.2 build 3790 Service Pack 1
Java version = J2RE 1.5.0 IBM J9 2.3 Windows Server 2003 x86-32 j9vmwi3223-20061001 (JIT enabled)
J9VM – 20060915_08260_lHdSMR
JIT – 20060908_1811_r8
GC – 20060906_AA, Java Compiler = j9jit23, Java VM name = IBM J9 VM
was.install.root = E:IBMWebSphereAppServer
user.install.root = E:PSOFTFS900webservPSEMHUB_fsdmo
Java Home = E:IBMWebSphereAppServerjavajre
ws.ext.dirs = E:IBMWebSphereAppServer/java/lib;E:PSOFTFS900webservPSEMHUB_fsdmo/classes;E:IBMWebSphereAppServer/classes;E:IBMWebSphereAppServer/lib;E:IBMWebSphereAppServer/installedChannels;E:IBMWebSphereAppServer/lib/ext;E:IBMWebSphereAppServer/web/help;E:IBMWebSphereAppServer/deploytool/itp/plugins/com.ibm.etools.ejbdeploy/runtime
Classpath = E:PSOFTFS900webservPSEMHUB_fsdmo/properties;E:IBMWebSphereAppServer/properties;E:IBMWebSphereAppServer/lib/startup.jar;E:IBMWebSphereAppServer/lib/bootstrap.jar;E:IBMWebSphereAppServer/lib/j2ee.jar;E:IBMWebSphereAppServer/lib/lmproxy.jar;E:IBMWebSphereAppServer/lib/urlprotocols.jar;E:IBMWebSphereAppServer/deploytool/itp/batchboot.jar;E:IBMWebSphereAppServer/deploytool/itp/batch2.jar;E:IBMWebSphereAppServer/java/lib/tools.jar
Java Library path = E:IBMWebSphereAppServerjavajrebin;.;E:IBMWebSphereAppServerbin;E:IBMWebSphereAppServerjavabin;E:IBMWebSphereAppServerjavajrebin;E:PSOFTFS900binclientwinx86;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;E:beaTuxedo9.1bin;E:PSOFTFS900webservPSOL_fsdmoinstalledAppsPSOL_fsdmoNodeCellPSOL.earPSOL.warWEB-INFlibwinx86;E:PSOFTFS900veritywinx86_nti40bin;C:PS_HOMEbinclientwinx86;C:Program FilesMicrosoft SQL Server80ToolsBinn;C:Program FilesMicrosoft SQL Server90Toolsbinn;C:Program FilesMicrosoft SQL Server90DTSBinn;C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDE;E:PSOFTFS900webservPSOL_fsdmoinstalledAppsPSOL_fsdmoNodeCellPSOL.earPSOL.warWEB-INFlibwinx86;E:PSOFTFS900veritywinx86_nti40bin;E:PSOFTFS900webservPSOL_fsdmoinstalledAppsPSOL_fsdmoNodeCellPSOL.earPSOL.warWEB-INFlibwinx86;E:PSOFTFS900veritywinx86_nti40bin;E:PSOFTFS900webservPSOL_fsdmoinstalledAppsPSOL_fsdmoNodeCellPSOL.earPSOL.warWEB-INFlibwinx86;E:PSOFTFS900veritywinx86_nti40bin;E:PSOFTFS900webservPSOL_fsdmoinstalledAppsPSOL_fsdmoNodeCellPSOL.earPSOL.warWEB-INFlibwinx86;E:PSOFTFS900veritywinx86_nti40bin
************* End Display Current Environment *************
[11/27/08 14:39:35:968 VET] 0000000a ModuleManifes E UTLS0002E: The shared library psSharedLibrary contains a classpath entry which does not resolve to a valid jar file, the library jar file is expected to be found at E:PSOFTFS900webservPSEMHUB_fsdmoinstalledAppsPSEMHUB_fsdmoNodeCellPSEMHUB.earPSIGW.warWEB-INFlibmail.jar.
[11/27/08 14:39:36:093 VET] 0000000a ModuleManifes E UTLS0002E: The shared library psSharedLibrary contains a classpath entry which does not resolve to a valid jar file, the library jar file is expected to be found at E:PSOFTFS900webservPSEMHUB_fsdmoinstalledAppsPSEMHUB_fsdmoNodeCellPSEMHUB.earPSIGW.warWEB-INFlibactivation.jar.

Note that there is no reference to the port number.

The file E:PSOFTFS900webservPSEMHUB_fsdmologsserverstartServer.log showed:

************ Start Display Current Environment ************
Host Operating System is Windows Server 2003, version 5.2 build 3790 Service Pack 1
Java version = J2RE 1.5.0 IBM J9 2.3 Windows Server 2003 x86-32 j9vmwi3223-20061001 (JIT enabled)
J9VM – 20060915_08260_lHdSMR
JIT – 20060908_1811_r8
GC – 20060906_AA, Java Compiler = j9jit23, Java VM name = IBM J9 VM
was.install.root = E:IBMWebSphereAppServer
user.install.root = E:PSOFTFS900webservPSEMHUB_fsdmo
Java Home = E:IBMWebSphereAppServerjavajre
ws.ext.dirs = E:\IBM\WebSphere\AppServer\java\lib;E:\IBM\WebSphere\AppServer\classes;E:\IBM\WebSphere\AppServer\lib;E:\IBM\WebSphere\AppServer\installedChannels;E:\IBM\WebSphere\AppServer\lib\ext;E:\IBM\WebSphere\AppServer\web\help;E:\IBM\WebSphere\AppServer\deploytool\itp\plugins\com.ibm.etools.ejbdeploy\runtime
Classpath = E:PSOFTFS900webservPSEMHUB_fsdmoproperties;E:IBMWebSphereAppServerproperties;E:IBMWebSphereAppServerlibstartup.jar;E:IBMWebSphereAppServerlibbootstrap.jar;E:IBMWebSphereAppServer/lib/j2ee.jar;E:IBMWebSphereAppServer/lib/lmproxy.jar;E:IBMWebSphereAppServer/lib/urlprotocols.jar;E:IBMWebSphereAppServerjavalibtools.jar
Java Library path = E:IBMWebSphereAppServerjavajrebin;.;E:IBMWebSphereAppServerbin;E:IBMWebSphereAppServerjavabin;E:IBMWebSphereAppServerjavajrebin;E:PSOFTFS900binclientwinx86;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;E:beaTuxedo9.1bin;E:PSOFTFS900webservPSOL_fsdmoinstalledAppsPSOL_fsdmoNodeCellPSOL.earPSOL.warWEB-INFlibwinx86;E:PSOFTFS900veritywinx86_nti40bin;C:PS_HOMEbinclientwinx86;C:Program FilesMicrosoft SQL Server80ToolsBinn;C:Program FilesMicrosoft SQL Server90Toolsbinn;C:Program FilesMicrosoft SQL Server90DTSBinn;C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDE;E:PSOFTFS900webservPSOL_fsdmoinstalledAppsPSOL_fsdmoNodeCellPSOL.earPSOL.warWEB-INFlibwinx86;E:PSOFTFS900veritywinx86_nti40bin;E:PSOFTFS900webservPSOL_fsdmoinstalledAppsPSOL_fsdmoNodeCellPSOL.earPSOL.warWEB-INFlibwinx86;E:PSOFTFS900veritywinx86_nti40bin;E:PSOFTFS900webservPSOL_fsdmoinstalledAppsPSOL_fsdmoNodeCellPSOL.earPSOL.warWEB-INFlibwinx86;E:PSOFTFS900veritywinx86_nti40bin;E:PSOFTFS900webservPSOL_fsdmoinstalledAppsPSOL_fsdmoNodeCellPSOL.earPSOL.warWEB-INFlibwinx86;E:PSOFTFS900veritywinx86_nti40bin
Current trace specification = *=info:com.ibm.*=all
************* End Display Current Environment *************

[11/27/08 14:39:29:515 VET] 0000000a ManagerAdmin I TRAS0017I: The startup trace state is *=info:com.ibm.*=all.
[11/27/08 14:39:29:515 VET] 0000000a WsServerContr 1 Executing executeUtilityOnWindows with args: E:PSOFTFS900webservPSEMHUB_fsdmoconfig PSEMHUB_fsdmoNodeCell PSEMHUB_fsdmoNode server1
[11/27/08 14:39:29:515 VET] 0000000a WsServerContr 1 Getting WindowsService obj with: server1 and E:PSOFTFS900webservPSEMHUB_fsdmoconfig PSEMHUB_fsdmoNodeCell PSEMHUB_fsdmoNode server1
[11/27/08 14:39:29:515 VET] 0000000a WindowsServic > getWindowsServiceNameForServer() Entry
[11/27/08 14:39:29:515 VET] 0000000a WindowsServic 1 In executeCommand, args are: E:IBMWebSphereAppServerbinWASService.exe -getServiceName server1 -profilePath E:PSOFTFS900webservPSEMHUB_fsdmo
[11/27/08 14:39:29:531 VET] 0000000a WindowsServic 1 Runtime.exec() returned process java.lang.ProcessImpl@456a456a
[11/27/08 14:39:29:531 VET] 0000000a WindowsServic 1 retCode from childProcess.waitFor() is 0
[11/27/08 14:39:29:531 VET] 0000000a WindowsServic 3 exitCode = 0
[11/27/08 14:39:30:531 VET] 0000000a WindowsServic 1 Trying to new up WindowsService using serverName=server1, winServiceName=null
[11/27/08 14:39:30:531 VET] 0000000a ManagerAdmin I TRAS0018I: The trace state has changed. The new trace state is *=info.
[11/27/08 14:39:30:562 VET] 0000000a AdminTool A ADMU0128I: Starting tool with the PSEMHUB_fsdmo profile
[11/27/08 14:39:30:562 VET] 0000000a AdminTool A ADMU3100I: Reading configuration for server: server1
[11/27/08 14:39:32:828 VET] 0000000a AdminTool A ADMU3200I: Server launched. Waiting for initialization status.
[11/27/08 14:40:41:796 VET] 0000000a AdminTool A ADMU3000I: Server server1 open for e-business; process id is 2580

Solution:

Ensure that the web server is started

References:

http://www-128.ibm.com/developerworks/forums/thread.jspa?threadID=169775&start=15&tstart=0

Version of OUI too low (Cloning)

Posted by on September 21, 2008 No comments

Problem:

When rerunning adcfgclone.pl, the following error occurs:

ERROR: The version of the OUI found in /u0/oracle/testora/iAS/appsoui (2.1.0.17.0) is too low. Please make sure that you have applied the latest OUI patch required by Rapid Clone.

Restart adclone.pl after performing required corrections.

ERROR: Failed to execute adclone.pl

Solution:

Apply patch 5035661:

A. Applying the patch on the iAS $ORACLE_HOME:

———————————————-

1.Unzip the patch into the <iAS ORACLE_HOME> directory:

unzip -od <iAS ORACLE_HOME> p5035661_11i_<PLATFORM>.zip

ie: unzip -od /u01/oracle/prodora/iAS p5035661_11i_LINUX.zip

2.Source the Apps environment file :

On Unix/Linux, execute <APPL_TOP>/APPS<SID>_<hostname>.env

On Windows, execute <APPL_TOP>Envshell.cmd.

If the environment file is not available, please make sure the environment variable ‘APPL_TOP’ is set.

3.Change directory to the <iAS ORACLE_HOME>/appsoui/setup

4.Execute the perl script OUIsetup.pl:

perl OUIsetup.pl

NOTE:

In the case of a Multi-Node instance, the above process should be repeated on the <iAS ORACLE_HOME> of each Node.

unzip -od /u0/oracle/testora/iAS/ /u0/patches/p5035661_11i_LINUX.zip

. /u0/oracle/testappl/APPSTEST_ebusinesstest.env

cd /u0/oracle/testora/iAS/appsoui/setup/

perl OUIsetup.pl

Invalid responsibility running patch 3262159

Posted by on September 10, 2008 1 comment

Problem:

When running patch 3262159, the following message appears:

ATTENTION: All workers either have failed or are waiting:
FAILED: file FNDLIBR      on worker  1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Checked adwork001.log:
/u0/oracle/prodappl/fnd/11.5.0/bin/FNDLIBR FND FNDCPBWV &ui_apps SYSADMIN 'System Administrator' SYSADMIN
List of errors encountered:
.......................................................................
_ 1 _
Please enter a valid responsibility.  The responsibility System
Administrator does not exist or is not active.  Check that the correct
application short name is specified for your responsibility.
(ROUTINE=AFPSSC)
.......................................................................
AD Worker error:
The above program failed with error code 1.
See the AD Worker log file and/or the program log file for details.

Solution:

In adctrl, used option 8 to skip the worker. Needed to disable, then enable maintenance mode. Then sourced the environment and ran:

/u0/oracle/prodappl/fnd/11.5.0/bin/FNDLIBR FND FNDCPBWV apps/apps SYSADMIN ‘System Administrator’ SYSADMIN

Reference:

Note 259319.1 – Adpatch Fails With Sysadmin Does Not Exist Or Not Active

adogjf() Unable to generate jar files under JAVA_TOP

Posted by on September 9, 2008 No comments

Problem:

While applying patch 6502082, the patch completes in error with the following message:

ERROR: Javakey subcommand exited with status 1
Javakey standard output:
Adding entry: META-INF/MANIFEST.MF
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
AD Java Key Generation
Version 11.5.0
NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Javakey error output:
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Reading language information from applUS.txt ...
Successfully created javaVersionFile.
TEST_hrms not found in database.
java key error:
adjava -ms128m -mx256m sun.security.provider.Main -gs /u0/oracle/prodcomn/java/oracle/apps/pon/jar/ponam.jar.tmp /u0/oracle/prodcomn/java/oracle/apps/pon/jar/ponam.jar.uns
The above Java program failed with error code 1.
Assigned: file adpcpset.pls on worker  1 for product ad  username APPLSYS.

Solution:

  1. Source the apps tier environment (APPSORA.env) and run adjkey –l
[applmgr@ebusiness 6502082]$ adjkey -l
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
AD Java Key Generation
Version 11.5.0
NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Successfully created javaVersionFile.
Scope: sun.security.provider.IdentityDatabase, source file: /home/applmgr/identitydb.obj
[Signer]Customer[identitydb.obj][trusted]
[Signer]DEMO_ebusiness[identitydb.obj][trusted]
java key is complete.
  1. Rename the identitydb.obj file in /home/applmgr
  2. Run: adjkey –initialize to create a new certificate
[applmgr@ebusiness 6502082]$ mv /home/applmgr/identitydb.obj /home/applmgr/identitydb.obj.20080909a
[applmgr@ebusiness 6502082]$ adjkey -initialize
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
AD Java Key Generation
Version 11.5.0
NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Successfully created javaVersionFile.
AD Java Key will now create a signing entity for you.
Please enter the name of the entity you wish to create [Customer] :
After creating the signing entity, a certificate will
be created for signing jar files locally.  You can specify an
organization to be used in identifying the certificate.
Please specify an organization to be assigned to the certificate [DEFAULT_ORG] :
Created identity [Signer]Customer[identitydb.obj][trusted]
Generated DSA keys for Customer (strength: 512).
Generated certificate from directive file /u0/oracle/prodappl/admin/out/adcert.txt.
Your digital signature has been created successfully and
imported into the javakey identity database. This signature
will now be used to sign Applications JAR files whenever
they are patched.
IMPORTANT: If you have multiple web servers, you must copy
files to each of the remaining web servers on your site.
See the documentation reference for more information.
java key is complete.

References:

Note 141692.1 – How to Install a Digital Certificate in Oracle Applications Release 11i

Note 365735.1 – How to use, create and/or update Digital Certificates for 11i Applications

Grants missing after applying patch 6502082

Posted by on September 7, 2008 No comments

Problem: The following error occurs when applying patch 6502082 for the second time:

AutoPatch error:

Your database is missing important grants on SYS objects.

To fix this:

1) Log on as the database server owner, and set your environment for maintaining your database server.  Create a directory called $ORACLE_HOME/appsutil/admin and copy $APPL_TOP/admin/adgrants.sql to that directory.

2) Connect to the database as the SYS user and run adgrants.sql passing the name of the schema containing FND tables. For example, if the schema that contains FND tables in your database is called APPLSYS, you would run adgrants.sql as follows:

$ cd $ORACLE_HOME/appsutil/admin

$ sqlplus /nolog

SQL> connect / as sysdba

SQL> @adgrants.sql APPLSYS

Solution: Perform steps listed above

FAILED: file affurgol.sql on worker 1

Posted by on August 25, 2008 No comments

Problem: When applying patch, the following error appears:

ATTENTION: All workers either have failed or are waiting:
           FAILED: file affurgol.sql on worker  1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Checked log file /u0/oracle/testappl/admin/TEST/log/adwork001.log:

declare
*
ERROR at line 1:
ORA-01653: unable to extend table APPLSYS.WF_LOCAL_ROLES_STAGE by 2362205 in
tablespace APPLSYSD
ORA-06512: at "APPS.WF_LOCAL_SYNCH", line 2380
ORA-06512: at line 55

Solution: Resize the next extent to 40K.

SQL> select table_name, initial_extent, next_extent, min_extents, max_extents, pct_increase, blocks from dba_tables where table_name = 'WF_LOCAL_ROLES_STAGE';
TABLE_NAME                     INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE     BLOCKS
------------------------------ -------------- ----------- ----------- ----------- ------------ ----------
WF_LOCAL_ROLES_STAGE                    40960  1.9351E+10           1  2147483645            0          1

SQL> alter table applsys.WF_LOCAL_ROLES_STAGE storage (next 40K);
Table altered.

SQL> select table_name, initial_extent, next_extent, min_extents, max_extents, pct_increase, blocks from dba_tables where table_name = 'WF_LOCAL_ROLES_STAGE';
TABLE_NAME                     INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE     BLOCKS
------------------------------ -------------- ----------- ----------- ----------- ------------ ----------
WF_LOCAL_ROLES_STAGE                    40960       40960           1  2147483645            0          1

SQL> alter table applsys.WF_LOCAL_ROLES_STAGE allocate extent;
Table altered.

SQL> select table_name, initial_extent, next_extent, min_extents, max_extents, pct_increase, blocks from dba_tables where table_name = 'WF_LOCAL_ROLES_STAGE';
TABLE_NAME                     INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE     BLOCKS
------------------------------ -------------- ----------- ----------- ----------- ------------ ----------
WF_LOCAL_ROLES_STAGE                    40960       65536           1         505           50          5

adpcpset.pls hangs applying patch 6502082

Posted by on August 22, 2008 No comments

Problem:

While applying patch 6502082, the patch hangs at the line:

Assigned: file adpcpset.pls on worker  1 for product ad  username APPLSYS.

Solution:

  1. Stop and restart database tier services (9.2.0 TNS Listener and database)
  2. Apply patch 3586394 (BRANCHED PATCH FOR BUG 3211492 (ADUTLRCMP.PLS) OVER 3242200 (ADHPCP))

The Parallel Compile step can take about 32 minutes to run.

Troubleshooting instance after cloning

Posted by on May 29, 2008 No comments

Situation: After reinstalling Red Hat Enterprise Linux AS 4 on the server and restoring Oracle Applications, the instance is started.

Problem: When accessing page http://ebusiness.support.com:8001/oa_servlets/AppsLogin, the following error is encountered:

Internet Explorer cannot display the webpage

   Most likely causes:
You are not connected to the Internet.
The website is encountering problems.
There might be a typing error in the address.

   What you can try:
     Diagnose Connection Problems  

     More information 

This problem can be caused by a variety of issues, including: 

Internet connectivity has been lost.
The website is temporarily unavailable.
The Domain Name Server (DNS) is not reachable.
The Domain Name Server (DNS) does not have a listing for the website's domain.
If this is an HTTPS (secure) address, click Tools, click Internet Options, click Advanced, and check to be sure the SSL and TLS protocols are enabled under the security section. 

For offline users

You can still view subscribed feeds and some recently viewed webpages.
To view subscribed feeds 

Click the Favorites Center button , click Feeds, and then click the feed you want to view. 

To view recently visited webpages (might not work on all pages) 

Click Tools , and then click Work Offline.
Click the Favorites Center button , click History, and then click the page you want to view.

Solution: Apply patch 4198954. Create a directory 4198954, copy the patch into this directory and extract the patch (two RPMS and README). Install the RPMS using rpm -ivh … . The RPMS install without issue

Then reran patch 3830807. Relink Application files using adadmin, use all defaults for the relink (takes about ten minutes).
Did not work.

Updated /etc/hosts

Checked Apache logs

/u0/oracle/testora/iAS/Apache/Apache/logs/error_log
/u0/oracle/testora/iAS/Apache/Jserv/logs/mod_jserv.log

See Metalink Doc ID: Note: 231137.1 “Troubleshooting the Self Service Framework with Oracle Applications”

Search for: File does not exist: /oa_servlets/AppsLogin
See Metalink Doc ID: Note: 344379.1  “Subject:  File Not Found /oa_servlets/AppsLogin”

http://ebusiness.support.com:8001/pls/TEST/fnd_web.ping

http://ebusiness.support.com:8001/OA_HTML/US/ICXINDEX.htm

ftp /usr/java/j2sdk-1_3_1_11-linux-i586.rpm.bin from 200.65.1.86 into the /usr/java (make this directory if necessary)
chmod a+x j2sdk-1_3_1_11-linux-i586.rpm.bin
Unzips jdk-1.3.1_11.i586.rpm
rpm -ivh jdk-1.3.1_11.i586.rpm

SUCCESS! Page appears.