INSTALLATION DOCUMENTS BY RAVI

Monday, April 10, 2017

Exporting and importing bar file obiee 12c

BI Application Archive (BAR) files are zipped copy of the RPD, Catalog and Security model metadata from a Service Instance. If we want to deploy BI application from one server to another we can use these BAR files to transfer the metadata rather than transferring the RPD, catalog and security model separately. It’s also a simple method of taking point in time backups of our application.

There is no web based tool for administering BAR files, we can do it in command line through the Weblogic Scripting Tool (WLST) which is invoked with the following command:

On Linux : <ORACLE_HOME>/oracle_common/common/bin/wlst.sh
On Windows: <ORACLE_HOME>\oracle_common\common\bin\wlst.cmd

$cd $ORACLE_HOME/oracle_common/common/bin/
./wlst.sh











Exporting Bar file:
Parameters used in this:
1.  Domain Home: <ORACLE_HOME>/user_projects/domains/bi
2. Service Instance Key: ssi
3. Working directory: /u01/workDir (we can create this any where on the file system which is accessible)
4. Export directory:  /u01/exportDir (we can create this any where on the file system which is accessible)
5. Include Catalog Runtime Info: The Runtime info is user-based information, such as the users own folders. By default this parameter is set to ‘false’. Use ‘true’ if you do want user info. This parameter is optional.
6. Include Credentials: This is a password field to encrypt the database connection credentials in the RPD. This field is optional and if not included the connection credentials are not exported.

Now in wlst prompt run the below command:








After completion we will get the below message:





Note : Copy the ssi.bar file from the export directory (/u01/exportDir) to the target server where we want to import. 

Importing Bar file:
Note: Before starting import stop all the servers and services on the target server where we want to import bar file using stop.sh command.
Parameters used in this:
1.  Domain Home: <ORACLE_HOME>/user_projects/domains/bi
2. Service Instance Key: ssi
3. Bar file to import: /u01/importDir (copy ssi.bar file from source server to this location)
4. Import the RPD: Should the RPD be imported from the BAR file. The default value is true, change to false if not wanted.
5. Import the WebCat: Should the Web Catalog be imported from the BAR file. The default value is true, change to false if not wanted.
6. Import the Security model: Should the security model be imported from the BAR file. The default value is true, change to false if not wanted.
7. Include Credentials: This is the password used to encrypt the database connection credentials in the RPD. If not provided the connection credentials will not be imported.

Note: According to the System Administrators guide for OBIEE 12c, there are two more parameters, one for to determine if user run-time info should be imported and another asking for the include credentials password again. These are not required and will produce an error if used. The importServiceInstance command can only have a maximum of seven parameters.

Now in wlst prompt run the below command:







After successful completion we will get the below message: 







Now start all the servers using start.sh command.

2 comments:

  1. I cannot see the image showing import command, can you please upload?

    ReplyDelete
    Replies
    1. It is there after the line "Now in wlst prompt run the below command:" in the post.
      Please check

      Delete

Loading xml file data to oracle table using python

Sample xml file (test.xml): <?xml version="1.0"?> <data>     <customer name="Ravi" >     ...