Oracle 10g Easy Connect Naming
Easy connect naming is not allowed in large or complex environments that require additional connect information. (Large or complex environments employ advanced features, such as connection pooling, external procedure calls, or Heterogeneous Services.) In these cases, you must use another naming method.
With Oracle 10g, easy connect naming is automatically configured by default at installation. However, before attempting to use this feature, you may want to ensure that EZCONNECT is specified first in the names.directory_path parameter in the sqlnet.ora file. The names.directory_path parameter is used to specify the order of naming methods that Oracle Net can use to resolve connect identifiers to connect descriptors. Verification is easy. To verify that the names.directory_path settings are correct, follow these instructions:
Start Oracle Net Manager.
In the navigator pane, expand Local > Profile.
From the list in the right pane, select Naming.
Click the Methods tab. Ensure that EZCONNECT is listed in the Selected Methods list. If it is not, then proceed to Step 5.
From the Available Methods list, select EZCONNECT, then click the right-arrow button.
From the Selected Methods list, select EZCONNECT, then use the Promote button to move the selection to the top of the list.
Choose File > Save Network Configuration. The sqlnet.ora file updates with the names.directory_path parameter, listing ezconnect first: names.directory_path =(ezconnect, tnsnames).