Home » RDBMS Server » Server Administration » How to run the Single Server Multiple instance and Multiple database?
How to run the Single Server Multiple instance and Multiple database? [message #194505] Fri, 22 September 2006 07:38 Go to next message
goudelly
Messages: 52
Registered: August 2006
Location: India
Member
Dear Gurus,


In a single server how to run thr multiple oracle instances and multiple database.

Thanks,

Mohan Reddy

Report message to a moderator

Re: How to run the Single Server Multiple instance and Multiple database? [message #194530 is a reply to message #194505] Fri, 22 September 2006 09:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Multiple databases in a single machine, yes. You can, as long as you have enough resources. Just create more databases using dbca/command line options.
Multiple instances of the same database, NO. You can have multiple instances of the same database across multiple nodes and it is called as RAC (real application clusters).
But for fun and learning, yes, you can build a rac on laptop
http://www.dizwell.com/prod/node/24

[Updated on: Fri, 22 September 2006 09:11]

Report message to a moderator

Re: How to run the Single Server Multiple instance and Multiple database? [message #194532 is a reply to message #194505] Fri, 22 September 2006 09:12 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
You can just use CREATE DATABASE command to create many database under your same oracle installaion.
Only thing is it all wil have diferent pfile,controlfile etc..
Also add all database names to your /etc/oratab file in unix env.
Before connecting you say DB1,you have to set $ORACLE_SID=DB1,once this value point to correct database,you can use sqlplus to work on that database.

Report message to a moderator

Re: How to run the Single Server Multiple instance and Multiple database? [message #194550 is a reply to message #194532] Fri, 22 September 2006 10:59 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> Before connecting you say DB1,you have to set $ORACLE_SID=DB1
Not essential.
You can use tnsentries.
sqlplus scott/tiger@db1
sqlplus scott/tiger@db2
...

Report message to a moderator

Previous Topic: db_domain
Next Topic: db links,procedures,functions,views,synoyms
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:19:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.