Tuesday, May 13, 2014

Unable to start application server in Peoplesoft.
===================================================================

While trying to install Peoplesoft HCM 9.2 along with Peopletools 8.53 on Linux on my Laptop and I faced the following issue.

PSAPPSRV.19596 (0) [2014-05-08T14:39:35.926](0) Cache Directory being used: /apps/oratest/pt853/appserv/PSDEMO/CACHE/PSAPPSRV_1/
PSAPPSRV.19596 (0) [2014-05-08T14:39:36.089](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database ORCL with user PS.
PSAPPSRV.19596 (0) [2014-05-08T14:39:36.089](0) Server failed to start
PSADMIN.19508 (0) [2014-05-08T14:39:43.787](0) End boot attempt on domain PSDEMO
PSADMIN.19651 (0) [2014-05-08T14:49:24.790](0) Begin boot attempt on domain PSDEMO
PSAPPSRV.19682 (0) [2014-05-08T14:49:35.082](0) PeopleTools Release 8.53 (Linux) starting. Tuxedo server is APPSRV(99)/1
PSAPPSRV.19682 (0) [2014-05-08T14:49:35.095](0) Cache Directory being used: /apps/oratest/pt853/appserv/PSDEMO/CACHE/PSAPPSRV_1/
PSAPPSRV.19682 (0) [2014-05-08T14:49:35.252](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database ORCL with user PS.
PSAPPSRV.19682 (0) [2014-05-08T14:49:35.252](0) Server failed to start
PSADMIN.19651 (0) [2014-05-08T14:49:42.952](0) End boot attempt on domain PSDEMO

I have reset the password for PS user but still its complaining about logging in.

The following is my configuration.

Quick-configure menu -- domain: PSDEMO
----------------------------------------------
Features Settings
========== ==========
1) Pub/Sub Servers : No 16) DBNAME :[orcl]
2) Quick Server : No 17) DBTYPE :[ORACLE]
3) Query Servers : No 18) UserId :[PS]
4) Jolt : Yes 19) UserPswd :[PASSWORD]
5) Jolt Relay : No 20) DomainID :[TESTSERV]
6) WSL : No 21) AddToPATH :[/apps/oratest/product/11.2.0/dbhome_1/bin]
7) PC Debugger : No 22) ConnectID :[people]
8) Event Notification: No 23) ConnectPswd:[peop1e]
9) MCF Servers : No 24) ServerName :[starworld.appstek.ca]
10) Perf Collator : No 25) DomainConnectPswd:[]
11) Analytic Servers : No 26) WSL Port :[7000]
12) Domains Gateway : No 27) JSL Port :[9000]
28) JRAD Port :[9100]

Actions
=========

I am able to connect to the database as ps/people/sysadm user but cant seem to move forward from here.

Solution:
======================


I resolved this issue. It seems the PS user account was locked.
The solution is as follows.
SQL> select ACCTLOCK from psoprdefn where oprid='PS';

ACCTLOCK
----------
1
SQL> update psoprdefn set ACCTLOCK=0 where oprid='PS';

1 row updated.

SQL> commit;

Commit complete.

SQL> select ACCTLOCK from psoprdefn where oprid='PS';

ACCTLOCK
----------
0

Thanks to the solution posted by Rajeev Paramathmuni on it.toolbox.com.

Friday, May 9, 2014

Peoplesoft Data Mover error:


While working with creating the db manually using psdmtx utility on Linux I kept getting the following error while loading the tables.

SQL Error. Error Position: 464  Return: 12899 - ORA-12899: value too large for column "SYSADM"."PS_GPFR_AF_ATTR"."DESCR60" (actual: 62, maximum: 60)
INSERT INTO PS_GPFR_AF_ATTR  (COUNTRY, GPFR_AF_APPL, GPFR_AF_KEY_NODE, GPFR_AF_KEY_ATTR, GPFR_AF_ATTR_NAME, GPFR_AF_ATTR_STAT, GPFR_AF_ATTR_SEQ, DESCR60, GPFR_AF_ATTR_TYPE, GPFR_AF_ATR_LENGTH, GPFR_AF_ATR_DECIML, GPFR_AF_MANDATORY, GPFR_AF_ATR_LBLSRC, GPFR_AF_CODE_ID, GPFR_AF_PROMPT, GPFR_DA_DATTYP, GPFR_AF_PR_LBL_FLD, GPFR_AF_PR_KEY_FLD, GPFR_AF_ATTR_FIELD, GPFR_AF_PS_DON, GPFR_AF_CUST_DON, GPFR_AF_RPT_ONLY, GPFR_AF_OWNER) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23)
Error: Unable to insert row 1337
Error: SQL execute error for GPFR_AF_ATTR
 SQL Spaces: 0  Tables: 4669  Triggers: 0 Indexes: 5431  Views: 0
