Search This Blog

Wednesday 31 January 2018

Split and Join Large files on Linux

When we are having a very large file or directory to be copied or transferred from one place to another, It would be good practice to create a tar file first and then split the tar into small pieces of tar which could be easily copied or transferred and then merged back as a single file in the target environment.

 First, we must compress the file with tar archiver.

Syntax: $ tar -cvzf <archive-name>.tar.gz <source_file>

example: tar -cvzf test.tar.gz /home/obiee12c/catalog

To Split:

This command file archive our folder to *.tar.gz. We can use file instead of path to folder for the argument. Then we will split up our file archive into small parts.

Syntax: $ split -b 1024M <archive-name>.tar.gz “parts-prefix”

example: $ Split -b 1024M test.tar.gz test.tar.part

-b 1024M will split the file into 1 Gigabytes size of file. The “part-prefix” will give the prefix name of our parts of file.

To Merge/Join this file, we can use cat command.

$ cat test.tar.part* > test.tar.gz

Cheers! Bose

Thursday 4 January 2018

OBIEE RPD Merge using XML Patch - How to generate and Merge RPD XML Patch

There is a simple method where you could compare the master RPD and latest RPD and You could generate a XML file which could have all your changes and that could be easily merged or migrated to another environment RPD.

Here is the steps for the same. First We will see how to Prepare the XML file and then next , We will see how to merge the same. 

Need OBIEE 12c Samplesales RPD, Just Click Here. RPD Password: Admin123

How to generate a XML patch using the Administration Tool:

Step 1:  

In the Administration Tool, Open the latest RPD in offline mode. In other words, open the updated repository that contains the changes you want to put in the patch.

Step 2: 

In the Administration Tool, Select File then select Compare.

Step 3: 

Select the Master or Original repository. Select Repository from the submenu to select a binary repository file in RPD format, 

or select XML to select a set of MDS XML documents.

Step 4: 

In the Open Offline dialog, enter the repository password and click OK.

Step 5a(optional): It is a good practice to equalize your changes to clean up underlying object IDs before generating a patch.

Step 5b: In the Compare repositories dialog, review the changes between the repositories. Then, click Create Patch. In the Create Patch dialog, 

enter a name for the patch file (for example, my_patch.xml) 

and click Save.

How To Merge the XML in the Target RPD:

Step 1:In the Administration Tool, open the modified Oracle BI repository in offline mode. In i.e., open the repository on which you want to apply the patch.

Step 2:Select File, then select Merge. The Merge Repository Wizard appears.  For Merge Type, select Patch Repository Merge.

Step 3: Select the original parent repository by clicking Select next to Original Master Repository. 

Select Repository from the submenu to select a binary repository file in RPD format, or select XML to select a set of MDS XML documents.

Step 4:Enter the repository password for the original repository.

Step 5: Click Select next to Patch File. Browse to select the patch file you want to apply, 

then click Open. The patch file must be in XML format. Please make sure patch file password is the same as the password for the current repository.

Step 6: Click Finish.



What is Oracle Database Link and How to create database link (DB Link)

Recent Posts