Actually starting in Oracle8i as long as a listener is running on port 1521
over TCP, PMON will automatically registier the $ORACLE_SID with the
listener.

-----Original Message-----
From: Siddegowda, Kempe Gowda (Cognizant)
[mailto:[Email Address Removed] Friday, August 29, 2003 12:27 AM
To: LazyDBA.com Discussion
Subject: RE: Same Port number for 2 database


U can have same listener for two or more database but u need to add entry
for service handler in the exisitng listener and bounce

Thanks and Regards

GowdA....
CTS - CSI
Vnet -- 42275
P & T -- 2275

"Our life is what our thoughts made it"



-----Original Message-----
From: Ajay Arora [mailto:[Email Address Removed] Friday, August 29, 2003 1:58 AM
To: LazyDBA.com Discussion
Subject: Same Port number for 2 database


Greetings,
I have production database running on AIX box. I installed a new Test
instance on same box. I am sharing same oracle home and oracle base. Does it
mean that I am having common listener. Also, both prod and test databases
are on same port 1521. Does it matters? If yes can we change it?

Thanks

Ajay

_________________________________________________________________
Are you a geek? Are you a techno freak? http://www.msn.co.in/Computing/
Welcome home!


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete the material from any
computer.
Oracle LazyDBA home page