Custom Search . . .

Friday, August 17, 2007


C:\> sqlplus

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

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

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


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