Steps for connecting oracle cloud environment through winscp

Connecting through WinSCP

Note: We need to download the private key and convert it into ssh private key first

Open WinSCP and enter the ip to connect

Browse the ssh private key

Click on open

Click on login

Click yes

Enter the username and click ok

Steps for connecting oracle cloud environment through putty

Connecting through putty:

Note: We need to download the private key and convert it into ssh private key first

Open putty and enter the IP of the cloud database to connect

Under ssh select Auth and browse the ssh private key

Click on open

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