R12.2 why is my apps tier growing?

Recent observation that RUN file system is growing rapidly, on quick analysis its been found that logs in OHS,forms server and reports cache is not being cleaned and has to be done manually.

Below are the location for the above mentioned points.
Schedule a cronjob to delete old access and error log files from the first 2 location and the last location can be purged as and when required.

1. /apps/PROD/fs2/FMW_Home/webtier/instances/EBS_web_PROD_OHS1/diagnostics/logs/OHS/EBS_web_PROD
2. /apps/PROD/fs2/FMW_Home/user_projects/domains/EBS_domain_PROD/servers/forms_server1/logs
3. /apps/PROD/fs2/inst/apps/PROD_prdsrv/logs/ora/10.1.2/reports/cache

Thank you.

Configuring ILOM in Enterprise Manager 13c

How to configure ILOM in EM13c?

Please follow the steps below.
1) From the setup go to add traget --> add targets manually.

2) click on Add using guided process.

3) Select systems infrastructure server ILOM.

4) Give a desired target name, enter the ip address of the ILOM

    In monitoring agent URL select the agent that was installed for EM server.

    Enter credentails for the ILOM and click on test connection once the connetion is successful click       on add.

5) Go to target and look for the platform section and there you should see the configured ILOM. 

Thank you.

Uninstalling 12c EM agent

Go to the agent home directory and perform the below steps:

make sure oraInst.loc is pointing to the correct inventory.

/u27/AGENT/core/12.1.0.5.0/perl/bin$ /u27/AGENT/core/12.1.0.5.0/perl/bin/perl /u27/AGENT/core/12.1.0.5.0/sysman/install/AgentDeinstall.pl -agentHome /u27/AGENT/core/12.1.0.5.0


agent@tstsrv:/u27/AGENT/core/12.1.0.5.0/perl/bin$ /u27/AGENT/core/12.1.0.5.0/perl/bin/perl /u27/AGENT/core/12.1.0.5.0/sysman/install/AgentDeinstall.pl -agentHome /u27/AGENT/core/12.1.0.5.0


 Agent Oracle Home: /u27/AGENT/core/12.1.0.5.0

agentHome = /u27/AGENT/core/12.1.0.5.0

NOTE: The agent base directory: /u27/AGENT will be removed after successful deinstallation of agent home.


 DetachHome Command executed:/u27/AGENT/core/12.1.0.5.0/oui/bin/runInstaller -detachHome -force -depHomesOnly -silent ORACLE_HOME=/u27/AGENT/core/12.1.0.5.0 -waitForCompletion -invPtrLoc /u27/AGENT/core/12.1.0.5.0/oraInst.loc
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 39265 MB    Passed
The inventory pointer is located at /u27/AGENT/core/12.1.0.5.0/oraInst.loc
'DetachHome' was successful.
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 39265 MB    Passed
The inventory pointer is located at /u27/AGENT/core/12.1.0.5.0/oraInst.loc
The Oracle home '/u27/AGENT/sbin' could not be updated as it does not exist.


Deinstall Command executed:/u27/AGENT/core/12.1.0.5.0/oui/bin/runInstaller -deinstall -silent "REMOVE_HOMES={/u27/AGENT/core/12.1.0.5.0}" -waitForCompletion -removeAllFiles -invPtrLoc /u27/AGENT/core/12.1.0.5.0/oraInst.loc
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 39265 MB    Passed
Oracle Universal Installer, Version 11.1.0.13.0 Production
Copyright (C) 1999, 2015, Oracle. All rights reserved.

Starting deinstall


Deinstall in progress (Monday, September 5, 2016 2:13:30 PM AST)
Configuration assistant "Agent Deinstall Assistant" succeeded
............................................................... 100% Done.

Deinstall successful

