INSTALLATION DOCUMENTS BY RAVI

Thursday, July 27, 2017

mysql server on linux

1. Checking the status of mysql server

Open the terminal and run the below command to check the status of the mysql server






2. Starting mysql server

Run the below command to start the mysql server
























3. Setting a password for mysql root user

To set the password for linux root user run the below command



4. Connecting to the mysql server as a root user











5. Granting privileges to mysql server to connect remotely





6. Binding ip address and port no for mysql server

Under /etc modify my.cnf file as below
























Steps for clearing the history in linux terminal

1. Command to check the history

Open a terminal and type the command "history" and click enter



















It will give the history of all commands which we used

2. Command to clear the history

To clear this history in the terminal type the command "history -c" and click enter




3. Now again check for history it will show nothing






Steps to start history server in hadoop

Navigate to $HADOOP_HOME/sbin and start the history server as shown below
















Hadoop history server started and we can check it in the out log mentioned in above screen

Job History url :

http://localhost:19888/jobhistory

Through the above url we can check the history of the jobs



















Friday, July 14, 2017

Starting and stopping Apache hadoop and yarn

Starting Hadoop

Login to server through putty
Change to hadoop user
Navigate to HADOOP_HOME/sbin directory
Start hadoop using the command start-dfs.sh command
















Now check the started nodes by using jps command as below






Check the nodes information by this url http://hostname:50070




















Starting Yarn

Login to server through putty
Change to hadoop user
Navigate to HADOOP_HOME/sbin directory
Start yarn using the command start-yarn.sh command










Now check the started nodes by using jps command as below







Check the nodes information by this url http://hostname:8088




















Stopping yarn

Login to server through putty
Change to hadoop user
Navigate to HADOOP_HOME/sbin directory
Stop yarn using the command stop-yarn.sh command









Stopping hadoop

Login to server through putty
Change to hadoop user
Navigate to HADOOP_HOME/sbin directory
Stop hadoop using the command stop-dfs.sh command















Cloudera Apache Hadoop Web UI Urls

Name Node url

http://hostname:50070


All Applications Hadoop

http://hostname:8088/cluster


Hive web url

http://hostname:10002/hiveserver2.jsp


Hue web url

http://hostname:8888


Oozie web console

http://hostname:11000/oozie


Spark history server

http://hostname:18088


Yarn job history server

http://hostname:19888/jobhistory




Sunday, July 2, 2017

OBIEE and OBIA Version History

OBIEE based on Siebel Business Analytics which was first developed by nQuire in the year 1997

Please find the major version releases below :


2001: nQuire acquired by Siebel
Siebel Analytics 7.0 – 2002
Siebel Analytics 7.5 – 2003
Siebel Analytics 7.7 – 2004
Siebel Analytics 7.8.2 and 7.8.3 – 2005
Siebel Analytics / Oracle Business Intelligence 7.8.4 and 7.8.5 – 2006

Please find the OBIEE versions releases below :













Please find the OBIA versions releases below :































Thursday, June 29, 2017

Step by step Oracle SOA suite installation windows

Prerequisites:

1.  64-bit operating system.
2.  Java 7 SDK (1.7.0_55+) (64 Bit)
3.  RAM 4 GB

4.  Database Oracle (12.1.0.1+; 11.1.0.7+; 11.2.0.3+)


Installing Oracle Database :


























In the welcome screen click next
















In the license agreement screen accept the license and click next

















Choose the destination location and click next













Enter the passwords that you would like provide fro the XE Database and click next



























In the summary screen click next


































Click finish to complete the database installation

Installing SOA:

Unzip the Oracle SOA Suite 12c that we have downloaded











Start the installation from command prompt


























In the welcome screen click next















Provide the installation location and click next

















If the prerequisite check got succeed click next















In the installation summary screen click install
















If the installation progress got 100% click next






























Click finish to complete the installation






















Rcu Creation:

Navigate to ORACLE_COMMON_HOME\bin directory and run the rcu



















In the welcome screen click next















Select create repository and click next














Provide the database details and click next
















Click ok








Give the prefix and select soa suite and click next
















Click ok












Provide the password and click next














Provide the value and click next















Click next















Click ok









Click ok









Click create














Click close to finish rcu creation















Configuring soa domains:

Navigate to ORACLE_COMMON_HOME\common\bin directory and run config.bat file


















Select create a new domain and click next
.














Click next


Click next














Give user name and password and click next














Provide jdk location and click next














Provide the database and rcu schema details and 
click on get rcu configuration














If the schema validation completed successfully click next
















Click next

















Click next















Provide password and click next













Click next














Click create














After configuration progress completed 100% click next













Check the box start the admin server and click finish to complete the configuration
.
Check the console and em whether all servers are running
 i.e.  BAM,SOA,OSB,Admin Server





















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