Implementing Oracle Internet Directory to end manual TNSNAMES.ora change and deployment woes
Hi,
I got frustrated in managing the TNSNAMES.ORA for more than 300+ users using varioous Oracle DB vesion 9i up to v11g
usually I send email for all of the users to manually copy and update the TNSNAMES.ora
so I wonder If Implementing this Oracle Internet Directory is the proper way to do it ? [http://www.oracle.com/technetwork/middleware/id-mgmt/overview/index-082035.html]
1. is it free ?
2. what is the prerequisite and the limitations ?
3. can I use it for both Oracle Server in WIndows Server and Unix install ?
my understanding is that this OID is like DNS to the computer systems.
Any kind of comments and help would be greatly appreciated.
Thanks.
I got frustrated in managing the TNSNAMES.ORA for more than 300+ users using varioous Oracle DB vesion 9i up to v11g
usually I send email for all of the users to manually copy and update the TNSNAMES.ora
so I wonder If Implementing this Oracle Internet Directory is the proper way to do it ? [http://www.oracle.com/technetwork/middleware/id-mgmt/overview/index-082035.html]
1. is it free ?
2. what is the prerequisite and the limitations ?
3. can I use it for both Oracle Server in WIndows Server and Unix install ?
my understanding is that this OID is like DNS to the computer systems.
Any kind of comments and help would be greatly appreciated.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
wait wait :) the suggestion above is not feasible? looks easy to me instead of buying a huge product and installing and configuring and changing all your applications... just 3 lines of code in a bat file and put them in startup :) or call it from your application... plus you need a ftp server :) to host the last ora file...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
oh... "lcd" command doesn't work on Windows XP Kurt :-)
well if the OID is expensive product then the only way is to get the file copied over from the FTP site like you suggested.
well if the OID is expensive product then the only way is to get the file copied over from the FTP site like you suggested.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
many thanks !
ASKER
but thanks for your suggestion Kurt.