End of install phases.(Monday, September 5, 2016 2:13:56 PM AST)
End of deinstallations
Please check '/u27/ORACLE/oraInventory/logs/silentInstall2016-09-05_02-13-26PM.log' for more details.
Can't locate Carp.pm in @INC (@INC contains: /u27/AGENT/core/12.1.0.5.0/perl/lib/5.10.0/sun4-solaris-thread-multi-64 /u27/AGENT/core/12.1.0.5.0/perl/lib/5.10.0 /u27/AGENT/core/12.1.0.5.0/perl/lib/site_perl/5.10.0/sun4-solaris-thread-multi-64 /u27/AGENT/core/12.1.0.5.0/perl/lib/site_perl/5.10.0 /u27/AGENT/core/12.1.0.5.0/perl/lib/5.10.0/sun4-solaris-thread-multi-64 /u27/AGENT/core/12.1.0.5.0/perl/lib/5.10.0 /u27/AGENT/core/12.1.0.5.0/perl/lib/5.10.0/sun4-solaris-thread-multi-64 /u27/AGENT/core/12.1.0.5.0/perl/lib/site_perl/5.10.0/sun4-solaris-thread-multi-64 /u27/AGENT/core/12.1.0.5.0/perl/lib/site_perl/5.10.0 /u27/AGENT/core/12.1.0.5.0/perl/lib/site_perl .) at /u27/AGENT/core/12.1.0.5.0/perl/lib/5.10.0/File/Path.pm line 32.
agent@tstsrv:/u27/AGENT/core/12.1.0.5.0/perl/bin$

The command name "import_update_catalog" is not a recognized command.

While updating catalog in Enterprise manager 13c i was facing below issue:


[applgrid@em13c bin]$ ./emcli import_update_catalog -file=/u01/SOFT/PATCHES/p9348486_112000_Generic.zip -omslocal
Error: The command name "import_update_catalog" is not a recognized command.
Run the "help" command for a list of recognized commands.
You may also need to run the "sync" command to synchronize with the current OMS.

Solution :


[applgrid@em13c bin]$ emcli import_update_catalog -file=/u01/SOFT/PATCHES/p9348486_112000_Generic.zip -omslocal
Error: The command name "import_update_catalog" is not a recognized command.
Run the "help" command for a list of recognized commands.
You may also need to run the "sync" command to synchronize with the current OMS.
[applgrid@em13c bin]$ ./emcli setup -url="https://em13c.domain.com:7802/em" -username=sysman -password=xxxxxx -trustall
Oracle Enterprise Manager 13c Release 1.
Copyright (c) 1996, 2015 Oracle Corporation and/or its affiliates. All rights reserved.

Emcli setup successful
[applgrid@em13c bin]$ ./emcli login -username=sysman
Error: Already logged in as user "sysman". Use "emcli logout" to logout the current user.
[applgrid@em13c bin]$ ./emcli sync
Synchronized successfully
[applgrid@em13c bin]$ emcli import_update_catalog -file=/u01/SOFT/PATCHES/p9348486_112000_Generic.zip -omslocal            

