Home » RDBMS Server » Server Administration » Creating Second Database and viewing through EM.
Creating Second Database and viewing through EM. [message #183094] Wed, 19 July 2006 06:07 Go to next message
bmsharma
Messages: 24
Registered: April 2006
Location: Surat
Junior Member
Hi All

I am having oracle 10G rel 2(Non RAC) running on Linux As 3. Already one database as DB01 is running on it. Now i wants to install second database as db02 on it through DBCA. My querries are:

1. Is there any neeed to create separate home & Base directories for the second database?

2. Through enterprise manage how can i see the db02 database. I mean how to switch between the two diffrent databases. As Enterprise Manager does not give the option to select the other database.

Kindly Reply

Regards
Bally

Report message to a moderator

Re: Creating Second Database and viewing through EM. [message #183104 is a reply to message #183094] Wed, 19 July 2006 06:37 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No need a new ORACLE_HOME.
all you need is a new ORACLE_SID.
set your tnsnames.ora to talk to both the databases.
In OEM browse databases based on tnsnames (or you can detect the other instance? I have not worked with the newer versions of OEM)

Report message to a moderator

Previous Topic: How to retrieve the dropped table
Next Topic: print database object
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:48:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.