Oracle 10g: EZConnect

It was a pain using SQLPlus to connect to remote database, especially a lot of them, as you need to setup tnsnames.ora etc.
In 10g, EZConnect is much EZier, as the name indicates.
All you need to do is add/modify this to your sqlnet.ora
NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)
And now you can use the following syntax to connect
sqlplus user/password@//host:[port]/service name

Advertisements

One Response to “Oracle 10g: EZConnect”

  1. Ramesh B S Says:

    very informative

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: