Using a connection string without the need to have a correct tnsname.ora on your computer is especially useful for ad hoc scripting on many different database instances, or when you are not sure if the user has a correct tnsnames.ora on his computer.