INSTALLATION DOCUMENTS BY RAVI

Saturday, August 25, 2018

Uploading templates in Apache Nifi HDF

Open Nifi UI

http://localhost:9090/nifi/



















In the operating window click on upload template



















Browse the template xml file and click on upload



















We will get template successfully imported message.



















In order to check for the uploaded template, drag the template button on to the canvas



















Select the uploaded template name and click on Add



















Now we will get the data flow of the uploaded template




















Steps for opening Oracle Analytics Cloud RPD online using Oracle BI Administration Tool

Open Administration Tool

















Navigate to File -> Open -> In the Cloud

















Provide the details below and click on open

















User: Admin username (like WebLogic)
Cloud: Service Instance Name
Port Number: Analytics port number
Hostname: hostname or IP address of the instance


Sql query for calculating the size of the current database, schema and tables

The size of the database is the space the files physically consume on disk.
Below is the query to get the size:

select sum(bytes)/1024/1024 size_in_mb from dba_data_files;















We can get the total space used with the below query:
select sum(bytes)/1024/1024 size_in_mb from dba_segments;














We can get the space used by individual schema with the below query:
select owner, sum(bytes)/1024/1024 Size_MB from dba_segments group by owner;















SQL query to check table size in Oracle database:
SELECT segment_name, segment_type, bytes/1024/1024 MB
FROM user_segments WHERE segment_type='TABLE' AND segment_name='Your Table Name';















SQL query to get top 10 tables by size in Oracle database:
select * from (select owner, segment_name, bytes/1024/1024 MB from dba_segments where
segment_type = 'TABLE' order by bytes/1024/1024 desc) where rownum <= 10;
















Exporting and importing dmp file in oracle database 12c

Exporting dmp file
Exporting dmp file of a schema using system user:
Syntax:
expdp system/Admin123@pdborcl schemas=HR directory=DPUMP_DIR dumpfile=hr.dmp logfile=expdpHR.log
Creating a directory object for oracle dump:
Syntax:

SQL> CREATE or REPLACE DIRECTORY dpump_dir as ' C:\app\BIASADMIN\oradata\orcl\pdborcl’;













To enable user hr to have access to these directory objects, you would assign the necessary privileges, for example:
SQL> GRANT READ, WRITE ON DIRECTORY dpump_dir TO hr;













Use the following Data Pump Export command





















Exporting dmp file of a schema using itself:
Syntax:
expdp hr/hr@pdborcl directory=DPUMP_DIR dumpfile=HR1.dmp logfile=HR1.log full=yes





















Importing dmp file
Importing dmp file of a schema using system user:
Syntax:
impdp system/Admin123@pdborcl schemas=HR directory=DPUMP_DIR dumpfile=HR.dmp logfile=impdpHR.log



















Importing dmp file of a schema using itself:
Syntax:
impdp hr/hr@pdborcl directory=DPUMP_DIR dumpfile=HR2.dmp logfile=HR2.log























Error: Cannot delete Process Group because it contains 1 Templates Apache Nifi HDF

Node sandbox-hdf.hortonworks.com:9090 is unable to fulfill this request due to: Cannot delete Process Group because it contains 1 Templates. The Templates must be deleted first.

















Templates, when created, are not inherently made available to all users.
They are tightly coupled to the authorization policies of the process group they are created in.
Since these templates are coupled in this way to a particular process group, that process group cannot be deleted until those associated templates are removed.

Removing the template:
Go to templates as shown in the below screen.

















Before removing the template, backup the template by downloading it

















































Now click on remove template to remove

















Click on yes to delete the template





























Like this remove all the templates with same “Process Group Id”

Close the Nifi templates page and try to delete the processor group now



































Altering user password in oracle analytics cloud database

ERROR at line 1:
ORA-65048: error encountered when processing the current DDL statement in
pluggable database OACDEVPDB1

ORA-01918: user 'USER1' does not exist








Enable oracle script as below
Sql> alter session set “_ORACLE_SCRIPT”=true;









Disable oracle script:
Sql> alter session set “_ORACLE_SCRIPT”=false;






Sunday, August 12, 2018

STEPS FOR INSTALLING AND CONFIGURING PSM (PAAS SERVICE MANAGER COMMAND LINE UTILITY)

Installing Python:

Download and install the python as below
















Click on Install Now
































Wait until the setup progress got finished
















Click on disable path length limit
















Checking for the python:















For some reason downloading the PSM is hidden away and not easy to find 
we need to login to your Oracle Cloud service, 
go to the service console screen, 
then click on the drop down arrow against your user name in the top right of the screen , 
select ‘Help’  and then ‘Download Center’

















Click on download

































Installing psm:
Open the command prompt and install psm as below



















Configuring psm:




Provide username, password, identity domain, region, 
output format and use oauth details and 
click enter



















It displays the list of available services as above.

Psm commands for Oracle analytics cloud
services:
List all Oracle Analytics Cloud instances
Syntax:
psm analytics services








Service:
Psm command to see the details of service
Syntax:
psm analytics service -s OACDEV










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