Re: tnsnames.ora and win2k

In article <902k6j$hnb$1_at_nnrp1.deja.com>,   casall_at_my-deja.com wrote:
> Hello!
> I have a problem connecting to an Oracle database with a win2k machine.
> The programs that I use are TOAD and SQL3.3 Plus. There is no problem
> connecting to the Oracle databases with our win95/98 and NT4 machines
> but we are having a problem with the win2k machine.
>
> When we try to connect we get the following error messages:
>
> ORA-12545: TNS:name lookup failure
> Details:
> *** First assume we have a valid install and registry ***
> Oracle home is set to C:\ORANT
> Bin path is set to C:\ORANT\bin\
> Using: C:\ORANT\BIN\ORA73.DLL
>
> 2) Oracle Home Key is SOFTWARE\ORACLE
> Looking for TNS_ADMIN environmental variable
> Oracle Path is now C:\ORANT\NETWORK\ADMIN
> Looking for C:\ORANT\NETWORK\ADMIN\tnsnames.ora
> tnsnames.ora found
> tnsnames entry: cosbp
> tnsnames entry: costr1
> tnsnames entry: cosrp
> tnsnames entry: cosrp1
> tnsnames entry: cosb1
> tnsnames entry: chs
> tnsnames entry: cosmo
> tnsnames entry: LSNCOS01
> tnsnames entry: ctest99
> tnsnames entry: cprod99
> tnsnames entry: cosmo_ifs99
> tnsnames entry: ctest99i2
> tnsnames entry: sitesalb
> tnsnames entry: sites
> tnsnames entry: DEVEL
> tnsnames entry: COSBP_REPLICA
> tnsnames entry: capmig1
> tnsnames entry: inttst1
> tnsnames entry: UATPASS1
> tnsnames entry: cobscs
> tnsnames entry: cortx
> tnsnames entry: trbscs
> tnsnames entry: dirman
> tnsnames entry: BSCS_521_REPLICA
>
> Sql*Net Help in TOAD.
> Oracle Root
> Oracle_Home = C:\ORANT
> C:\ORANT\BIN is in system PATH
> C:\ORANT\BIN does exist
> Client dll found ORA73.DLL
> ORA73.DLL version: 7.3.4.0.0
> C:\ORANT\NETWORK\ADMIN\tnsnames.ora found.
> Oracle Root is valid
>
> and
>
> ***********************************************************************
> Fatal OSN connect error 12545, connecting to:
> (DESCRIPTION=(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=XXXXXX)
> (Port=XXXX))(CONNECT_DATA=(SID=XXXXXX)(CID=(PROGRAM=Toad.exe)
> (HOST=PC00102012)(USER=Administrator))))

Are these XXXX put here by you? If not, why is you tnsnames contain them? Check your tnsnames.ora file once again. And check if you can ping host in host part of address in tnsnames.ora.
>
> VERSION INFORMATION:
> TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
> Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows:
> Version 2.3.4.0.0 - Production
> Time: 29-NOV-00 08:06:58
> Tracing not turned on.
> Tns error struct:
> nr err code: 12206
> TNS-12206: TNS:received a TNS error during navigation
> ns main err code: 12545
> TNS-12545: Connect failed because target host or object does not
> exist
> ns secondary err code: 12560
> nt main err code: 515
> TNS-00515: Connect failed because target host or object does not
> exist
> nt secondary err code: 1004
> nt OS err code: 0
>
> ***********************************************************************
> Fatal OSN connect error 12547, connecting to:
> (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)
> (ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=
> (PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=Toad.exe)
> (HOST=PC00102012)(USER=Administrator))))
>
> VERSION INFORMATION:
> TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
> Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version
> 2.3.4.0.0 - Production
> Time: 29-NOV-00 08:07:34
> Tracing not turned on.
> Tns error struct:
> nr err code: 12206
> TNS-12206: TNS:received a TNS error during navigation
> ns main err code: 12547
> TNS-12547: TNS:lost contact
> ns secondary err code: 12560
> nt main err code: 517
> TNS-00517: Lost contact
> nt secondary err code: 0
> nt OS err code: 0
>
> All help is greatly appreciated!
>
> With best regards,
> Thor
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 30 2000 - 21:16:27 CET