Oninit cdi / Archive
Talk to an expert →

Informix and oracle in the same box

Posted in 2011

Summary

Frank asked whether installing Oracle 11gR2 alongside a busy IDS 11.50.FC8 instance on Red Hat Linux would cause conflicts, given Oracle would see little activity. Respondents said there are no inherent conflicts, but advised: use different TCP/IP ports for each listener, ensure enough memory for both and avoid overlapping/shared memory segment keys (capping Informix memory if needed), and watch CPU contention. Art Kagel added that Oracle is a resource hog and could degrade Informix performance. No problem report or further follow-up beyond this advice.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Installation, Setup & Upgrades

FRANK — — source: IIUG Forums & Mailing Lists

Hi, Guys, Because of the support requirement of one of our software , we are going to install Oracle in our current busy Informix box. The Oracle database will be used only for CM purpose ( so, not much daily activity at all). The question is, Are there any conflicts when we install and run both Informix and Oracle in the same box/host? Thanks, Frank --00151747b2865a9d8404ae2b9446

↪ replying to FRANK
FRANK — — source: IIUG Forums & Mailing Lists

Sorry, more info, DB: IDS 11.50 FC8 Oracle 11g Release 2 (11.2) OS: Redhat Linux 2.6 Thanks, Frank On Fri, Sep 30, 2011 at 1:01 PM, FRANK <yunyaoqu@gmail.com> wrote: > Hi, Guys, > > Because of the support requirement of one of our software , we are going > to install Oracle in our current busy Informix box. > The Oracle database will be used only for CM purpose ( so, not much daily > activity at all). > > The question is, Are there any conflicts when we install and run both > Informix and Oracle in the same box/host? > > Thanks, > Frank > > --00151747b2865a9d8404ae2b9446 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0015174733102d999104ae2ba45a

↪ replying to FRANK
Celso Cabral Coimbra — — source: IIUG Forums & Mailing Lists

Be carefull about the TCP/IP port, install each one using different ports. Celso Cabral Coimbra Administrador de Banco de Dados ClearTech Ltda "Trust at the heart of Communications" Tel. (11) 3576-4509 -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de FRANK Enviada em: sexta-feira, 30 de setembro de 2011 14:06 Para: ids@iiug.org Assunto: Re: Informix and oracle in the same box [25079] Sorry, more info, DB: IDS 11.50 FC8 Oracle 11g Release 2 (11.2) OS: Redhat Linux 2.6 Thanks, Frank On Fri, Sep 30, 2011 at 1:01 PM, FRANK <yunyaoqu@gmail.com> wrote: > Hi, Guys, > > Because of the support requirement of one of our software , we are going > to install Oracle in our current busy Informix box. > The Oracle database will be used only for CM purpose ( so, not much daily > activity at all). > > The question is, Are there any conflicts when we install and run both > Informix and Oracle in the same box/host? > > Thanks, > Frank > > --00151747b2865a9d8404ae2b9446 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0015174733102d999104ae2ba45a ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to FRANK
Alexandre Marini — — source: IIUG Forums & Mailing Lists

Hi Frank. There´s no problem, since you have enough memory available (remaining for Oracle, of course). You could limit Informix maximum memory, and map its maximum used area. Check for their documentation, and make sure both systems do not access the same memory areas. Regards. Em 30/09/2011 13:06, FRANK escreveu: > Sorry, more info, > > DB: > IDS 11.50 FC8 > Oracle 11g Release 2 (11.2) > > OS: > Redhat Linux 2.6 > > Thanks, > Frank > > On Fri, Sep 30, 2011 at 1:01 PM, FRANK<yunyaoqu@gmail.com> wrote: > >> Hi, Guys, >> >> Because of the support requirement of one of our software , we are going >> to install Oracle in our current busy Informix box. >> The Oracle database will be used only for CM purpose ( so, not much daily >> activity at all). >> >> The question is, Are there any conflicts when we install and run both >> Informix and Oracle in the same box/host? >> >> Thanks, >> Frank >> >> --00151747b2865a9d8404ae2b9446 >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > --0015174733102d999104ae2ba45a > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix <Cert-Info-Mgmt_color.jpg> IBM Certified System Administrator - Informix Dynamic Server V10 / V11 / V11.70 IBM Information Management Informix Technical Professional v3

↪ replying to Celso Cabral Coimbra
Alexandre Marini — — source: IIUG Forums & Mailing Lists

