Swastik Dey wrote:Each particular sid is mapped to a particular db instance, and accordingly you have to configure listeners in tnsnames.ora. For e.g. if you have a db instance running as orcl, you may configure a sid in tnsnames.ora as orcl, and if you have another db instance running as mydatabase, you need to configure a sid for this too.
Are you talking about the server side, or the client side?