Re: Connection problem ORA 12535 TNS Timeout

To end a sad story:
I took another machine, did the setup again and it worked immediately. If I have spare time, I will try to setup the VMWare box on another machine, but I think, the combination I tried does not work.

Many thanks for your assist, however.

Bernd

"Frank van Bortel" <fvanbortel_at_netscape.net> schrieb im Newsbeitrag news:c25hqd$ihd$1_at_news4.tilbu1.nb.home.nl...
> Bernd Maierhofer (dato) wrote:
> > As I did a new setup, the machine is now calles oracleserver, but yes, I
can
> > ping it.
> Good.
>
> >
> >>2a) your sqlnet.ora file (sits next to tnsnames.ora) contains
> >>an entry default_domain = DATO.LOCALHOST, or:
> >
> > SQLNET.ORA on the remote machine:
> > # SQLNET.ORA Network Configuration File:
> > C:\Oracle\Ora81\NETWORK\ADMIN\sqlnet.ora
> > # Generated by Oracle configuration tools.
> >
> > NAMES.DEFAULT_DOMAIN = dato.localhost
> >
> As predicted ;-)
> >
>
>
> > TNSNAMES.ORA on the remote machine:
> > # TNSNAMES.ORA Network Configuration File:
> > C:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora
> > # Generated by Oracle configuration tools.
> >
> > BF1.DATO.LOCALHOST =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = oracleserver)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SID = bf1)
> > )
> > )
> >
> >
> you might want to consider chenging:
> (ADDRESS = (PROTOCOL = TCP)(HOST = oracleserver)(PORT = 1521))
> to:
> (ADDRESS = (PROTOCOL = IPC)(KEY = BF1)
>
>
>
> >
> > LISTENER.ORA on the remote machine:
> OK
> > SQLNET on the client:
> > # SQLNET.ORA Network Configuration File:
> > c:\Oracle\Ora81\network\admin\sqlnet.ora
> > # Generated by Oracle configuration tools.
> >
> > NAMES.DEFAULT_DOMAIN = dato.localhost
> >
> > SQLNET.AUTHENTICATION_SERVICES= (NTS)
> >
> Did you install advanced security? Comment it out, as:
> # SQLNET.AUTHENTICATION_SERVICES= (NTS)
> and see it it speeds up initial connections
>
> > NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
> Lose ONAMES, perhaps HOSTNAME as well:
> NAMES.DIRECTORY_PATH= (TNSNAMES)
>
> >
> > TNSNAMES.ORA on the client:
> > # TNSNAMES.ORA Network Configuration File:
> > c:\Oracle\Ora81\network\admin\tnsnames.ora
> > # Generated by Oracle configuration tools.
> >
> > BF1.DATO.LOCALHOST =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = oracleserver)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SID = bf1)
> > )
> > )
> To rule out a DNS problem, change (HOST = oracleserver) to
> (HOST = 10.10.10.xxx)
>
> >
> > TNS Ping Utility for 32-bit Windows: Version 8.1.6.0.0 - Production on
> > 03-M?R-2004 12:46:56
> >
> > (c) Copyright 1997 Oracle Corporation. All rights reserved.
> >
> > Attempting to contact

(ADDRESS=(PROTOCOL=TCP)(HOST=oracleserver)(PORT=1521))
> > OK (9020 msec)
> > OK (30 msec)
> > OK (30 msec)
> > OK (30 msec)
> > OK (30 msec)
> > OK (30 msec)
> > OK (30 msec)
> > OK (20 msec)
> > OK (30 msec)
> > OK (30 msec)
> >
>
> inline... lots of snipping...
>
> The above could be security, could be a DNS problem.
> Try both - all else looks fine to me, as far as I can judge
> from over here.
> --
>
> Regards,
> Frank van Bortel
>
Received on Fri Mar 05 2004 - 00:47:25 CST