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!

Difference between service name and sid

840710Jun 15 2011 — edited Jun 15 2011

Hi All,

1. I am not able to understand the difference between Service_name and SID.
2. And I have 3 different databases(like 9i,10g,11g) with 3 instances in each(total 6), Can I configure one listener for all the databases and instances, as I have found in some documents that we need to set SID's list in listener.ora file.

Please help me in this regard,

Thanks in advance

This post has been answered by PrafullaNath on Jun 15 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2011

Added on Jun 15 2011

#general-database-discussions

8 comments

26,448 views