Processing catalog for Agent Software
Processing update: Agent Software - Agent Software (12.1.0.5.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Microsoft Windows (32-bit)
Processing update: Agent Software - Agent Software (12.1.0.5.0) for HP-UX PA-RISC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for HP-UX PA-RISC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for HP-UX PA-RISC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for HP-UX PA-RISC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for HP-UX PA-RISC (64-bit)
Processing update: Agent Software - Agent Software (13.1.0.0.0) for Linux x86
Processing update: Agent Software - Agent Software (12.1.0.5.0) for Linux x86
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Linux x86
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Linux x86
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Linux x86
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Linux x86
Processing update: Agent Software - Agent Software (13.1.0.0.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.5.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Oracle Solaris on x86-64 (64-bit)
Processing update: Agent Software - Agent Software (13.1.0.0.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.5.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Oracle Solaris on SPARC (64-bit)
Processing update: Agent Software - Agent Software (13.1.0.0.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.5.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Microsoft Windows x64 (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.5.0) for Linux x86-64
Processing update: Agent Software - Agent Software (12.1.0.4.0) for Linux x86-64
Processing update: Agent Software - Agent Software (12.1.0.3.0) for Linux x86-64
Processing update: Agent Software - Agent Software (12.1.0.2.0) for Linux x86-64
Processing update: Agent Software - Agent Software (12.1.0.1.0) for Linux x86-64
Processing update: Agent Software - Agent Software (13.1.0.0.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.5.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.4.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.3.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.2.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.1.0) for IBM AIX on POWER Systems (64-bit)
Processing update: Agent Software - Agent Software (12.1.0.5.0) for IBM: Linux on System z
Processing update: Agent Software - Agent Software (12.1.0.4.0) for IBM: Linux on System z
Processing update: Agent Software - Agent Software (12.1.0.3.0) for IBM: Linux on System z
Processing update: Agent Software - Agent Software (12.1.0.2.0) for IBM: Linux on System z
Processing update: Agent Software - Agent Software (12.1.0.1.0) for IBM: Linux on System z
Processing update: Agent Software - Agent Software (13.1.0.0.0) for HP-UX Itanium
Processing update: Agent Software - Agent Software (12.1.0.5.0) for HP-UX Itanium
Processing update: Agent Software - Agent Software (12.1.0.4.0) for HP-UX Itanium
Processing update: Agent Software - Agent Software (12.1.0.3.0) for HP-UX Itanium
Processing update: Agent Software - Agent Software (12.1.0.2.0) for HP-UX Itanium
Processing update: Agent Software - Agent Software (12.1.0.1.0) for HP-UX Itanium
Processing catalog for Middleware Profiles and Gold Images
Processing update: Middleware Profiles and Gold Images - Three Fusion Middleware Provisioning Profiles with different heap size configuration
Processing catalog for Data Masking and Subsetting templates
Processing update: Data Masking and Subsetting templates - Mask template Fusion Rel v1.x Combined All Family
Processing update: Data Masking and Subsetting templates - Data Masking template for Oracle E-Business suite 12.1.3 (Standard Model)
Processing update: Data Masking and Subsetting templates - Data Masking template for Oracle E-Business suite 12.1.3 (JG model)
Processing update: Data Masking and Subsetting templates - Preparation script required for Oracle E-Business Suite masking process
Processing update: Data Masking and Subsetting templates - ADM template Fusion Rel v1.x Combined All Family
Processing update: Data Masking and Subsetting templates - Application Data Model Template for Oracle E-Business Suite 12.1.3(Standard Model)
Processing update: Data Masking and Subsetting templates - Application Data Model Template for Oracle E-Business Suite 12.1.3(JG Model)
Processing catalog for Extensibility Development Kit
Processing catalog for Plug-in
Processing update: Plug-in - Enterprise Manager for VCP
Processing update: Plug-in - Enterprise Manager for Oracle Utilities Application provides management, metrics and monitoring capabilities for the Oracle Utilities products that use the Oracle Utilities Framework.
Processing update: Plug-in - Enterprise Manager for Oracle Utilities Application provides management, metrics and monitoring capabilities for the Oracle Utilities products that use the Oracle Utilities Framework.
Processing update: Plug-in - Enterprise Manager for Oracle Public Sector Revenue Management Application provides management, metrics and monitoring capabilities for the Oracle Public Sector Revenue Management.
Processing update: Plug-in - Enterprise Manager for Oracle Utilities Network Management System provides management and monitoring for the NMS
Processing update: Plug-in - Enterprise Manager for Sun Ray Software
Processing update: Plug-in - Enterprise Manager for Oracle ZFS Storage Appliances
Processing update: Plug-in - Enterprise Manager for Oracle ZFS Storage Appliances
Processing update: Plug-in - Enterprise Manager for Oracle ZFS Storage Appliances
Processing update: Plug-in - Enterprise Management Plug-in for Oracle ZFS Storage Appliances
Processing update: Plug-in - Management Plug-in for the Sun ZFS Storage Appliance Family
Processing update: Plug-in - Management Plug-in for the Sun ZFS Storage Appliance Family
Processing update: Plug-in - Enterprise Manager for Oracle Secure Global Desktop
Processing update: Plug-in - Enterprise Manager for Oracle Secure Global Desktop Gateway
Processing update: Plug-in - Enterprise Manager for Oracle Primavera Prime
Processing update: Plug-in - Enterprise Manager for Oracle Primavera P6 EPPM
Processing update: Plug-in - Enterprise Manager for Oracle Primavera P6 EPPM
Processing update: Plug-in - Enterprise Manager for Oracle Unified Directory
Processing update: Plug-in - Enterprise Manager for Oracle Key Manager
Processing update: Plug-in - Enterprise Manager for Oracle Flash Storage System
Processing update: Plug-in - Enterprise Manager for Oracle Instant Messaging Server is used for monitoring/managing the Oracle Instant Messaging Server
Processing update: Plug-in - Enterprise Manager for MySQL Database
Processing update: Plug-in - Enterprise Manager for MySQL Database
Processing update: Plug-in - Enterprise Manager for MySQL Database
Processing update: Plug-in - Enterprise Manager for Oracle Tuxedo
Processing update: Plug-in - Enterprise Manager for Oracle Tuxedo
Processing update: Plug-in - Enterprise Manager for Oracle GoldenGate
Processing update: Plug-in - Enterprise Manager for Ops Center Infrastructure stack
Processing update: Plug-in - Enterprise Manager for Ops Center Infrastructure stack
Processing update: Plug-in - Ops Center Infrastructure stack management plug-in.
Processing update: Plug-in - Ops Center Infrastructure stack management plug-in.
Processing update: Plug-in - Enterprise Manager for Oracle Database Appliance provides comprehensive monitoring and management for Oracle Database Appliance and related targets.

Processing update: Plug-in - Enterprise Manager for Oracle TimesTen In-Memory Database
Processing update: Plug-in - Enterprise Manager for Oracle TimesTen In-Memory Database
Processing update: Plug-in - Enterprise Manager for Oracle Communications enables management of Oracle Communications products
Processing update: Plug-in - Enterprise Manager for Big Data Discovery consists of monitoring, diagnosing, and management for Oracle Big Data Discovery and its components.
Processing update: Plug-in -
                Enterprise Manager for Pillar Axiom

Processing update: Plug-in - Enterprise Manager for PeopleSoft
Processing update: Plug-in -
    Enterprise Manager for Jdedwards EnterpriseOne consists of monitoring and management for Oracle Jdedwards EnterpriseOne system.

Processing update: Plug-in - Enterprise Manager for Oracle E-Business Suite consists of System Management and Change Management Feature Sets
Processing catalog for Management Connector
Processing update: Management Connector -
             IBM TEC Connector - 12.1.0.3.0

Processing update: Management Connector -
             IBM TEC Connector - 12.1.0.2.0

Processing update: Management Connector -
             Microsoft SCOM R2 Connector - 12.1.0.2.0

Processing update: Management Connector -
             Microsoft SCOM preR2 Connector - 12.1.0.2.0

Processing update: Management Connector - BMC Remedy 7.6.04 Service Desk Connector - 12.1.0.2.0
Processing update: Management Connector - BMC Remedy Change Management Connector - 12.1.0.1.0
Processing update: Management Connector -
            IBM Tivoli Netcool/OMNIbus Connector - 12.1.0.2.0

Processing update: Management Connector -
             HP Service Manager 7.0 Connector - 12.1.0.2.0

Processing update: Management Connector -
             HP Operations Manager UNIX Connector - 12.1.0.2.0

Processing update: Management Connector -
             CA Service Desk Connector - 12.1.0.2.0

Processing catalog for Compliance Content
Processing update: Compliance Content - Compliance Framework - Security Technical Implementation Guides (STIGs)
Processing update: Compliance Content - Compliance Standard - Security Technical Implementation Guide (STIG Version 1.1) for Oracle WebLogic Server 12c
Processing update: Compliance Content - Oracle 11.2g Database STIG - Version 1, Release 6
Processing catalog for Informational
Processing update: Informational - Announcing New and Updated Cloud Management Capabilites for Database, Infrastructure, and Testing
Processing update: Informational - Enterprise Manager Cloud Control 12c Release 2 Plug-in Update 1 (12.1.0.2) now available on OTN
Processing update: Informational - Enterprise Manager Cloud Control 12C white papers available now on Oracle Technology Network
Processing update: Informational - Integration of Oracle Business Intelligence (BI) Publisher 11.1.1.5.0 with Enterprise Manager Cloud Control 12.1.0.1
Processing update: Informational - Management of Oracle VM 3.1.1 now available with Oracle Enterprise Manager 12c
Processing update: Informational - Oracle Enterprise Manager Cloud Control Mobile now available for Apple iPhone
Processing catalog for Provisioning Bundle
Processing catalog for Diagnostic Tools

Successfully uploaded the Self Update catalog to Enterprise Manager. Use the Self Update Console to view and manage updates.
Time taken for import catalog is 48.359 seconds.

Oracle EBS 12.1,12.2 AD_TRACKABLE_ENTITIES table

Oracle EBS AD_TRACKABLE_ENTITIES table

If you have been running patchsets.sh to get the patch level for family packs now you can use AD_TRACKABLE_ENTITIES table to get the same.

select * from AD_TRACKABLE_ENTITIES where abbreviation like '%pf'

select * from AD_TRACKABLE_ENTITIES

Thank you,
TAI