Home » RDBMS Server » Networking and Gateways » Shared server configuration
Shared server configuration [message #193998] Wed, 20 September 2006 05:59 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
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
Re: Shared server configuration [message #194163 is a reply to message #193998] Thu, 21 September 2006 01:32 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Duplicate thread...
http://www.orafaq.com/forum/t/69755/72347/

Topic closed.
Previous Topic: Oracle 10g Express for Windows on a USB key
Next Topic: Urgent: Transparent Gateway 2 MSSQL
Goto Forum:
  


Current Time: Thu Dec 05 01:33:22 CST 2024