What is the most Oracle compatible open source DBMS? [closed]

Question

My organization is thinking on using an open source DBMS (free if possible, but not mandatory) for all new apps that we develop. Since we already have quite a few apps that connect to an oracle server, we would like to use a DBMS that is as compatible as possible with Oracle. So we can port the apps to oracle with the less work in the case we don't get the same performance or just don't like how it responds. Also, most of the developers have experience only with Oracle.

Which one would you recommend? We're trying to cut down costs.

Answer 1

Postgresql has always proven to be a good choice in my experience.

Read up on Oracle to Postgres conversion

There is also this page which offers links to more information and tools for migration.

Specifically the Porting from Oracle PL / SQL section of the PostgreSQL manual.

Answer 2

PostgreSQL is probably the only open source enterprise class DBMS and the syntax resembles more of PL/SQL than anything else.