Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Location
    kualalumpur
    Posts
    89

    Unanswered: change from dedicated to shared server

    Hello Oracle DBAs,
    We have oracle8.1.6(HP-UX1.0) running on Dedicated server process.
    Iam trying to change it to MTS as the number of users have increased.
    I did the following..
    1)Ensured that the instance_name,service_names,db_name,db_domain parameters are defined.
    2)Added mts_servers=2,mts_dispatchers=(protocol=tcp)(dispa tchers=2),mts_max_servers=40,mts_max_dispatchers=5 in init parameterfile.
    3)shutdown db,restart the listener,restart the database.
    4)Queried v$session ..shown server=dedicated..then tried $ps -ef|grep 'ora_s'
    shows s00_elx,s001_elx (elx is sid)along with others.Queried v$dispatcher_rate,v$queue
    show couple of rows.
    ...Why server value didnt changed to shared.(from dedicated) in v$session.
    Did I make any mistake.
    Could someone please help me in resolving this..by detailing about the whole process of changing from dedicated to shared server process(MTS).
    Thanks in advance.
    sridhar
    Last edited by sridharreddy_d; 07-07-04 at 23:23.

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Also dont forget in the tnsnames.ora you can force a connection to be DEDICATED so check the tnsnames.ora on the client end.

    Alan

  3. #3
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86
    Check if the LOCAL_LISTENER parameter (this is the service name of the listener) in the initSID.ora is the same that you defined in the tnsnames.ora.

    Manf

  4. #4
    Join Date
    Nov 2003
    Location
    kualalumpur
    Posts
    89

    Thanks..

    Quote Originally Posted by Manf
    Check if the LOCAL_LISTENER parameter (this is the service name of the listener) in the initSID.ora is the same that you defined in the tnsnames.ora.

    Manf
    Thanks all..earlier the parameter(local_listener) was not defined now I defined one with a value.
    Then I started the listener..and then instance.
    checked the v$session,v$circuit,v$dispatcher ..gives the figures as shared server is been used..
    but ..
    got ora04031 error.
    so..I increased the shared_pool_size by 40% and large_pool_size from 640kb to 100mb.,(ram is 2 gb)and db_block_buffer size from 65k to 80k and now its working fine.
    but Im worried wheather what I did was perfectly proper or not.
    will it arise any new problems..
    Pl. lemme know..
    Thanks in advance.

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    why doesn't your application server use a connection pool??

    be aware there are some disadvantages to using MTS
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •