469,319 Members | 2,291 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,319 developers. It's quick & easy.

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
Jul 19 '05 #1
6 4364
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
|
|
Jul 19 '05 #2
> 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
Jul 19 '05 #3
"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".
Jul 19 '05 #4

"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
Jul 19 '05 #5
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
|
|

Jul 19 '05 #6
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.

Jul 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Adam Ruth | last post: by
2 posts views Thread by Miori | last post: by
6 posts views Thread by Neil Zanella | last post: by
30 posts views Thread by Yevgen Muntyan | last post: by
6 posts views Thread by bdj | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.