Home » RDBMS Server » Backup & Recovery » Shared Server Configuration
Shared Server Configuration [message #194001] Wed, 20 September 2006 06:11 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 #194204 is a reply to message #194001] Thu, 21 September 2006 03:07 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Do not test/look at SYS. Sys it not a normal user, and special rules apply for SYS.
Re: Shared Server Configuration [message #194348 is a reply to message #194204] Thu, 21 September 2006 10:36 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
This thread is posted everywhere:

http://www.orafaq.com/forum/t/69755/85219/
http://www.orafaq.com/forum/t/69752/85219/
Previous Topic: tablespace full
Next Topic: Zipped Export Dump
Goto Forum:
  


Current Time: Tue Dec 06 04:41:40 CST 2016

Total time taken to generate the page: 0.13845 seconds