Sunday, August 17, 2008

Steven Chan's "Identity Crisis: Are Patches to EBS 11.5.9 Equivalent to 11.5.10?"

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 release_name from fnd_product_groups.

#2. The patch readme is the ultimate source of truth to know if the patch can be applied for 11.5.9 instance. Lets take up an example of applying ATG Rup 4.

Pre-requisite section of Read me for 11i.ATG_PF.H.RUP4 (4676589) points out this very clearly.

==Clip==
==End clip==

So, for Apps DBAs source of truth should be patch readme and I guess there is no Identity crisis out there.

Enjoy !!

Thursday, August 14, 2008

vi for Apps DBAs (2)

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 educate yourself. Happy blogging. !!

Following are great blogs I came across.

Steven Chan's - I like the controlled words and constant updates he provides.
Ask Tom - How many hours in a day he has got ? :) I admire the time he spends in answering questions.
Krishna Kumar's (Thought Clusters) - he articulates very well.


This August 15th, I would like to post Part 2 of vi for Apps DBAs.

How to copy multiple text strings located at different places in a file and paste em whenever you want and retain the selection till the time you quit the file ?

Interesting ? Read on...

Assume you have "Tom" located at line 1 and "Jerry" located at line 10.

Go to line 1: "ayy
Go to line 10 :"byy

Lines 1 and 10 are retained in the buffer a and b till the time you quit the file or over write the buffer with the new text. Now it is very simple to get Tom and Jerry whenever you need :).

To get "Tom" : "ap
To get "Jerry" : "bp

Thats all Folks !! :)

Tuesday, August 12, 2008

EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet

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 is running currently on the port 4890.

$ telnet testsrvoms.msudhan.com 4890
Trying xx.xx.xx.xx...
Connected to testsrvoms.msudhan.com.
Escape character is '^]'.
^]

--

$ emctl secure agent agent
Oracle Enterprise Manager 10g Release 10.2.0.2.0.
Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
Agent successfully stopped... Done.
Securing agent... Started.
Requesting an HTTPS Upload URL from the OMS... Done.
Requesting an Oracle Wallet and Agent Key from the OMS... Done.
Check if HTTPS Upload URL is accessible from the agent... Done.
Configuring Agent for HTTPS in CENTRAL_AGENT mode... Done.
EMD_URL set in /agent10g/agent10g/sysman/config/emd.properties
Securing agent... Successful.
Agent successfully restarted... Done.


--





Wednesday, May 28, 2008

ORA-12547 while creating ASM instance using DBCA in 10gR2

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 and

cd $ORACLE_HOME/bin
relink all

and restart the DBCA. It should go through