Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to Change SERVICE_NAME in ORACLE 10g

 
jaya kemmannu
Ranch Hand
Posts: 90
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There is a system parameter you can set: SERVICE_NAMES

See ALTER SYSTEM for details on setting system parameters.
 
Md Haidar Ali Khan
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ALTER SYSTEM SET SERVICE_NAMES = 'SOMETHINGELSE'
Regards,
MD HAIDAR ALI KHAN
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic