Home » RDBMS Server » Server Administration » CREATING TWO OR MORE ORACLE UNIX IDs IN ONE MACHINE
CREATING TWO OR MORE ORACLE UNIX IDs IN ONE MACHINE [message #58591] Fri, 19 September 2003 12:33 Go to next message
randy
Messages: 25
Registered: November 2000
Junior Member
Hi Gurus,

The Oracle DB for Unix creates a single oracle unix id which can manage multiple databases and versions in a single machine. Is there a way where we can create say two DBs using 8i and 9i and be able to have two oracle unix IDs. The oracle unix IDs should be exclusive to its own DB. Can this be done?

Report message to a moderator

Re: CREATING TWO OR MORE ORACLE UNIX IDs IN ONE MACHINE [message #58592 is a reply to message #58591] Fri, 19 September 2003 15:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
can be,though not recomended in a long run.

Report message to a moderator

Re: CREATING TWO OR MORE ORACLE UNIX IDs IN ONE MACHINE [message #58593 is a reply to message #58591] Fri, 19 September 2003 15:28 Go to previous messageGo to next message
Kartik Nair
Messages: 15
Registered: August 2003
Junior Member
Create 2 different accounts for 8i and 9i respectively.

eg: oracle8:oinstall for Oracle 8i &
oracle9:oinstall for Oracle9i

The ORACLE_HOME, ORACLE_BASE, ORACLE_SID, TNS_ADMIN values in the .profile should be set accordingly for each of the user.

Hope this helps.

Report message to a moderator

Re: CREATING TWO OR MORE ORACLE UNIX IDs IN ONE MACHINE [message #58594 is a reply to message #58591] Sat, 20 September 2003 09:30 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Yes,but why ?

Randy,dont you think its much easier if you can have a single login that can manage multiple databases/versions ? The administration is much easier with a single Unix id.

Make use of oraenv and /var/opt/oracle/oratab to switch your environment depending on your version.

Thiru

Report message to a moderator

Previous Topic: Need your advices
Next Topic: difficulties of prototyping huge database applications
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 15:33:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.