Good Contents Are Everywhere, But Here, We Deliver The Best of The Best.Please Hold on!
POSTS PORTFOLIO SEARCH SHOP
PORTFOLIO
SEARCH
SHOP
  • Your Cart Is Empty!
  • +971 52 849 3496
  • +1 512 808 5399
  • +91 988 534 4596
  • +966 54 602 9364
  • +61 420768137

Step 7 – Oracle DBCS : Connecting To a Database Service Using Oracle SQL Developer

By on

January 4, 2018

- Uncategorized

You can connect to the Oracle database in Oracle Cloud using Oracle SQL Developer or similar tool to perform the database operations as you would similar to an on-premises databases. When you create a Database Cloud Service database deployment on Oracle Cloud, by default the Oracle Net Listener port 1521 is Disabled to ensure network security. Use the Oracle Database Cloud Service console to enable access to port 1521 on a compute node to make a SQL Developer connection to the Oracle Database.

 Note: If you DO NOT want to open the Oracle Net Listener port 1521 for security reasons, you can create an SSH tunnel to port 1521 on the compute node associated with Oracle Database Cloud Service. Then you can use SSH client software that supports tunneling. Oracle SQL Developer supports SSH and it can used to create an SSH tunnel to port 1521 on the compute node if you don’t want to enable port 1521 explicitly.

 In this article we will demonstrate how to connect to Oracle Database in Cloud using Oracle SQL Developer Remotely

 This article assumes that Oracle Net Listener port 1521 is enabled. To enable port 1521, follow the steps outline at:
http://netsoftmate.blogspot.in/2018/01/step-6-oracle-dbcs-enable-access-to.html

 Prerequisites
  • IP address of Compute node
  • Enable port 1521 – This port is used by SQL*Net
  • Database Service name
  • Database username and password to connect to the database
  • Download and unzip SQL Developer software. Use the below link to download latest SQL Developer software
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

 Steps to connect to Oracle Database in Cloud using Oracle SQL Developer
  • Open a web browser and enter the URL you received in the Welcome email to login to Oracle Cloud Account
https://myservices-xxxxx-xxxxxxxxxxef4b21bb7ee3b2cf4123d1.console.oraclecloud.com/mycloud/faces/dashboard.jspx
  • Enter your username and password
  • On the home page, Click “Menu” under “Database” Cloud Service as shown below
  • Click “Open Service Console”
  • Click on Service Name. In my case “NSM-DBaaS” is the service name
  • Hover mouse on the “Connect String”, it will pop up the complete Connect String. Copy the Service Name as shown below
  • You can also get the service name of you Container DB and Pluggable DB using “lsnrctl status” Command as shown below
  • Open Oracle SQL Developer on your Desktop/Laptop and Click the Add button
  • Fill in all the details, Connection name, username, password, Host name, Service Name
  • Click “Test” button and make sure the Status is Success
  • Execute some SQL Statement to ensure you can fetch the data from database
  • From  SQL Developer Click “View” menu select DBA to display DBA menu on left pane of SQL Developer
  • Under DBA menu click Add button to add database connection
  • Select a Connection and click OK
  • Navigate to DBA Menu, select your database connection to explore database configuration, status, other DBA options

 Conclusion

 In this article we have learned how to connect to Oracle Database in Oracle Cloud using Oracle SQL Developer remotely. You can connect to the Oracle database in Oracle Cloud using Oracle SQL Developer or similar tool to perform the database operations as you would similar to an on-premises databases. Oracle Net Listener port 1521 should be enabled on the compute node to make a SQL Developer connection to the Oracle Database.

0

Step 6 – Oracle DBCS : Enable Access To A Compute Node Port

By on

January 3, 2018

- Uncategorized

Oracle Database Cloud Service uses access rules to provide secure network access to database deployments. You can use the Oracle Database Cloud Service console to perform network access operations such as enabling and disabling access rules and creating new access rules. 

 Network access to the compute nodes associated with Oracle Database Cloud Service is primarily provided by SSH connections on port 22. When you access a compute node using SSH, you must provide the private key that matches the public key associated with database deployment. To access other network protocols and services may require additional configuration.

 The following rules are created when a database deployment is created. They are set to disabled by default:

  • ora_p2_ssh: Controls access to port 22 and this port is used by SSH client to connect to the compute node. 
  • ora_p2_dbconsole: Controls access to port 1158 and this port is used by Enterprise Manager 11g Database Control.
  • ora_p2_dbexpress: Controls access to port 5500 and this port is used by Enterprise Manager Database Express 12c.
  • ora_p2_dblistener: Controls access to port 1521 and this port is used by SQL*Net.
  • ora_p2_http: Controls access to port 80 and this port is used for HTTP connections.
  • ora_p2_httpssl: Controls access to port 443 and this port is used for HTTPS connections, including Oracle REST Data Services (ORDS), Oracle Application Express (APEX), and Oracle DBaaS Monitor.
To access network protocols and services on a compute node by using a port other than port 22, require additional configuration:
  • Enable network access to the port: Use the Oracle Database Cloud Service console to enable access to a port on a compute node
  • Create an SSH tunnel to the port: Create SSH tunnel enables you to access a specific compute node port by using an SSH connection as the transport mechanism

    In this article we will demonstrate how to Enable Access to a Compute Node Port other than port 22 using Oracle Database Cloud Service console.


    Prerequisites
    • Access to Oracle Database Cloud Service console

    Steps to Enable Ports using Oracle Database Cloud Service Console

    • Open a web browser and enter the URL you received in the Welcome email to login to Oracle Cloud Account
      https://myservices-xxxxx-xxxxxxxxxxef4b21bb7ee3b2cf4123d1.console.oraclecloud.com/mycloud/faces/dashboard.jspx

    • Enter your username and password

    • On the home page, Click “Menu” under “Database” Cloud Service as shown below

    • Click “Open Service Console”

    • Click on Service Name. In my case “NSM-DBaaS” is the service name

      • Click on “Menu” and select “Access Rules”

      • By default only port 22 is enabled and all other ports are disabled for security reasons

      • To enable a port click on “Menu” and select “Enable”. Here I am opening port 1521 used by SQL*Net access

      • Click “Enable”


      • We can see the port 1521 is now enabled

      • Similarly open port 443 used by HTTPS connection as shown below

      • Port 443 is now Enabled

      • Enable port 5500 used by EM Express

      • Port 5500 is now Enabled

      Conclusion
      In this article we have learned how to Enable Access to a Compute Node Port other than port 22 using Oracle Database Cloud Service console. Oracle Database Cloud Service uses access rules to provide secure network access to database deployments. You can use the Oracle Database Cloud Service console to perform network access operations such as enabling and disabling access rules and creating new access rules. 


      0

      ABOUT US

      Netsoftmate is an Oracle Gold Partner and an expert service provider for Oracle Engineered Systems, Databases and Cyber Security. We are headquartered in India with offices spread across North America, Middle-east and SEA.

      Know More

      Privacy Policy | Terms & Conditions

       

      CONTACT US

      India
      Address: Hyderabad, Telangana-500052
      Phone: +91 965 246 5533
      Phone: +91 988 534 4596

      United States
      Address: 228 Bagatelle Road, Melville, NY 11747
      Phone: +1 512 808 5399

      Middle East
      KSA Address: Dabbad Streest, Riyadh, Saudi Arabia
      Phone: +966 54 602 9364
      UAE Address: Nad Al Sheba, Dubai, U.A.E
      Phone: +971 52 849 3496