Re: 8.0.6 odbc performance

"Jerry D" <jdubuke_at_notme.gpdservices.com> wrote in message news:<3dd24cd7$0$29943$4c41069e_at_reader0.ash.ops.us.uu.net>...
> Before I get flamed for not reading the manuals - where can I find the 8.0.6
> manuals? Tahiti starts with 8i.
> That being said, here is my sqlnet.ora - pretty sparse, and I dont
> understand it (which is why I would like to read up on it!!)
>
> Looking as far as I can, I see the authentication is commented out - what is
> the default?
> Jerry
>
> *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
> TRACE_LEVEL_CLIENT = USER
> TRACE_FILE_CLIENT = odbc
> TRACE_DIRECTORY_CLIENT = d:\orant\rdbms80\trace
> USE_OTRACE = YES
It looks like you've enabled tracing. If you disable tracing, does performance return to normal?

>
> #sqlnet.authentication_services = (NONE)
> names.directory_path = (TNSNAMES, HOSTNAME)

I assume that the database you're trying to reach has an entry in the tnsnames.ora file and that you've verified the setup there with the Net8 Configuration Assistant. If there is a TNS entry but there's a problem with it (i.e. it's using an IP address that no longer resolves to the machine), that could cause the problem.

Justin Cave

> names.default_domain = world
> name.default.zone = world
> automatic_ipc = off
> *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
>
> "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
> news:3dd17b61$0$9444$cc9e4d1f_at_news.dial.pipex.com...
> > have a look at sqlnet.ora and see if it is tring to use nts
> authentication.
> > if so disable it.
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> > ******************************************
> > "Jerry D" <jdubuke_at_notme.gpdservices.com> wrote in message
> > news:3dd1732c$0$11057$724ebb72_at_reader2.ash.ops.us.uu.net...
> > > Hi all,
> > > We had a meltdown of an Oracle database running on NT Server 4.0. We
> > > rebuilt the server from scratch, installed Oracle from scratch,
> recreated
> > > our database and imported a .dmp file from the previous night to get
> back
> > > online.
> > > Amazingly, the only problem we are now facing is the fact that
> connecting
> > > via ODBC takes a *lot* longer than it used to. For example, a Microsoft
> > > Excel sheet with an ODBC query in it will stay onscreen with "connecting
> to
> > > datasource" fro anywhere between 10 and 45 seconds. It will eventually
> > > connect, but take such a long time, which never happened before the
> rebuild.
> > > I figure I missed sumthin pretty important, and I have not got a cluse
> as
> to
> > > where to look, since I was sortat thrown into the deep end here.
> > > Could someone point me in the right direction to start looking? I would
> > > appreciate it!
> > >
> > > Jerry D
> > >
> > >
> > >
> >
> >
Received on Wed Nov 13 2002 - 16:47:07 CST