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: