Re: Connect To Oracle Using Easy Connect (NAMES.DIRECTORY_PATH in sqlnet.ora)
Date: Thu, 6 Aug 2009 11:25:40 -0500
Message-ID: <eb64345d0908060925t27dfbf7cra2a78cb8cbc9c1a_at_mail.gmail.com>
Bingo! After I modified it to NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT), it works!
H:\>sqlplus tsdba/roadnet_at_bplnap11:1527/UPS60D0 SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 6 11:20:25 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> select SYS_CONTEXT('USERENV','DB_NAME') from dual;
SYS_CONTEXT('USERENV','DB_NAME')
ups60d0
SQL> Thank you so much Wang Tao and everyone else.
Roger
On Thu, Aug 6, 2009 at 11:01 AM, Wang, Tao <twang_at_iso-ne.com> wrote:
> check the NAMES.DIRECTORY_PATH in sqlnet.ora.
>
>
>
> FYI:
>
>
>
> NAMES.DIRECTORY_PATH
>
> This parameter specifies the order of naming methods Oracle Net can use to
>
> resolve connect identifiers to connect descriptors.
>
> By default, when this parameter is not set in sqlnet.ora, all naming
> methods
>
> (including Easy connect naming) are enabled for Net name resolution. In
> other
>
> words, Easy connect naming is available and used by default.
>
> If this parameter is set, please ensure that EZCONNECT is specified as one
> of the
>
> values in order to use Easy connect naming method.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Roger Xu
> *Sent:* Thursday, August 06, 2009 11:22 AM
> *To:* Oracle-L_at_freelists.org
> *Subject:* Connect To Oracle Using Easy Connect
>
>
>
> *Good Morning List,*
>
>
>
> *Do you know why the SQL*PLUS easy connect below failed with ORA-12154?*
>
>
>
> H:\>sqlplus tsdba/xxxxxx_at_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_at_bplnap11:1527/UPS60D0*<tsdba/xxxxxx_at_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)
> )
> )
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 06 2009 - 11:25:40 CDT