Madhu Thatamsetty

Oracle Enterprise Linux 5 Update 5 Installation on HP DV6 (I7 700 Series) Quad Core 8GB RAM panics with Kernel panic - not syncingSolution: At the boot prompt use "linux acpi=off" , this will help you overcome the above kernel panic error mentioned and puts one more in front.In the next screen, it will prompt you to select the media location. If you are installing using CD it will prompt Madhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com1

I was going through Steven Chan's "Identity Crisis: Are Patches to EBS 11.5.9 Equivalent to 11.5.10? - very well explained from Oracle and Support perspective for Apps customers, gave me a food for thought and hence this post of mine.From Apps DBA perspective, the way to resolve this confusion is to follow the simple checks.#1. Check the release name/Applications version using the sql .select Madhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com0

Happy Independence Day !! - August 15th 2008. Its been a year I started blogging. I started my first post with vi for Apps DBAs on Aug 15th 2007. It was a great experience being part of the online community. I admire and I'm inspired by seeing the time and efforts put in by the fellow bloggers in the world to share their experiences. No wonder blogging is a great platform to convey, express and Madhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com0

I ran into an issue where agent was not uploading the xmls to the OMS server. emctl upload fails with the error "EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet..."To resolve the issue try the following. Check if the host is able to communicate with the OMS by using telnet as mentioned below. If you punch in "^]" escape sequence, you will receive Apache version that OMS isMadhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com0

ORA-12547 - TNS Lost Contact while creating ASM instance using DBCA.Cause: Seems like Oracle Binaries were not relinked properly.[oracle@testsrv01 ~]$ ldd `which oracle`lddlibc4: cannot read header from `/oracle01/oracle/product/10.2.0/db_1/bin/oracle'[oracle@testsrv01 ~]$Fix: shutdown the listener and kill any stale processes referring to the executable of your ORACLE_HOME andcd $ORACLE_HOME/Madhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com0

This is a common problem after the upgrade. One important point to remember is to disable all the schedules for dbms jobs before kicking off the upgrade and enable the schedule after the uprade is over. Alternatively job_queue_processes parameter can be set to '0'.You see following symptoms in the alert log.-- Clip --Active call for process 21244 user 'oracle' program 'oracle@hostname (J000)'Madhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com1

I was all set to write a shell script that will parse the patch log file and arrive at top time consuming sqls that will help me know the time taken by the sqls for the upgrades. After constantly watching the Maintenance Pack ( 3480000 ) session for 30+ hours. The following lines of the autopatch session caught my attention.-- Clip --sqlplus -s APPS/***** @/xxxx/xxxx/xxxxappl/ad/11.5.0/admin/sql/Madhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com2

Does this Note:265048.1 sound familiar ? At least I can't forget this Note#. I can tell this Note# even if someone wakes me up in the middle of the night. This is because I have spent so much of time and iterations doing Service Contracts Rule Migration before 11.5.10.2 upgrade to cut down the time the Maintenace Pack (Patch# 3480000) takes. Coming to the technical aspect of this Note#, Madhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com0

I thought i'll add in more details to the post "DBUA FAILS WITH unable to extend rollback segment ODMA_RBS01".Just changing the entry " InNewTablespace name="ODMA_RBS" size="50" unit="MB"" in $ORACLE_HOME/assistants/dbma/mep.cfg is not sufficient. There are couple of more tags that you need to play with in mep.cfg. Refer to "CreateRollbackSegmentsODMA_RBS01" revert="true" " section in the Madhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com0

Any simple problem after the upgrade that is not resolved will have long term maintenance related issues in production.It is very important to watch the alert log while applying Oracle Applications patch as it gives wealth of information. As a matter of practice I watch the alert log while applying a patch and noticed that Invalid's Compilation stage of adpatch performed by "adpcpcmp.pls" was Madhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com5

--Clip--BEGIN2 dbms_prvtaqis.upgrade_rulesub_msgs;3 END;4 /BEGIN*ERROR at line 1:ORA-01562: failed to extend rollback segment number 12ORA-01650: unable to extend rollback segment ODMA_RBS01 by 384 in tablespace ODMA_RBSORA-06512: at "SYS.DBMS_PRVTAQIS", line 3507ORA-06512: at "SYS.DBMS_PRVTAQIS", line 3515ORA-06512: at line 2--End Clip--If the Oracle Applications used database is having Madhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com0

SYMPTOM:sqlplus "/ as sysdba" @adgrants.sqlSQL*Plus: Release 9.2.0.8.0 - Production on Sun Nov 18 16:14:16 2007Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Connected to:Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.8.0 - ProductionO/S Message: No such file or directorySQL*PLUS Madhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com0

I would like to publish this blog post in the form of a set of questions and answers that will help you resolve a situation if "Ready" state messages in WF_DEFERRED queue are in few millions and Workflow Deferred Agent listener is down from years which caused the pile up of records in WF_DEFERRED Queue.Q1. How do I find out in first place WF_DEFERRED Queue is having millions of records inMadhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com9

Workflow Background Process concurrent request fails with the following error message when the request is submitted with Order Management Item type.Symptom:ORA-00600: internal error code, arguments: [4414], [12226], [1], [12226], [1], [], [],ORA-01403: no data foundWorkflow Background Process concurrent request is a Workflow Background Engine. Workflow Backedground Process concurrent request Madhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com2

Symptom:If the existing .pls in your environment has the following version & you have just upgraded to Oracle Apps 11.5.10.2, then read further.$ strings -a ./patch/115/sql/csiviiws.pls | grep -i HeaderREM $Header: csiviiws.pls 115.4.1159.2 2006/03/10 10:04:55 abhgupta ship $/* $Header: csiviiws.pls 115.4.1159.2 2006/03/10 10:04:55 abhgupta ship $ */procedure construct_inst_header_rec(p_inst_id Madhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com2

10 Tips for protecting your 'APPS' password - is a very nice post by Oracle Corp - Mike Shaw. Out of the 10 tips in the post by M.Shaw, #7 & #10 are my favourites.#7. Ensure no processes are running with APPS username/password in command line - This is very important as Apps DBAs are always tempted to use sqlplus apps/apps-password at unix command prompt. Any other users who are not supposed to Madhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com4

I intend to start of my first Blog with "vi for DBAs". I used to receive queries ( not sql queries :) ) from fellow DBAs on how to search and replace in "vi". A collection of complex (which I think are) search and replace commands of vi that I came across are summarized below. These commands are useful for DBAs in their day-to-day Administration. #1. Once upon a time a user sent Madhu Sudhanhttp://www.blogger.com/profile/11947987602520523332noreply@blogger.com6