Connecting to EBS Database in Oracle Cloud using SQL Developer


Based on some user requests, I am posting this to show to how to connect to Oracle EBS Database running in Oracle Cloud. I have already done below:

  • Launched EBS 12.2.9 Instance using Oracle Image in Oracle Cloud
  • Completed running hostname , running
  • Started the EBS database

You can see detailed instruction to Launch EBS instance in my previous post:

[oracle@apps 19.0.0]$ sqlplus '/as sysdba'
SQL*Plus: Release - Production on Sun May 24 15:57:36 2020
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release - Production
SQL> select instance_name,status from v$instance;

ebscdb OPEN

Firstly, open the Database Port from the VM using opc user as below:

[opc@ebs1229 ~]$ sudo firewall-cmd --permanent --add-port=1521/tcp

Now, add a security rule to access 1521 port in the specific subnet

Now open the SSH tunnel port as below using putty or mobaxterm

Use SQL developer to connect to the localhost:1521 using the credentials as below. Remember that the new image of EBS 12.2.9 is coming with 19c (CDB) so you need to connect to the PDB i.e. ebsdb not ebscdb.


Please enter your comment!
Please enter your name here