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

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


Installing Anaconda:

Run the below command to install Anaconda


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

Sunday, February 11, 2018

Oracle database RMAN and archive logs

Starting rman

Connecting to the target database:

Archivelog List:

Delete archive logs

Enter yes to delete 

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