Good remembering, Celso! Except for this 2 recommendations, I don´t see any troubles (cpu of course will require attention). Em 30/09/2011 13:16, Celso Cabral Coimbra escreveu: > Be carefull about the TCP/IP port, install each one using different ports. > > Celso Cabral Coimbra > Administrador de Banco de Dados > ClearTech Ltda > "Trust at the heart of Communications" > Tel. (11) 3576-4509 > > -----Mensagem original----- > De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de FRANK > Enviada em: sexta-feira, 30 de setembro de 2011 14:06 > Para: ids@iiug.org > Assunto: Re: Informix and oracle in the same box [25079] > > Sorry, more info, > > DB: > IDS 11.50 FC8 > Oracle 11g Release 2 (11.2) > > OS: > Redhat Linux 2.6 > > Thanks, > Frank > > On Fri, Sep 30, 2011 at 1:01 PM, FRANK<yunyaoqu@gmail.com> wrote: > >> Hi, Guys, >> >> Because of the support requirement of one of our software , we are going >> to install Oracle in our current busy Informix box. >> The Oracle database will be used only for CM purpose ( so, not much daily >> activity at all). >> >> The question is, Are there any conflicts when we install and run both >> Informix and Oracle in the same box/host? >> >> Thanks, >> Frank >> >> --00151747b2865a9d8404ae2b9446 >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > --0015174733102d999104ae2ba45a > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix <Cert-Info-Mgmt_color.jpg> IBM Certified System Administrator - Informix Dynamic Server V10 / V11 / V11.70 IBM Information Management Informix Technical Professional v3

↪ replying to FRANK
rroussey@comcast.net — — source: IIUG Forums & Mailing Lists

Both will lock up segments of SHM even though Oracle won't be doing much work? Bob ----- Original Message ----- From: "FRANK" <yunyaoqu@gmail.com> To: ids@iiug.org Sent: Friday, September 30, 2011 1:06:12 PM Subject: Re: Informix and oracle in the same box [25079] Sorry, more info, DB: IDS 11.50 FC8 Oracle 11g Release 2 (11.2) OS: Redhat Linux 2.6 Thanks, Frank On Fri, Sep 30, 2011 at 1:01 PM, FRANK <yunyaoqu@gmail.com> wrote: > Hi, Guys, > > Because of the support requirement of one of our software , we are going > to install Oracle in our current busy Informix box. > The Oracle database will be used only for CM purpose ( so, not much daily > activity at all). > > The question is, Are there any conflicts when we install and run both > Informix and Oracle in the same box/host? > > Thanks, > Frank > > --00151747b2865a9d8404ae2b9446 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0015174733102d999104ae2ba45a ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to rroussey@comcast.net
Alexandre Marini — — source: IIUG Forums & Mailing Lists

Any database engine will require memory segments, I mean. Just make sure both will not share any of them, and you´ll be safe.... Em 30/09/2011 13:26, rroussey@comcast.net escreveu: > Both will lock up segments of SHM even though Oracle won't be doing much work? > > Bob > > ----- Original Message ----- > > From: "FRANK"<yunyaoqu@gmail.com> > To: ids@iiug.org > Sent: Friday, September 30, 2011 1:06:12 PM > Subject: Re: Informix and oracle in the same box [25079] > > Sorry, more info, > > DB: > IDS 11.50 FC8 > Oracle 11g Release 2 (11.2) > > OS: > Redhat Linux 2.6 > > Thanks, > Frank > > On Fri, Sep 30, 2011 at 1:01 PM, FRANK<yunyaoqu@gmail.com> wrote: > >> Hi, Guys, >> >> Because of the support requirement of one of our software , we are going >> to install Oracle in our current busy Informix box. >> The Oracle database will be used only for CM purpose ( so, not much daily >> activity at all). >> >> The question is, Are there any conflicts when we install and run both >> Informix and Oracle in the same box/host? >> >> Thanks, >> Frank >> >> --00151747b2865a9d8404ae2b9446 >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > --0015174733102d999104ae2ba45a > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix <Cert-Info-Mgmt_color.jpg> IBM Certified System Administrator - Informix Dynamic Server V10 / V11 / V11.70 IBM Information Management Informix Technical Professional v3

↪ replying to Alexandre Marini
FRANK — — source: IIUG Forums & Mailing Lists

