RE: Onames and various connections scenarios

No need to do it quite the way you are attempting.

c:> namesctl dump_tnsnames c:\temp\tnsnames.txt

worked fine for me. The default server is ns_ns1

Had I wanted to do this from another server, say ns2, I would have gone directly into namesctl, then issued the command 'set server ns_ns2'

Jared

"Bob Metelsky" <bmetelsky_at_cps92.com>
Sent by: ml-errors_at_fatcity.com
 08/26/2003 03:04 PM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: Onames and various connections scenarios

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: bmetelsky_at_cps92.com
>
> 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: ListGuru_at_fatcity.com (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: john.kanagaraj_at_hds.com
>
> 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: ListGuru_at_fatcity.com (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: bmetelsky_at_cps92.com

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: ListGuru_at_fatcity.com (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: 
  INET: Jared.Still_at_radisys.com

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: ListGuru_at_fatcity.com (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).