Monday, November 23, 2015

AIOUG Sangam 15 - My Experience

This time once again I attended Sangam15 - Largest Oracle User Group Conference in India which is organized every year. This time it was in Hitec City in Hyderabad at Hyderabad International Convention Center on 21-22 Nov 2015.

It was very nice to see and meet old friends as well as meet new professionals. The event was very well managed by @AIOUG Team and volunteers from different regional chapters of AIOUG. The venue was perfect with large halls and rooms and logistics/facilities very nicely handled by the convention center staff.

I flew in to Hyderabad from Singapore a night before rather 21st morning 2.30am. So I was unable to had a complete sleep which made me unwell and I went late on the venue. Nevertheless I was all set for my session on Oracle Mobile Application Framework.

Friday, November 13, 2015

Connecting Oracle PDB on Cloud using SQL Developer

In this post we will see how we can connect to Pluggable Database which is hosted on Oracle PaaS Cloud : Database as a Service.

As we know Pluggable databases is a new features in Oracle 12c Database so we will be using Oracle 12c Database on Oracle Database Cloud.

Pre Requisites :

  • Oracle Public Cloud environment Access.
  • Oracle Database as a Service subscription.
  • Oracle 12c Database Instance created on OPC.
  • Combination of Public key(required to create 12 instance in above step) and private key to access 12c DB instance using client - Putty and SQL Developer.
  • Passcode of keys.
  • Putty
  • SQL Developer.

Once we have all the information available we are all set to make a connection to PDB on cloud from local SQL Developer.

To connect to PDB, first we need to have a user created if not created already which has access to PDB.

For this connect to DCS cloud environment using putty. 

Enter the public IP in the putty.