union of tnsnames.ora

[bdj]

Hello!
I have at set of tnsnames.ora. I wich to make an union, e.g. a single file
of it.
How can I do that easy?
Greetings
Bjørn

[Mark C. Stock]

Re: union of tnsnames.ora

cut and paste in notepad should work pretty well

(or yank and put in vi)

are there some issues or concerns you have that you've not described in your
post?

-- mcs

"bdj" <B.D.Jensen@gmx .net> wrote in message
news:4033be56$0 $181$edfadb0f@d read11.news.tel e.dk...
| Hello!
| I have at set of tnsnames.ora. I wich to make an union, e.g. a single file
| of it.
| How can I do that easy?
| Greetings
| Bjørn
|
|

[Folke Larsson]

Re: union of tnsnames.ora

> I have at set of tnsnames.ora. I wich to make an union, e.g. a single file[color=blue]
> of it.
> How can I do that easy?
> Greetings
> Bjørn[/color]

Hello Bjørn
My opinion is that you should avoid editing tnsnames.ora manually.
It is safer to use Oracle Net tools to enter the services.
At least in some versions Oracle can mess it up if you first edit
it manually and then use Oracles tools to change it.

Regards

Folke Larsson

[Christine]

Re: union of tnsnames.ora

"bdj" <B.D.Jensen@gmx .net> wrote in message news:<4033be56$ 0$181$edfadb0f@ dread11.news.te le.dk>...[color=blue]
> Hello!
> I have at set of tnsnames.ora. I wich to make an union, e.g. a single file
> of it.
> How can I do that easy?
> Greetings
> Bjørn[/color]

In "init_A.ora " file,
----------------------------
ifile='/aa/../init_B.ora'
blabla...settin g...
----------------------------

then "init_A.ora " file will be union of
"init_A.ora " and "init_B.ora ".

[Mark C. Stock]

Re: union of tnsnames.ora


"Christine" <karistom@hotma il.com> wrote in message
news:693b7163.0 402231925.45efa 9ef@posting.goo gle.com...
| "bdj" <B.D.Jensen@gmx .net> wrote in message
news:<4033be56$ 0$181$edfadb0f@ dread11.news.te le.dk>...
| > Hello!
| > I have at set of tnsnames.ora. I wich to make an union, e.g. a single
file
| > of it.
| > How can I do that easy?
| > Greetings
| > Bjørn
|
| In "init_A.ora " file,
| ----------------------------
| ifile='/aa/../init_B.ora'
| blabla...settin g...
| ----------------------------
|
| then "init_A.ora " file will be union of
| "init_A.ora " and "init_B.ora ".

good answer to wrong question -- that's for the parameter file, not the
tnsnames.ora file

;-{ mcs

[bdjensen]

Re: union of tnsnames.ora

Hi!
This would be easy, if the files are small.
But the files are big - some hundred db's
and I know that file A is better than file B (both files can describe the
same instances, but sometime there may be differences!)

Also important:
The tns-name should only be listet a single time in the resulting file, in
other
case, it could be that the wrong would be edited in future.
Greetings Bjørn

"Mark C. Stock" <mcstockX@Xenqu ery .com> wrote in message
news:Gsednf2J2e A0Xq7dRVn-vA@comcast.com. ..[color=blue]
> cut and paste in notepad should work pretty well
>
> (or yank and put in vi)
>
> are there some issues or concerns you have that you've not described in[/color]
your[color=blue]
> post?
>
> -- mcs
>
> "bdj" <B.D.Jensen@gmx .net> wrote in message
> news:4033be56$0 $181$edfadb0f@d read11.news.tel e.dk...
> | Hello!
> | I have at set of tnsnames.ora. I wich to make an union, e.g. a single[/color]
file[color=blue]
> | of it.
> | How can I do that easy?
> | Greetings
> | Bjørn
> |
> |
>
>[/color]

[Harry]

Re: union of tnsnames.ora

bdjensen wrote...[color=blue]
>
>Hi!
>This would be easy, if the files are small.
>But the files are big - some hundred db's
>and I know that file A is better than file B (both files can describe the
>same instances, but sometime there may be differences!)
>
>Also important:
>The tns-name should only be listet a single time in the resulting file, in
>other
>case, it could be that the wrong would be edited in future.
>Greetings Bjørn[/color]

For each tnsnames.ora
Do
vi $file
Join the lines so that one SID per line
Done
Cat all tnsnames.ora | sort | uniq > a_big_tnsnames. ora_sorted

Hope this help.