OOW 2009 1st report

It’s all about innovation that what Larry Ellison/Oracle and Scott McNealy/Sun said at the opening key note. I arrived to san Francisco for oow 2009 and I have to admit it’s a butifaul place. The organization of the oow is more than perfect so far. I did my registration online at moscone center and even thought there were thousands doing registration at the same time the registration process did not take more that 5 min. it was all online and automated. Meeting some of oracle team/employees was they were very friendly and helpful. Attending the unconffrance session was very good experience I attended Michael taylor session (Hyperion 11.1.1.3 on Linux Live Demo) and Fundamentals of Performance (Oracle ACE Director Cary Millsap). Attending ahmed al-omari session was a very good experience to me it was a Q&A session which was very helpful really. Also tom kyte session was great too I cannot put every thing in one post but more to come soon I will post some video and pictures I took from the event here soon If anyone who is reading this blog at the conference it’s a great chance to meet please drop me a line.

The Unconference sessions

the games area were people can have some fun

more to come soon.

fadi

OOW 2009

Preparation been made this year for Oracle open world conference 2009. The conference will take place in San Francisco between 11-15 Oct. there is a high chance that I will attend this conference. I will post here again once confirmed so we can meet there if any one is planning to attend. I will use this chance of attending to back to blogging again as its been a while since I last update my blog.
For more information about OOW 2009 please check http://www.oracle.com/openworld/index.html
Fadi

Oracle Buys Sun Microsystems‏

Today I received an email from my friend mohammad muhtadi telling me that Oracle Corporation the largest enterprise software company acquired Sun Microsystems and thought of sharing that with you.
http://www.sun.com/aboutsun/media/presskits/2009-0420/index.jsp
http://www.oracle.com/sun/index.html
http://www.bloomberg.com/apps/news?pid=20601087&sid=a38_8MJNSjR4&refer=home

It seems oracle now acquiring different type of business and this is a big step from Oracle

fadi

Cloning 11i with 10g database (you may need a patch)

I faced the following error while configuring database when cloning apps 11i with 10g database and it happens directly after entering the path of the third data_top (by the way the script will always assume you have 4 data_tops even if you have more/less data_tops)

StackTrace:
java.lang.NullPointerException
at oracle.apps.ad.context.CloneContext.createContextFileForDbhomes(CloneContext.java:2816)
at oracle.apps.ad.context.CloneContext.getInputFromUsers(CloneContext.java:1485)
at oracle.apps.ad.context.CloneContext.doClone(CloneContext.java:627)
at oracle.apps.ad.context.CloneContext.main(CloneContext.java:6085)

On metalink there was the solution on Note:427981.1 Subject:RC-50004 When Specifying DATA_TOPS While Cloning a 10.2 Database
And the solution is to apply a patch with a version of CloneContext.java above 115.203. the following are possibilities patches

Patch 5473292, Patch 5732291, Patch 5604818, Patch 5456078, Patch 5474116

Well I did not do that because this means that I have to apply the patch and recopy the database, which take time.
So I recreate the database manually using control file. And when try to open the database I issued
SQL>alter database open resetlogs;
It failed with the following
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/ora_dev/data/system01.dbf'
Even though the database was completely down when I copied it I faced this error the good thing is 2 days ago I was reading bas post http://basklaassen.blogspot.com/2008/01/recover-database.html
I followed the steps for recovery and provided the path to my online log files and the recovery completed successfully.
Next down time for the production database for sure I will apply one of the patches above.

Hope that helped
Fadi

Soft-skills (not oracle related post)

Dears,
As a part of my study in my masters program we have to create a blog related to e-business course and it must be evaluated and one of the evaluation criteria is the number of users accessing it and comments so if you have free time can you access it and leave comments the blog has a good and helpful information.
the blog talks about soft skills and how they are important in our life check for example (speed reading post and managing a busy schedule post and many others)
please check and leave comments if you can
Thank you
Fadi

Add new node to apps 2

Please read http://oracle-magic.blogspot.com/2008/02/add-new-node-to-apps.html before reading the steps below,

After finishing configuring the clone instance by running adcfgclone.pl I had to run the adaddnode.pl script according to note 464018.1.
While running adaddnode.pl I faced the following error
ERROR at line 1:
ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated
ORA-06512: at line 16

I followed note 394615.1 to solve it and after I did the steps in the note I run adaddnode.pl again and I faced error related to AD_TIMESTAMPS_U1 I checked on metalink but I could not find anything then I search on google and found post by dave http://newappsdba.blogspot.com/2006/09/dont-hit-ctrl-c-while-running.html from his post I took a backup the ad_timestamps and then truncate it after that I run adaddnode.pl and it completed successfully.
Then I updated the xml file to have only the forms and web servers running on this new node following the same note 464018.1 I run autoconfig the start the service on both nodes a now able to access both nodes.

What I want to do now is to configure web cache as load balancer also I want to implement Step 2.4.1.2. Implement Forms Listener Servlet Support from note (Advanced Configurations and Topologies for Enterprise Deployments of E-Business Suite 11i) Note:217368.1 in order to have Forms Server Load Balancing, so when one form server go down in one node users will be connect to the other forms node.Because the current configuration if I am connect to webnode1 and forms on that node is down I will not be able to connect to forms and I will receive an error but if load balancing is implemented it will take me to the other working forms server node.


Fadi

Sharing is Caring 4

Oracle Community
it the new site for oracle social networking, http://www.oraclecommunity.net/to make oracle community even smaller.

enjoy
Fadi