OraFAQ Forum: Server Administration » how to switch service

Home » RDBMS Server » Server Administration » how to switch service (11.2.0.1 windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to switch service [message #533632]

Wed, 30 November 2011 23:45

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
A sid which is using the service1, how can i switch it to the service2.


Select Value
from v$parameter where name='service_names'

VALUE
---------------
service1, service2, service3, service4

SQL> Select service_name From v$session where sid=1980;

SERVICE_NAME
----------------------------------------------------------------
service1

Report message to a moderator

Re: how to switch service [message #533660 is a reply to message #533632]

Thu, 01 December 2011 01:23

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Put service2 in tnsnames.ora entry instead of service1.

Regards
Michel

Report message to a moderator

Re: how to switch service [message #533971 is a reply to message #533660]

Fri, 02 December 2011 00:48

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,
Michel,i want to know how to switch a running session to another sercice?

Report message to a moderator

Re: how to switch service [message #533982 is a reply to message #533971]

Fri, 02 December 2011 01:01

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You do not switch to a service during, you connect to a service.
Think this example: you go to the Post Office, how do you switch to tobacco shop? You leave the Post Office!

Regards
Michel

Report message to a moderator

Re: how to switch service [message #534162 is a reply to message #533982]

Sat, 03 December 2011 09:33

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks!

Report message to a moderator

Previous Topic:	Removing Auditing
Next Topic:	ORACLE instance terminated

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 25 05:20:08 CDT 2026