Hi Guys,

i just installe oracle 9i on my home pc windows xp os but I have problem with connecting sql *pluse 9i. i am getting error ORA-12535-TNS-operation time out.I check every thing in listner.ora,tnsname.ora,i can ping machine.i also tried to change listner_timeout = 0 ,i also chnge port from 1521 to 1526 but still nothing but weird thing is that i can connect with database without specifying service name just user name and password.i am not understanding why i can not connect with sql*plue or any thired party product like sqlnave or tode.here is my listner.ora and tnsname.ora file :
# LISTENER.ORA Network Configuration File: C:\oracle\ora90\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WHITE)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = EMPAC)
(ORACLE_HOME = C:\ORACLE\ORA90)
(SID_NAME = EMPAC)
)
)

# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

EMPAC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = WHITE)PORT= 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = EMPAC)
)
)

I also change host name useing my ip address.

Can any one solve my problem ? any oracle guru? that will be apcreciate.

Minesh.