| Shared server configuration [message #193998] |
Wed, 20 September 2006 05:59  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
