R12: Where is my Context XML file?

Hi Everyone!!

Here is the main change in R12. Context File is no more in $APPL_TOP/admin directory!!!Appltop context file has been moved to $INST_TOP/appl/admin directory.

Experienced Apps DBA's usually changes context files manually rather changing by OAM.Oralce Strongly suggest to use OAM to modify the context file. I worked recently with 11i to R12 upgraded environment, where actual context file was present in $INST_TOP/appl/admin and old copy was present in $APPL_TOP/admin, one of my 11i experienced colleague modified $APPL_TOP/admin context_file and ran autoconfig accidentally which made big mess. It led to rework and another downtime in Alpha environment.

11i Apps DBA's who are moving to R12 have to remember this. Irrespective of 11i or R12, I would suggest to use 'vi $CONTEXT_FILE' after making the copy of the context file by 'cp $CONTEXT_FILE_bkp_date'. Otherwise use OAM!!

you can get the context_file paths from FND_OAM_CONTEXT_FILES


SQL> desc fnd_oam_context_files;
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME NOT NULL VARCHAR2(512)
VERSION NOT NULL VARCHAR2(30)
PATH NOT NULL VARCHAR2(1024)
LAST_SYNCHRONIZED NOT NULL DATE
TEXT NOT NULL CLOB
LAST_UPDATE_DATE NOT NULL DATE
LAST_UPDATED_BY NOT NULL NUMBER(15)
CREATION_DATE NOT NULL DATE
CREATED_BY NOT NULL NUMBER(15)
LAST_UPDATE_LOGIN NOT NULL NUMBER(15)
NODE_NAME NOT NULL VARCHAR2(30)
STATUS VARCHAR2(1)
SERIAL_NUMBER NUMBER
EDIT_COMMENTS VARCHAR2(2000)
CTX_TYPE NOT NULL VARCHAR2(1)

SQL>


See you all in the next technical article.

Happy Learning!!

14 comments:

Farooq said...

Hi Suresh,

I read your Blog on R12 excellent Stuff you have put ,
i am Working Appsdba and am going to Install R12 ,so i was looking for the scripts for
shutting down Application and Database Tier thanks for you Knowledge sharing
i got more than what am looking for ,My comapny having similar
Architicture you have but little bit less
webserver and formserver Load balance and Conc manager as well
with Rac on 3 nodes

thanks once again ,i will check your blog now frequently for updates
Excellent knowledge and Expeericne you have in Apps.

Bye.
Farooq

Suresh Lakshmanan said...

Hi Farooq,

Thanks for your encouraging comments.

Thanks
Suresh

Anonymous said...

Hi Suresh,
I too found your article very helpful
Thanks and Regards,
Cheers ..
Momin Owais Ahmed :-))

Kaberi from Mitre said...

Suresh,

Saw your postings on web and they are very helpful.

I wanted to find out from you if R12 Vision can be installed on Red-Hat Linux with Split Configuration meaning during installation is it possible to install the database on a 64-bit Red-Hat Linux OS and the R12 Application software on Red-Hat Linux 32 bit OS?



If you know the answer please let me know. Basically we have our Linux database servers running 64-bit Red-Hat Linux and all Application servers are running on 32-bit Red-Hat Linux and was wondering if we can keep the same strategy for R12 Apps Vision install.

Also the database version that comes bundle with R12 Vision CD’s for 32-bit Linux OS also have 32-bit DB versions of 10.2.0.3, correct?

Thanks and I appreciate your help.

Kaberi.
Oracle Apps DBA.

Suresh Lakshmanan said...

Hi Nayak,

Thanks for your encouraging comment.

The way it worked in 11i will work for R12 too. You have to have 64 bit downloaded software for db tier and 32 bit software downloaded for apps tier. split confiig note for r12 456197.1.
oaig.pdf says base techstack comes with R12 is 10.2.0.2(10g R2). Not sure the latest one which comes with oracle apps R12. I am downloading latest R12+ doc set. Hopefully I can answer 10gR12 or 10gR3 comes along with r12 fresh install.
Make sure the platforms you are going to use is in certified. If not clear check with oracle support whether it got certified.

Hope this helps you.

Thanks
Suresh

Xiteez vyas said...

I want to know on which platform does R12 works?
and what is the minimum configuration required to install the clientside applications?
waiting for your useful comments..........! -:)

Suresh Lakshmanan said...

Hi Xiteez,

Answers inline.

Xiteez>> I want to know on which platform does R12 works?

* Linux x86
* Linux x86-64
* HP-UX Itanium
* HP-UX PA-RISC
* IBM AIX based Systems
* Sun SPARC Solaris

More details can be found at certify tab in metalink. select the ebusiness suite product.

Suresh>>

Client needs only browser. certified browsers list can be found at 389422.1. It contains more information about j2se versions etc. in short IE/Firefox/Safari browsers work.

Thanks for the comment.

Suresh

Karuna said...

Hi Suresh,

Could please answer below question, I saw similar question some other person asked on your blog, but no answer, If you know the answer could you please shed some light on this.I really appreciate you taking time to answer this in advance.

In the 11i scenario the following setups were done in the jserv.properties file -

wrapper.classpath=/oracle/rapid/RI11510_CU2/iAS/Apache/Jserv/libexec/ApacheJServ.jar
....many such entries for various jar files
wrapper.bin.parameters=-Djava.protocol.handler.pkgs=HTTPClient
....

Where are these parameters set in R12 ? I am specifically looking for the above parameters.

Thanks in advance.
--
Thanks
Karuna

Suresh Lakshmanan said...

--over mail --

Hi Karunakar,

http://applicationsdba.blogspot.com/2008/07/r12-cdata-in-context-xml-file.html

that will help you.

Just to remind - Always configuration should be in context XML rather than updating the end config file.
you would need to touch orion config files.

Suresh

Karunakar Thoom said...

Thank you Suresh, that helped me a lot, I have open a SR to get an answer and still they have not answered, but I found your site on the net and it was very useful and informative. I really appreciate your help.

And also I really appreciate for your time and patience in answering my email and sharing the knowledge with the world.

God bless you.

Thanks
Karunakar

shiva said...

Excellent article... It really helped in finding xml file in R12

shiva said...

Your blog on R12 is really interesting and informative.

It really helped me in finding the xml file location in R12..

Good job dude.

chennupati veeraiah chowdary said...

Hi suresh,
you are posting all valuble information.It's help me alot.
keep on post valuble and useful stuff
thanks
veera

Rajendra Kumar said...

hai suresh this is rajendra from hyderabad thanks for helping it is good for knowing about oracle apps
thanks a lot
Rajedra Kumar S