RE: Informix and Oracle in the same shop

I've been watching this thread with some interest. Enough of the philosophical discussion on why you might place Informix and Oracle in the same shop. There are valid reasons you might do so. I just found this out the hard way. I'm a new DBA in an Informix shop. My boss just informed me that we will get Oracle as a part of a new project. The exact why(s) aren't really that important. What is important is that we will have Informix and Oracle on the same machine and that I will be the administrator for both.

Has anyone out there had experiences running Informix and Oracle on the same machine? What are the technical issues to address when doing so? Are there any shared memory issues? How do you handle continuous logging for both systems? What are the pitfalls to look out for? Should I be looking for a new job? :-)

James May
Database Administrator,
Agency for Health Care Administration, Florida voice 904.413.9072
email = mayj_at_fdhc.state.fl.us

}----------
}From: ic[SMTP:iac_at_frc.com]
}Sent: Monday, June 02, 1997 12:54 PM
}To: pablo_at_sgi.com
}Cc: informix-list_at_rmy.emory.edu
}Subject: Re: Informix and Oracle in the same shop
}
}Definitely have to agree with Pablo on this one.
}
}
}* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
}
}On 2 Jun 1997, Pablo Sanchez wrote:
}
}}
}} In article <01bc6e57$5fdd9ae0$618285ce_at_ian>, "Ian Sparkes"
 <sparkes_at_sprintmail.com> writes:
}} > I would also be interested in hearing why you feel Informix is a better
}} > choice for a large data warehouse.
}} >
}} > The major differentiation between Oracle and Informix is normally the
}} > available tools. Specifically, Informix has nothing like Designer/2000
 and
}} > having a powerful tool to manage schemas is real critical in a large
}} > warehouse.
}} >
}}
}} At the risk of sounding boring, I'd have to agree with Ian. If this
}} shop is already Oracle, why incur the cost of retooling people to
}} learn another RDBMS. I see Ian's point that for all intents and
}} purposes an RDBMS is an RDBMS is an RDBMS.
}} --
}} Pablo Sanchez | wk: 415.933.3812| pg: 800.930.5635 -or-
 pablo_p_at_pager.sgi.com
}}

 --------------+-----------------+--------------------------------------------