Home » RDBMS Server » Server Administration » How to change Service name of a databse (Oracle 10g release 1)
How to change Service name of a databse [message #309321] Thu, 27 March 2008 02:06 Go to next message
MELAKU
Messages: 32
Registered: April 2007
Location: ETHIOPIA
Member
Hi Experts,
I want to change the service name of my database. Can you help me in providing me steps to be followed in order to change service name?
Thank you
Melaku K.
Re: How to change Service name of a databse [message #309327 is a reply to message #309321] Thu, 27 March 2008 02:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends what you meant with "service name".
If it is "service_names" configuration parameter then use "alter system".
If it is tns connection name then change it in your tnsnames.ora.
If it is another thing then precise.

Regards
Michel
Re: How to change Service name of a databse [message #309341 is a reply to message #309327] Thu, 27 March 2008 02:59 Go to previous messageGo to next message
MELAKU
Messages: 32
Registered: April 2007
Location: ETHIOPIA
Member
Hi Michel,

I mean the databse name. My databse name is UBTEST. I want to change it to UBTRAINING.
Melaku K.
Re: How to change Service name of a databse [message #309346 is a reply to message #309341] Thu, 27 March 2008 03:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
To change the database name you have to use DBNEWID utility.

Regards
Michel
Re: How to change Service name of a databse [message #309357 is a reply to message #309346] Thu, 27 March 2008 03:32 Go to previous messageGo to next message
MELAKU
Messages: 32
Registered: April 2007
Location: ETHIOPIA
Member
Thank you Michel,

But how can I get the utility DBNEWID

Melaku K.
Re: How to change Service name of a databse [message #309370 is a reply to message #309357] Thu, 27 March 2008 04:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is on your server. It is part of Oracle delivery.

Regards
Michel
Re: How to change Service name of a databse [message #310067 is a reply to message #309321] Mon, 31 March 2008 02:52 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

nid help=y
Previous Topic: error while running script
Next Topic: How can we plan storage for very large tables ?
Goto Forum:
  


Current Time: Wed Dec 07 14:58:14 CST 2016

Total time taken to generate the page: 0.17130 seconds