tag:blogger.com,1999:blog-47521054611025212562012-02-16T03:52:56.684-08:00Welcome to home of Oracle Applications . Lets start the journey in Oracle Applications world!!Viresh Nighut - ORACLE APPS DBAhttp://www.blogger.com/profile/15481878648342718555noreply@blogger.comBlogger101100tag:blogger.com,1999:blog-4752105461102521256.post-92218069675014135362009-12-14T21:54:00.000-08:002009-12-14T21:54:04.293-08:00

Hello !! what to call the product next to 11.5.10(11i)? Many still using 12i. I was there with R12 product development where none using 12i internally. There was a name 11.5.10P for awhile(P for Plus 11.5.10+) then Dev, Unit test cycle of the product next to 11.5.10 named as R12. So keep always saying R12 not 12i .

Viresh Nighut - ORACLE APPS DBAhttp://www.blogger.com/profile/15481878648342718555noreply@blogger.com39tag:blogger.com,1999:blog-4752105461102521256.post-85022457195155473732009-12-14T13:13:00.000-08:002009-12-14T13:14:46.257-08:00

Recently 11i is certified with Database Vault. Nilesh explained the details in the blog http://blogs.oracle.com/schan/2008/02/07#a2375.Metalink note ID to integrate ebiz suite 11i with 10.2.0.3 is 428503.1.If you look at the note, you will see once you integrated Ebiz 11i with Database Vault, you will use Database Vault User account manager user or the user which has been granted DV_ACCTMGR Role

Viresh Nighut - ORACLE APPS DBAhttp://www.blogger.com/profile/15481878648342718555noreply@blogger.com0tag:blogger.com,1999:blog-4752105461102521256.post-78666845116485627662009-12-12T21:33:00.000-08:002009-12-12T22:28:39.563-08:00

Hi Everyone!!Here is good option of opmnctl utility you can use to find various good information like memory usage, start time, ports being used.By default, adopmnctl.sh status gives short status message[applmgrr12@champ scripts]$ ./adopmnctl.sh statusYou are running adopmnctl.sh version 120.4Checking status of OPMN managed processes...Processes in Instance: r12test_champ.champ.dunno.com---------

Viresh Nighut - ORACLE APPS DBAhttp://www.blogger.com/profile/15481878648342718555noreply@blogger.com0tag:blogger.com,1999:blog-4752105461102521256.post-85075141152608081402009-12-12T12:36:00.000-08:002009-12-12T12:48:18.819-08:00

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

Viresh Nighut - ORACLE APPS DBAhttp://www.blogger.com/profile/15481878648342718555noreply@blogger.com0tag:blogger.com,1999:blog-4752105461102521256.post-74271473904064069162009-12-05T07:05:00.000-08:002009-12-05T07:15:25.999-08:00

Order of Startup Shutdown————————————–As in Oracle Apps 11i order for startup isA) Start Database Tier Services–Start Database Listener–Start DatabaseThenB) Start Application/Middle Tier Services– adstrtal.shOrder for shutdown in Oracle Apps R12 isA) Stop Application/Middle Tier Services– adstpall.shThenB) Stop Database Tier Services–Stop Database–Stop Database ListenerDatabase Tier Scripts in

Viresh Nighut - ORACLE APPS DBAhttp://www.blogger.com/profile/15481878648342718555noreply@blogger.com0tag:blogger.com,1999:blog-4752105461102521256.post-13746306688835184462009-12-05T06:59:00.000-08:002009-12-05T07:03:31.616-08:00

We need to change apps password manually, if you forgot and can’t check it in wdbsvr.app at $IAS_ORACLE_HOME/Apache/modplsql/cfg .Please remember that the APPLSYS and APPS passwords alwayshave to be the same. Always change both at the same time. When changing thesepasswords, it is important to change the APPLSYS password first and the APPS later.please back up the FND_ORACLE_ID and FND_USER

Viresh Nighut - ORACLE APPS DBAhttp://www.blogger.com/profile/15481878648342718555noreply@blogger.com0tag:blogger.com,1999:blog-4752105461102521256.post-52349530414778743322009-01-08T05:10:00.000-08:002009-01-08T07:32:40.632-08:00

R12 :No hard coded password in R12 !!!It is long time I did not write any blog!! Coming back to R12 , I want you to introduce one feature of R12. In 11i and R12 we can say R12 very much advanced and much more secure . Below article will give small idea about these enhancements. I am going to handle small security aspect of 11i which is improved and modified in R12. In 11i you will

Viresh Nighut - ORACLE APPS DBAhttp://www.blogger.com/profile/15481878648342718555noreply@blogger.com0tag:blogger.com,1999:blog-4752105461102521256.post-48849408072724492932008-12-29T12:48:00.000-08:002008-12-29T12:53:05.027-08:00

If some one ask you what is difference between dbms_stats and fnd_stats what you will say. If some one ask what is better to use when you are working with 11i. Don’t worry go through the following article and get it cleared. Basically FND_STATS is specifically provided for 11i . As we will se DBMS_STATS is provided in database. Oracle recommends when you are working with 11i, you should use

Viresh Nighut - ORACLE APPS DBAhttp://www.blogger.com/profile/15481878648342718555noreply@blogger.com0tag:blogger.com,1999:blog-4752105461102521256.post-20595084093181656002008-12-28T12:11:00.000-08:002008-12-28T12:25:25.235-08:00

Hello Friends !I thought to enter bit more in depth of R12 techstack. I was talking about 10.1.2 AS and 10.1.3 AS oracle homes earlier. I have discussed why there are two Mid-Tier oracle homes in my earlier post 10g AS in R12 ebiz.In this post I will be covering OC4J. OC4J expands to Oracle Containers For Java. Originally based on the IronFlare Orion Application Server, has developed solely under

Viresh Nighut - ORACLE APPS DBAhttp://www.blogger.com/profile/15481878648342718555noreply@blogger.com0tag:blogger.com,1999:blog-4752105461102521256.post-5252798319775058202008-12-28T11:21:00.000-08:002008-12-28T12:10:53.881-08:00

R12: Where you can find XML file ?Hi Friends ,This is post for which removes mess between context file in R12 and 11i. Generally any apps dba worked on 11i will go blindly to the directory to $APPL_TOP/admin to get xml or context file. Many times people working on R12 make big problem while working.Experienced dba’s most of the time do the modification manually in context file. In case of 11i

Viresh Nighut - ORACLE APPS DBAhttp://www.blogger.com/profile/15481878648342718555noreply@blogger.com0