Wednesday, January 31, 2018

Information Center: Using EBS Technology Stack OID and SSO (Doc ID 1461466.2)


Posted by at No comments:

TXK Technology Inventory Report Apps Tier

source you appstier env

oracle@suthakar$perl TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP
Enter Apps password ? 
Enter Report File name ? r1227.html
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** STDOUT   = /apps2/oracle/product/inst/fs1/inst/apps/VIS_suthakar/logs/appl/rgf/TXK/txkInventory_Wed_Jan_31_13_20_49_2018_stdout.log 
Reportfile /apps2/oracle/product/inst/fs1/inst/apps/VIS_suthakar/appltmp/TXK/r1227.html generated successfully.

oracle@suthakar$

Posted by at No comments:

Friday, January 26, 2018

How to determine the application of WebLogic Server PSU. 

 

  $ . $WL_HOME/server/bin/setWLSEnv.sh 
  $ java weblogic.version
Posted by at No comments:

Thursday, January 25, 2018

Patching verious home

Patching webtier env.

/apps2/oracle/product/fs1/FMW_Home/webtier
export ORACLE_HOME=/apps2/oracle/product/fs1/FMW_Home/webtier
export PATH=$ORACLE_HOME/OPatch:$PATH



 Patching oracle_common

/apps2/oracle/product/fs1/FMW_Home/oracle_common
oracle@suthakar$export ORACLE_HOME=/apps2/oracle/product/fs1/FMW_Home/oracle_common
oracle@suthakar$export PATH=$ORACLE_HOME/OPatch:$PATH

patching  form and report
oracle@suthakar$pwd
/apps2/oracle/product/fs1/EBSapps/10.1.2
oracle@suthakar$which opatch
/apps2/oracle/product/fs1/EBSapps/10.1.2/OPatch/opatch







No need to set oracle home for 10.1.2 this is default oracle home patches.

Posted by at No comments:

Tuesday, January 23, 2018

Application Tier code level checker

Source you App environment

checkMTpatch.sh

 +===============================================================+ 
 |    Copyright (c) 2005, 2016 Oracle and/or its affiliates.     | 
 |                     All rights reserved.                      | 
 |             Oracle E-Business Suite Release 12.2              | 
 |        Applicatione Tier Technology Codelevel Checker         | 
 +===============================================================+ 

Using context file from currently set applications environment:
/apps2/oracle/product/inst/fs1/inst/apps/VIS_suthakar/appl/admin/VIS_suthakar.xml

Starting Application Tier Technology Codelevel Checker 
Version: 120.0.12020000.32.
Tue Jan 23 11:30:13 EST 2018
Log file for this session: /scratch/r12patch/checkMTpatch_12087.log

Bugfix XML file version: 120.0.12020000.33
This file will be used for identifying missing bugfixes. 

Mapping XML file version: 120.0.12020000.18
This file will be used for mapping bugfixes to patches.

Checking for prerequisite bugfixes in File Edition: run

Enter the password for the APPS user: 
Connecting to database. 
Database connection successful.
The installed AD.C codelevel does not support storing the results in the database.

===============================================================================
Oracle Forms and Reports
===============================================================================
Now examining product Oracle Forms and Reports.

