INSTALLATION DOCUMENTS BY RAVI

Saturday, February 17, 2018

Step by step installing oracle stream analytics and configuration

Installing Oracle Stream Analysis























Click next



















Select skip auto updates and click next




















Provide installation location and click next



















Click next



















Click next



















Click install



















Click next



















Click finish to complete the installation

Configuring the domain:

Before configuring the domain create a schema as below









Run the below command to start the domain configuration






















Click next

















Select create new osa domain with examples and click next


















Provide user name and password and click next


















Provide server name and port and click next


















Provide key-store password and click next


















Click next


Click next

















Provide domain name and location and click next

















Click done to finish the configuration

Installing the OSA-Spark Integration Component
The OSA-Spark integration component adds Oracle’s Continuous Query Language (CQL) support, along with an OSA-specific runtime environment, to the Spark framework to implement application deployment.
This component is delivered as part of the OSA server installation as a single JAR at OSA_HOME/oep/spark/lib/spark-osa.jar.
This JAR file must be copied to all worker nodes and also to the OSA node. Ideally, you copy this file into your Spark installation at SPARK_HOME/lib/spark-osa.jar







Setting Kafka server.properties






















Configuring the OSA Domain for Spark
  1. Stop the OSA server (OSA domain).
  2. Create the Spark configuration folder in your domain as: OSA_DOMAIN/config/spark.
  3. Create the OSA configuration file in the Spark configuration folder as: OSA_DOMAIN/config/spark/osa.properties.
  4. Edit the OSA configuration file according your 



















































Changing your Python version with Anaconda ( Installing Anaconda Python )


Checking the current python version





Installing Anaconda Python:

Searching for available python modules in anaconda

Installing python using conda







































Type y to continue installation

Installation completed .

Now check for the updated python version






Installing Anaconda On Linux

Downloading software:

cd /opt


wget http://repo.continuum.io/archive/Anaconda3-4.0.0-Linux-x86_64.sh















Installing Anaconda:

Run the below command to install Anaconda

bash Anaconda3-4.0.0-Linux-x86_64.sh







Press Enter to continue the installation
















Type yes to accept licence agreement

Provide the location for anaconda installation

































Installation completed successfully

Testing Anaconda installation





























yarn application and listing commands

We can do that via yarn application -list command.
Listing yarn applications:
From web ui 
This will give you list of all SUBMITTED, ACCEPTED or RUNNING applications.
From this you can filter applications of default queue by running yarn application -list | grep default

From terminal














Killing yarn application
To kill the application you can run yarn application -kill <Application ID>






Resolution for the error (ERROR: java.io.IOException: Table Namespace Manager not fully initialized, try again later)

In Hbase shell when try to create a table getting the below error:







To resolve this error one of the solution is to clean the Hbase related data from zookeeper and hdfs.
Steps for cleaning HBase related data from zookeeper and hdfs











While cleaning if we get the below error
WatchedEvent state:SyncConnected type:None path:null Node does not exist: /HBase-unsecure
Create the node by connecting to zookeeper










Again run the Hbase clear command

Now try to create table in Hbase shell again








Table created successfully

Check for the table in Hbase master UI






















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...