Search
  • Arun Kumar
    • 1 min read

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

137 views

Recent Posts

See All

MySQL Installation on Linux

This article demonstrates MySQL installation on Oracle Enterprise Linux 6.5 version. Installation of MySQL Make sure you are able to connect internet via virtual machine. Try to ping google.com and pr

118

Add ISO image storage repository on XenServer

If you have used VMware ESXI, its very easy to upload ISO files to the data store and create VMs. With XenServer, you must create your own ISO repository to upload ISO files. Create ISO directory Acce

117

Automate RMAN Backup using Shell Script

In a real environment, off course you will not manually trigger all the Oracle database backups. You need an automated mechanism to trigger RMAN backups. In this article we will look at RMAN backup au

2,137
  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis