Leave a Comment:
28 comments
atul before going to advanced apps dba,
can u tell about Workflow
I Appreciate your feedback & I’ll take next few topics on workflow with Apps 11i before moving to Advanced DBA topics .
I’ll happy if you put your name (Though you can still write as anonymous if you wish )
Atul
ReplyHi Atul,
This is a good blog !!
I am having similar ones I started recently
http://blogs.oracle.com/spadhye
mainly for Apps DBAs
I would like your comments on : http://blogs.oracle.com/spadhye/2006/07/17#a17
cheers
Sandeep
Sandeep,
Thanks for informing about your blog but its not updated regularly.
Atul
ReplyHi Atul,
I really enjoy your blog and like to read more about apps dba. I have one suggestion which i think might be helpful. It seems like you are touching too many topics and it might be harder for u to keep updated, so i would suggest to start with one topic and finish it to the end and take on next topic. For example, if u start load balancer finish it and may be move to concurrent manager.
thanks
sudip
Sudip ,
Thanks a lot for your feedback.
I can understand that you want to read from start till end about a topic but sometime its boring for me as well for readers too much on same topic .
I have noticed that I loose interest if I write continuously on single topic for 3-4 days.
I tried experimenting writing on same topic CPU patches on 9 & 10th Oct.
So what I have done is listed related topic in order in left menu bar .
Keep posting feedback & comments to improve this blog .
Atul
ReplyHi Guys,
Talking about Workflows, have you implemented IMAP4?
We have recently upgraded 11.5.7 to 11.5.10.2 on 10g (OS redhat).
Incase you have implemented IMAP4, please do let me know about your experiences.
Regards,
Harshita.
Harshita,
I think IMAP4 is requirement for Workflow Notification Mailer .
Are you looking for implementation Doc or Just Experience of implementing it .
Atul
ReplyHi Atul,
Thanks for your quick response.
I want to know your exp. I have the implementation docs.Just want to foresee the problems faced and the solutions.
Regards,
Harshita.
No Harshita, No issues as long as you follow documentation proprly.
Atul
ReplyHI Atul
Have you done a 9i to 10g RAC database upgrade for a E Business suite before? (any 11.5.10).
If so could you please tell me if yu have noticed any performance issues?? Request you to pls share if any to ramana.gh@gmail.com and thanks once again for your great efforts in sharing your knowledge with others through your sites and blogs.
Best Regards
Ramana
Hi Ramana,
I have done it with 10g Application Server but not with Apps. In 10g AS I don’t see any issues but yeah RAC in apps is not certified on OCFS , its only certified on ASM
Hi Atul,
We are in the process of upgrading Apps11i database from 9.2.0.6 to 10gR2. I have two questions:
1. What is ASM? is it mandatory configuring ASM while upgrading to 10GR2
2. How to upgrade database using exp/imp method with out disturbing the existing database? Which method is good for upgrade?
reg
sweta
Sweta
ASM is Automatic Storage Management feature in database . To know more about ASM check http://www.oracle.com/technology/products/database/asm/index.html
2. Upgrade database using exp/imp trust me I never saw anyone upgrading via Imp/Exp , What you can do is install 10gR2 software & then Install separate database & exp from 9i & imp to 10g r2 complete database .
Better would be install 10gR2 software & then upgrade.
I don’t understand why you want to use exp/imp & why you don’t want to disturb existing database .
ReplyHi Atul,
Could you give me document number “Oracle Database Upgrade Guide 10g Release 2 (10.2).” this was reffered in latest document 362203.1 (i.e., Interoperability Notes).
I need to upgrade 9.2.0.5 to 10g(10.2.0.2).
Thanks in advance,
Suresh.
Suresh ,
Upgarde guide is mentioned in next post http://becomeappsdba.blogspot.com/2006/08/upgrade-oracle-apps-11i-with-database.html
and location is
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14238/preup.htm#i1007718
ReplyHi Atul,
I have upgraded my database to 10g, during implemented autoconfig, I have generated appsutil.zip file and copied to Oracle home and unzipped, and generated context file,ran autoconfig. Question is, do I have to apply any latest autoconfig patch to get it work for 10g?, adchknls.pl script is looking for $ORACLE_HOME/nls/data/9idata directory, which doesn’t exist any more, hence autoconfig is failing, and clone can not be done.
Thanks in advance,
Suresh.
Hi Atul,
Could you help finding a syntax that is used to expire a db user password after N number of days also, not re-using old password.
Also for password changing intervels.
Thanks in advance,
Suresh.
For any apps quesries/questions / doubts raise them in forum at http://teachMeOracle.com/forum
ReplyHi Atul,,
Can u please tell me how to migrate the 9.2.0.5 database to 10.2.0.2..(its not APPS)
though it is not the apps…
its urgent can u please help me..
Thanks in advance…
ReplyCheck this at DB upgrade guide
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14238/toc.htm
ReplyThese comments have been invaluable to me as is this whole site. I thank you for your comment.
Reply<<< I have upgraded my database to 10g, during implemented autoconfig, I have generated appsutil.zip file and copied to Oracle home and unzipped, and generated context file,ran autoconfig. Question is, do I have to apply any latest autoconfig patch to get it work for 10g?, adchknls.pl script is looking for $ORACLE_HOME/nls/data/9idata directory, which doesn't exist any more, hence autoconfig is failing, and clone can not be done.
Thanks in advance,
Suresh.>>>
Were you able to fix the above said problem…if so, can you please share your fix. I have the problem..
ReplyHi
We are going for 10R2 with Non RAC and 11.5.10.2
oracle Application.
Please let me know which are post checks
after upgrade to oracle 10GR2.
My concern are as below
Perofmance issue
standard functionalities
custom reports
AP module
How it will impact on above point as i mention.
Thanks
Raags (raghavendra.rao73@yahoo.com)