Oracle Database Discussions

Hi all,

I have an Windows XP OS with SP3.
I have installed the Oracle 11g server.

On trying to connect to the ODBC connection, i get the following error message:

Unable to connect SQL State=S1000 [Oracle][ODBC][Ora]ORA-12170: TNS: Connect timeout occured

On trying the tnsping,

TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 09-OCT-2
011 13:11:05

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:
E:\app\Gautam\product\11.1.0\db_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.
5.207)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl))
)
TNS-12535: TNS:operation timed out


On trying to connect with SQL Developer, i get the following error:

Status: Failure - Test failed: Io Exception: The Network Adapter could not establish the connection

However i am able to connect to the same using SQL Plus

Another issue that occurs is that the Oracle Enterprise Manager shows the following error after a while:

Agent Connection to Instance




Status Failed

Details ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)


The following services are all up during this point of time:

OracleDBConsoleorcl
OracleOraDb11g_home1TNSListener
OracleServiceORCL


Any help in this regard will be very useful as this is hindering the progress of my work.

Thanks in advance for the help.

- Gautam