Shulou(Shulou.com)06/01 Report--

How to understand the EZCONNECT parameters and Easy Connect Naming Method methods in sqlnet.ora files? in view of this problem, this article introduces the corresponding analysis and solutions in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

If the tnsnames.ora file is not fully configured, you can also use Oracle's Easy Connect Naming Method method to test whether the database is accessible.

The principle and detailed usage of this method are not described here, and this information can be obtained through the following Oracle connection.

Http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/naming.htm#i498306

Or visit subordinate articles directly for reference.

Net Services Administrator's Guide-2 Quick Start to Oracle Net Connections-Task 3: Configure the Client for Connection to a Database

Net Services Administrator's Guide-8 Configuring Naming Methods-Using the Easy Connect Naming Method

Simply list the syntax of this method for reference.

CONNECT username/password@host [: port] [/ service_name] [/ instance_name]

CONNECT username/password@ [/ /] host [: port] [/ service_name]

This article would like to emphasize that if you want to use the Easy Connect Naming Method method to test database connectivity, you need to add "NAMES.DIRECTORY_PATH= (EZCONNECT)" information to the sqlnet.ora file, otherwise this feature will not be available.

Location of the 1.sqlnet.ora file

This file is in the same directory as the listener.ora and tnsnames.ora files, specifically $ORACLE_HOME/network/admin.

two。 Learn from the experience of reporting mistakes

If the Windows client does not configure the corresponding parameters, you will receive the following error:

C:\ Users\ secooler > sqlplus sec/sec@10.17.193.211:1521/ora10g

SQL*Plus: Release 10.2.0.3.0-Production on Monday August 2 21:19:01 2010

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR:

ORA-12154: TNS: unable to parse the specified connection identifier

Please enter a user name:

ERROR:

ORA-12560: TNS: protocol adapter error

Please enter a user name:

ERROR:

ORA-12560: TNS: protocol adapter error

SP2-0157: unable to connect to ORACLE after 3 attempts, exit SQL*Plus

C:\ Users\ secooler >

If the sqlnet.ora file on the Linux server does not set the corresponding parameters, you will receive the following error:

Sec@secdb / home/oracle$ sqlplus sec/sec@10.17.193.211:1521/ora10g

SQL*Plus: Release 10.2.0.3.0-Production on Mon Aug 2 21:21:34 2010

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR:

ORA-12154: TNS:could not resolve the connect identifier specified

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

The two kinds of error content are the same, from the error prompt, it is difficult to locate directly due to sqlnet.ora file configuration problems. This requires us to have a deep understanding of the principle of Easy Connect Naming Method.

3. Add "EZCONNECT" information to the sqlnet.ora file to resolve the problem

The word "EZCONNECT" is easy to understand and can be pronounced as "Easy Connect". From then on, this parameter will no longer be unfamiliar.

Sec@secdb / home/oracle$ cat $ORACLE_HOME/network/admin/sqlnet.ora

# sqlnet.ora Network Configuration File: / oracle/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)

Attempt to connect after adding parameters, successful.

Sec@secdb / oracle$ sqlplus sec/sec@10.17.193.211:1521/ora10g

SQL*Plus: Release 10.2.0.3.0-Production on Mon Aug 2 21:31:50 2010

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0-64bit Production

With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options

Sec@ora10g >

Oracle provides many Easy Connect Naming Method tips similar to those mentioned in this article. It is recommended that you fully understand the prerequisites and constraints of tool use before using these convenient methods, so that you can improve efficiency without bringing too many obstacles.

On how to understand the sqlnet.ora file EZCONNECT parameters and Easy Connect Naming Method method questions shared here, I hope the above content can be of some help to you, if you still have a lot of doubts have not been solved, you can follow the industry information channel to learn more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.