Ended: Wed May  7 20:27:07 2014
Unsuccessful completion







This error perplexed me.  Then I ran the same utility on Windows.  Thats when I got the following error.

Character Length Semantis (CLS) Feature is not enabled.

The solution is to make the change as follows:


alter system set NLS_LENGTH_SEMANTICS=CHAR scope=both;

and bounce the db.











Weblogic PSU patch error unrecognized patch ID: FCX7

While applying the p18040640_1036_Generic.zip patch I kept getting the above error.

There was no issue with my command it was fine.

./bsu.sh -prod_dir=/home/oracle/Oracle/Middleware/wlserver_10.3/ -patchlist=T5F1 -verbose -log=patch.log -log_priority=trace -install

I noticed that after I ran the above command the following directory{MW_HOME} got created.

[oracle@starbird bsu]$ ls -ltr
total 152
-rw-r--r--. 1 oracle oinstall    516 May  9 10:41 patch-client.jar
-rw-r--r--. 1 oracle oinstall    520 May  9 10:41 bsu.jar
-rw-r--r--. 1 oracle oinstall  25214 May  9 10:41 smartupdate.ico
-rwxr-x---. 1 oracle oinstall    135 May  9 10:42 bsu.sh
drwxr-xr-x. 2 oracle oinstall   4096 May  9 12:11 cache_dir
drwxr-xr-x. 3 oracle oinstall   4096 May  9 12:13 {MW_HOME}
-rw-r--r--. 1 oracle oinstall 104976 May  9 12:20 patch.log


The patch.log showed the following.

[oracle@starbird bsu]$ cat patch.log
2014-05-09 12:13:34,588 DEBUG [main] com.bea.plateng.patch.PatchHelper - BEA Patch Managment System 3.3.0.0 (Irish Bank) Started.
2014-05-09 12:13:34,600 DEBUG [main] com.bea.plateng.common.util.ResourceBundleManager - Retrieved (auto.login) under key (PatchPreference.auto.login) from namespace .
2014-05-09 12:13:34,601 DEBUG [main] com.bea.plateng.common.util.ResourceBundleManager - Retrieved (auto.login.username) under key (PatchPreference.auto.login.username) from namespace .
2014-05-09 12:13:34,602 DEBUG [main] com.bea.plateng.common.util.ResourceBundleManager - Retrieved (auto.login.password) under key (PatchPreference.auto.login.password) from namespace .
2014-05-09 12:13:34,603 DEBUG [main] com.bea.plateng.common.util.ResourceBundleManager - Retrieved (download.directory) under key (PatchPreference.download.directory) from namespace .
2014-05-09 12:13:34,604 DEBUG [main] com.bea.plateng.common.util.ResourceBundleManager - Retrieved (http.proxy) under key (PatchPreference.http.proxy) from namespace .
2014-05-09 12:13:34,604 DEBUG [main] com.bea.plateng.common.util.ResourceBundleManager - Retrieved (http.proxy.host) under key (PatchPreference.http.proxy.host) from namespace .
2014-05-09 12:13:34,605 DEBUG [main] com.bea.plateng.common.util.ResourceBundleManager - Retrieved (http.proxy.port) under key (PatchPreference.http.proxy.port) from namespace .
2014-05-09 12:13:34,606 DEBUG [main] com.bea.plateng.common.util.ResourceBundleManager - Retrieved (http.proxy.authentication) under key (PatchPreference.http.proxy.authentication) from namespace .
2014-05-09 12:13:34,607 DEBUG [main] com.bea.plateng.common.util.ResourceBundleManager - Retrieved (http.proxy.authentication.username) under key (PatchPreference.http.proxy.authentication.username) from namespace .
2014-05-09 12:13:34,608 DEBUG [main] com.bea.plateng.common.util.ResourceBundleManager - Retrieved (http.proxy.authentication.password) under key (PatchPreference.http.proxy.authentication.password) from namespace .
2014-05-09 12:13:34,608 DEBUG [main] com.bea.plateng.common.util.ResourceBundleManager - Retrieved (target.installation) under key (PatchPreference.target.installation) from namespace .
2014-05-09 12:13:34,609 DEBUG [main] com.bea.plateng.common.util.ResourceBundleManager - Retrieved (display.all.patches) under key (PatchPreference.display.all.patches) from namespace .
2014-05-09 12:13:34,610 DEBUG [main] com.bea.plateng.common.util.ResourceBundleManager - Retrieved (display.support.dialog) under key (PatchPreference.display.support.dialog) from namespace .
2014-05-09 12:13:34,611 DEBUG [main] com.bea.plateng.common.util.ResourceBundleManager - Retrieved (null) under key (PatchPreference.default.manifest.attributes) from namespace .
2014-05-09 12:13:34,691 DEBUG [Thread-0] com.bea.plateng.patch.ProductAliasTargetHelper - beaHome: /home/oracle/Oracle/Middleware
2014-05-09 12:13:34,691 DEBUG [Thread-0] com.bea.plateng.patch.ProductAliasTargetHelper - Getting the registry
2014-05-09 12:13:34,693 DEBUG [main] com.bea.plateng.patch.PatchSystem - getting the catalog from the cahce dir: /home/oracle/Oracle/Middleware/utils/bsu/{MW_HOME}/utils/bsu/cache_dir
2014-05-09 12:13:34,720 DEBUG [main] com.bea.plateng.patch.dao.cat.PatchCatalogHelper - getting patchcatalog for /home/oracle/Oracle/Middleware/utils/bsu/{MW_HOME}/utils/bsu/cache_dir
2014-05-09 12:13:34,721 DEBUG [main] com.bea.plateng.patch.dao.cat.PatchCatalogHelper - getting patchcatalog for /home/oracle/Oracle/Middleware/utils/bsu/{MW_HOME}/utils/bsu/cache_dir and file available
2014-05-09 12:13:34,733 DEBUG [main] com.bea.plateng.patch.dao.cat.PatchCatalogHelper - getting patchcatalog for /home/oracle/Oracle/Middleware/utils/bsu/{MW_HOME}/utils/bsu/cache_dir and file not available
2014-05-09 12:13:35,271 DEBUG [main] com.bea.plateng.patch.dao.pio.PatchProductInfoHelper - Getting product info from prodInfoDir: /home/oracle/Oracle/Middleware/utils/bsu/{MW_HOME}/utils/bsu/cache_dir


Thats when I realised that its looking for the patch files in /home/oracle/Oracle/Middleware/utils/bsu/{MW_HOME}/utils/bsu/cache_dir.

I moved the files there and voila it worked.

 ./bsu.sh -prod_dir=/home/oracle/Oracle/Middleware/wlserver_10.3/ -patchlist=T5F1 -verbose -log=patch.log -log_priority=trace -install
Checking for conflicts...
No conflict(s) detected

Starting installation of Patch ID: T5F1
Installing /home/oracle/Oracle/Middleware/utils/bsu/{MW_HOME}/utils/bsu/cache_dir/T5F1.jar
Extracting /home/oracle/Oracle/Middleware/patch_wls1036/patch_jars/BUG18040640_103608.jar
Extracting /home/oracle/Oracle/Middleware/patch_wls1036/patch_jars/com.bea.core.stax2_2.0.0.0_3-0-3.jar
Extracting /home/oracle/Oracle/Middleware/patch_wls1036/patch_jars/glassfish.jaxb.xjc_1.2.0.0_2-1-14.jar
Extracting /home/oracle/Oracle/Middleware/patch_wls1036/patch_jars/glassfish.jaxb_1.2.0.0_2-1-14.jar
Extracting /home/oracle/Oracle/Middleware/patch_wls1036/patch_jars/glassfish.jaxp_1.4.5.0.jar
Extracting /home/oracle/Oracle/Middleware/patch_wls1036/patch_jars/glassfish.jaxws.mimepull_1.1.0.0_1-3-8.jar
Updating /home/oracle/Oracle/Middleware/patch_wls1036/profiles/default/sys_manifest_classpath/weblogic_patch.jar
Old manifest value: Class-Path=
New manifest value: Class-Path=../../../patch_jars/BUG18040640_103608.jar ../../../patch_jars/com.bea.core.stax2_2.0.0.0_3-0-3.jar ../../../patch_jars/glassfish.jaxb.xjc_1.2.0.0_2-1-14.jar ../../../patch_jars/glassfish.jaxb_1.2.0.0_2-1-14.jar ../../../patch_jars/glassfish.jaxp_1.4.5.0.jar ../../../patch_jars/glassfish.jaxws.mimepull_1.1.0.0_1-3-8.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wseeclient.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlclient.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/jms-xa-adp.rar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/jms-notran-adp.rar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/modules/com.bea.core.descriptor.wl.binding_1.4.0.0.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/common/bin/wlsifconfig.sh into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/consoleapp/webapp/WEB-INF/lib/console.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/schema/weblogic-domain-binding.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/common/deployable-libraries/jsf-2.0.war into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlthint3client.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/common/wlst/modules/jython-modules.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/webserviceclient+ssl.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/jdbcdrivers.xml into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wseeclient.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlclient.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/jms-xa-adp.rar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/jms-notran-adp.rar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/bugsfixed/WLS-PSU-bugsfixed.txt
Extracting /home/oracle/Oracle/Middleware/modules/com.bea.core.descriptor.wl.binding_1.4.0.0.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/common/bin/wlsifconfig.sh
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/consoleapp/webapp/WEB-INF/lib/console.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/schema/weblogic-domain-binding.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/common/deployable-libraries/jsf-2.0.war
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlthint3client.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/common/wlst/modules/jython-modules.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/webserviceclient+ssl.jar
Extracting /home/oracle/Oracle/Middleware/modules/com.bea.core.stax2_2.0.0.0_3-0-3.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/bugsfixed/18040640-WLS-10.3.6.0.8_PSU_WebServices-ClientSide-Configuration-README.txt
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/jdbcdrivers.xml
Backing up /home/oracle/Oracle/Middleware/modules/com.bea.core.utils_1.10.0.0.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlw-langx.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/modules/com.bea.core.utils.full_1.10.0.0.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/modules/com.bea.core.common.security.saml2_1.0.0.0_6-2-0-0.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/modules/ws.databinding_1.3.0.0.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlsaft3client.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/modules/com.bea.core.bea.opensaml_1.0.0.0_6-2-0-0.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlsafclient.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wseeclient.zip into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/modules/ws.databinding.plugins_1.3.0.0.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/modules/com.bea.core.apache_1.3.0.1.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wljmsclient.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlstestclient.ear into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wls-api.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/modules/com.bea.core.bea.opensaml2_1.0.0.0_6-2-0-0.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/webserviceclient.jar into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Backing up /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/uddiexplorer.war into /home/oracle/Oracle/Middleware/patch_wls1036/backup/backup.jar
Extracting /home/oracle/Oracle/Middleware/modules/com.bea.core.utils_1.10.0.0.jar42406.tmp
Merging /home/oracle/Oracle/Middleware/modules/com.bea.core.utils_1.10.0.0.jar42406.tmp with /home/oracle/Oracle/Middleware/modules/com.bea.core.utils_1.10.0.0.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlw-langx.jar8739.tmp
Merging /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlw-langx.jar8739.tmp with /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlw-langx.jar
Extracting /home/oracle/Oracle/Middleware/modules/com.bea.core.utils.full_1.10.0.0.jar64692.tmp
Merging /home/oracle/Oracle/Middleware/modules/com.bea.core.utils.full_1.10.0.0.jar64692.tmp with /home/oracle/Oracle/Middleware/modules/com.bea.core.utils.full_1.10.0.0.jar
Extracting /home/oracle/Oracle/Middleware/modules/com.bea.core.common.security.saml2_1.0.0.0_6-2-0-0.jar50986.tmp
Merging /home/oracle/Oracle/Middleware/modules/com.bea.core.common.security.saml2_1.0.0.0_6-2-0-0.jar50986.tmp with /home/oracle/Oracle/Middleware/modules/com.bea.core.common.security.saml2_1.0.0.0_6-2-0-0.jar
Extracting /home/oracle/Oracle/Middleware/modules/ws.databinding_1.3.0.0.jar46160.tmp
Merging /home/oracle/Oracle/Middleware/modules/ws.databinding_1.3.0.0.jar46160.tmp with /home/oracle/Oracle/Middleware/modules/ws.databinding_1.3.0.0.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlt3client.jar62205.tmp
Updating /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlt3client.jar62205.tmp to /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlt3client.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlsaft3client.jar9195.tmp
Merging /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlsaft3client.jar9195.tmp with /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlsaft3client.jar
Extracting /home/oracle/Oracle/Middleware/modules/com.bea.core.bea.opensaml_1.0.0.0_6-2-0-0.jar1028.tmp
Merging /home/oracle/Oracle/Middleware/modules/com.bea.core.bea.opensaml_1.0.0.0_6-2-0-0.jar1028.tmp with /home/oracle/Oracle/Middleware/modules/com.bea.core.bea.opensaml_1.0.0.0_6-2-0-0.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlsafclient.jar62532.tmp
Merging /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlsafclient.jar62532.tmp with /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlsafclient.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wseeclient.zip6917.tmp
Merging /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wseeclient.zip6917.tmp with /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wseeclient.zip
Extracting /home/oracle/Oracle/Middleware/modules/ws.databinding.plugins_1.3.0.0.jar56334.tmp
Merging /home/oracle/Oracle/Middleware/modules/ws.databinding.plugins_1.3.0.0.jar56334.tmp with /home/oracle/Oracle/Middleware/modules/ws.databinding.plugins_1.3.0.0.jar
Extracting /home/oracle/Oracle/Middleware/modules/com.bea.core.apache_1.3.0.1.jar27627.tmp
Merging /home/oracle/Oracle/Middleware/modules/com.bea.core.apache_1.3.0.1.jar27627.tmp with /home/oracle/Oracle/Middleware/modules/com.bea.core.apache_1.3.0.1.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wljmsclient.jar16323.tmp
Merging /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wljmsclient.jar16323.tmp with /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wljmsclient.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlstestclient.ear9922.tmp
Merging /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlstestclient.ear9922.tmp with /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlstestclient.ear
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wls-api.jar22624.tmp
Merging /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wls-api.jar22624.tmp with /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wls-api.jar
Extracting /home/oracle/Oracle/Middleware/modules/com.bea.core.bea.opensaml2_1.0.0.0_6-2-0-0.jar767.tmp
Merging /home/oracle/Oracle/Middleware/modules/com.bea.core.bea.opensaml2_1.0.0.0_6-2-0-0.jar767.tmp with /home/oracle/Oracle/Middleware/modules/com.bea.core.bea.opensaml2_1.0.0.0_6-2-0-0.jar
Extracting /home/oracle/Oracle/Middleware/modules/com.bea.core.weblogic.stax_1.11.0.0.jar37844.tmp
Updating /home/oracle/Oracle/Middleware/modules/com.bea.core.weblogic.stax_1.11.0.0.jar37844.tmp to /home/oracle/Oracle/Middleware/modules/com.bea.core.weblogic.stax_1.11.0.0.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlt3jmsclient.jar61475.tmp
Updating /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlt3jmsclient.jar61475.tmp to /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/wlt3jmsclient.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/webserviceclient.jar16191.tmp
Merging /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/webserviceclient.jar16191.tmp with /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/webserviceclient.jar
Extracting /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/uddiexplorer.war16344.tmp
Merging /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/uddiexplorer.war16344.tmp with /home/oracle/Oracle/Middleware/wlserver_10.3/server/lib/uddiexplorer.war
Result: Success

