Dedicated and MTS Connections

[marist89]

I want a database to accept both MTS and Dedicated Server connections. Users that I want to use MTS will go through one tnsnames.ora alias and those who use Dedicated Servers will use a different alias. For example, I want some users to:

sqlplus user1/pass1@mts.prod

and other users to:

sqlplus user1/pass1@dedicated.prod

Has anybody ever done this before? Any suggestions?

[aracnid]

you have to specify tow alias in your tnsnames , in the second alias have to specify the parameter SERVER=DEDICATED

[marist89]

Yes, Yes, Yes... That's it.

I changed the tnsnames.ora entry from:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521))(CONNECT_DATA=(SID=dev)))

to

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521))(CONNECT_DATA=(SID=dev)(SERVER=DEDICATED)))

Thanks!