[Previous entry: "An exploit has been published for database security bug DB27"] [Next entry: "My site was on the BBC 1 breakfast - well a picture of a link to it was!"]
Easy connect identifier
October 20th, 2005 by Pete
Post to del.icio.us
Post to Furl
This was a great short post by Sergio that I saw today. Sergio shows us in his post "Learn Something New Every Day: Easy Connect Identifier" how to connect to a remote database without a tnsnames.ora file where any normal connect string can be used except that in this case you also supply the IP Address and the port number and service name as part of the connect string. An example is:
sqlplus pete/finnigan@//127.0.0.1:1521/dev
The components of the syntax are quite obvious. This is a very simple way to connect to remote databases.
