Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

listener sid redirect

hermannkSep 13 2005 — edited Sep 22 2005

I desire to have only one database intance running on Win2003 server.
However the software (IBM ICM) wants to have two separate databases
It refers to the DBS by jdbc lite using SID to connect

Is there a way in the listener config to accept a SID of say "ICMXXXX" but force the traffic to SID "ICM"

The only way I have seen the listener config working is when a connection is made via the service name instead of sid. In this case I could have two global service names mapped to the same sid in the listener.

As this soft is packaged by IBM and is using jdbc lite which requires SID and not global name I can not use the above.

Any other tricks?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 20 2005

Added on Sep 13 2005

#general-database-discussions

4 comments

2,496 views