Home » RDBMS Server » Server Administration » service_name issue (10.2.0.1)
service_name issue [message #547040] Mon, 12 March 2012 00:50 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
Some one says that it should configure multi service_name in a database,i don't know what the purpose is, some one can explain it?
Re: service_name issue [message #547041 is a reply to message #547040] Mon, 12 March 2012 00:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
andy huang wrote on Sun, 11 March 2012 22:50
Dear all,
Some one says that it should configure multi service_name in a database,i don't know what the purpose is, some one can explain it?


what exactly is 'it"?

how do you or anyone know correct answer has been posted?
Re: service_name issue [message #547056 is a reply to message #547040] Mon, 12 March 2012 02:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

You can then follow the activity for each service.
You also can stop and start services when the other services (and the instance/database) are still alive.

Regards
Michel
Re: service_name issue [message #547061 is a reply to message #547056] Mon, 12 March 2012 02:28 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks
Michel and BlackSwan,there are 4 server_names in my db,what is the purpose about setting this?

[code]
SQL> show parameters service_name;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string oss1,oss2,oss3,oss4
[code]
Re: service_name issue [message #547062 is a reply to message #547061] Mon, 12 March 2012 02:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What can I say more than what I said?
Tell us what you don't understand in my post.

Regards
Michel
Re: service_name issue [message #547076 is a reply to message #547062] Mon, 12 March 2012 03:28 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,
Michel,the 4 service_names are reside in a database, i can not understand your says:

You also can stop and start services when the other services (and the instance/database) are still alive.

how can i stop oss1 and let oss2 still alive? because there are in the same db.
Re: service_name issue [message #547077 is a reply to message #547076] Mon, 12 March 2012 03:34 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
dbms_service. It is all in the docs.
Re: service_name issue [message #547081 is a reply to message #547077] Mon, 12 March 2012 03:51 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks your reply,
Is there some performance issue about set mutil service_name in a database?

[Updated on: Mon, 12 March 2012 03:52]

Report message to a moderator

Re: service_name issue [message #547083 is a reply to message #547081] Mon, 12 March 2012 03:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No.

Regards
Michel
Re: service_name issue [message #547090 is a reply to message #547083] Mon, 12 March 2012 04:30 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks all!
Previous Topic: ORA-01652: unable to extend temp segment by 128 in tablespace DATA_01
Next Topic: about XDB service issue
Goto Forum:
  


Current Time: Sun Dec 01 14:39:26 CST 2024