Dedicated or Shared Server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Dedicated or Shared Server

  1. #1
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763

    Question

    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

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Do you have the following item in your TNSNames.ora entry?

    (SERVER=dedicated)

    http://download-west.oracle.com/otnd...mes.htm#448498
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    No, I havenīt.

  5. #5
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    I will check this Jurij

    Thanks

    Angel

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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.


  7. #7
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    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

  8. #8
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    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
  •  


Click Here to Expand Forum to Full Width