Oracle Home = /apps2/oracle/product/fs1/EBSapps/10.1.2.
Product version = 10.1.2.3.0.
Checking required bugfixes for Oracle Forms and Reports 10.1.2.3.0.
  Missing Bugfix: 17353142  ->  Patch 25768948
  Missing Bugfix: 20643256  ->  Patch 25768948
  Missing Bugfix: 16041055  ->  Patch 25768948
  Missing Bugfix: 16910762  ->  Patch 25768948
  Missing Bugfix: 20270659  ->  Patch 25768948
  Missing Bugfix: 17372642  ->  Patch 25768948
  Missing Bugfix: 17566694  ->  Patch 25768948
  Missing Bugfix: 20240480  ->  Patch 25768948
  Missing Bugfix: 19304738  ->  Patch 25768948
  Missing Bugfix: 20391574  ->  Patch 25768948
  Missing Bugfix: 22351071  ->  Patch 25768948
  Missing Bugfix: 21024122  ->  Patch 25768948
  Missing Bugfix: 19588847  ->  Patch 25768948
  Missing Bugfix: 19639173  ->  Patch 25768948
  Missing Bugfix: 20545718  ->  Patch 25768948
  Missing Bugfix: 22524329  ->  Patch 25768948
  Missing Bugfix: 23123655  ->  Patch 25768948
  Missing Bugfix: 23728755  ->  Patch 25768948
  Missing Bugfix: 24315226  ->  Patch 25768948
  Missing Bugfix: 24480018  ->  Patch 25768948
  Missing Bugfix: 24808044  ->  Patch 25768948
  Missing Bugfix: 24620875  ->  Patch 25768948
  Missing Bugfix: 25355211  ->  Patch 25768948
  Missing Bugfix: 23538157  ->  Patch 25768948
  Missing Bugfix: 23538170  ->  Patch 25768948
  Missing Bugfix: 13557392  ->  Patch 25768948
  Missing Bugfix: 25506193  ->  Patch 25768948
The above list shows missing bugfixes for Oracle Forms and Reports.

Checking required bugfixes for RSF within Forms 10.1.0.5.0.
All required bugfixes are present for RSF within Forms.

===============================================================================
Oracle Fusion Middleware (FMW) - Web Tier
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) - Web Tier.

Oracle Home = /apps2/oracle/product/fs1/FMW_Home/webtier.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - Web Tier 11.1.1.9.0.
  Missing Bugfix: 21300463  ->  Patch 22288381
  Missing Bugfix: 21892015  ->  Patch 22288381
The above list shows missing bugfixes for FMW - Web Tier.

Checking required bugfixes for RSF within FMW Web tier 11.1.0.7.0.
All required bugfixes are present for RSF within FMW Web tier.

===============================================================================
Oracle Fusion Middleware (FMW) - oracle_common
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) - oracle_common.

Oracle Home = /apps2/oracle/product/fs1/FMW_Home/oracle_common.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - oracle common 11.1.1.9.0.
  Missing Bugfix: 9905685  ->  Patch 9905685
  Missing Bugfix: 17428617  ->  Patch 17428617
  Missing Bugfix: 21366277  ->  Patch 21366277
  Missing Bugfix: 21628307  ->  Patch 21628307
  Missing Bugfix: 24606362  ->  Patch 24606362
  Missing Bugfix: 24843064  ->  Patch 24843064
The above list shows missing bugfixes for FMW - oracle common.

===============================================================================
Oracle WebLogic Server (WLS)
===============================================================================
Now examining product Oracle WebLogic Server (WLS).

Oracle Home = /apps2/oracle/product/fs1/FMW_Home/wlserver_10.3.
Product Version = 10.3.6.0.7

Note that for Oracle WebLogic Server, patches rather than bugfixes are verified.

Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.7.
  Missing Patch ID: 23743997
The above list shows missing patches for Oracle WebLogic Server. 
If you have applied other Oracle WebLogic Server patches, they may have included the bugfixes needed. 
Contact Oracle Support if you require assistance in determining whether this is the case.

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

Generating Patch Recommendation Summary.

===============================================================================
PATCH RECOMMENDATION SUMMARY
===============================================================================
One or more products have bugfixes missing.
The default patch recommendations to install these missing bugfixes are:

-------------------------------------------------------------------------------
Oracle Forms and Reports 10.1.2.3.0
-------------------------------------------------------------------------------
  Patch 25768948
    - Filename: p25768948_101232_LINUX.zip


-------------------------------------------------------------------------------
Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0
-------------------------------------------------------------------------------
  Patch 22288381
    - Filename: p22288381_111190_Generic.zip


