Domain name in tnsnames

[yanban]

Hi,

I am using Oracle 9.2 on Win2000 and everytime I add a new alias, my domain's name gets appended to the alias' name.

Basically I will have an entry like that :

TEST.MYDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sid)
)
)

So what I do : I manually delete the mydomain, in order to have :
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sid)
)
)

Does anybody know why my domain gets added and how to change this behaviour ?

Remark : the NAMES.DEFAULT_DOMAIN parameter is commented in my sqlnet.ora.

Thanks.

[fraze]

Not sure I totally understand your problem - but have a look at this Metalink Note - it may help
http://metalink.oracle.com/metalink/...&p_id=201316.1

[fraze]

Not sure I totally understand your problem - but have a look at this Metalink Note - it may help
http://metalink.oracle.com/metalink/...&p_id=201316.1

[yanban]

Thanks but the link did not help me.

However I have found something else :

IF I create a new alias - giving it the name TEST - with Net Manager, I will get that in my tnsnames (which is just perfect and what I want) :

TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sid)
)
)


Now, If I create the new alias - still giving it the name TEST - using Net Config Assistant I will get :

TEST.MYDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sid)
)
)

The ONLY difference is that my alias is now called TEST.MYDOMAIN instead of TEST while I did not named it TEST.MYDOMAIN but only TEST.

Not a big deal, but strange.
If you have any idea...

[Mr.Hanky]

Do you have multiple sqlnet.ora files?
It would appear that the information is getting pulled from different locations.
Multiple Oracle homes?

MH

[yanban]

I have only one sqlnet.ora and only one Oracle home.

Also I have not set tns_admin, so Oracle searches for the tnsnames.ora ( and others ) in the standard directory network\admin\

BTW this happens on different workstations (maybe all?).

[DaPi]

Originally posted by yanban
IF I create a new alias - giving it the name TEST - with Net Manager, I will get that in my tnsnames (which is just perfect and what I want) :
. . . . . .
Now, If I create the new alias - still giving it the name TEST - using Net Config Assistant I will get : . . . .

Which confirms my opinion that using Net Config Assistant is like driving with your eyes shut. Net Manager (Net8 Assistant in versions before 9) does what you tell it to do, lets you see what you are doing and shows you what you have done!

[Mr.Hanky]

HEY!!

I do my best sleeping while driving to work, so don't knock driving with your eyes closed.

MH

[slimdave]

Originally posted by DaPi
Which confirms my opinion that using Net Config Assistant is like driving with your eyes shut. Net Manager (Net8 Assistant in versions before 9) does what you tell it to do, lets you see what you are doing and shows you what you have done!

Oh, you can't beat manual editing, i always say.

[DaPi]

Originally posted by Mr.Hanky
I do my best sleeping while driving to work, so don't knock driving with your eyes closed.

Great when it works, painful when it doesn't.

Of course the Config Assistant is in the best traditions of GUI's, which are intended to hide the details from the end user, increasing the chance of a consultant being called in to sort out the mess.

Originally posted by slimdave
Oh, you can't beat manual editing, i always say.

Provi)ding you c)(an get the) par(atheses in the rig)(ht pl(a)ces. (I usually can)t