Re: Can't TNSPing XE database

Am 01.06.2014 15:40, schrieb Mladen Gogala:
> On Tue, 27 May 2014 12:13:31 -0700, patelrahul766 wrote:
>
>> When i am trying to connect my JDBC Driver it is showing ORA 12170: TNS
>> Connect timeout occurred.
>> I am not able to fix this any help.
>>
>> My Sqlnet.Ora file is almost empty.
>> and when i was doing tnsping XE the output is like ======
>>
>> C:\Users\RAHUL>tnsping XE
>>
>> TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0 - Production on
>> 28-MAY-2 014 00:37:25
>>
>> Copyright (c) 1997, 2010, Oracle. All rights reserved.
>>
>> Used parameter files:
>> D:\oraclexe\app\oracle\product\11.2.0\server\network\admin\sqlnet.ora
>>
>>
>> Used TNSNAMES adapter to resolve the alias Attempting to contact
>> (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = RAHUL-PC )(PORT =
>> 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
>>
>>
>>
>> it's keep going, never ends.
>> Any help
>
> 1) It's probably looking for the name RAHUL-PC. Try looking it up with
> nslookup. Most of the modern ISP's return address of their own "last
> resort host" instead of failure, when the host is not found.
> 2) Your path names are all wrong. Instead of "D:\oraclexe\app", the path
> name should look like "/usr/lib/oracleXE". Please install VMWARE_PLAYER
> on you PC and then use a Red Hat derivative to install the express
> edition RPM's.
>
>
>
Did you change your computername?
'hostname' will give you the answer.
Firewall? Please turn it off.

Best regards

--