-------------------------------------------------------------------------------
Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0
-------------------------------------------------------------------------------
  Patch 9905685
    - Filename: p9905685_111190_Generic.zip

  Patch 17428617
    - Filename: p17428617_111190_Generic.zip

  Patch 21366277
    - Filename: p21366277_111190_Generic.zip

  Patch 21628307
    - Filename: p21628307_111190_Generic.zip

  Patch 24606362
    - Filename: p24606362_111190_Generic.zip

  Patch 24843064
    - Filename: p24843064_111190_Generic.zip


-------------------------------------------------------------------------------
Oracle WebLogic Server (WLS) 10.3.6.0.7
-------------------------------------------------------------------------------
  Patch 23743997 [SU Patch [K25M]: WLS PSU 10.3.0.6.161018]
    - Filename: p23743997_1036_Generic.zip


Apply the required patches and rerun this script. 

+-----------------------------------------------------------------------------+
A consolidated zip file with the required application tier patches is
available on My Oracle Support via:

  Patch 26821047
    - EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR OCT 2017

+-----------------------------------------------------------------------------+
[WARNING]  Patch 23743997 [SU Patch [K25M]: WLS PSU 10.3.0.6.161018] is missing. 
This is the recommended minimum WLS patch set.
You should install it now, and then rerun this script to check for any
further fixes available.
+-----------------------------------------------------------------------------+

See Doc ID 1594274.1 for any special instructions regarding these patches.
Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.

Finished checking prerequisite patches for File Edition: run.
Tue Jan 23 11:30:35 EST 2018

Log file for this session: /scratch/r12patch/checkMTpatch_12087.log

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

oracle@suthakar$

Posted by at 1 comment:

Monday, January 22, 2018

checkDBpatch.sh will tell you Database EBS Technology Codelevel

checkDBpatch.sh

 +===============================================================+ 
 |    Copyright (c) 2005, 2017 Oracle and/or its affiliates.     | 
 |                     All rights reserved.                      | 
 |             Oracle E-Business Suite Release 12.2              | 
 |          Database EBS Technology Codelevel Checker            | 
 +===============================================================+ 

Using context file from currently set database environment:
/apps2/oracle/product/12.1.0/appsutil/VIS_suthakar.xml

Starting Database EBS Technology Codelevel Checker, Version 120.55 
Mon Jan 22 12:01:40 EST 2018
Log file for this session : ./checkDBpatch_15647.log

Bugfix XML file version: 120.0.12020000.39
This file will be used for identifying missing bugfixes. 

Mapping XML file version: 120.0.12020000.12
This file will be used for mapping bugfixes to patches.


[WARNING] DB-ETCC: Bugfix XML file (./txk_R1220_DB_base_bugs.xml) in current directory is more than 30 days old.
 Check if a newer version is available in patch 17537119.

Identifying database release. 
Database release set to 12.1.0.2.

Connecting to database. 
Database connection successful. 

Database VIS is in READ WRITE mode.

Identifying APPS and APPLSYS schema names. 
 - APPS schema : APPS
 - APPLSYS schema : APPLSYS

Checking for DB-ETCC results table. 
Table to store DB-ETCC results already exists in the database.

Checking if InMemory option is enabled. 
InMemory option is not enabled in the database.

Checking Bugfix XML file for 12.1.0.2

Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.

The opatch utility is version 12.1.0.1.10.
DB-ETCC is compatible with this opatch version.

Found patch records in the inventory.

