Dedicated or Shared Server

[aarroyob]

Hi,

The database problem is Oracle 8.1.7.0.0 on Windows 2000. We have defined one dedicated listener and ten dispatchers.
When we connect to the database from slqplus for example, always it takes the dedicated server.

Does anybody know why?

Thanks in advance and best regards

Angel

[TimHall]

Do you have the following item in your TNSNames.ora entry?

(SERVER=dedicated)

http://download-west.oracle.com/otnd...mes.htm#448498

[jmodic]

Your deedicated connections are established through one port, and the shared connections through another one. Check your listener/database configuration for those port numbers. Then modify your tnsnames.ora to have one separate service name for dedicated and one for shered connections, each pointing to an appropriate port. Then you can choose which kind of connection you want to establish with your SQL*Plus.

[aarroyob]

No, I haven´t.

[aarroyob]

I will check this Jurij

Thanks

Angel

[julian]

We have defined one dedicated listener and ten dispatchers.

10 dispatchers! Oh boy, are you the administrator of yahoo or amazon :-)

You very seldom need 10 dispatchers.

[aarroyob]

Originally posted by julian

We have defined one dedicated listener and ten dispatchers.

10 dispatchers! Oh boy, are you the administrator of yahoo or amazon :-)

You very seldom need 10 dispatchers.

No Julian,

It will be a database to be accesed from Petroleum Portal.
Apparently all is correct configured, but it continues saying dedicated when I query V$SESSION.

I am comparing you similar databases and I don´t find differences ?

Any idea?

Thanks

Angel

[Sureshy]

Hopw did you set up client connection ?
If through Net8 assistant -
click on service you want to modify.
click on advanced
untick Use dedicated server.

If manually entering tnsnames.ora file ensure server=dedicated does not exist in tnsnames on each client

Ensure MTS is set up correctly on server.
query v$dispathers,v$servers,v$queue, etc.
Ensure there are some stats against them.