DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Shared Server Configuration

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    Shared Server Configuration

    i am trying to configure a database into shared server from dedicated server architecture,i had done that by using DBCA
    shared_servers=3
    and dispatchers=3;
    and after configuration i have restarted the database
    but i have observed that sys as sysdba then this user is connected as shared and all other users are connected as None
    SQL> select username,server
    2 from v$session;


    USERNAME SERVER
    ------------------------------ ---------
    DEDICATED
    DEDICATED
    DEDICATED
    DEDICATED
    DEDICATED
    DEDICATED
    SYS SHARED
    HR NONE

    but when i chaged the tnsnames.ora file
    From
    NCL.NCTEX.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = shakeel)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = nishat)
    )
    )
    To
    NCL.NCTEX.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = shakeel)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = nishat)(SERVER=DEDICATED) )
    )
    And i observed that all user are connected as DEDICATED

    USERNAME SERVER
    ------------------------------ ---------
    DEDICATED
    DEDICATED
    DEDICATED
    DEDICATED
    DEDICATED
    DEDICATED
    SYS DEDICATED
    HR DEDICATED

    Do anybody have any idea about this?
    if anybody have then please help me in this regard
    Prompt response will be appreciated
    Thanx in advance

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    NONE is shared, just inactive.
    Jeff Hunter

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