Call: +44 (0)1904 557620 Call
Blog

Pete Finnigan's Oracle Security Weblog

This is the weblog for Pete Finnigan. Pete works in the area of Oracle security and he specialises in auditing Oracle databases for security issues. This weblog is aimed squarely at those interested in the security of their Oracle databases.

[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



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.