Re: clean install of oracle apps (ebs) 11i (11.5.10.2)
Date: Fri, 14 Mar 2008 16:00:45 -0700 (PDT)
Message-ID: <ecaaf381-8189-42e7-b13c-472bd18709f6@s8g2000prg.googlegroups.com>
On Mar 12, 3:31 am, batman <uspen..._at_gmail.com> wrote:
> we are doing a clean install of 11.5.10.2 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
> is
> 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
ad_bugs
where
bug_number = '&bug_no'
and exists (
select null from ad_bugs where bug_number = '&bug_no')union all
select
'NO' applied
from
dual
where
not exists (
select null from ad_bugs where bug_number = '&bug_no');
regards
Niall Received on Fri Mar 14 2008 - 18:00:45 CDT