wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes How to Change SERVICE_NAME in ORACLE 10g Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "How to Change SERVICE_NAME in ORACLE 10g" Watch "How to Change SERVICE_NAME in ORACLE 10g" New topic
Author

How to Change SERVICE_NAME in ORACLE 10g

jaya kemmannu
Ranch Hand

Joined: Sep 23, 2011
Posts: 83

Hi,

We have oracle10g installed in redhat linux server. IF my current service_name is set to "XXXX" how can change his to "YYYY". Any help would be appreciated.

Thanks & Regards,
Joy
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3606
    
  60

There is a system parameter you can set: SERVICE_NAMES

See ALTER SYSTEM for details on setting system parameters.
Md Haidar Ali Khan
Greenhorn

Joined: Feb 18, 2010
Posts: 12
ALTER SYSTEM SET SERVICE_NAMES = 'SOMETHINGELSE'
Regards,
MD HAIDAR ALI KHAN
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: How to Change SERVICE_NAME in ORACLE 10g
 
Similar Threads
Code for JSP dropdown menu
How to get SERVICE_NAME
heap size in apache tomcat 5.x
AXIS 2 : Developing a help page for a Web service created
Server Instructions...