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]
Sent: 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

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.

Visit us at http://www.cognizant.com
Oracle LazyDBA home page