Home » RDBMS Server » Server Administration » Shared server configuration (Oracle 10g release2,Windows)
Shared server configuration [message #378048] Sun, 28 December 2008 03:20 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Hi all,

Presently, db is installed locally in my machine.

i want to configure my db to shared server from dedicated server. i used the following steps to configure shared server.


1.Changed corresponding entry, server = shared in tnsnames.ora file


2.alter system set shared_servers=4 scope=both;


3.then ,restarted db


4.But still ,showing me the same.


select username , sid , server from v$session where username='SYS';

USERNAME SID server
------------------------------ ---------- ---------
SYS 159 DEDICATED


Please let me know if any thing i have left out in the steps for shared server configuration.


Regards,
Balaji

Report message to a moderator

Re: Shared server configuration [message #378049 is a reply to message #378048] Sun, 28 December 2008 03:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- Never ever use SYS but for maintenance purpose (startup, shutdown, backup, recover)
- SYS is special
- SYS is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS" and you'll see the immediate answer)
- SYS does not act like any other user
- When you use SYS Oracle deactivates some code path and activates others
- Whatever you do with SYS will neither validate nor invalidate the same thing with any other user.

NEVER EVER use SYS for anything that can be done by another user.
Use SYS ONLY for something that can't be done by someone else.

Regards
Michel

Report message to a moderator

Re: Shared server configuration [message #378052 is a reply to message #378049] Sun, 28 December 2008 03:53 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member
Thanks michel for your speedy response.


I created another user called 'bala' and executed the 'Alter system' command for changing the parameter shared_servers in spfile.ora

show user
"bala"

alter system set shared_servers=4 scope=both;


I received the following error

ERROR at line 1:
ORA-01031: insufficient privileges

Please advice me on this.

Regards,
Balaji

[Updated on: Sun, 28 December 2008 03:55]

Report message to a moderator

Re: Shared server configuration [message #378057 is a reply to message #378052] Sun, 28 December 2008 04:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once again read documentation about the statement you're trying to use, there is prerequirement you have to satisfy before using a command.

In addition, you have not to change the parameter for each user you create it is an instance wide parameter. Now you previously did it you have not to reexecute it.

Regards
Michel

Report message to a moderator

Re: Shared server configuration [message #378059 is a reply to message #378057] Sun, 28 December 2008 04:32 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

"there is prerequirement you have to satisfy before using a command."


What is the prerequirement that i need to satisfy before using a command??

Regards,
Balaji

[Updated on: Sun, 28 December 2008 04:34]

Report message to a moderator

Re: Shared server configuration [message #378061 is a reply to message #378059] Sun, 28 December 2008 04:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is in the documentation. Search for alter system.

Regards
Michel

Report message to a moderator

Re: Shared server configuration [message #378063 is a reply to message #378061] Sun, 28 December 2008 04:40 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member
where is the documentation?

Report message to a moderator

Re: Shared server configuration [message #378065 is a reply to message #378063] Sun, 28 December 2008 04:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Online, you have been pointed to it hundred times.

Regards
Michel

Report message to a moderator

Re: Shared server configuration [message #378068 is a reply to message #378065] Sun, 28 December 2008 04:57 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member


The prerequisite is that i need to grant alter system privilege to user bala for the error insufficient privilege.i have done that. But still able to see user connecting to dedicated server .

What could be the reason?? please revert me with the answer.

Report message to a moderator

Re: Shared server configuration [message #378070 is a reply to message #378068] Sun, 28 December 2008 05:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What did you read about shared server?

Regards
Michel

Report message to a moderator

Re: Shared server configuration [message #378074 is a reply to message #378070] Sun, 28 December 2008 05:28 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member
The DISPATCHERS initialization parameter configures dispatcher processes in the shared server architecture. At least one dispatcher process is required for shared server to work.


To configure dispatcher, i have set the parameter as

alter system set dispatchers='(protocol=tcp)(dispatchers=2)';

since it s dynamic parameter ,restarted db.

But still, the result is the same.

Regards,
Balaji

Report message to a moderator

Re: Shared server configuration [message #378075 is a reply to message #378074] Sun, 28 December 2008 06:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Before using using a feature you need to read the principles:
Database Concepts
Chapter 9 Process Architecture
Section Shared Server Architecture

What does say the note?

Regards
Michel

[Updated on: Sun, 28 December 2008 06:03]

Report message to a moderator

Re: Shared server configuration [message #378166 is a reply to message #378075] Mon, 29 December 2008 03:37 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

hi,

Sorry for the late response.


Dedicated Server

The separate server process created on behalf of each user process is called a dedicated server process (or shadow process), because this server process acts only on behalf of the associated user process.

Shared server

Shared server architecture eliminates the need for a dedicated server process for each connection.

The dispatcher processes support shared server configuration by allowing user processes to share a limited number of server processes. With the shared server, fewer shared server processes are required for the same number of users, Therefore, the shared server can support a greater number of users, particularly in client/server environments where the client application and server operate on different computers.

Regards,
Balaji

Report message to a moderator

Re: Shared server configuration [message #378183 is a reply to message #378166] Mon, 29 December 2008 04:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is NOT what is in the "note".

Regards
Michel

Report message to a moderator

Re: Shared server configuration [message #378237 is a reply to message #378183] Mon, 29 December 2008 07:09 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member
Do you want me to copy & paste the whole thing that is in the document about shared and dedicated server?? else give me the solution for my issue ?

Regards,
Balaji

Report message to a moderator

Re: Shared server configuration [message #378253 is a reply to message #378237] Mon, 29 December 2008 08:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I just want to read (and to prove it post it) and understand the "Note". It is just a sentence of 30 words.
Did you do what is in this note?

Regards
Michel

[Updated on: Mon, 29 December 2008 08:38]

Report message to a moderator

Re: Shared server configuration [message #378397 is a reply to message #378253] Tue, 30 December 2008 04:41 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Note:

To use shared servers, a user process must connect through Oracle Net Services or SQL*Net version 2, even if the process runs on the same computer as the Oracle instance.


Hope , you were talking about this note.

later i had configured new listener with the name LISTENER1 and following is the parameters that i have added in tnsnames.ora file.

bala =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = balaji)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = bala)
)
)


Actually, i was able to ping with bala (tnsping bala) but the outcome was same showing users connecting through dedicated server.


SQL> select username,server from v$session where username='bala';

USERNAME SERVER
------------------------------ ---------
bala NONE



Please point out where i went wrong.


Regards,
Balaji

[Updated on: Tue, 30 December 2008 04:49]

Report message to a moderator

Re: Shared server configuration [message #378404 is a reply to message #378397] Tue, 30 December 2008 05:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How could I know, you didn't post how you connect and even if what you show has anything with any connection.
In addition, it is not formatted.

Regards
Michel

Report message to a moderator

Re: Shared server configuration [message #378476 is a reply to message #378404] Tue, 30 December 2008 10:10 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member


I created new listener called listener1 and added the following in tnsnames.ora


bala =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = balaji)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = bala)
)
)


To confirm the user connection ,i ran the query


SQL> select username,server from v$session where username in( 'bala','SYS');


USERNAME SERVER
------------------------------ ---------
SYS DEDICATED
bala DEDICATED


Still showing me the same.

Report message to a moderator

Re: Shared server configuration [message #378478 is a reply to message #378476] Tue, 30 December 2008 10:25 Go to previous message
Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You repeat the same thing, I repeat the same answer, so reread my previous post.

Don't tell what you do, post it, prove it, and post it FORMATTED

Regards
Michel

Report message to a moderator

Previous Topic: client 9i for sparc 64 bit
Next Topic: Account Lock
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 03:28:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.