Once the oracle cloud database is ready, next step is to test the database and server connectivity.

Access SSH Access via Putty

  • Login to your DBCS Console Page  and click instance you intend to login into via SSH. And then locate the Public IP address.Capture11
  • Open putty.exe and place the Public IP Address in the Host Name for Putty.

 

Capture10

  • Under the Category section navigate to Connection – SSH – Auth, Click Browse on the Auth page to locate your putty private key file (.ppk extension).

Capture12

  • Now under the Category section navigate to Connection – Data, Put oracle as the Auto-login username.

Capture13

  • Navigate back to Session and click Save.
  • Now open the putty connection.Capture14

SQL Developer Access

  • Open SQL Developer on your local machine.
  • Start new connection and fill in information like Host IP address, default port 1521 and Database name.
  • Test the connection, but it’ll fail with an network adapter error.

Capture15

  • To fix network adapter issue, Click on the Database Cloud Service menu in  icon and choose “Access Rules”.

Capture14

  • Enable the “ora_p2_dblistener” access rule, by clicking the icon under Actions. And enable the access rule.

Capture16

  • Re-test the connection. I fix the SID from CDB1 -> CDB01 and now able to connect to the database.

Capture17

SQL Developer Access using SSH

In SQL Developer menu, click on View –> SSH. Then right click and choose “Create New SSH Host”. Add Host public IP , username and Private key. Tick on local port forward.Press ok.

Capture18

Make a new connection database connection with Sql developer.Use service name. check active services at database PDB level.

SQL> select name, open_mode from v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB$SEED READ ONLY
PDB01 READ WRITE
SQL> alter session set container=PDB01;
Session altered.
SQL> select name from v$active_services;
NAME
----------------------------------------------------------------
pdb01.587235808.oraclecloud.internal
  • Enter detail as below and test the connectivity. And its successful.

Capture19

I hope this article is helpful for you!!!

Mandy

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s