Re: Oracle Financials

You're right, I completely forgot to mention the version. The databases where I think it might be running are 9i. I'll check for those schema names. Thanks to everyone for your help. That's what I love about oracle-l.

On Wed, Dec 16, 2020 at 12:39 PM John Piwowar <jpiwowar_at_gmail.com> wrote:

> Check in with your network security team and ask them which servers have
> ignore rules for alerts on criminally old/unsupported Oracle client and
> middleware installations. ;-)
> </tongue_in_cheek>
>
> You don't mention which version you're running, so this is kind of
> high-level suggestion.
>
> If you have a database that you know/suspect contains Oracle
> EBS/Financials data, look for a schema called APPLSYS (or APPS, but the
> first is more distinctive). If things aren't terribly broken, then the
> related application server hostnames should be listed in the FND_NODES
> table.
>
> If you're really flying blind, you can look for running application
> processes with names containing FND, XDO, WF (case-insensitive search).
> Also for "application servers" running a TNS listener without a database
> on-board (not a 100% guarantee, but it's a tell).
>
> For a general overview of the sort of stuff that runs on the applications
> tier, you can also check out the docs
> <https://docs.oracle.com/cd/E26401_01/nav/technology.htm>, specifically
> the "Oracle E-Business Suite System Administration" section. That's for
> the 12.2 release, but you should be able to find similar docs for older
> releases. I assume you're already perfectly capable of looking for docs, so
> I'm offering this up as a convenience, not as "RTFM snark." :)
>
> On Wed, Dec 16, 2020 at 11:04 AM Sandra Becker <sbecker6925_at_gmail.com>
> wrote:
>
>> I've been tasked with finding all the servers where Oracle Financials is
>> installed/running. The former DBA left no information at all about it and
>> I've never worked with Oracle apps before. What command(s) can I use to
>> see if it's running or installed? Appreciate any help you can provide.
>>
>> Thank you
>>
>> --
>> Sandy B.
>>
>>

-- 
Sandy B.

--
http://www.freelists.org/webpage/oracle-l