Re: clean install of oracle apps (ebs) 11i (22.214.171.124)
Date: Fri, 14 Mar 2008 16:00:45 -0700 (PDT)
On Mar 12, 3:31 am, batman <uspen..._at_gmail.com> wrote:
> we are doing a clean install of 126.96.36.199 on a win 2003 server.
> it is a a multi-tier installation with a single DB node and a single
> apps/etc node.
> all pre-reqs check out ok and the installlation goes smoothly and all
> post install checks are ok too. postinstall, however, we have gotten
> mixed opinions about installing patches. when we look into one patch
> it asks for a prereq of a different one and the cycle seems to go on
> forever. the only modules we need is HR and financials. the install
> a fresh download that only about 3 weeks old. does anyboy have a list
> of specific patches (including pre-reqs), if any, we need to download
> to be up to date and stable. we are primarilly a microsoft shop and
> definetly a bit spoiled with the single click updates to all our
> microsoft software without any user interaction.
Welcome to the wonderful world of apps, and ERP in general.
We use the script below to check whether pre-reqs are applied, but yes it isn't for nothing that there are courses on applying patches for apps - and that other ERP makers release patches daily as well.
set verify off
ACCEPT bug_no PROMPT 'Enter Bug Number: ' select
'YES on '||to_char(CREATION_DATE,'dd-Mon-yyyy') applied from
bug_number = '&bug_no'
and exists (
select null from ad_bugs where bug_number = '&bug_no')union all
not exists (
select null from ad_bugs where bug_number = '&bug_no');
Niall Received on Fri Mar 14 2008 - 18:00:45 CDT