[oracle@starbird bsu]$

 [oracle@starbird bsu]$ java weblogic.version

WebLogic Server 10.3.6.0.8 PSU Patch for BUG18040640 THU MARCH 27 15:54:42 IST 2014
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


Now I don't know if this the standard procedure or not but it worked for me.

Hope this helps someone.

Tuesday, January 28, 2014

Startup Shutdown R12.2

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



 I have followed the blog http://ltd.kentw.co.uk/technical/managing-oracle-e-business-suite-r12-2/ to setup this on my machine.

In R12.2 there are two filesystems. One is the run (runtime) and the other patch (patching).

I have created a vis.sh file similar to one given in the above site.

#/usr/bin/bash

. $HOME/EBSapps.env run

DBFS=/apps/oracle/VIS/11.2.0

OID=VIS_starworld

DBSCRIPTS=$DBFS/appsutil/scripts/$OID

PATCH_TOP=$APPL_TOP_NE/../patch;export PATCH_TOP

OPATCH_PLATFORM_ID=226; export OPATCH_PLATFORM_ID

alias addbctl=$DBSCRIPTS/addbctl.sh

alias addlnctl=$DBSCRIPTS/addlnctl.sh

alias adstrtal=$ADMIN_SCRIPTS_HOME/adstrtal.sh

