OraFAQ Forum: Server Administration » installing 2 databases on same machine

Home » RDBMS Server » Server Administration » installing 2 databases on same machine

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

installing 2 databases on same machine [message #200452]

Mon, 30 October 2006 23:59

khushi2006
Messages: 13
Registered: October 2006

Junior Member

Hi

I wish to install another database (version 9.2) on same machine as the first one. what steps are required for this(setting variables etc/path)? Under what circumstances would it conflict with the first database? Also, can 2 databases be opened simultaneaously or only 1?? Please help.

Khushi

Report message to a moderator

Re: installing 2 databases on same machine [message #200454 is a reply to message #200452]

Tue, 31 October 2006 00:12

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi

I am not clear what ru what to achieve.

1. You want to Install More than one Oracle Software
like Oracle 9i , 10g, 8i on One Machine

Answer > Yes.

Every Oracle Software Create seprate Ora-home.
For use some utilities ( like Imp etc) you have to set path variable for specific version.

2. You want to Create More than One Database on One Machine.

Answer > Yes.

Through DBCA ( Database Configuration Assistant)
start>run>dbca

You can Open more than one database sometime but you have to First set Oracle_Sid enviourment variable. like
cmd>set oracle_sid=db_name ( which one want to operate)

hope this Helps

[Updated on: Tue, 31 October 2006 00:13]

Report message to a moderator

Re: installing 2 databases on same machine [message #200455 is a reply to message #200452]

Tue, 31 October 2006 00:16

khushi2006
Messages: 13
Registered: October 2006

Junior Member

yes, i already have a database installed on my machine and wish to install another. But i want both of these databases to be active so that i can communicate using database links. How can i achieve that?

Report message to a moderator

Re: installing 2 databases on same machine [message #200458 is a reply to message #200455]

Tue, 31 October 2006 00:21

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

First You can use DBCA for Database creation.

then create DB link to communicate with each other.

Suppose I have two database like
1.db01
2.db02
i want to connect db02 through db01
i will create db link between two database.

like

create database link "dblink_name"
  2  connect to "user_name"
  3  identified by "pwd"
  4  using 'DB_name'

Note : For more info google Documentation.

and also you connect without specify oracle_sid.
like

1.
cmd>sqlplus/nolog
cmd>conn scott/tiger@db01

2.
cmd>sqlplus/nolog
cmd>conn scott/tiger@db02

hope this helps.

Report message to a moderator

Re: installing 2 databases on same machine [message #200462 is a reply to message #200452]

Tue, 31 October 2006 00:39

khushi2006
Messages: 13
Registered: October 2006

Junior Member

what if i want one database as the target database and the other to store recovery catalog for backup/recovery operations(cold/hot) ?? would it work when both databases need to be opened?? what setting would oracle_sid hold then?

Report message to a moderator

Re: installing 2 databases on same machine [message #200463 is a reply to message #200462]

Tue, 31 October 2006 00:50

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

1.i want one database as the target database
Ok
2.the other to store recovery catalog for backup/recovery operations(cold/hot) ??
Ok
3.would it work when both databases need to be opened??
Yes , above both database work sometime. ( open )
4.what setting would oracle_sid hold then?

For Target Database 
cmd>sqlplus "scott/tiger@target_db"

For Recovery Catalog.
cmd>rman
The following example uses Oracle Net password file authentication for the target database, which requires that the target database be using a password file, that defines the password for user SYS to be 'oracle'. Oracle Net authentication is also used for the recovery catalog.

% rman
RMAN> CONNECT TARGET SYS/oracle@trgt 
RMAN> CONNECT CATALOG rman/cat@catdb

http://download-west.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmcnctg002.htm#sthref444

hope this helps

Report message to a moderator