OraFAQ Forum: Server Administration » How to change Service name of a databse

Home » RDBMS Server » Server Administration » How to change Service name of a databse (Oracle 10g release 1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to change Service name of a databse [message #309321]

Thu, 27 March 2008 02:06

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.

Report message to a moderator

Re: How to change Service name of a databse [message #309327 is a reply to message #309321]

Thu, 27 March 2008 02:17

Michel Cadot
Messages: 68684
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

Report message to a moderator

Re: How to change Service name of a databse [message #309341 is a reply to message #309327]

Thu, 27 March 2008 02:59

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.

Report message to a moderator

Re: How to change Service name of a databse [message #309346 is a reply to message #309341]

Thu, 27 March 2008 03:09

Michel Cadot
Messages: 68684
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

To change the database name you have to use DBNEWID utility.

Regards
Michel

Report message to a moderator

Re: How to change Service name of a databse [message #309357 is a reply to message #309346]

Thu, 27 March 2008 03:32

MELAKU
Messages: 32
Registered: April 2007
Location: ETHIOPIA

Member

Thank you Michel,

But how can I get the utility DBNEWID

Melaku K.

Report message to a moderator

Re: How to change Service name of a databse [message #309370 is a reply to message #309357]

Thu, 27 March 2008 04:22

Michel Cadot
Messages: 68684
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It is on your server. It is part of Oracle delivery.

Regards
Michel

Report message to a moderator

Re: How to change Service name of a databse [message #310067 is a reply to message #309321]

Mon, 31 March 2008 02:52

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

nid help=y

Report message to a moderator

Previous Topic:	error while running script
Next Topic:	How can we plan storage for very large tables ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 18 18:27:25 CDT 2024