Sunday, June 15, 2014

Weblogic April 14 PSU patch and BSU utliity

Was applying Weblogic PSU Aoril 2014 using BSU utility,

Had an issue with removing a previous Patchset 10.3.6.5 which is conflicting with current patchset 10.3.6.0.8 (April2014).
 The issue is patch is looking for product info and the instance details are found to be wrong, they refer to a different instance.

 Basically this is a refresh issue.
 So had to modify the entries in patch-backup.xml and remove the previously conflicting PSU.

 And then the April 2014 PSU went fine to be a SUCCESS.
 ========================================

bash-3.2$ cd /SID/disco11g/product/utils/bsu

bash-3.2$ bsu.sh -install -patch_download_dir=/ood_repository/patches  -patchlist=T5F1
-prod_dir=/SID/disco11g/product/wls_103
Checking for conflicts..

Conflict(s) detected - resolve conflict condition and execute patch installation again

Conflict condition details follow:

Patch T5F1 is mutually exclusive and cannot coexist with patch(es): L51R
bash-3.2$
==========================================

bsu.sh -remove -patchlist=L51R -prod_dir=/SID1/disco11g/product/wls_103


Checking for conflicts..
No conflict(s) detected

Removing Patch ID: L51R.
Result: Failure


java.io.FileNotFoundException: /SID2/disco11g/product/wls_103/server/lib/wls-api.jar (No such

file or directory)
Result: Failure


Fix:
======
 Replace the SID2 entries to SID1 in patch-backup.xml


cd /SID1/disco11g/product/patch_wls1036/registry
cp patch-backup.xml patch-backup.xml.old


vi patch-backup.xml
change SID2  entries to SID1

====================================================

bash-3.2$ cd /SID/disco11g/product/utils/bsu
bash-3.2$ bsu.sh -remove -patchlist=L51R -prod_dir=/SID/disco11g/product/wls_103
Checking for conflicts..
No conflict(s) detected

Removing Patch ID: L51R..
Result: Success


bash-3.2$ bsu.sh -install -patch_download_dir=/ood_repository/patches/Discoverer 
-patchlist=T5F1 -prod_dir=/SID/disco11g/product/wls_103 -log=18040640_patch.log

Checking for conflicts..
No conflict(s) detected

Installing Patch ID: T5F1..
Result: Success

AFPASSWD utility

    Change the password for an Application user.
    ==============================================
    AFPASSWD [-c APPSUSER [@TWO_TASK] -f FNDUSER
   
$ AFPASSWD -c apps -f SYSADMIN
Enter the ORACLE password of Application Object Library 'APPSUSER':
Connected successfully to APPS.
Log file: AFPWD_SID_746667.log
Enter new password for user [SYSADMIN]:
Verify new password for user [SYSADMIN]:
===================================================
Change the password for an Oracle Applications Database user.

AFPASSWD [-c APPSUSER [@TWO_TASK] -o ORAUSER
==============================================
 Modify APPLSYS user. This requires the execution
          of autoconfig (in ALL-TIERS) to distribute the
          changes on your instance ie DB-TIER and ADMIN-TIER.

$ AFPASSWD -c apps -s applsys
Enter the ORACLE password of Application Object Library 'APPSUSER':
Connected successfully to APPS.
Enter the password for your 'SYSTEM' ORACLE schema:
Connected successfully to SYSTEM.
Log file: AFPWD_SID_752136.log
Enter new password for user:
Verify new password for user:
AFPASSWD completed successfully.

Tuesday, June 3, 2014

How to check Weblogic server Version

Different ways to check weblogic server version
------------------------------------------------------------
bash-3.2$ grep WebLogic registry.xml
     
          product format="1.0" name="WebLogic Platform"

        component name="WebLogic Server" version="10.3.6.0" InstallDir="/SID/disco11g/product/wls_103"
       

bash-3.2$ pwd
/sid/disco11g/product
bash-3.2
=================================================
bash-3.2$ vi AdminServer.log
bash-3.2$ grep Copyright AdminServer.log
WebLogic Server 10.3.6.0  Tue Nov 15 08:52:36 PST 2011 1441050  Copyright (c) 1995, 2011, Oracle and/or its affiliates. All rights reserved.>
WebLogic Server 10.3.6.0  Tue Nov 15 08:52:36 PST 2011 1441050  Copyright (c) 1995, 2011, Oracle and/or its affiliates. All rights reserved.>
WebLogic Server 10.3.6.0  Tue Nov 15 08:52:36 PST 2011 1441050  Copyright (c) 1995, 2011, Oracle and/or its affiliates. All rights reserved.>
bash-3.2$ pwd
/sid/disco11g/product/user_projects/domains/SID/servers/AdminServer/logs
bash-3.2$
========================================================
bash-3.2$ cd $WL_HOME/server/bin/
bash-3.2$ ls
setWLSEnv.sh  startNodeManager.sh
bash-3.2$ . ./setWLSEnv.sh
CLASSPATH=/SID/disco11g/product/patch_wls1036/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/SID/disco11g/product/patch_ocp371/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/SID/disco11g/product/jdk1.6.0_21/lib/tools.jar:/SID/disco11g/product/wls_103/server/lib/weblogic_sp.jar:/SID/disco11g/product/wls_103/server/lib/weblogic.jar:/SID/disco11g/product/modules/features/weblogic.server.modules_10.3.6.0.jar:/SID/disco11g/product/wls_103/server/lib/webservices.jar:/SID/disco11g/product/modules/org.apache.ant_1.7.1/lib/ant-all.jar:/SID/disco11g/product/modules/net.sf.antcontrib_1.1.0.0_1-0b2/lib/ant-contrib.jar:

PATH=/SID/disco11g/product/wls_103/server/bin:/SID/disco11g/product/modules/org.apache.ant_1.7.1/bin:/SID/disco11g/product/jdk1.6.0_21/jre/bin:/SID/disco11g/product/jdk1.6.0_21/bin:.:/SID/disco11g/product/disco_111/jdk/jre/bin:/SID/disco11g/product/disco_111/discoverer/bin:/SID/disco11g/product/disco_111/bin:/SID/disco11g/product/wls_103/server/bin:/SID/disco11g/product/user_projects/domains/SID/bin:/SID/disco11g/product/instance/bin:/SID/disco11g/product/disco_111/jdk/bin:/SID/disco11g/product/disco_111/bin:/usr/local/git/bin:/usr/bin:/usr/xpg4/bin:/usr/ccs/bin:/usr/ucb:/bin:/usr/sbin:/sbin:/usr/local/bin

Your environment has been set.
bash-3.2$ java weblogic.version

WebLogic Server 10.3.6.0.5 PSU Patch for BUG16619891 Tue Apr 23 13:24:29 IST 2013
WebLogic Server 10.3.6.0  Tue Nov 15 08:52:36 PST 2011 1441050

Use 'weblogic.version -verbose' to get subsystem information

Use 'weblogic.utils.Versions' to get version information for all modules

Sunday, May 11, 2014

Host based concurrent program fails with Error: No such file or directory

A custom Concurrent program fails with Error: No such file or directory
====================================================
Basically this is a host-based concurrent program and a custom program ...

This custom program actually is a FTP process which transfers files from one server to another -- from and to specific locations.

--> checked if the program is unable to find the source directory/file it is trying to transfer ---  their permissions -- But that's not the issue.

Log file says it cannot find the Executable the program is trying to run

+---------------------------------------------------------------------------+

usdsop: exec failed during spawn/SID/applmgr/CUSTOM/***12.0.0/bin/***_ftp_out: No such file or directory
/SID/applmgr/CUSTOM/***/12.0.0/bin/***_ftp_out
Program exited with status 1

+---------------------------------------------------------------------------+
Executing request completion options...

Output file size:
0

---> Checked the executable -- it exists and fine with permissions.
---> Played around with some more similar files but different versions.

Other programs in same location work actually.

---> Checked for any scrap characters in the file finally opening the executable script. Found few , removed them

----> Finally done a dos2unix conversion on it .

Re-tested the issue which went fine atlast.

ICM and Wallet Issue

Issue
=====


You are running adcmctl.sh version 120.17.12010000.5

ORACLE error 28365 in afpgdbcf

Cause: afpgdbcf failed due to ORA-28365: wallet is not open
ORA-06512: at "APPS.FND_SECURITY_PKG", line 539
ORA-06512: at line 1.

The SQL statement being executed at the time of the error was:  SELECT /*+ USE_NL (A I) */  DISTINCT A.APPLICATION_ID, A.APPLICATION_NAME,  A.APPLICATION_SHORT_NAME, A.BASEPATH, I.PRODUCT_VERSION  FROM FND_APPLICATION_VL A, FND_PRODUCT_INSTALLATIONS I  WHERE A.APPLICATION_ID = I.APPLICATION_ID (+)  and was executed from the file &ERRFILE.
Internal Concurrent Manager status could not be determined.
===============================
  declare
*
ERROR at line 1:
ORA-20000: ORA-28365: wallet is not open Failed to call the procedure
fnd_apps_mode_util.set_to_maintenance_mode while enabling
maintenance mode.
ORA-06512: at line 38

=============================


Alert Log error
=================

kcbztek_get_tbskey: decrypting encrypted key for tablespace 0 without opening the wallet
Errors in file /SID/oracle/product/112/admin/SID_host/diag/rdbms/SID/SID/trace/SID_smon_4269.trc:
ORA-28365: wallet is not open
kcbztek_get_tbskey: decrypting encrypted key for tablespace 0 without opening the wallet
kcbztek_get_tbskey: decrypting encrypted key for tablespace 0 without opening the wallet
kcbztek_get_tbskey: decrypting encrypted key for tablespace 0 without opening the wallet
kcbztek_get_tbskey: decrypting encrypted key for tablespace 0 without opening the wallet


==============================

SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2235208 bytes
Variable Size             427820216 bytes
Database Buffers          624951296 bytes
Redo Buffers               13930496 bytes
Database mounted.
ORA-28365: wallet is not open


Fix
====
bash-3.2$  cd /SID/oracle/product/112/network/admin/SID_host/wallet
bash-3.2$ ls
cwallet.sso  encryption_passwd  ewallet.p12

orapki wallet change_pwd -wallet $ORACLE_HOME/wallet
-------------------

SQL> SELECT * FROM gv$encryption_wallet;

   INST_ID WRL_TYPE
---------- --------------------
WRL_PARAMETER
--------------------------------------------------------------------------------
STATUS
------------------
  1 file
/SID/oracle/product/112/network/admin/SID_host/wallet
CLOSED


SQL> ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "*****";

System altered.

APP-FND-01931 -- Forms Issue R12

Forms Issue
===========

APP-FND-01931 Your session is no longer valid or your logon information could not be reestablished from your session

Solution tried
============
 Tried following ::
Please use adadmin utility to :

- regenerate jar files - select YES when prompted to force generation of jar files.
- recompile apps schema to check for invalid objects.
- regenerate forms and pll's.
- relink all applications programs - specifically f60webmx, although relinking all the applications executables is advisable.
- recreate grants and synonyms.
- recompile menus.

- Clear Oracle jinitiator cache on client machine - typically c:\programs\oracle\jinit...\jcache .
- Clear browser cache.
- Bounce Oracle application services and re-test the issue.

Supplier site Certificate issue

Problem Description/Question:          1. The requester logs on to Oracle iProcurement.
                                       2. From Oracle iProcurement, the requester clicks a punchout link to the supplier site.
                                       3. The supplier authenticates the requester and returns a response.

During this, unable to go to Supplier site
====================================
Error Code: 201 Unable To Reach Supplier Site
Unable to send the Login Request XML.

java.io.IOException: java.io.IOException: javax.net.ssl.SSLException: SSL handshake failed: X509CertChainInvalidErr

Solution :
===========
POR : CA Certificate File Name => this profile option points to a file where we have to add the certificate to this file.

The certificate has to be obtained by accessing the Website(Supplier site in the error logfile) from browser.
Then finally bounce the Complete MT ( just Apache bounce doesnot work in R12).