OraFAQ Forum: Server Administration » multiple db at a time

Home » RDBMS Server » Server Administration » multiple db at a time

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

multiple db at a time [message #57497]

Thu, 19 June 2003 06:54

jack
Messages: 123
Registered: September 2000

Senior Member

hi can i work on multiple databases at a time on one machine/one software where multiple databases r created.

Report message to a moderator

Re: multiple db at a time [message #57498 is a reply to message #57497]

Thu, 19 June 2003 07:13

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

yes.
you have multiples databases in multiple homeS.
HAVE ONE AS PRIMARY.
add entries to listener.ora in primary home.
add tnsentries in the tnsnames.ora to connect to the other databaes.
else
the pain will be different listener for different database.

----------------------------------------------------------------------

if u dont wnat to use tnsentries,
every time u login
set ur ORACLE_SID, ORACLE_HOME and login to the conecerned database

Report message to a moderator

Previous Topic:	CHECKPOINT IS NOT ACCURE
Next Topic:	Dropping table causes oracle to stop / restart gives error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:26:35 CDT 2024