alias adstpall=$ADMIN_SCRIPTS_HOME/adstpall.sh

alias adadminsrvctl=$ADMIN_SCRIPTS_HOME/adadminsrvctl.sh

alias adopmnctl=$ADMIN_SCRIPTS_HOME/adopmnctl.sh

alias adcmctl=$ADMIN_SCRIPTS_HOME/adcmctl.sh

alias runenv=". $HOME/EBSapps.env run"

alias patchenv=". $HOME/EBSapps.env patch"

alias dbenv=". $DBFS/$OID.env"

alias vis=". $HOME/vis.sh"

alias ops="ps -fed | grep VIS | wc -l"

alias opsl="ps -fed | grep VIS"


Here I have changed the values of DBFS and OID according to my environment.

I have placed this file in the home directory of the oravis user.

[oravis@starworld ~]$ pwd

/home/oravis

[oravis@starworld ~]$ ls -l vis.sh

-rwxr-xr-x 1 oravis oinstall 754 Jan 11 18:52 vis.sh

[oravis@starworld ~]$


I have then called it from the .bashrc file

[oravis@starworld ~]$ cat .bashrc

# .bashrc



# Source global definitions

if [ -f /etc/bashrc ]; then

. /etc/bashrc

fi

if [ -f /home/oravis/vis.sh ]; then

