-
2 databases but one oracle home
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?
-
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.
Ales The whole difference between a little boy and an adult man is the price of toys
-
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.
-
the port number in listener for these 2 sids can be either the same and not, right?
-
-
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?
-
if I were thinking like you I would have had to install 100 ORACLE_HOMEs LOL
-
dont forget the 100 different listener ports
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|