April 24, 2003
different OS level oracle user different oracle dba group. such as, you create different oracle user ora92, ora817, different dba gourp: dba92, dba817.
Option 2: One OS oracle user:
Different ORACLE_HOME. every time you need go to one environment, you need export ORACLE_HOME AND ORACLE_SID. But Oracle recommances to user different OraInventory directory.
We did install upto 4 Oracle_home at one server by two Oracle users. But got some problems about listener. All Oracle Environment looks for port 1521 for default listener, you have to set up some parameters manually.