Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12154 connecting to 9i on XP

Re: ORA-12154 connecting to 9i on XP

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 17 Nov 2004 21:26:28 +1100
Message-ID: <419b2753$0$27445$afc38c87@news.optusnet.com.au>


Comments inline
HJR news.west.cox.net wrote:
> Hi All:
>
> I installed 9.2.0.3 on XP Home Edition SP2 -

Oracle is not certified for XP Home, only for XP Professional. So Lord knows whether you are encountering problems due to that or not.

>THE DBCA had trouble
> completing...

There's your first clue.

> so i created a database manually from a DOS Window and also
> installed the example schemas - At that point i was able to connect from a
> DOS Window to all schemas - And then i either changed the tnsnames and
> listener.ora
>
> Now when i try to connect i'm getting a ORA-12154 TNS:could not resolve
> service name

Straightforward. The entry you're making in the "@xxxxx" bit of your connection string doesn't match what's in your tnsnames.ora.

Regrettably, the one bit of information you don't include in your post is what your connection string actually looks like!!

If your tnsnames.ora really has an entry of:

SB9205 =

    (DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = F85DV51))(PORT = 1521))

...then you should be attempting to connect like so:

sqlplus scott/tiger_at_sb9205

Unless your sqlnet.ora actually has a line it called "names.default_domain=xxx", in which case that connection string will actually be interpreted as a connection to "sb9205.xxx", for which you have no entry in your tnsnames.

The sqlnet.ora you post here shows no such entry of course. But then I don't know what you're typing as your connection string either!

Incidentally, why is your tnsnames alias "9205" when you post that your database is on 9.2.0.3? It's little discrepancies like that which make me worry I'm not being told the entire picture.

> The home pc is connected to the internet through a cable modem - When i ping
> to the server i get the router IP address.

Which may or may not be an issue. But whether your networking setup is stuffed or not is irrelevant at this juncture. Your problem is that Oracle isn't even attempting to get out to the network, because the error message you quote means it doesn't have the first clue about what you're attempting to connect to.

> When i tnsping it never returns and the computer becomes extremely slow. I
> finally have to cancel out.
>
>
> C:\ora_base\ora92\admin\SB9205\scripts>tnsping SB9205

And that's the correct alias to use, according to the tnsnames.ora file you mention later on.

> TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on
> 11-NOV-20
> 04 01:02:28
>
> Used parameter files:
> C:\ora_base\ora92\network\admin\sqlnet.ora
>
>
> Used TNSNAMES adapter to resolve the alias
> Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL =
> TCP)
> (HOST = F85DV51))(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = SB9205))
And that indicates that tnsping has no problem resolving the alias. Yet you quote an error message that makes it abundantly clear that Oracle can *not* resolve the alias.

There's an internal contradiction in the content of your post which I can't work out.

I think you are quoting an error message from one incident which is not the error condition you're experiencing now. If the connection attempt hangs, but tnsping has no problems resolving the alias, you cannot be experiencing 12154 errors.

And I suggest you make sure you are not running a firewall such as Zone Alarm, and that the XP built-in firewall is switched off.

Can I also suggest that you stop running Oracle on domestic operating systems? It's doing so that causes these sorts of problems. Try http://www.dizwell.com/html/virtual_oracle__linux_.html for a different approach.

Regards
HJR Received on Wed Nov 17 2004 - 04:26:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US