Checking Mapping XML file for 12.1.0.2

  Missing Bugfix: 14666816  ->  Patch 26635276
  Missing Bugfix: 18793246  ->  Patch 18793246
  Missing Bugfix: 19239846  ->  Patch 26794113
  Missing Bugfix: 19591608  ->  Patch 19591608
  Missing Bugfix: 20627866  ->  Patch 26794113
  Missing Bugfix: 20766180  ->  Patch 20766180
  Missing Bugfix: 20868862  ->  Patch 26635276
  Missing Bugfix: 21099502  ->  Patch 25967939
  Missing Bugfix: 21028698  ->  Patch 22098146
  Missing Bugfix: 21106027  ->  Patch 26794113
  Missing Bugfix: 21321429  ->  Patch 21321429
  Missing Bugfix: 21387964  ->  Patch 26794113
  Missing Bugfix: 21614112  ->  Patch 25967939
  Missing Bugfix: 21751519  ->  Patch 26635276
  Missing Bugfix: 21813400  ->  Patch 26794113
  Missing Bugfix: 21864513  ->  Patch 21864513
  Missing Bugfix: 21904072  ->  Patch 21904072
  Missing Bugfix: 21967332  ->  Patch 21967332
  Missing Bugfix: 22024071  ->  Patch 26794113
  Missing Bugfix: 22229581  ->  Patch 26635276
  Missing Bugfix: 22452653  ->  Patch 26635276
  Missing Bugfix: 22496904  ->  Patch 22496904
  Missing Bugfix: 22568797  ->  Patch 26794113
  Missing Bugfix: 22660003  ->  Patch 25967939
  Missing Bugfix: 22666802  ->  Patch 26794113
  Missing Bugfix: 22731026  ->  Patch 22731026
  Missing Bugfix: 22737974  ->  Patch 26635276
  Missing Bugfix: 23089357  ->  Patch 23089357
  Missing Bugfix: 23220453  ->  Patch 26794113
  Missing Bugfix: 23604553  ->  Patch 26635276
  Missing Bugfix: 23632545  ->  Patch 26794113
  Missing Bugfix: 23645516  ->  Patch 26794113
  Missing Bugfix: 24326444  ->  Patch 26794113
  Missing Bugfix: 24385983  ->  Patch 26794113
  Missing Bugfix: 24560906  ->  Patch 24560906
  Missing Bugfix: 24589081  ->  Patch 26794113
  Missing Bugfix: 25099339  ->  Patch 26794113
  Missing Bugfix: 25139545  ->  Patch 26635276
  Missing Bugfix: 25643931  ->  Patch 25643931
  Missing Bugfix: 25906117  ->  Patch 25906117
  Missing Bugfix: 25971286  ->  Patch 26794113
  Missing Bugfix: 25919622  ->  Patch 26794113
  Missing Bugfix: 25995938  ->  Patch 25995938
  Missing Bugfix: 26658759  ->  Patch 26794113

Generating Patch Recommendation Summary.

===============================================================================
PATCH RECOMMENDATION SUMMARY
===============================================================================
The default patch recommendations to install these missing bugfixes are:
-------------------------------------------------------------------------------
Oracle Database Release 12.1.0.2  (No PSU applied)
-------------------------------------------------------------------------------
  Patch 26635276
    - Filename: p26635276_121020_Linux-x86-64.zip

  Patch 18793246
    - Filename: p18793246_121020_Generic.zip

  Patch 26794113
    - Filename: p26794113_121020_Linux-x86-64.zip

  Patch 19591608
    - Filename: p19591608_121020_Linux-x86-64.zip

  Patch 20766180
    - Filename: p20766180_121020_Generic.zip

  Patch 25967939
    - Filename: p25967939_121020_Linux-x86-64.zip

  Patch 22098146
    - Filename: p22098146_121020_Linux-x86-64.zip

  Patch 21321429
    - Filename: p21321429_121020_Generic.zip

  Patch 21864513
    - Filename: p21864513_121020_Linux-x86-64.zip

  Patch 21904072
    - Filename: p21904072_121020_Linux-x86-64.zip

  Patch 21967332
    - Filename: p21967332_121020_Linux-x86-64.zip

  Patch 22496904
    - Filename: p22496904_121020_Linux-x86-64.zip

  Patch 22731026
    - Filename: p22731026_121020_Generic.zip

  Patch 23089357
    - Filename: p23089357_121020_Linux-x86-64.zip

  Patch 24560906
    - Filename: p24560906_121020_Linux-x86-64.zip

  Patch 25643931
    - Filename: p25643931_121020_Linux-x86-64.zip

  Patch 25906117
    - Filename: p25906117_121020_Linux-x86-64.zip

  Patch 25995938
    - Filename: p25995938_121020_Linux-x86-64.zip


