2 databases but one oracle home

[yls177]

is it possible to have 2 databases that shared one oracle home?

so in this case, only the oracle binaries are the same whereas the rest of the files are different?

[ales]

Yes, it is.
Set a new ORACLE_SID, create a new parameter file, create database, adjust listener.ora and so on.
Change ORACLE_SID to switch databases.

[hacketta1]

Yes, this is very much possible. The Oracle binaries are shared but each database will have their own set of datafiles, controlfiles, passwords files, init.ora files etc.

You can create subdirectories for instance specific files

e.g:

/u01/oradata/DB01

/u01/oradata/DB02

Do some reading on the Oracle Optimal Flexible Architecture (OFA) here . This provides a standard for easily implementing multiple instances on a single machine/oracle home.

[yls177]

the port number in listener for these 2 sids can be either the same and not, right?

[marist89]

yes

[yls177]

what i understand is that if 2 sids share a given port number, then they will have to contest for the right to communicate.

so its of advantage to have 2 different ports for 2 different sids , hence exclusive rights to a port number?

[pando]

if I were thinking like you I would have had to install 100 ORACLE_HOMEs LOL

[davey23uk]

dont forget the 100 different listener ports