OraFAQ Forum: Server Administration » how to install oracle 8i and 9i databases on same server

Home » RDBMS Server » Server Administration » how to install oracle 8i and 9i databases on same server (windows server 2000,2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to install oracle 8i and 9i databases on same server [message #495505]

Sun, 20 February 2011 02:47

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

how to install oracle 8i and 9i databases on same server for example i want that both type of databases run on same server if it possible then please guide me with some examples

regards

Faheem

Report message to a moderator

Re: how to install oracle 8i and 9i databases on same server [message #495506 is a reply to message #495505]

Sun, 20 February 2011 02:51

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is nothing special to do.
Just give a different home for each one.

Regards
Michel

[Updated on: Sun, 20 February 2011 02:51]

Report message to a moderator

Re: how to install oracle 8i and 9i databases on same server [message #495508 is a reply to message #495506]

Sun, 20 February 2011 03:16

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

when i install 9i to different home then how can we manage exp command to backup database and how can i instruct in tnsnames to connect both databases

Report message to a moderator

Re: how to install oracle 8i and 9i databases on same server [message #495512 is a reply to message #495508]

Sun, 20 February 2011 03:48

John Watson
Messages: 8966
Registered: January 2010
Location: Global Village

Senior Member

If I were you, I wouldn't worry about the TNS names configuration yet. Get your 8i snd 9i Oracle Homes installed and the two databases created: once that is done, you'll be in a better position to understand the netwrking.

And by the way, you said Quote:

how can we manage exp command to backup database

Never forget that an export is NOT a backup.

Report message to a moderator

Re: how to install oracle 8i and 9i databases on same server [message #495513 is a reply to message #495512]

Sun, 20 February 2011 04:04

jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai

Senior Member

As far as, Windows is concerned, if you are going to work on different Oracle Homes then you need to set them manually before invoking the utility.

Use the command:
set ORACLE_HOME=path of the Oracle Home
set PATH=%PATH%;%ORACLE_HOME%\bin

Report message to a moderator

Re: how to install oracle 8i and 9i databases on same server [message #495514 is a reply to message #495508]

Sun, 20 February 2011 04:11

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

qanita786 wrote on Sun, 20 February 2011 10:16

when i install 9i to different home then how can we manage exp command to backup database and how can i instruct in tnsnames to connect both databases

If you don't want to bother with SQL*Net setting use the following:

set ORACLE_HOME=<8i home>
set PATH=%ORACLE_HOME%\bin;%PATH%
set ORACLE_SID=<8i SID>
exp ...
set ORACLE_HOME=<9i home>
set PATH=%ORACLE_HOME%\bin;%PATH%
set ORACLE_SID=<9i SID>
exp ...

Regards
Michel

Report message to a moderator