Home » RDBMS Server » Server Administration » instance name (oracle 10.2.0 on linux redhad version 5.3 )
instance name [message #476261] Wed, 22 September 2010 06:50 Go to next message
pvdkamp
Messages: 3
Registered: September 2010
Junior Member
we want to change the instance name to something like db-prod.
My question is is it possible to use "-" in an instance name?

Report message to a moderator

Re: instance name [message #476264 is a reply to message #476261] Wed, 22 September 2010 06:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Why don't you try it?
Anyway, even if it would be possible you should not do it because "-" is a special character and I bet Oracle did not test it is harmless in ALL cases (if, of course, it is possible).

Regards
Michel

Report message to a moderator

Re: instance name [message #476267 is a reply to message #476264] Wed, 22 September 2010 07:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>we want to change the instance name to something like db-prod.
>My question is is it possible to use "-" in an instance name?

what does it mean to subtract sting "prod" from string "db"?
The "-" character is the MINUS operator.

Report message to a moderator

Re: instance name [message #476269 is a reply to message #476267] Wed, 22 September 2010 07:17 Go to previous messageGo to next message
pvdkamp
Messages: 3
Registered: September 2010
Junior Member
its not the issue to substract anything. we have to build a new oracle environment and the current database are named like dbprod ect. those names are well chosen for our environment and we like to change them as little ass possible. thats why we thought that maybe this was a solution.

Report message to a moderator

Re: instance name [message #476270 is a reply to message #476269] Wed, 22 September 2010 07:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can change it as you want but just use alphanumeric characters.

Regards
Michel

Report message to a moderator

Re: instance name [message #476271 is a reply to message #476270] Wed, 22 September 2010 07:21 Go to previous messageGo to next message
pvdkamp
Messages: 3
Registered: September 2010
Junior Member
Oke we will do.
Thx Michel for youre quick respons.

Report message to a moderator

Re: instance name [message #476272 is a reply to message #476269] Wed, 22 September 2010 07:30 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
pvdkamp wrote on Wed, 22 September 2010 14:17
those names are well chosen for our environment

Don't fix what ain't broken /forum/fa/1601/0/

Report message to a moderator

Re: instance name [message #476273 is a reply to message #476272] Wed, 22 September 2010 07:32 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>the current database are named like dbprod ect. those names are well chosen for our environment and we like to change them as little ass possible.
dbprod1

Report message to a moderator

Previous Topic: ORA-04043 resulting while quering user_views
Next Topic: Find or set new Oracle Instance Name on backup server
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 06:09:29 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.