Re: tnsname.ora question

On Fri, 29 Oct 1999 09:56:06 GMT, Tony Adolph <tony.adolph_at_viaginterkom.de> wrote:

>Hello Folks,
>
>I've just had some new software installed on my NT box. Post
>installation the entries in tnsnames.ora failed.
>
>The aliases were in the form ALIAS_NAME.world and I have had to change
>the domain name "world" to be able to tnsping databases (all is now ok).
>
>But I can't see from the environment that the domain has changed.
>Can anyone explain how the domain name mechanisium works with respect
>to tnsnames.ora?
>
>Thanks
>Tony Adolph
>PS: Ora 7.3.4 NT4
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

Hi Tony,
Basically you have two choices: using a flat-naming scheme for your databases or a hierarchical one. You need to use a hierarchical naming system if a) your have multuple locations b) you have multiple databases with the same name. In that case you can either rename databases or (better!) for the domain-name use the real internet domain. The global_name of that database becomes <database_name>.<internet_domain>, the db_domain parameter in init<sid>.ora should be set to the internet_domain. The domain name also is appended to the service name in tnsnames.ora In flat systems you don't really have a domain name. The fictitious domain 'world' is being used instead. The db_domain parameter is left out, however it defaults to the names.default_domain sqlnet.ora parameter below. That default is appended to any service name in tnsnames.ora
In all cases the domain will end up in the service name. In order to make sure you don't have to specify the domain always in the service name, names.default_domain and names.default_zone has been introduced in sqlnet.ora. This means if your database domain differs from the default domain in sqlnet.ora, you will be forced to specify it always.
Right now, assuming you use a flat naming scheme, I can't really see why you was forced to change anything.

Hth,

Hth,

Sybrand Bakker, Oracle DBA Received on Sat Oct 30 1999 - 03:18:39 CDT