Steps for installing odi 12c standalone agent

Installing ODI in standalone mode:

Start the installation as below:

In the welcome screen click on Next

Select skip auto updates and click on Next

Provide the home directory to install and click on Next

Select Standalone installation and click on Next

If the prerequisite checks got completed successfully click on Next

In the installation summary screen click on Install

If the installation progress got completed successfully click on Next

Click on Finish.

Configuring domain for the ODI standalone agent:

Run the config utility as below

Select create the domain and provide domain location and click on Next

Select Oracle Data Integrator – Standalone Agent – 12.2.1.3.0 [odi] and click on Next

Click on Next

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

If rcu configuration got successfully click on Next

Select all the component schemas and click on Next

If the connections got tested successfully click on Next

Click on Next

Provide the details and click on Next

Select per-domain default location and provide credentials and click on Next

Click on Create

If the configuration progress got completed, click on Next

Click on Finish

Configuring ODI studio:

Open the studio as below

Create new repository connection as below

Click on ok to open the newly created repository connection

Create New Agent as below

Provide the details and save the Agent

Starting Node manager and Agent:

Starting Node manager:

Start the node manager as below

Starting Agent:

Start the Agent as below

It asks for the password provide it

The agent started successfully.

Testing the agent in the ODI studio:

Test the agent in ODI studio as below

Test the agent URL:

Test the agent in the browser with the below URL

http://localhost:20910/oraclediagent

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