Shared server configuration [message #378048] |
Sun, 28 December 2008 03:20 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
balaji1482
Messages: 312 Registered: July 2007 Location: INDIA
|
Senior Member |
![YES](/forum/theme/orafaq/images/yahoo.png)
|
|
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
|
|
|
|
Re: Shared server configuration [message #378052 is a reply to message #378049] |
Sun, 28 December 2008 03:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
balaji1482
Messages: 312 Registered: July 2007 Location: INDIA
|
Senior Member |
![YES](/forum/theme/orafaq/images/yahoo.png)
|
|
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 #378397 is a reply to message #378253] |
Tue, 30 December 2008 04:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
balaji1482
Messages: 312 Registered: July 2007 Location: INDIA
|
Senior Member |
![YES](/forum/theme/orafaq/images/yahoo.png)
|
|
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 #378478 is a reply to message #378476] |
Tue, 30 December 2008 10:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|