1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

changing server from dedicated to shared server

Discussion in 'General' started by Kavita, Apr 18, 2010.

  1. Kavita

    Kavita Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Mumbai
    Iam using windows xp 2003 as operating system and oracle version is 9.2.0.1.0 iam trying to convert server from dedicated t oshared
    according i have done changes in my pfile related to
    dispatchers
    max_shared_Servers
    shared_servers
    and on client side i have done changes to tnsnames .ora file
    server=shared
    when i check in v$session it is showing dedicated i restarted the database but it was showing me as dedicated
    do i require to modify or add any other parameter
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Show us exactly what you've done.