-
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
-
Do you have the following item in your TNSNames.ora entry?
(SERVER=dedicated)
http://download-west.oracle.com/otnd...mes.htm#448498
-
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.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
-
I will check this Jurij
Thanks
Angel
-
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.
-
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
-
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.
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|