. $HOME/vis.sh

fi

# User specific aliases and functions

[oravis@starworld ~]$


The EBSapps.env is available from 12.2.2 and is also applicable for R12.2.0. I have placed the same in $HOME directory of oravis and applvis user.

Here too, I have to change the node info file to point according to my environment.

Startup

[oravis@starworld ~]$ . ./vis.sh



E-Business Suite Environment Information

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

RUN File System : /apps/oracle/VIS/fs1/EBSapps/appl

PATCH File System : /apps/oracle/VIS/fs2/EBSapps/appl

Non-Editioned File System : /apps/oracle/VIS/fs_ne

DB Host: starworld.appstek.ca Service/SID: VIS



Sourcing the RUN File System …



[oravis@starworld ~]$


[oravis@starworld ~]$ addlnctl start VIS

Logfile: /apps/oracle/VIS/11.2.0/appsutil/log/VIS_starworld/addlnctl.txt



You are running addlnctl.sh version 120.4





Starting listener process VIS ...





LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 27-JAN-2014 22:13:49



Copyright (c) 1991, 2011, Oracle. All rights reserved.



Starting /apps/oracle/VIS/11.2.0/bin/tnslsnr: please wait...



TNSLSNR for Linux: Version 11.2.0.3.0 - Production

System parameter file is /apps/oracle/VIS/11.2.0/network/admin/VIS_starworld/listener.ora

Log messages written to /apps/oracle/VIS/11.2.0/admin/VIS_starworld/diag/tnslsnr/starworld/vis/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=starworld.appstek.ca)(PORT=1521)))



Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=starworld.appstek.ca)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias VIS

Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date 27-JAN-2014 22:13:50

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /apps/oracle/VIS/11.2.0/network/admin/VIS_starworld/listener.ora

Listener Log File /apps/oracle/VIS/11.2.0/admin/VIS_starworld/diag/tnslsnr/starworld/vis/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=starworld.appstek.ca)(PORT=1521)))

Services Summary...

Service "VIS" has 1 instance(s).

Instance "VIS", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully



addlnctl.sh: exiting with status 0



addlnctl.sh: check the logfile /apps/oracle/VIS/11.2.0/appsutil/log/VIS_starworld/addlnctl.txt for more information ...



[oravis@starworld ~]$


[oravis@starworld ~]$ addbctl start VIS



You are running addbctl.sh version 120.1





Starting the database VIS ...





SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 27 22:14:29 2014



Copyright (c) 1982, 2011, Oracle. All rights reserved.



Connected to an idle instance.

ORACLE instance started.



Total System Global Area 2137886720 bytes

Fixed Size 2230072 bytes

Variable Size 452987080 bytes

Database Buffers 1660944384 bytes

Redo Buffers 21725184 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options



addbctl.sh: exiting with status 0



[oravis@starworld ~]$



Starting the apps

[applvis@starworld ~]$ . ./vis.sh



E-Business Suite Environment Information

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

RUN File System : /apps/oracle/VIS/fs1/EBSapps/appl

PATCH File System : /apps/oracle/VIS/fs2/EBSapps/appl

Non-Editioned File System : /apps/oracle/VIS/fs_ne

DB Host: starworld.appstek.ca Service/SID: VIS



Sourcing the RUN File System …



[applvis@starworld ~]$

[applvis@starworld ~]$ adstrtal apps/apps



