Dear Sir,

Could anyone point out the reason for the errors that I get:

SQL> sho user
user is "DCBL"
SQL> connect sys/change_on_install@dcbl as sysdba
ERROR:
ORA-12154: TNS:could not resolve service name


Warning: You are no longer connected to ORACLE.
SQL> connect dcbl/dcbl@dcbl
Connected.


You can see that Iam not able to connect as sysdba but as user DCBL for the same service. This happens while trying to connect through SQLPLUS on my PC(Windows).

When I do it through telnet, I get the same error:

SQL> connect dcbl/dcbl@dcbl
ERROR:
ORA-12154: TNS:could not resolve service name


Warning: You are no longer connected to ORACLE.



But through telnet I cannot connect even as the user DCBL as I did so in the previous case.


Could anyone throw some light on this.

Regards,

K.Diwakar