http://onlineAppsDBA.com

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

 

Hi 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

 

Hi 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

 

Hi 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

 

Hi 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

 

Thanks, Atul.

Harshita.

 

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

 

Hi 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

 

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

 

Yes 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

 

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

 

please tell me how to migrate from 9205 database to 10202

 

Check this at DB upgrade guide

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14238/toc.htm

 

These comments have been invaluable to me as is this whole site. I thank you for your comment.

 

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

 

Kindly raise this in forum at http://teachMeOracle.com/forum