Oracle Easy Connect Method

At times you will have a requirement to connect an remote Oracle database without a TNS entry. In such situation you will be using the Oracle easy connect method to connect Oracle database servery

Easy connect syntax

With easy connect method you provide userid, password, hostname, port number and database service name all in one single command.

sqlplus user/password@//hostname/service_name

Easy connect example

To connect a server with ip address

sqlplus scott/tiger@10.25.35.2/testdb

To connect a server with hostname

sqlplus scott/tiger@//sapdev.company.com/devdb

To connect a server on non default port 1621 (other than 1521)

sqlplus scott/tiger@//sapdev.company.com:1621/devdb