Home » RDBMS Server » Server Administration » installing 2 databases on same machine
installing 2 databases on same machine [message #200452] Mon, 30 October 2006 23:59 Go to next message
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
Re: installing 2 databases on same machine [message #200454 is a reply to message #200452] Tue, 31 October 2006 00:12 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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?
Re: installing 2 databases on same machine [message #200458 is a reply to message #200455] Tue, 31 October 2006 00:21 Go to previous messageGo to next message
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.
Re: installing 2 databases on same machine [message #200462 is a reply to message #200452] Tue, 31 October 2006 00:39 Go to previous messageGo to next message
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?
Re: installing 2 databases on same machine [message #200463 is a reply to message #200462] Tue, 31 October 2006 00:50 Go to previous messageGo to next message
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
Re: installing 2 databases on same machine [message #200468 is a reply to message #200452] Tue, 31 October 2006 01:05 Go to previous messageGo to next message
khushi2006
Messages: 13
Registered: October 2006
Junior Member
Thanks for your help.
Regards,
Khushi
Re: installing 2 databases on same machine [message #200469 is a reply to message #200468] Tue, 31 October 2006 01:06 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You're Welcome.

i hope you will solve ur problem.
Previous Topic: Table Space
Next Topic: unable to connect to second database on same machine
Goto Forum:
  


Current Time: Sat Dec 10 13:02:41 CST 2016

Total time taken to generate the page: 0.04053 seconds