• 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


199 views

Recent Posts

See All

Oracle 12c to 19c Database Upgrade

In this article we will be looking at two most commonly used methods of upgrading Oracle database from 12c to 19c Pre-upgrade tasks Upgrade using DBUA Upgrade using Manual Method You can perform a dir

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis