-
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/[email protected]
and other users to:
sqlplus user1/[email protected]
Has anybody ever done this before? Any suggestions?
-
you have to specify tow alias in your tnsnames , in the second alias have to specify the parameter SERVER=DEDICATED
-
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=DEDICATE D)))
Thanks!