May 25, 2007

Easy connect naming method

Easy connect name method is very convenient to use. So you do not need to modify tnsnames.ora any more.

The format copied from Oracle doc is as follows:
CONNECT username/password@host[:port][/service_name][/instance_name]

However, the instance_name one did not work during my test.
The service name works. The service name = sid + doman name.(e.g. orcl.xyz.com)

The sqlnet.ora need to be changed as well.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)


- No comments Not publicly viewable


Add a comment

You are not allowed to comment on this entry as it has restricted commenting permissions.

Search this blog

Search Warwick Blogs

 

Tags

Most recent comments

  • Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry
  • All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry
  • "logical standby failed to re–start, I am also getting the same error. I have search on internet and… by anemia on this entry
  • Thanks for the nice information because from last three days i am stuck on this problem…. by robot vacuum on this entry
  • So what happen City speed dating when you tried this coding once in your PC.. Please tell me so i am… by John Bergeron on this entry
Not signed in
Sign in

Powered by BlogBuilder
© MMXXI