INSTALLATION DOCUMENTS BY RAVI

Thursday, July 26, 2018

Apache superset installation and configuration

Installing prerequisites:


Python:





Cryptography:












Virtualenv:


















Setting virtualenv environment:







Activating virtualenv:




Upgrading setup tools:







Installing superset:

















Creating admin user for superset:












Getting error “no module named pandas.core”

Upgrading pandas to resolve the issue:

































Again try to create the admin user:








Upgrading the superset database:










Getting error “ImportError: cannot import name ‘ExtDeprecationWarning”

To resolve this install the prerequisites in the Requirements.txt file as below:

Note: If the file is not there create the file and add the below requisites in it.

Requirements.txt
bleach==2.1.2
boto3==1.4.7
botocore==1.7.48
celery==4.2.0
colorama==0.3.9
cryptography==1.9
flask==0.12.2
flask-appbuilder==1.10.0
flask-caching==1.4.0
flask-compress==1.4.0
flask-migrate==2.1.1
flask-testing==0.7.1
flask-wtf==0.14.2
flower==0.9.2
future==0.16.0
geopy==1.11.0
gunicorn==19.8.0
humanize==0.5.1
idna==2.6
isodate==0.6.0
markdown==2.6.11
pandas==0.23.1
parsedatetime==2.0.0
pathlib2==2.3.0
polyline==1.3.2
pydruid==0.4.4
pyhive==0.5.1
python-dateutil==2.6.1
python-geohash==0.8.5
pyyaml==3.12
requests==2.18.4
simplejson==3.15.0
six==1.11.0
sqlalchemy==1.2.2
sqlalchemy-utils==0.32.21
sqlparse==0.2.4
tableschema==1.1.0
thrift==0.11.0
thrift-sasl==0.3.0
unicodecsv==0.14.1
unidecode==1.0.22
contextlib2==0.5.5

















After the requirements installed successfully upgrade superset database again































Loading the default examples:


















Initializing the superset:














Starting the superset server:














Accessing superset console:














































The 'microsoft.ace.oledb.12.0' provider is not registered on the local machine

When trying to login essl time tracker getting below error
















Resolution:

Open command as administrator and navigate to C:\Windows\Microsoft.NET\Framework64\v2.0.50727






Run the below command
idr64.exe setwow








Try to login Essl again























Wednesday, July 25, 2018

ORA-01031 INSUFFICIENT PRIVILEGES

When trying to connect to the database as sys from command prompt getting the below error







The issue is due to the password file got corrupted
Creating a new password file will resolve the issue
Back up the password file under ORACLE_HOME/database (PWDorcl.ora)









Create new password file with the command below:

Note: set the ORACLE_HOME, ORACLE_SID and PATH variables 
before running the below command



Try to connect again







Steps for connecting oracle cloud environment through winscp

Connecting through WinSCP

Note: We need to download the private key and convert it into ssh private key first


Open WinSCP and enter the ip to connect






















Browse the ssh private key




















Click on open























Click on login










Click yes
























Enter the username and click ok



Steps for connecting oracle cloud environment through putty

Connecting through putty:

Note: We need to download the private key and convert it into ssh private key first

Open putty and enter the IP of the cloud database to connect













Under ssh select Auth and browse the ssh private key


































































Click on open








Steps for converting oracle cloud environment private key to ssh private key


Note: Get the private key from oracle cloud instance to local


Open puttygen

























Click on load and browse the private key


























































Click ok
























Click on save private key
























Click on yes











































Steps for Connecting Oracle cloud database from sqldeveloper


Note: Get the private key from oracle cloud database instance (privateKey)


Open sqldeveloper

















Under View select SSH

















Right click on SSH hosts and click on New SSH Host

















Provide name, host and browse the private key file and click on ok

























Test the newly created ssh host connection


































Right click on the newly created ssh host connection and 
click on new local port forward

















Give name, host and port and click on ok

















Right click and click on connect to connect the ssh host

































Now connect the oracle cloud database as below




















Test the connection














Click on connect to connect the database


















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