Oracle Database Discussions

Hi, we intend to set up 3 seperate 10g R2 environments, Dev, Test and Prod that are independant of each other.

Dev has been installed, database instance created etc and works fine with EM on listener port 1521.

I want to setup the test environment so have installed 10gR2 in a new home and have created the database instance with DBCA. The url for EM is created a different port (5500).

When I go to the test environment EM it shows the same listener as for the dev environment (LISTENER on port 1521). So that each environment has it's own listener, how can I set this up ?

I think it might entail the listener.ora in ../network/admin and the SID_LIST=
which exists in the dev environment but nowhere else.

I have had a few attempts at using the Network Config Assistant (running it from the test environment) to create a new listener but cannot associate it with the test instance or the EM for test. It also seems to pick up the presence of the original listener on 1521 too.


Any suggestions on how to set this up ?

Thanks

Paul