Re: ORA-12154 connecting to 9i on XP

Thanks. My sqlnet.ora does not have a default domain. And i'm using the sb9205 as the connect string, which is why i tested tnsping sb9205. The tnsnames adapter is 'resolving' correctly but tnsping is not succeeding, indicating some sort of 'port blocking'. The error message is correct, ORA-12154 (TNS:could not resolve service name) - tnsping is effectively timing out and the error seems logical.

The problem seems to be one of the pre-installed security software running on my just purchased Dell PC - Norton Internet Security, Norton Anti Virus or some 'built-in firewall' you mentioned. I tried disabling the Norton stuff but i have not been able to bring down whatever is blocking the tnsping from returning with an OK. I'm new to Windows XP and all the security stuff Dell has loaded into the computer and was hoping someone else had dealt with similar problems.

Any suggestions on getting the tnsping to succeed?

Thanks & regards,
- Tom

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:419b2753$0$27445$afc38c87_at_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 - 23:48:56 CST