Re: creating another database on the same box ?

From: sybrandb <sybrandb_at_gmail.com>
Date: 20 Jul 2006 03:27:45 -0700
Message-ID: <1153391265.914456.74550@p79g2000cwp.googlegroups.com>

newhorizon wrote:
> My question is a general one most probably a simple one also.
>
> I am using oracle 10G and I have one oracle home on the box.
> I have created another database with dbca. Right now I have two
> database with different control files and datafiles etc.. I have had
> problems creating the listener for the second database.
> Do I need another listener for that database or should I add another
> service for the new database on the current listener.
>
> Right now I can start,stop,connect with sqlplus on the box just
> changing the ORACLE_SID but for OEM I can only connect to one of the
> databases.

You don't need another listener. You should add the database to your current listener using the net configuration assist. OEM will discover the database only when it's configured in a listener.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Thu Jul 20 2006 - 05:27:45 CDT