Sunday, March 16, 2008

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)


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 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
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

Monday, March 03, 2008

Soft-skills (not oracle related post)

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

Wednesday, February 13, 2008

Add new node to apps 2

Please read before reading the steps below,

After finishing configuring the clone instance by running I had to run the script according to note 464018.1.
While running 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 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 from his post I took a backup the ad_timestamps and then truncate it after that I run 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 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.


Tuesday, February 12, 2008

Sharing is Caring 4

Oracle Community
it the new site for oracle social networking, make oracle community even smaller.


Monday, February 04, 2008

Add new node to apps

A customer want to add new web/forms node to his current multi-node apps production system also we have to configure a web cache load balancer.
The current system is 2 nodes (db node, apps tire node).
I am currently doing the configuration on test environment, I followed note (
How to Add a New Node to The Application Tier, and Make It a Web Server Node Only, Note: 464018.1 same as instructions of "Part 4: Adding a new node to an existing system" under "Section 4: Advanced Cloning Options" of Note 230672.1"Cloning Oracle Applications Release 11iwith Rapid Clone".

I am currently cloning the apps tire to the new server after that I will run then in order to configure it. One important note is to disable SQL*Net Access so that the new node can access the database.
after that i will try to configure the webcache as load balancer.
I will update you once done.


Friday, February 01, 2008

Questions needed answers

Dears apps dbas,
I hope thing are well with you, I received the following questions from a friend of mine and I promised him to answer them and wanted to share them with you maybe you can help me answer most of them.
Appreciate your help.

(we have some of the answers by dave (thank you) in the comments and all of them under

1. How do we know that particular instance is cloned or normal installed?
2. How can you know that how many modules are already implemented in this instance?
3. How to enable archive log without shutting down your database?
4. How can we know that whether we already applied latest AUTOCONFIG patch or not at our instance?
5. Is this possible to clone a database from hotbackup? If yes plz tell how?
6. Suppose your database size is 2000GB now you want to clone a particular one datafile or tablespace. Plz tell how co clone a datafile or tablespace?
7. You are applying a patch but suddenly it HANGS but log file didn’t showing any error what should be the reason for that HANG?
8. How to clone from multimode to single node?
9. How to apply patch on forms/reports server?

Thanks again for help

Thursday, January 10, 2008

I have been tagged

Gareth Roberts tagged me in the current round of OraBlog tag, you can check the rules.

Below are the 8 things you might not know about me:

1- Athens, Greece, Masters: I am currently doing my masters in managing business innovation and technology thurogh a scholarship here in Athens, Greece.
2- Having to change your job is a good thing: I started my oracle career after I had to change my previous job (well my old manager claims that my work was done there and the project i was working on was over, actually it turns out to be a good thing after that I changed my career path from Microsoft to Oracle)
3- Travel: I like to travel a lot and I am welling to take any chance to visit any new country/places.
4- Documentary: I am a T.V documentary addict; I can watch any type of documentary but prefer political ones.
5- Jogging: I jog 3-4 KM every other day I like jogging a lot.
6- Single: well still I am currently single. (Marry to oracle apps I guess ;-).
7- Reading: currently I am trying to get used to reading I have this book called (the management bible by John Wiley and sons) it’s a good book I guess every manager should read it, although I am not a manager yet but be prepared always. You never now what will happen next.
8- Sky is the limit and think big: Sky is the limit is my personal message at MSN messenger, and think big will be my next personal message at MSN.

My turn in tagging, I will tag.
OCP Advisor
Syed Jaffar Hussain
Lutz hartmann
Mark Rittman
Grant Ronald
Senthil Rajendran
Vikram Das
Famy Rasheed

have a nice tagging


Tuesday, January 08, 2008

Hail the Champions

I participate recently in a post from our famous Bolger OCP advisor, it a nice blog that help apps community with info. About Apps certification.
I am trying to be active again.
You can check his post here.

Good luck with your certification