Oracle Name server
I am using 3 Sun450 servers. for prod,dev,support. I am using oracle8i and oracle 9i instances on all these server, and nwo i ama maintaining a separate tnsnames.ora file for each box and for both 8i and 9i databases. Is it possible by using oracle names server my maintaneance will be minimal? If yes? how i can proceed?. Is Oracle names server a completely a new server?
I appriciate your advice.
- New info
I would like to knwo since i am using two Oracle versions oracle 8i and 9i which Names ctl i should use?
Last edited by natram; 01-09-2003 at 01:40 PM.
You need to install the Oracle Names software as part of the Oracle install.
The documentation is short and uncomplicated. Installing Names and configuring 10 databases should take a half a day at the most. There is a GUI call netmgr that makes things simple.
I recommend that you have one master tnsnames and use tdist or some sort of centralized distribution to update all copies if you want them to be uniform.
OCP DBA 8i, 9i, 10g
Oracle name server comes with software.
In Oracle 8i, typical installation did not install oracle name server, you need to add name server software. In 9i, typical installation do install name server. Easy way to test if name server installed;
Click Here to Expand Forum to Full Width