Steps for converting oracle cloud environment private key to ssh private key

Note: Get the private key from oracle cloud instance to local

Open puttygen

Click on load and browse the private key

Click ok

Click on save private key

Click on yes

Steps for Connecting Oracle cloud database from sqldeveloper

Note: Get the private key from oracle cloud database instance (privateKey)

Open sqldeveloper

Under View select SSH

Right click on SSH hosts and click on New SSH Host

Provide name, host and browse the private key file and click on ok

Test the newly created ssh host connection

Right click on the newly created ssh host connection and 

click on new local port forward

Give name, host and port and click on ok

Right click and click on connect to connect the ssh host

Now connect the oracle cloud database as below

Test the connection

Click on connect to connect the database

Installing Oracle Analytics Cloud Developer Client Tool

Downloading the software:

Download the software from below link:

http://www.oracle.com/technetwork/middleware/oac/downloads/oac-tools-4392272.html

Right click on the setup file and run as administrator

Click Next

Provide home directory path to install and

Click next

Click install

Wait until the process got completed

Click next

Click finish

ERROR: Failed to create collection 'myhdfscore1' due to: create the collection time out:180s

When trying to create a collection in solr getting the below error

"ERROR: Failed to create collection 'myhdfscore1' due to: create the collection time out:180s"

To resolve this

Login to ambari console and stop Ambari infra

Stop Zookeeper

Start Zookeeper 

Start Ambari Infra

Now try to create the collection again

Integrating solr with banana in hortonworks

Download and extract banana

https://github.com/lucidworks/banana.git

Copy banana folder to $SOLR_HOME/server/solr-webapp/webapp/

Creating a collection for banana:

banana url:

http://localhost:8886/solr/banana/src/index.html#/dashboard

Postgresql on linux

By default, we will get postgresql on Linux installation

Check for the status of postgresql service as below

Before starting the postgresql service initialize the database as below

Enable the firewall for postgresql as below

Start the service and check for the status as below

Now postgresql is up and running.

Granting permissions for root user to run postgresql

Steps for creating postgresql user:

Change to postgres user and run the below command

$createuser --pwprompt

Give username and password and enter "y" and click enter

Creating postgresql database:

Now we can create postgresql database as a root user as below

Connect to the newly created database as below: