Oracle Database Discussions

Hi!

I am tired of this problem, hopefully some one could help me out. I was able to login using sqlplus on DB server locally. I installed Oracle client on my workstation and trying to login to the DB on DB server. Its not working. I could not figure out why? I tried the tnsping, and it is working fine.

Any suggestion would be highly appreciated.

regards,
Samatha


********************************* tnsnames.ora file on client ************************
MSD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = romeo.urz.tu-dresden.de)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = GRID)
)
)
******************** sqlnet.ora file on client **********
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

******************** tnsname.ora on DB server **********
GRID =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = romeo.urz.tu-dresden.de)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = GRID.urz.tu_dresden.de)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

*****************************************************
kottha@ite17168:~> sqlplus kottha@MSD

SQL*Plus: Release 10.1.0.3.0 - Production on Tue May 16 16:27:48 2006

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name: kottha
Enter password:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


Enter user-name: kottha
Enter password:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
kottha@ite17168:~>
kottha@ite17168:~> tnsping romeo.urz.tu-dresden.de

TNS Ping Utility for Linux: Version 10.1.0.3.0 - Production on 16-MAY-2006 16:32:09

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

Used parameter files:
/home/oracle/OraHome_1/network/admin/sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=romeo.urz.tu-dresden.de))(ADDRESS=(PROTOCOL=TCP)(HOST=141.30.60.31)(PORT=1521)))
OK (10 msec)
kottha@ite17168:~>

Message was edited by:
user510219