Thursday, October 13, 2016

Create Windows Instances on Oracle Infrastructure as a Service - Step By Step

In this post we will see how we can create Windows Instances on Oracle IaaS (Infrastructure as a Service) with desired Image (Windows Version) , Compute , Memory , Disk as well as enabling Remote Desktop service. At last we will enable RDP Connections to the instance and will try to connect.

Lets Get started.

Login to the cloud portal using Identity domain, Username & Password Information. Go to Compute service console. Click Instances and click create instance.



Click on MarketPlace to search for Windows Image.



Monday, June 13, 2016

Create Oracle Cloud Database Connection in Jdeveloper 12.2.1

While doing development on J2EE and ADF very often it is needed to create Oracle Database Connection from Jdeveloper. Jdeveloper provides a wonderful easy window to create and manage multiple Database Connections.

Since the environments have started to move to Cloud much often it is required to create Database Connection for the Oracle Database which is hosted on Oracle Database Cloud Service (DBCS).

There was no way to create SSH Tunnel in Jdeveloper and one has to tunnel the traffic using Putty or SSH command and then use the localhost in jdeveloper database connection window to create successful connection to Database on Cloud.

Jdeveloper 12.2.1 solved this problem by providing a very nice SSH Tunnel window in Database Connections Set up. This SSH Tunnel Configuration can be used to do configure the tunnel and use SSH Public key and user to create the connection.

Below is the process for creating a successful Database Cloud Instance connection from Jdeveloper 12.2.1

On clicking + sign for adding new connection, below window pops up.


Sunday, April 10, 2016

OTNYathra - 2016 - AIOUG

OTNYathra event is back this year in 2016 and once again AIOUG (All India Oracle User Group) is privileged to organised this event in various parts of the Country.

OTNYathra is very typical form of series of conferences which starts from North India and covers throughout India in couple of weeks.

This year again we have very experienced speakers and we expect to have loads and loads of information on new oracle offerings and oracle's roadmaps.

The regional chapters of AIOUG will have responsibilities for organizing the event in their respective cities.

North part of OTNYathra will be managed by NIAIOUG(North India chapter of AIOUG). The event will be held on 1st of May in Noida.


Monday, April 4, 2016

Alert in Oracle Public Cloud - Notifications on Quota

There are new updates in Oracle Public Cloud portal. Now there are new Alerts which lets one set notifications for the quota usage. These notifications are both for Metered as well as Subscription based Non Metered PaaS services.

Below are the steps to set Alerts and notifications in Cloud Public Portal for PaaS Services.

Step 1 : On the Dashboard, Click on Estimated Balance of the services for which you want to set new alert.





Step 2 : Check the Amount for Database Public Cloud Service. This is total available credits. Suppose this is X amount. We will set an alert on 80% of X.

Thursday, March 3, 2016

Oracle Public Cloud - Test Throughput from Customer Place to Data Center

Most common question in mind while going to cloud is to get statistics for latency and throughput from customer location to the Data Centers based in different geography’s e.g. (US – Chicago and Ashburn ).


Below is the way to get the numbers of throughput and latency from tooling provided by OPC Interface.


Step 1 : Click on the user name and select Diagnostics.



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.