Applications DBA Arena

EBS on Exadata

2012-01-02T01:00:00.002+05:30

Hi Everyone,Wish you all very happy and prosperous new Year 2012.I am hoping to write few articles with respect to EBS 11i running on Exadata machine as I am currently on it.History on Exadata:In 2008 Oracle released HP Oracle Database Machine and ExadataStorage Servers especially for data warehousingIn 2009 Oracle released Sun Oracle Database Machine (ExadataVersion 2) for OLTP/DW/Mixed loadsIn

11gR2 Grid Infrastructure with lower version DB

2011-11-22T05:15:00.004+05:30

Hi Everyone!I had a situation where I need to have 11gR2 infrastructure Grid with lower version Database 10gr2. I was facing issues starting the database after 11gr2 grid install.Steps I have done before starting the DBx. Install Grid Infrasture 11.2.0.1x. Install 10.2.0.1x. Apply patch set on 10.2.0.1 to 10.2.0.3This was non-EBS instanceDB start up was giving the error[oracle@qlxd3cfp001 dbs]$

10g: Library Cache Pin - Revoke on DBMS_UTILITY

2011-11-01T12:30:00.005+05:30

Hi Everyone!!Recently there was a outage on one of the financials 11i production system for couple of hours. Applications support team received bunch of site scope alarms saying unable to do synthetic transactions on finprod which was running on 11i EBS with 10g DB. Production red team call got started, people tried to reproduce the issue, Login page didn't come up.Troubleshooting was attempted

R12: OAM stops working after SSL setup

2011-10-25T03:14:00.001+05:30

Hi Everyone,Wish you all a very Happy Diwali.In R12.0.4, OAM functions stopped working after enabling SSL.Observation showed that all the URL's repointed to https except OAM function, menus.They were still referencing http://hostname.domainname/OA_HTML/...This has been fixed by removing # for the context variable sslterminator.This is required change when using ssl terminator.R12 SSL Note:

DR Gap resolution on RAC with ASM

2011-10-07T23:27:00.006+05:30

Hi Everyone,Due to data center network issues, primary RAC nodes were disconnected from DR RAC for few days. Since no space to hold the archive logs generated, RMAN pushed older archive logs to tape.Once network issues have been resovled between the data center, DR was not catching up.Configuration had 5 primary RAC nodes and DR of 5 nodes. preferred apply node was set at node5 in dgmgrl broker

LSH: OC Global Meta-data Adapter

2011-07-31T13:28:00.006+05:30

Hi Everyone!!Integrating Oracle Life Sciences (LSH) with Oracle Clinical needs Adapter setup.As a part of it, OC Global meta-data job has be run in LSH. It failed due to the fact that OC security restricting the privileges on GET_MAX_JN_SN for LSH account.--excerpt of job log--Log for the job: Standard Execution SetupParameters:Remote Location: ..............OCPROD/OCPRODSubmission Type: ......

Oracle TMS 4.6.1 Upgrade

2011-07-31T13:01:00.015+05:30

