Re: Oracle 9i troubles

Hello!
Thanks for the reply!

"Hans Forbrich" <forbrich_at_telusplanet.net> wrote in message news:3EC3C215.F5642F1D_at_telusplanet.net...
> "Arcadius A." wrote:
>
> > Hello!
> > I've sucessfully installed Oracle 9i on my WinXP box....
> > I can connect to the DB server locally using SQLPlus and the SYSTEM
account
> > without specifying the "host string"
> > <prompt>
> > SQL*Plus: Release 9.2.0.1.0 - Production on Thu May 15 17:30:39 2003
> > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
> > Connected to:
> > Personal Oracle9i Release 9.2.0.1.0 - Production
> > With the Partitioning, OLAP and Oracle Data Mining options
> > JServer Release 9.2.0.1.0 - Production
> > SQL>
> > </prompt>
>
> Remember that Windows 'standard' is to confuse the host name at different
> times. My Win2K box has a name 'xxx001l', my domain is 'domain.ca' but my
HOSTS
> file has 'xyz01.domain.ca'. Sometimes I need to access
'xyz001l.domain.ca',
> others it's xzy01.domain.ca' ... you may have to play around with this.
>
> Other things
> - is the TNSLinstener set up properly and configured? (probably)
> - is TNSNames.ora set up properly and configured?
> - does SQLNet.ora have a default_domain?
> - is the default domain being appended and thereby causing the key in
> TNSNames.ora to be missed?

Please, how can I check that TNSLinstener, TNSNames.ora and SQLNet.ora are properly configured?

Thanks.

Arcadius. Received on Thu May 15 2003 - 12:25:13 CDT