By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,130 Members | 2,100 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,130 IT Pros & Developers. It's quick & easy.

union of tnsnames.ora

P: n/a
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
Share this Question
Share on Google+
6 Replies


P: n/a
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

P: n/a
> 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

P: n/a
"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

P: n/a

"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

P: n/a
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

P: n/a
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.