tag:blogger.com,1999:blog-2411185029102809641Wed, 27 Aug 2025 12:42:26 +000011i11i / R12R12Database10gASMiscCertifyOCSUnix-Linux- Sharing Knowledge on Oracle E-Business Suite Applications, Database, Fusion Middleware !!!http://onlineappsdba.blogspot.com/noreply@blogger.com (Famy Rasheed)Blogger103125en-ustag:blogger.com,1999:blog-2411185029102809641.post-6082136706980753684Fri, 11 Mar 2016 16:31:00 +00002016-03-11T22:01:42.050+05:30 Run Oracle E-Business Suite on the Oracle Cloud today! By running Oracle E-Business Suite on Oracle Cloud, you can reduce time and cost for new projects, increase business agility, better manage growth, and increase the productivity of your global IT workforce. Oracle E-Business Suite on Oracle Cloud FAQ LEARN HOW TO USE ORACLE E-BUSINESS SUITE ON ORACLE CLOUD Get hands-on, step-by-stephttp://onlineappsdba.blogspot.com/2016/03/oracle-e-business-suite-on-oracle-cloud.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-5417699390648343819Tue, 08 Mar 2016 11:57:00 +00002016-03-08T17:27:26.478+05:30 <!--[if gte mso 9]> Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 <![endif]--> <!--[if gte mso 9]> http://onlineappsdba.blogspot.com/2016/03/ssl-setup-on-ebs-122-environments_8.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-8385093845948522333Tue, 08 Mar 2016 11:44:00 +00002016-03-08T17:14:39.888+05:30 1. Clean the current oraInventory location:Check the oraInventory location from the /etc/oraInst.loc fileBackup and clean that directoryCustomer can write down the name of all entries from the old inventory from /ContentsXML/inventory.xml to use during the creation of the new OHs2. Add the RDBMS Oracle Home first to the new oraInventory:Go to $ORACLE_HOMEsource the environment file .envcd $http://onlineappsdba.blogspot.com/2016/03/create-clean-orainventory-in-release-122.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-3219659000250786353Thu, 28 May 2015 19:11:00 +00002015-05-29T00:41:07.570+05:30 Good piece of script to identify the status of the workflow components from sql prompt.This is alternate option to see workflow service components status from OAM GUI.Run the below SQL as apps usercol component_id format 999999 col startup_mode format a10 col component_status format a10 col component_name format a50 set linesize 125 set pagesize 25 select component_id, startup_mode,http://onlineappsdba.blogspot.com/2015/05/ebs-workflow-service-components-status.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-504925246564209801Thu, 28 May 2015 19:08:00 +00002015-05-29T00:38:20.052+05:30 perl -pi -e 's/old_string/new_string/g' file_pattern perl -pi -e 's/temp/tmp/g' *.html /happy/ To correctly replace it, you would have to escape the forward slashes with the escape character (the backslash) so that the forward slashes aren't interpreted as commands. Your replacement string would need to be: \/happy\/ http://onlineappsdba.blogspot.com/2015/05/search-and-replace-string-across.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-3404432870753097388Mon, 22 Dec 2014 17:12:00 +00002014-12-22T22:42:59.098+05:30 The steps are mentioned on the EBS Setup Guide for 12.2 which can be downloaded from the link : https://docs.oracle.com/cd/E26401_01/doc.122/e22953/T174296T589913.htm (12.2 Setup Guide) under the topic&nbsp; "If the Admin Password of an EBS WebLogic Domain is lost or forgotten" Also refer for more details :- Procedure To Restore The Weblogic User Password On EBS 12.2 In Case Of Lost Or http://onlineappsdba.blogspot.com/2014/12/howto-restore-weblogic-user-password-on.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-142935060065230500Mon, 10 Mar 2014 03:39:00 +00002014-03-10T09:09:53.333+05:30&nbsp; High levels to apply P4FA: Shutdown FMW, IDM and DB (Transaction, OID and OIM database) services Backup Environment * Apply patches to FMW Oracle Homes (excluding ATGPF/Generic and ATGPF/Database patches) * Apply patches to IDM Oracle Homes * Apply RDBMS patches to Transaction, OID and OIM ** Oracle Homes Start DB (Transaction, OID and OIM database) services Apply RDBMS patches posthttp://onlineappsdba.blogspot.com/2014/03/fusion-applications-p4fa-patches.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-435847905483209886Thu, 26 Sep 2013 13:00:00 +00002013-09-26T18:30:42.537+05:30&nbsp; During Release 12.2 installation, Rapid Install will lay down two copies of the application tier file system. One of the copies will be labeled as the run file system, and the other as the patch file system. Subsequently, when a patch is applied, adop will: Synchronize the contents of the run file system to the patch file system. This happens during the prepare phase. Perform patching http://onlineappsdba.blogspot.com/2013/09/ebs122-how-does-online-patching-work-on.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-4276376687846847327Thu, 26 Sep 2013 11:50:00 +00002013-09-26T17:20:49.331+05:30&nbsp; As EBS R12 - 12.2 is released officially, for installing , Download all the software 12.2&nbsp; from edelivery.oracle.com. Here are the steps to stage 12.2. software First unzip start CD parts in the staging directory “Stage” as in this example. cd /u01/oracle/122/Stageunzip ../V35215-01_1of3.zipunzip ../V35215-01_2of3.zipunzip ../V35215-01_3of3.zip Go to startCD/Disk1/rapidwiz/bin cd /u01http://onlineappsdba.blogspot.com/2013/09/stage-r12-122-software-for-installation.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-9120883239504596493Mon, 10 Jun 2013 07:24:00 +00002013-06-10T12:54:17.845+05:30New or changed technology-related features in EBS 12.2 include: Streamlined installation: Use of native installation tools for Oracle Fusion Middleware and Oracle Database technology stack components. Option for installing EBS 12.2 on to existing database servers. Capability of installation into existing Real Application Clusters environments. Database deployment on Automatic Storage http://onlineappsdba.blogspot.com/2013/06/what-new-in-ebs-122.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-1303452951238513232Mon, 10 Jun 2013 05:43:00 +00002013-06-10T11:14:19.255+05:30The Concurrent Processing Analyzer is a Self-Service Health-Check script which reviews the overall Concurrent Processing Footprint, analyzes the current configurations and settings for the environment providing feedback and recommendations on Best Practices. This is a non-invasive script which provides recommended actions to be performed on the instance it was run on and can be run at any time.http://onlineappsdba.blogspot.com/2013/06/concurrent-processing-cp-analyzer-for-e.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-5697948698054332867Tue, 08 Mar 2011 06:27:00 +00002011-03-08T11:57:02.328+05:30 This is already discussed in Steven Chan's Blog article&nbsp;http://blogs.oracle.com/stevenChan/2006/05/11/&nbsp;and much of this note is a straight copy from this article. &nbsp;Please review this blog article in it's entirety before proceeding. If you're willing to experiment a bit, the following are general guidelines to point you in the right direction.&nbsp; Some customers and Oracle http://onlineappsdba.blogspot.com/2011/03/cloning-sso-enabled-environments-in-e.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-4112231087407280111Tue, 08 Mar 2011 06:23:00 +00002011-03-08T11:53:55.692+05:30The Rapidclone utility does not support like for like cloning of an SSL enabled E-business suite middle tier. Note 230672.1 Cloning Oracle Applications Release 11i with Rapid Clone Note 406982.1 Cloning Oracle Applications Release 12 with Rapid Clone The problem can be broken down into 3 issues 1:- File system changes. The location of the SSL files on the clone is different to that from the http://onlineappsdba.blogspot.com/2011/03/is-it-possible-to-clone-ssl-enabled-e.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-8799161023449640097Tue, 08 Mar 2011 06:16:00 +00002011-03-08T11:46:57.792+05:301:- Is it recommended to implement a shared APPL_TOP? Both single APPL_TOP and shared APPL_TOP are supported. Full details of the requirement can be found in Note.233428.1 Sharing the Application Tier File System in Oracle Applications Release 11i Note.384248.1 Sharing The Application Tier File System in Oracle E-Business Suite Release 12 There is no official Oracle support document that http://onlineappsdba.blogspot.com/2011/03/should-i-implement-shared-appl-top-and.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-7270922147783084373Tue, 08 Mar 2011 06:07:00 +00002011-03-08T11:37:31.368+05:30 To gather statistics for Oracle Applications Ebusiness Suite 11i or R12 modules you should use the concurrent programs 'Gather Schema Statistics', 'Gather Table Statistics', or run 'FND_STATS'. In order to run the programs 'Gather Schema Statistics', 'Gather Table Statistics', or run 'FND_STATS'&nbsp; for a custom schema, the schema must be registered with the Application. To register an http://onlineappsdba.blogspot.com/2011/03/how-to-gather-statistics-on-custom.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-8375505843731986706Fri, 18 Jun 2010 15:44:00 +00002010-06-20T13:24:35.087+05:30Follow the instructions below to compile your forms in Release 121:- Log into the forms tier.2:- Set the applications environment3:- Ensure that the $FORMS_PATH includes $AU_TOP/resource and $AU_TOP/resource/stub, for example echo $FORMS_PATH /u01/oracle/TEST/apps/apps_st/appl/au/12.0.0/resource:/u01/oracle/TEST/apps/apps_st/appl/au/12.0.0/resource/stub 4:- Compile the forma:- If you are using http://onlineappsdba.blogspot.com/2010/06/compile-forms-in-release-12.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-8993227364023481416Fri, 18 Jun 2010 15:19:00 +00002010-06-18T20:50:41.309+05:30E-Business suites (EBS) 11i and R12 both support the sharing of the Applications Tier File System. Sharing a file system in EBS involves sharing a volume between 2 or more physical servers. In a shared Application Tier File System (ATFS) implementation, the application services can be configured to run (utilize CPU and memory) on any server sharing the ATFS simply by changing some context file http://onlineappsdba.blogspot.com/2010/06/shared-application-file-system-in-r12.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-3421181933127427318Sun, 01 Feb 2009 19:44:00 +00002009-02-02T01:14:06.055+05:30Misc&nbsp; Oracle E-Business Management&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Foglight helps organizations achieve application service levels and improve Oracle E-Business application performance. &nbsp; http://www.quest.com/application-and-service-management-technology/oracle-e-business.aspx http://onlineappsdba.blogspot.com/2009/02/quest-foglight-oracle-e-business.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-2530211955893761647Sun, 01 Feb 2009 19:35:00 +00002009-02-02T01:05:54.667+05:30&nbsp; Check this out ! &nbsp; http://www.linxcel.co.uk/software_symantec_I3oracleapp.html http://onlineappsdba.blogspot.com/2009/02/symantec-i3-for-oracle-applications.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-3501783884662950522Sun, 01 Feb 2009 19:31:00 +00002010-06-14T21:46:17.088+05:3011i / R12&nbsp; Here we are going to create a schema similar to the APPS schema but has only read-only prviliges. Steps: 1. Create the user for the required schema: SQL&gt; connect system/manager SQL&gt; create user &lt;your_user&gt; identified by &lt;your_user_password&gt; default tablespace &lt;tablespace_to_assign_to_user&gt; temporary tablespace temp; 2. Grant connect and resource privileges to http://onlineappsdba.blogspot.com/2009/02/steps-to-create-read-only-apps-schema.html1noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-2202733378517732010Sun, 01 Feb 2009 19:25:00 +00002009-02-02T00:55:16.622+05:30Misc&nbsp; Upgrade your Oracle Applications Certifications &nbsp; http://onlineappsdba.blogspot.com/2009/02/now-live-r12-install-patch-and-maintain.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-1092448198917948700Sun, 01 Feb 2009 19:16:00 +00002009-02-02T00:48:39.696+05:30Misc&nbsp; XClone is the world's first completely automated solution for cloning Oracle databases, applications and and middleware solutions. &nbsp; &nbsp; &nbsp; http://www.babboo.com/ http://onlineappsdba.blogspot.com/2009/02/xclone-automated-solution-for-cloning.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-4329750301023751140Tue, 26 Aug 2008 14:27:00 +00002008-08-26T19:57:33.172+05:30&nbsp; A concurrent request has a life cycle consisting of the following phases: pending, running, completed, and inactive. During each phase, a concurrent request has a specific condition or status. The below table lists each phase/status combination and describes its meaning in relation to a request. &nbsp; Concurrent Request Phase and Status Phase Status Description PENDING http://onlineappsdba.blogspot.com/2008/08/concurrent-request-phase-and-status.html0noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-5764980917434333508Sat, 19 Jul 2008 06:16:00 +00002008-07-19T11:46:28.809+05:30 &nbsp; Customer wishing to implement load balancing should focus their attention firstly on the following note depending on their version of E-Business Suite: R11i Note 217368.1 Advanced Configurations and Topologies for Enterprise Deployments of E-Business Suite 11i See Option 2.2. HTTP Layer Hardware Load Balancing R12 Note 380489.1 Using Load-Balancers with Oracle E-Business Suite http://onlineappsdba.blogspot.com/2008/07/implementing-load-balancing-on-apps.html1noreply@blogger.com (Famy Rasheed)tag:blogger.com,1999:blog-2411185029102809641.post-250087848988985093Sat, 28 Jun 2008 15:46:00 +00002008-06-28T21:16:57.557+05:30&nbsp; Sizing an UNDO tablespace requires three pieces of data. (Note:Overall consideration for peak/heavy vs normal system activity should be taken into account when peforming the calculations.) (UR) UNDO_RETENTION in seconds (UPS) Number of undo data blocks generated per second (DBS) Overhead varies based on extent and file size (db_block_size) UndoSpace = [UR * (UPS * DBS)] + (DBS * 24) http://onlineappsdba.blogspot.com/2008/06/size-undo-tablespace-for-automatic-undo.html1noreply@blogger.com (Famy Rasheed)