- Arun Kumar
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