Re: TNS Resolve SERVICE_NAME

On Mon, 30 Dec 2002 03:29:32 GMT, "Randy Harris" <randy.harris_at_nospam.net> wrote:

>The show parameter service_name returns a value that makes little sense.
>Can you tell me how and when that parameter would normally get set or
>changed? Thank you very much for your help.

The service_name is normally
db_name||'.'||db_domain
or just db_name when db_domain is null
All parameters are init.ora parameters.
Be aware if you decide to change the db_domain you also need to issue alter database rename global_name to db_name||'.'||db_domain

You can override the service_name (not recommended) by just changing it in the init<sid>.ora and bounce the database.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Dec 30 2002 - 14:42:22 CST