• 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@

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


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