Re: Oracle 9i troubles

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Thu, 15 May 2003 16:42:07 GMT
Message-ID: <3EC3C215.F5642F1D@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?

>
> But when I specify a host string, i get an error: "ORA-12541: TNS:no
> listener" or
> "ORA-12154: TNS:could not resolve service name"
> However, when I don't specify a host string, it works great!

No Listener -probably hitting the Windows host confusion. No service name - probably hitting the misconfigured SQLNet.ora/TNSNAmes.ora Received on Thu May 15 2003 - 11:42:07 CDT