Thanks Alex and Celso! We can control the ports assignment, no problem. Alex mentioned The two databases may access the same memory area? Mess up each other possibly? I assume the OS will take care of the memory boundary for each process, right or ....? Thanks, Frank On Fri, Sep 30, 2011 at 1:24 PM, Alexandre Marini <amarini@fazenda.ms.gov.br > wrote: > Good remembering, Celso! > Except for this 2 recommendations, I don´t see any troubles (cpu of > course will require attention). > > Em 30/09/2011 13:16, Celso Cabral Coimbra escreveu: > > Be carefull about the TCP/IP port, install each one using different > ports. > > > > Celso Cabral Coimbra > > Administrador de Banco de Dados > > ClearTech Ltda > > "Trust at the heart of Communications" > > Tel. (11) 3576-4509 > > > > -----Mensagem original----- > > De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de FRANK > > Enviada em: sexta-feira, 30 de setembro de 2011 14:06 > > Para: ids@iiug.org > > Assunto: Re: Informix and oracle in the same box [25079] > > > > Sorry, more info, > > > > DB: > > IDS 11.50 FC8 > > Oracle 11g Release 2 (11.2) > > > > OS: > > Redhat Linux 2.6 > > > > Thanks, > > Frank > > > > On Fri, Sep 30, 2011 at 1:01 PM, FRANK<yunyaoqu@gmail.com> wrote: > > > >> Hi, Guys, > >> > >> Because of the support requirement of one of our software , we are going > >> to install Oracle in our current busy Informix box. > >> The Oracle database will be used only for CM purpose ( so, not much > daily > >> activity at all). > >> > >> The question is, Are there any conflicts when we install and run both > >> Informix and Oracle in the same box/host? > >> > >> Thanks, > >> Frank > >> > >> --00151747b2865a9d8404ae2b9446 > >> > >> > >> > >> > > > > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. > >> > >> > > --0015174733102d999104ae2ba45a > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > > Alexandre Marini > > Tecnologia da Informação - DBA > > SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix > > <Cert-Info-Mgmt_color.jpg> > > IBM Certified System Administrator - Informix Dynamic Server V10 / V11 / > V11.70 > > IBM Information Management Informix Technical Professional v3 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00151744890497f8cd04ae2c1115

↪ replying to rroussey@comcast.net
FRANK — — source: IIUG Forums & Mailing Lists

Thanks Bob! On Fri, Sep 30, 2011 at 1:26 PM, rroussey@comcast.net <rroussey@comcast.net>wrote: > Both will lock up segments of SHM even though Oracle won't be doing much > work? > > Bob > > ----- Original Message ----- > > From: "FRANK" <yunyaoqu@gmail.com> > To: ids@iiug.org > Sent: Friday, September 30, 2011 1:06:12 PM > Subject: Re: Informix and oracle in the same box [25079] > > Sorry, more info, > > DB: > IDS 11.50 FC8 > Oracle 11g Release 2 (11.2) > > OS: > Redhat Linux 2.6 > > Thanks, > Frank > > On Fri, Sep 30, 2011 at 1:01 PM, FRANK <yunyaoqu@gmail.com> wrote: > > > Hi, Guys, > > > > Because of the support requirement of one of our software , we are going > > to install Oracle in our current busy Informix box. > > The Oracle database will be used only for CM purpose ( so, not much daily > > activity at all). > > > > The question is, Are there any conflicts when we install and run both > > Informix and Oracle in the same box/host? > > > > Thanks, > > Frank > > > > --00151747b2865a9d8404ae2b9446 > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --0015174733102d999104ae2ba45a > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517402694fb97ac04ae2c1ae9

↪ replying to FRANK
Art Kagel — — source: IIUG Forums & Mailing Lists

No direct conflicts, but be aware, Oracle is a resource hog! It may affect Informix server performance. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Sep 30, 2011 at 1:01 PM, FRANK <yunyaoqu@gmail.com> wrote: > Hi, Guys, > > Because of the support requirement of one of our software , we are going > to install Oracle in our current busy Informix box. > The Oracle database will be used only for CM purpose ( so, not much daily > activity at all). > > The question is, Are there any conflicts when we install and run both > Informix and Oracle in the same box/host? > > Thanks, > Frank > > --00151747b2865a9d8404ae2b9446 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --90e6ba21248532d53c04ae46cec8

↪ replying to Art Kagel
FRANK — — source: IIUG Forums & Mailing Lists

Thanks, Art!! Frank On Sat, Oct 1, 2011 at 9:30 PM, Art Kagel <art.kagel@gmail.com> wrote: > No direct conflicts, but be aware, Oracle is a resource hog! It may affect > Informix server performance. > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > do not reflect on my employer, Advanced DataTools, the IIUG, nor any other > organization with which I am associated either explicitly, implicitly, or > by > inference. Neither do those opinions reflect those of other individuals > affiliated with any entity with which I am affiliated nor those of the > entities themselves. > > On Fri, Sep 30, 2011 at 1:01 PM, FRANK <yunyaoqu@gmail.com> wrote: > > > Hi, Guys, > > > > Because of the support requirement of one of our software , we are going > > to install Oracle in our current busy Informix box. > > The Oracle database will be used only for CM purpose ( so, not much daily > > activity at all). > > > > The question is, Are there any conflicts when we install and run both > > Informix and Oracle in the same box/host? > > > > Thanks, > > Frank > > > > --00151747b2865a9d8404ae2b9446 > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --90e6ba21248532d53c04ae46cec8 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517448478ef0f5d04ae6c1cf4