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]

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.********@gmx.net> wrote in message
news:40*********************@dread11.news.tele.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]

> 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

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]

"bdj" <B.********@gmx.net> wrote in message news:<40*********************@dread11.news.tele.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...setting...
----------------------------

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

[Mark C. Stock]

"Christine" <ka******@hotmail.com> wrote in message
news:69**************************@posting.google.c om...
| "bdj" <B.********@gmx.net> wrote in message
news:<40*********************@dread11.news.tele.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...setting...
| ----------------------------
|
| 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]

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@Xenquery .com> wrote in message
news:Gs********************@comcast.com...

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.********@gmx.net> wrote in message
news:40*********************@dread11.news.tele.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
|
|

[Harry]

bdjensen wrote...

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

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.