No doubt im in the wrong ball field here but this is what I have Windows 2k Server1 Ns1 on 8.1.7.4 Server2 Ns2 on 9.2.0.1.0
[server1] C:\> start \\server1\bin\namesctl dump_tnsnames C:\mytnsnames.txt It creates an empty file on my (remote) machine >From the server C:\> namesctl dump_tnsnames C:\mytnsnames.txt it creats an empty C:\mytnsnames.txt [server2] C:\> start \\server2\bin\namesctl dump_tnsnames C:\mytnsnames.txt And it creates an empty file on my (remote) machine >From the server itself it creats a full C:\mytnsnames.txt file with all the connect discriptors How is this supposed to be called? Thanks! > Bob, > > I understand what you are saying (and your pain). My > suggestion would be to use the 'namesctl dump_tnsnames' > command to dump out the current Onames repository to the PC's > $TNS_ADMIN dir via a login script or SMS. You might want o > rename the current TNSNAMES.ORA file just prior to that as > dump_tnsnames adds to the end of the current one and doesn't > handle changes very well. > > Hth, > John Kanagaraj > DB Soft Inc > Phone: 408-970-7002 (W) > > Grace - Getting something we do NOT deserve > Mercy - NOT getting something we DO deserve > Click on 'http://www.needhim.org' for Grace and Mercy that is > freely available! > > ** The opinions and facts contained in this message are > entirely mine and do not reflect those of my employer or customers ** > > -----Original Message----- > Sent: Tuesday, August 26, 2003 6:44 AM > To: Multiple recipients of list ORACLE-L > > > Hello All > > Im back from the trenches to post a quick request for > help....<g> > > Ive setup onames on 2 servers and standard applications, (our app and > sqlplus) connect just fine, a problem situation manifests itself when: > > 1 users need to connect (add a database) to dba studio. They > get a error to the effect "cant resolve host name" And the > other 2. Users connect to remote databases (via vpn) that are > in our onames but many of these vpn connections once made do > not allow access to > *our* network resources. > > So basically almost all of oour users have one or more of > these secenarios which means they will need to maintain a > tnsnames file as well. > > I'm managing about 70+ connect discriptors.... And I was > hoping onames could be a centralised answer > > Is this common? Or is there a workaround? > > Thanks! > bob > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Bob Metelsky > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in the message BODY, include a line containing: UNSUB > ORACLE-L (or the name of mailing list you want to be removed > from). You may also send the HELP command for other > information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: John Kanagaraj > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in the message BODY, include a line containing: UNSUB > ORACLE-L (or the name of mailing list you want to be removed > from). You may also send the HELP command for other > information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).