You are running adstrtal.sh version 120.24.12020000.6





Enter the WebLogic Server password:



The logfile for this session is located at /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adstrtal.log



Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/jtffmctl.sh start

Timeout specified in context file: 100 second(s)



script returned:

****************************************************



You are running jtffmctl.sh version 120.3.12020000.4



Validating Fulfillment patch level via /apps/oracle/VIS/fs1/EBSapps/comn/java/classes

Fulfillment patch level validated.

Starting Fulfillment Server for VIS on port 9300 ...



jtffmctl.sh: exiting with status 0





.end std out.



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/adopmnctl.sh start

Timeout specified in context file: 100 second(s)



script returned:

****************************************************



You are running adopmnctl.sh version 120.0.12020000.2



Starting Oracle Process Manager (OPMN) ...



adopmnctl.sh: exiting with status 0



adopmnctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adopmnctl.txt for more information ...





.end std out.



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/adapcctl.sh start

Timeout specified in context file: 100 second(s)



script returned:

****************************************************



You are running adapcctl.sh version 120.0.12020000.2



Starting OPMN managed Oracle HTTP Server (OHS) instance ...

opmnctl start: opmn is already running.

opmnctl startproc: starting opmn managed processes...



adapcctl.sh: exiting with status 0



adapcctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adapcctl.txt for more information ...





.end std out.



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/adnodemgrctl.sh start -nopromptmsg

Timeout specified in context file: 100 second(s)



script returned:

****************************************************



You are running adnodemgrctl.sh version 120.11.12020000.4





Calling txkChkEBSDependecies.pl to perform dependency checks for oacore

Perl script txkChkEBSDependecies.pl got executed successfully





Starting the Node Manager...

NMProcess:

NMProcess: Jan 27, 2014 10:29:26 PM weblogic.nodemanager.server.NMServerConfig initDomainsMap

NMProcess: INFO: Loading domains file: /apps/oracle/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.domains

NMProcess:

NMProcess: Jan 27, 2014 10:29:26 PM weblogic.nodemanager.server.NMServer

NMProcess: INFO: Loaded node manager configuration properties from '/apps/oracle/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.properties'

NMProcess: Node manager v10.3

NMProcess:

NMProcess: Configuration settings:

NMProcess:

NMProcess: NodeManagerHome=/apps/oracle/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1

NMProcess: ListenAddress=starworld.appstek.ca

NMProcess: ListenPort=5556

NMProcess: ListenBacklog=50

NMProcess: SecureListener=false

NMProcess: AuthenticationEnabled=true

NMProcess: NativeVersionEnabled=true

NMProcess: CrashRecoveryEnabled=false

NMProcess: JavaHome=/apps/oracle/VIS/fs1/FMW_Home/jrockit64

NMProcess: StartScriptEnabled=false

NMProcess: StopScriptEnabled=false

NMProcess: StartScriptName=startWebLogic.sh

NMProcess: StopScriptName=

NMProcess: LogFile=/apps/oracle/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.log

NMProcess: LogLevel=INFO

NMProcess: LogLimit=0

NMProcess: LogCount=1

NMProcess: LogAppend=true

NMProcess: LogToStderr=true

NMProcess: LogFormatter=weblogic.nodemanager.server.LogFormatter

NMProcess: DomainsFile=/apps/oracle/VIS/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.domains

NMProcess: DomainsFileEnabled=true

NMProcess: StateCheckInterval=500

NMProcess: QuitEnabled=true

NMProcess: UseMACBroadcast=false

NMProcess: DomainRegistrationEnabled=true

NMProcess: DomainsDirRemoteSharingEnabled=false

NMProcess:

NMProcess: Domain name mappings:

NMProcess:

NMProcess: EBS_domain_VIS -> /apps/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS

NMProcess:

NMProcess:

NMProcess: Jan 27, 2014 10:29:27 PM weblogic.nodemanager.server.AbstractServerManager log

NMProcess: INFO: Startup configuration properties loaded from "/apps/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/AdminServer/data/nodemanager/startup.properties"

NMProcess:

NMProcess: Jan 27, 2014 10:29:27 PM weblogic.nodemanager.server.AbstractServerManager log

NMProcess: INFO: Startup configuration properties loaded from "/apps/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/oacore_server1/data/nodemanager/startup.properties"

NMProcess:

NMProcess: Jan 27, 2014 10:29:27 PM weblogic.nodemanager.server.AbstractServerManager log

