Connecting to EBS Database in Oracle Cloud using SQL Developer

2
1272

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 apps.example.com , running updatehosts.sh
  • 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 19.0.0.0.0 - Production on Sun May 24 15:57:36 2020
Version 19.6.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.6.0.0.0
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS

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
success

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.

2 COMMENTS

  1. Hi Vishnu.
    small help needed. i have installed oracle 12c database in oracle free tier cloud not able to connect with sql developer.
    my hostname details-
    Listening Endpoints Summary…
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=instance-20191224-1131.subnet.vcn.oraclevcn.com)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
    Services Summary…
    Service “cdb2” has 1 instance(s).
    Instance “cdb2”, status READY, has 1 handler(s) for this service…
    Service “cdb2XDB” has 1 instance(s).
    Instance “cdb2”, status READY, has 1 handler(s) for this service…
    Service “pdb2” has 1 instance(s).
    Instance “cdb2”, status READY, has 1 handler(s) for this service…
    The command completed successfully

    CON_ID CON_NAME OPEN MODE RESTRICTED
    ———- —————————— ———- ———-
    2 PDB$SEED READ ONLY NO
    3 PDB2 READ WRITE NO
    i have added the port 1521 in ingress rule to allow.

    • Sorry! Missed your comment.
      1. Open port
      2. Create SSH tunnel using localhost:1521. Try telnet localhost 1521. If this works then you are ready to connect.
      3. Then use SQL developer to connect

LEAVE A REPLY

Please enter your comment!
Please enter your name here