Hi Everyone!!This article is on Oracle TMS (Treasures Management System) - a product part of Oracle Health Sciences.I have upgraded Oracle TMS from 4.5.2 to 4.6.1TMS 4.6.1 is compatible with OC 4.6. If you are upgrading Oracle Clinical to 4.6 from 4.5.x then you would require to upgrade TMS to 4.6.x. See the certification matrix in Health Sciences techstack metalink note - (Oracle Life Sciences

R12: FNDCPASS to AFPASSWD

2011-06-13T20:09:00.006+05:30

Hi Everyone!EBS passwords are changed by the utility called FNDCPASS. In R12.1.2 Oracle has come up with another Utility AFPASSWD for the same purposeAdvantage is that you can run AFPASSWD utility from DB tier or from Midtier where as FNDCPASS can only be run from midtier side.It prompts only the required passwords .AFPASSWD [-c APPSUSER[@TWO_TASK]] [-f FNDUSER]AFPASSWD [-c APPSUSER[@TWO_TASK]]

R12 DB - Deprecated cursor_sharing = similar

2011-06-09T01:38:00.005+05:30

Hi Everyone,In Database version 12 Oracle will deprecate the cursor_sharing = Similar due to issues that are occurring with it in 11g.In short,Use Adaptive cursor sharing that is the feature of 11g.cursor_sharing=EXACT or FORCE will still be availablecursor_sharing = SIMILAR is highly discouraged in 11gR2.More details are at 1169017.1What is the impact to EBS?No impact.EBS uses Cursor_sharing =

Oracle Clinical - PSUB part II

2011-06-04T05:36:00.006+05:30

Hi Everyone,In the last article I have given quick view about PSUB daemon. Part I URL for reviewhttp://applicationsdba.blogspot.com/2011/06/oracle-clinical-batch-execution-quick.htmlLet us look at the UNIX configurations required for PSUB.RSH ConfigurationMy Unix DB server name is clinprd and Oracle Clinical Database name is clindbclinprd - clindb$ cat /etc/hosts.equivoclinprd

Oracle Clinical Batch Execution - A quick view

2011-06-04T04:55:00.007+05:30

Hi All,Oracle Clinical has PSUB (Parameterized Submission) module which is the method to execute the batch jobs - similar to Concurrent Managers in Oracle E-Business Suite. Any Batch Validation jobs are run by PSUB.Module code is pretty old runs with 3GL - No active enhancement has been made for years. It used OS authentication for executing the jobs. It uses UNIX 'at' job mechanisms to run the

11g: Oracle Multimedia

2011-05-24T10:08:00.004+05:30

Hi Everyone!One of the database got recently upgraded from 9i to 11g.My L2 DBA was asking me the question media component is missing after 11g upgrade.dba_registry view was showing as below9i DB:SQL> select * from dba_registry where comp_name like '%edia%';ORDIMOracle interMedia9.2.0.8.0 VALID 16-NOV-2007 19:34:42SYS SYSIn 11g:SQL> select *

Oracle Life Sciences Hub 2.2

2011-05-20T01:59:00.005+05:30

Hi Everyone,Oracle has released Life sciences Data Hub (LSH) version 2.2 this week.LSH is data warehouse which integrates Clinical Data Management Systems(eg. Oracle Clinical), TMS(Oracle Treasures Management System), Clinical Trial Management Systems(e.g Oracle Siebel Clinical), Adverse Event Reporting Systems(eg. Oracle Argus Safety Systems, Oracle AERS) and non clinical systems say Financial(

R12: IP/Host name change

2011-04-10T11:13:00.001+05:30

Hi Everyone,One of the small client that I was supporting moved the service provider from comcast to Verizon recently. After the IP change of the server hosting R12 application, GUI was not coming up!!If you have configurations based on IP address you have to update the config files.DB Tier:followConsiderations when Changing the Database Server Name or IP [ID 734559.1]Preparing For Changing

11g: Active data guard - part I

2011-04-08T14:14:00.006+05:30

Hi Everyone!!11g has new features for Data guard. We have Active Data guard in 11g which brings wonderful reporting environment in the business world.Data guard can be kept in read only mode while it receives and applies the transaction from primary.Remember: If you are keeping the database in read only mode and you are applying the redo logs then you need to have separate licensing (for Active

R12: Conc Manger Status

2011-03-26T10:42:00.003+05:30

Hi Everyone!!Good to meet you all in this post.Here is the piece of code which DBA's can make use of in sql prompt to check the concurrent manager's statuses with out going to GUI.Run the Below Code in sqlplus as APPS account. (tested in R12.1)-- http://applicationsdba.blogspot.comset verify offset lines 256set trims ONset pages 60col concurrent_queue_id format 99999 heading "QUEUE Id"col

R12: INST_TOP on NAS

2011-02-16T09:03:00.004+05:30

Hi Everyone!!Its been very long time since I have blogged. Quite long vacation after tight schedule pushed me back on writing article on the blog. I tried my best to answer the queries of the users meanwhile with few day delay in response time.Before I move on I wish you all a happy year 2011. Quite late though.Back to track, One of the user asked the question 'can INST_TOP reside on NAS

Troubleshooting - Library Cache pin wait

2010-11-04T07:13:00.003+05:30

Hi Everyone!One of the interesting troubleshooting that I had recently.One of the developer reported that his query is running forever, never coming with result in production database.He reported page long query and indicated that one of the function in the query that is is causing the issue.First I have figured out the way to reproduce the issue with simple sql statement using the using the

Novice Apps DBA ?

2010-08-09T10:00:00.003+05:30

Hi Everyone,Its been a while since I have blogged. hope everyone is doing good out there.I got couple of mails saying, 'I am new to Apps DBA, can you send me some documentations'.When you work with any COTS (Commercial Off-The Shelf) product, right way to begin would be to see the vendor documentations. Oracle is no different, the nice thing about Oracle is they publish the documentations online

Oracle Golden Gate

2010-05-19T10:37:00.004+05:30

Hi Everyone!!Oracle has bought one of the fanciest replication software Golden Gate. Golden Gate is real time heterogeneous replication software.There are many replication products available in the market like shareplex, Data Mirror(called as Infospere Change Data Capture from IBM). The real beauty of this software is it supports replication between various databases like MS SQL Server, DB2,

Tracing ORA errors

2010-05-07T09:10:00.004+05:30

Hi Everyone,Today one of the developer came and asked me to find the sql which is causing the ORA error in his custom application. He was accessing the URL and he was getting 'ORA-00942' error in the screen.I have gone ahead and enabled system wide event the error ORA-00942.This statement will capture the 942 errors.SQL> alter system set events '942 trace name errorstack level 1';System

11g: Incident Service Packaging

2010-05-06T09:41:00.002+05:30

Hi Everyone!Another cool feature of 11g is Incident server packaging, called shortly IPS.This feature reduces the tremendous effort from DBA's to gather trace information for Oracle Support. This is another benefit that you can get from adrci utility. If you haven't seen my previous post on adrci you can view at http://applicationsdba.blogspot.com/2008/01/11g-rac-adrci.htmlLet us take an example

Monitoring CPU usage of multiple oracle databases running on Shared server

2010-03-02T15:14:00.002+05:30

Hi Everyone!!Here is interesting stuff on monitoring CPU usage of multiple oracle databases running on single unix box. I have seen many times CPU usage of the box crosses 90-95% and when the box hosts multiple databases it becomes cumbersome to troubleshoot the culprit. It will be easy to troubleshoot in case of dedicated database server.How to find which database is using much of the CPU?Here

Sitescope: Monitoring system

2010-01-21T16:32:00.004+05:30

Hi Everyone,Wish you all a Happy new year 2010.Today we will see monitoring tool that can be used for monitoring multi node oracle ebusiness suite, oracle Health sciences suite or any other application or server.When the application becomes multi node HA environment, manual monitoring becomes impossible with meager resources.With multiple monitoring systems available from different vendors in the

Configuring Discoverer SSL with Ebiz - Part III

2009-11-04T11:20:00.001+05:30

Hi Everyone, I give my sincere thanks to Author Sibusiso Maphalala, Oracle Apps DBA, South Africa for creating this fabulous article. n this article we will see configuring webcache, discovere,ebiz to make SSL work. This is in continuation of the article posted earlier in the blog http://applicationsdba.blogspot.com/2009/10/configuring-discoverer-ssl-with-ebiz.html - PART I http://

Configuring Discoverer SSL with Ebiz - Part II

2009-11-01T11:13:00.002+05:30