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).