Re: ORA-12154 connecting to 9i on XP

In case someone is trying to get 9i working on XP home....

Finally found time to do some troubleshooting myself instead of hoping for a free answer... Disabled all the security software and set the SID and Oracle home is a DOS window and connected without giving the connect string. When i connect as sqlplus system/manager_at_sb9205 i still get the ORA-12154 (error copy/pasted) but with out the connect string i can get in.

C:\ora_base\ora92\bin>sqlplus system/manager

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Nov 18 21:18:05 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

21:47:37 SYSTEM_at_SB9205> XP home being uncertified i may have to stick to the DOS window for a while until i have to time to troubleshoot, but this will let me do some destructive testing i was hoping to do

Thanks,
Tom

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:419c6f87$0$27451$afc38c87_at_news.optusnet.com.au...
> news.west.cox.net wrote:
>> 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?
>
> Buy a Windows XP for Dummies book.
>
> And next time, don't tell me what you think "seems reasonable". Just stick
> to reporting the facts, and learn to cut and paste from command line
> sessions so we can see what the facts are for ourselves.
>
> HR
Received on Thu Nov 18 2004 - 23:05:52 CST