TNS Names and multiple homes
Posted: Wed 25 Jan 2006 15:14
This is kind of a double question:
Firstly, I want to be able to list all of the TNS names in an oracle home. How do I do this?
Secondly:
I have 2 oracle homes, How do I list them? and how do I select a particular one to connect with? I have tried the connection.homes object, but although it gets the count correct, if I iterate through them, they are all 'nothing'.
I am using version 3.01.
Thanks.
Firstly, I want to be able to list all of the TNS names in an oracle home. How do I do this?
Secondly:
I have 2 oracle homes, How do I list them? and how do I select a particular one to connect with? I have tried the connection.homes object, but although it gets the count correct, if I iterate through them, they are all 'nothing'.
I am using version 3.01.
Thanks.