aspose file tools*
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


Win a copy of Spring in Action this week in the Spring forum!
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: 85

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: 3610
    
  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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to Change SERVICE_NAME in ORACLE 10g