INSTALLATION DOCUMENTS BY RAVI

Monday, March 26, 2018

How to skip prerequisite check while installing oracle softwares on linux operating system

Installing obiee software on linux throwing prerequisite check failed error














To install the software by ignoring the prerequisite check , issue the command as below
























Sunday, March 25, 2018

Running 32 bit software on Linux 64 bit operating system

Installing NIFI

Downloading the software














Extracting the software















Configuring Nifi


Open nifi.properties for updating configurations























Save and close the file

Starting the Nifi server


















Connect to Nifi data flow management url in your browser: http://localhost:8090/nifi/























Disable Archive Log Mode in Oracle Database

Connect to the database










Checking for the database log mode and its status







To disable the archive log mode shutdown the database first




Now start the database in mount








Now alter the database to non archive log mode






Now open the database






Check for the database log mode and its status now







java.lang.OutOfMemoryError: Java heap space, Running OOM killer script for process 11420 for Solr on port 8983, hortonworks

In Hortonworks cluster environment Ambari Infra Solr service failed to start with below error:


# java.lang.OutOfMemoryError: Java heap space
# -XX:OnOutOfMemoryError="/usr/lib/ambari-infra-solr/bin/oom_solr.sh 8983 /var/log/ambari-infra-solr"
#   Executing /bin/sh -c "/usr/lib/ambari-infra-solr/bin/oom_solr.sh 8983 /var/log/ambari-infra-solr"...
Running OOM killer script for process 11420 for Solr on port 8983
Killed process 11420



Resolution:

To resolve this

1. Login to Ambari management console.
2. Goto Ambari Infra
3. Click on Configs
4. Under settings tab increase the Infra Solr Minimum and Maximum heap size and click on save.
5. Start the service now.






















Sunday, March 11, 2018

How to automatically start mysql after server reboot linux machine


If we want mysql server to start automatically on reboot

Issue the below command:


chkconfig --level 345 mysqld on






Reboot the machine and check now.


Error: Could not contact Elasticsearch at http://localhost:9200. Please ensure that Elasticsearch is reachable from your system

Error: Could not contact Elasticsearch at http://172.16.10.53:9200. Please ensure that Elasticsearch is reachable from your system

Getting above error when we open Kibana console














Resolution:


Navigate to $ELASTICSEARCH_HOME/config



Open elasticsearch.yml and add lines below

script.disable_dynamic: true
http.cors.enabled: true
http.cors.allow-origin: "/.*/"























Close and save the file

Restart the elasticsearch and reopen kibana console











































SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...