Member Avatar for rizkiapriansyah

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

  • 3 Contributors
  • 4 Replies
  • 202 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by hfx642
Member Avatar for debasisdas

Yes, it can be.

Member Avatar for rizkiapriansyah

Yes, it can be.

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

Member Avatar for debasisdas

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.

Member Avatar for hfx642

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.