Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Snowy on May 12 at 4:34 PM Hi,
you should not use "oracle" as the oracle username. it should be ora[sid] as per SAP's standards.
I am not saying this is impossible, but it is not recommended.
also, use 1 ORACLE_HOME for every database you use.
this way, you wil lbe able to upgrade Oracle 1 SID at a time... and even run multiple Oracle versions at the same time (but 1 per SID).
thanks
| | | ---------------Original Message---------------
From: Carol Perkins
Sent: Monday, May 11, 2015 3:13 PM
Subject: How can the same username "oracle" be used for 4 databases?
Dear SAP Basis,
For Oracle 12c, how can the "oracle" user use these environmental files for 4 different database instances on one server? Two of the variables defined in these files are ORACLE_SID and ORACLE_HOME. For each of the databases instances, these 2 variables differ.
.dbenv.csh
.dbenv.sh
.dbenv_`hostname`.csh
.dbenv_`hostname`.sh
.j2eeenv.csh
.j2eeenv.sh
.j2eeenv_`hostname`.csh
.j2eeenv_`hostname`.sh
.sapenv.csh
.sapenv.sh
.sapenv_`hostname`.csh
.sapenv_`hostname`.sh
.sapsrc.csh
.sapsrc.sh
.sapsrc_`hostname`.csh
.sapsrc_`hostname`.sh
Please advise.
Thanks and regards,
Carol Perkins
SAP ECC6
Oracle 10.2.0.5 upgrading to Oracle 12.1.0.2 |
| Reply to this email to post your response. __.____._ |   _.____.__ |
