Wednesday, July 25, 2018

Installing Oracle Analytics Cloud Developer Client Tool

Downloading the software:

Download the software from below link:

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

Wednesday, July 4, 2018

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

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

Creating a collection for banana:

banana url:

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:

Tuesday, July 3, 2018

Finding files that use the most disk space in linux

Command to list the top 10 largest directories from the current path

du -sh * | sort -hr | head -n10

Database crashed, unable to connect through sqlplus ; ORA-01012: not logged on ; Oracle Instance alive for sid "orcl"

When trying to start the database getting the below error:

ORA-01012: not logged on
Process ID: 0

Session ID: 0 Serial number: 0

To resolve this exit from the database first

Run SYSRESV Utility as below:

Remove damaged Semaphores and shared memory as below:

Try to connect the database now

Command to unzip all the zip files in a directory in Linux

Below is a directory containing 5 zip files

To extract all the zip files at a time run the below command
#unzip \*.zip

  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...