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

Reply via email to