Oracle Database Discussions

My installation is as follows:

Server: Oracle Linux 5.6 with latest updates through ULN
Client Windows Xp proffesional with Oracle Tools installed

Oracle Database: 11.2.0.1.0

listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1522))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
(SID_NAME = test)
)
)
ADR_BASE_LISTENER = /u01/app/oracle


sqlnet.ora

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
#NAMES.DEFAULT_DOMAIN = LOCALDOMAIN
ADR_BASE = /u01/app/oracle


tnsnames.ora (in windows xp)
test =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP) (HOST= 192.168.56.1) (PORT=1522))

(CONNECT_DATA =
(SERVICE_NAME = test)
)
)

from windows xp i can ping the server, i can telnet the 1522 port, so its not a matter of network connectivity.
Also in windows xp i set the variables ORACLE_HOME to c:\OCT and TNS_ADMIN to c:\OCT\network\admin where i have my tnsnames.ora file.
I updated the PATH variable and in the very beggining i put the c:\OCT path.

if i tnsping test (in server) i get a reply
if i try to login using sqlplus from the client i get ORA-12504 TNS: listener was not given the SERVICE_NAME in CONNECT_DATA ( but as you see i did)

if i try to login with navicat with connection type TNS i get ORA-01034and ORA_27101
if i try to login with navicat and connection type BASIC i can connect!

The issue is with TNS because i need to use it with a specific service that needs TNS.

Any ideas of how to resolve that ?

Edited by: 865269 on Jun 11, 2011 2:20 PM