Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Error: Could not Resolve the Connect Identifier

By: FYIcenter.com

(Continued from previous topic...)

What Happens If You Use a Wrong Connect Identifier?

Of course, you will get an error, if you use a wrong connect identifier. Here is an example of how SQL*Plus react to a wrong connect identifier:

SQL> CONNECT fyi/retneciyf@WRONG;
ERROR:
ORA-12154: TNS:could not resolve the connect identifier
   specified

Warning: You are no longer connected to ORACLE.

What you need to do in this case:

  • Check the CONNECT command to make sure that the connect identifier is entered correctly.
  • Check the tnsnames.ora file to make sure that the connect identifier is defined correctly.
  • Check the tnsnames.ora file to make sure that there is no multiple definitions of the same connect identifier.
  • Check your files system to see if you have multiple copies of tnsnames.ora in different Oracle home directories, because you installed multiple versions of Oracle. If you do have multiple copies, make sure your SQL*Plus session is picking up the correct copy of tnsnames.ora.

(Continued on next topic...)

  1. What Is SQL*Plus?
  2. How To Start the Command-Line SQL*Plus?
  3. How To Get Help at the SQL Prompt?
  4. What Information Is Needed to Connect SQL*Plus an Oracle Server?
  5. What Is a Connect Identifier?
  6. How To Connect a SQL*Plus Session to an Oracle Server?
  7. What Happens If You Use a Wrong Connect Identifier?
  8. What To Do If DBA Lost the SYSTEM Password?
  9. What Types of Commands Can Be Executed in SQL*Plus?
  10. How To Run SQL Commands in SQL*Plus?
  11. How To Run PL/SQL Statements in SQL*Plus?
  12. How To Change SQL*Plus System Settings?
  13. How To Look at the Current SQL*Plus System Settings?
  14. What Are SQL*Plus Environment Variables?
  15. How To Generate Query Output in HTML Format?
  16. What Is Output Spooling in SQL*Plus?
  17. How To Save Query Output to a Local File?
  18. What Is Input Buffer in SQL*Plus?
  19. How To Revise and Re-Run the Last SQL Command?
  20. How Run SQL*Plus Commands That Are Stored in a Local File?
  21. How To Use SQL*Plus Built-in Timers?
  22. What Is Oracle Server Autotrace?
  23. How To Set Up Autotrace for a User Account?
  24. How To Get Execution Path Reports on Query Statements?
  25. How To Get Execution Statistics Reports on Query Statements?

Oracle Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...