Hi everyone,

I'm new to this oracle database, and i have a question. first I'm sorry if my question is misplaced.

My company recently implemented a new ERP system, but unfortunately the ERP system doesn't have a financial module on it. so we planned to buy an oracle financial. and we will install the oracle financial database on our ERP system database

And the problem is we don't know yet is it will be a matter, if we have two different oracle database in one server.

FYI : my ERP system using oracle 11g and the oracle financial is using oracle database too

Thanks

Re: Two Database oracle in one server 80 80

Yes, it can be.

Re: Two Database oracle in one server 80 80

Yes, it can be.

oh hi debasisdas,
thanks for the reply. i will try to install it then

Re: Two Database oracle in one server 80 80

you need not instal two oracle servers.

Just need to create two separate schemas.

Up -- it will be easy to manage the application data and DB server for space management and other related issues.
Down -- if the DB or DB server is down both the applications will starve.

Re: Two Database oracle in one server 80 80
Member Avatar

I'm NOT a DBA, but...
What debasisdas said is (also) what I would recommend.
It would be MUCH easier to communicate between schemas,
than it would be to communicate between databases.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.