Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I'd like to define several service names for my instance in such a way that users should not know the actual instance name. This is what I have done in my init.ora:

db_domain='company.com'
db_name='tdbket'
instance_name='tdbket'
service_names=tedab+ket.company.com, tedab.company.com, ket.company.com

By definition, the default value DB_UNIQUE_NAME.DB_DOMAIN of the service_names attribute should be overridden.

Though, the Listener still lists this default value:

Dienst "ket.company.com" hat 1 Instanzen.
  Instanz "tdbket", Status READY, hat 6 Handler für diesen Dienst...
Dienst "tdbket.company.com" hat 1 Instanzen.
  Instanz "tdbket", Status READY, hat 6 Handler für diesen Dienst...
Dienst "tedab+ket.company.com" hat 1 Instanzen.
  Instanz "tdbket", Status READY, hat 6 Handler für diesen Dienst...
Dienst "tedab.company.com" hat 1 Instanzen.
  Instanz "tdbket", Status READY, hat 6 Handler für diesen Dienst...
Der Befehl wurde erfolgreich ausgeführt.

Why?

share|improve this question
2  
SERVICE_NAMES are in addition to the database name, not instead of it. If users don't have local access to the machine, they won't be able to see the "tdbket" entry anyway. If they do have local access to the machine they'll be able to see the Unix processes for the DB anyway. – Phil May 11 '12 at 9:02

1 Answer

up vote 2 down vote

This is the default behaviour. As long as you don't have the default service in your tns_aliasses that are in use it should not be a problem.

share|improve this answer
I am sorry, I do not fully understand what you are trying to say. Phil's answer is quite helpful. – Michael-O May 11 '12 at 12:25
2  
The database instance will always register it's db_unique_name. You asked: why? answ: it is the default behaviour, we can not [yet] change that. – ik_zelf May 11 '12 at 12:36
Ok, this is clear now. I presumed that the default value is replaced when the parameter is defined. – Michael-O May 11 '12 at 12:42
yes, sometimes default is incorrectly called default ;-) – ik_zelf May 11 '12 at 12:54
I've sent a comment on the parameter site at Oracle. – Michael-O May 11 '12 at 13:07

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.