ORA-12154

C:\> sqlplus

SQL*Plus: Release 10.1.0.2.0 - Production on Fri Aug 17 12:46:18 2007

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

Enter user-name: system/abc@devdb
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Action:

1. The “net service name” must exist in the tnsnames.ora file. This file is used by clients and database servers to identify server destinations. It stores the service names and database addresses. The “count” parameter is optional and will show the number of times the command should try to connect to the specified service name

2. If tnsping is working well. So there is no problem in your network side.

3. Check out service name.

Thanks & Regards

Babu B