NMProcess: INFO: Startup configuration properties loaded from "/apps/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/oafm_server1/data/nodemanager/startup.properties"

NMProcess:

NMProcess: Jan 27, 2014 10:29:27 PM weblogic.nodemanager.server.AbstractServerManager log

NMProcess: INFO: Startup configuration properties loaded from "/apps/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/forms_server1/data/nodemanager/startup.properties"

NMProcess:

NMProcess: Jan 27, 2014 10:29:27 PM weblogic.nodemanager.server.AbstractServerManager log

NMProcess: INFO: Startup configuration properties loaded from "/apps/oracle/VIS/fs1/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/forms-c4ws_server1/data/nodemanager/startup.properties"

NMProcess:

NMProcess: Jan 27, 2014 10:29:27 PM weblogic.nodemanager.server.Listener run

NMProcess: INFO: Plain socket listener started on port 5556, host starworld.appstek.ca

Refer /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adnodemgrctl.txt for details



adnodemgrctl.sh: exiting with status 0



adnodemgrctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adnodemgrctl.txt for more information ...





.end std out.

*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS

*** Log File = /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/rgf/TXK/txkChkEBSDependecies_Mon_Jan_27_22_29_13_2014/txkChkEBSDependecies_Mon_Jan_27_22_29_13_2014.log



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/adalnctl.sh start

Timeout specified in context file: 100 second(s)



script returned:

****************************************************



adalnctl.sh version 120.3.12020000.2



Checking for FNDFS executable.

Starting listener process APPS_VIS.



adalnctl.sh: exiting with status 0





adalnctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adalnctl.txt for more information ...





.end std out.



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/adcmctl.sh start

Timeout specified in context file: 1000 second(s)



script returned:

****************************************************



You are running adcmctl.sh version 120.19.12020000.3



Starting concurrent manager for VIS ...

Starting VIS_0127@VIS Internal Concurrent Manager

Default printer is noprint



adcmctl.sh: exiting with status 0





adcmctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adcmctl.txt for more information ...





.end std out.



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/adadminsrvctl.sh start -nopromptmsg

Timeout specified in context file: 1000 second(s)



script returned:

****************************************************



You are running adadminsrvctl.sh version 120.10.12020000.2



Starting WLS Admin Server...

Refer /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adadminsrvctl.txt for details



adadminsrvctl.sh: exiting with status 0



adadminsrvctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adadminsrvctl.txt for more information ...





.end std out.



.end err out.



****************************************************











Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/admanagedsrvctl.sh start forms_server1 -nopromptmsg

Timeout specified in context file: -1 second(s)



script returned:

****************************************************



You are running admanagedsrvctl.sh version 120.14.12020000.4



Starting forms_server1...



admanagedsrvctl.sh: exiting with status 0



admanagedsrvctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adformsctl.txt for more information ...





.end std out.



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/admanagedsrvctl.sh start forms-c4ws_server1 -nopromptmsg

Timeout specified in context file: -1 second(s)



script returned:

****************************************************



You are running admanagedsrvctl.sh version 120.14.12020000.4



Starting forms-c4ws_server1...



admanagedsrvctl.sh: exiting with status 0



admanagedsrvctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adforms-c4wsctl.txt for more information ...





.end std out.



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/admanagedsrvctl.sh start oafm_server1 -nopromptmsg

Timeout specified in context file: -1 second(s)



script returned:

****************************************************



You are running admanagedsrvctl.sh version 120.14.12020000.4



Starting oafm_server1...



admanagedsrvctl.sh: exiting with status 0



admanagedsrvctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adoafmctl.txt for more information ...





.end std out.



.end err out.



****************************************************







Executing service control script:

/apps/oracle/VIS/fs1/inst/apps/VIS_starworld/admin/scripts/admanagedsrvctl.sh start oacore_server1 -nopromptmsg

Timeout specified in context file: -1 second(s)



script returned:

****************************************************



You are running admanagedsrvctl.sh version 120.14.12020000.4



Starting oacore_server1...



admanagedsrvctl.sh: exiting with status 0



admanagedsrvctl.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adoacorectl.txt for more information ...





.end std out.



.end err out.



****************************************************







All enabled services for this node are started.



adstrtal.sh: Exiting with status 0



adstrtal.sh: check the logfile /apps/oracle/VIS/fs1/inst/apps/VIS_starworld/logs/appl/admin/log/adstrtal.log for more information ...



[applvis@starworld ~]$

[applvis@starworld ~]$

[applvis@starworld ~]$