Connect To Oracle Using Easy Connect

  • From: Roger Xu <wellmetus@xxxxxxxxx>
  • To: Oracle-L@xxxxxxxxxxxxx
  • Date: Thu, 6 Aug 2009 10:21:32 -0500

*Good Morning List,*
**
*Do you know why the SQL*PLUS easy connect below failed with ORA-12154?*

H:\>sqlplus tsdba/xxxxxx@UPS60D0
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 6 10:12:37 2009
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
- 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
*H:\>sqlplus 
**tsdba/xxxxxx@bplnap11:1527/UPS60D0*<tsdba/xxxxxx@bplnap11:1527/UPS60D0>
*SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 6 10:13:13 2009*
*Copyright (c) 1982, 2005, Oracle.  All rights reserved.*
*ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified*

*Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
*
Thanks,

Roger Xu

P.S.

tnsnames.ora entry -

UPS60D0 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = bplnap11)(PORT = 1527))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ups60d0)
    )
  )

Other related posts: