Re: Can't TNSPing XE database

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.

--