Apply the required patches and rerun this script

You should check the patch READMEs for minimum opatch version requirements.
The latest opatch is available from My Oracle Support via Patch 6880880.


+-----------------------------------------------------------------------------+
A consolidated zip file with the required patches for Database release
12.1.0.2.0 is available on My Oracle Support via:

  Patch 26821046 [12.1.0.2.0 version]
    - EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR OCT 2017

Note: This zip does not include any database bundle patches or PSUs.
+-----------------------------------------------------------------------------+

See Doc ID 1594274.1 for any special instructions for these patches.
Note: Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.

Stored Technology Codelevel Checker results in the database VIS successfully.

Finished checking fixes for Oracle Database: Mon Jan 22 12:01:53 EST 2018

Log file for this session: ./checkDBpatch_15647.log

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

oracle@suthakar$

Posted by at No comments:

R12.2 Latest AD and TXK Release

Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
Posted by at No comments:

Tuesday, January 16, 2018

How to move space from one volume to another volume in oracle linux

[root@suthakar ~]# lvs
  LV         VG          Attr       LSize   Pool Origin Data%  Meta%  Move Log Cpy%Sync Convert
  LogVol12   vg_suthakar -wi-ao----  58.59g                                                    
  lv_apps    vg_suthakar -wi-ao---- 195.31g                                                    
  lv_apps2   vg_suthakar -wi-ao---- 390.62g                                                    
  lv_home    vg_suthakar -wi-ao----  19.53g                                                    
  lv_local   vg_suthakar -wi-ao----  19.53g                                                    
  lv_opt     vg_suthakar -wi-ao----  19.53g                                                    
  lv_orafra  vg_suthakar -wi-ao---- 341.80g                                                    
  lv_ordata  vg_suthakar -wi-ao---- 341.80g                                                    
  lv_scratch vg_suthakar -wi-ao---- 427.80g                                                    
  lv_swap    vg_suthakar -wi-ao----  15.74g                                                    
  lv_swap1   vg_suthakar -wi-ao----   9.77g                                                    
  lv_tmp     vg_suthakar -wi-ao----   1.95g                                                    
  lv_var     vg_suthakar -wi-ao----  19.53g                                                    

umount /dev/mapper/vg_suthakar-lv_orafra
fsck -f  /dev/mapper/vg_suthakar-lv_orafra
resize2fs /dev/mapper/vg_suthakar-lv_orafra 300G
lvreduce -L -37G /dev/mapper/vg_suthakar-lv_orafra
mount /dev/mapper/vg_suthakar-lv_orafra
--
lvextend -L +37G /dev/mapper/vg_suthakar-lv_tmp
resize2fs /dev/mapper/vg_suthakar-lv_tmp

[root@suthakar ~]# lvs
  LV         VG          Attr       LSize   Pool Origin Data%  Meta%  Move Log Cpy%Sync Convert
  LogVol12   vg_suthakar -wi-ao----  58.59g                                                    
  lv_apps    vg_suthakar -wi-ao---- 195.31g                                                    
  lv_apps2   vg_suthakar -wi-ao---- 390.62g                                                    
  lv_home    vg_suthakar -wi-ao----  19.53g                                                    
  lv_local   vg_suthakar -wi-ao----  19.53g                                                    
  lv_opt     vg_suthakar -wi-ao----  19.53g                                                    
  lv_orafra  vg_suthakar -wi-ao---- 304.80g                                                    
  lv_ordata  vg_suthakar -wi-ao---- 341.80g                                                    
  lv_scratch vg_suthakar -wi-ao---- 427.80g                                                    
  lv_swap    vg_suthakar -wi-ao----  15.74g                                                    
  lv_swap1   vg_suthakar -wi-ao----   9.77g                                                    
  lv_tmp     vg_suthakar -wi-ao----  38.95g                                                    
  lv_var     vg_suthakar -wi-ao----  19.53g        
Posted by at No comments:
Subscribe to: Posts (Atom)