First, if in tnsnames.ora file on the client alias group contains
srvr=dedicated or in sqlnet.ora there is a parameter server=dedicated (or
something like this) - you will have dedicated connection. Second if your
maximum number of shared servers in init.ora less then number of users
trying to
I'm fighting this same problem, but in reverse.
I'm trying to get all my folks using DEDICATED connections.
Simply put on my server the listener uses port 1521 for MTS/shared
connections. It uses port1529 for DEDICATED connections. The
TNSNAMES.ORA file on each client determines which port is