BI Publisher OC4J as a Windows service

To install Bi Publisher as a Windows service and forgot about OC4Jstart.cmd skript You need to do following:

• Download Java service

                     http://forge.ow2.org/projects/javaservice/

• Copy Java service to a folder on Oracle Application server (OAS)

         C:\oracle\javaservice

• Install Java JDK 1.6u45 on OAS

•  Go to BI Publisher OC4J folder  c:\ORACLE\Bipublisher\oc4j_bi\bin and check oc4j.cmd for JVMARGS :

         Set JVMARGS=-XX:MaxPermSize=128m  –Xmx512m  %OC4J_JVM_ARGS

•  Go to c:\oracle\javaservice in command prompt and run

javaservice -install "ORACLE BIP OC4J" "C:\Program Files\Java\jdk1.6.0_45\jre\bin\client\jvm.dll" -XX:MaxPermSize=128m -Xmx512m "-Djava.class.path=C:\ORACLE\BIPUBLISHER\oc4j_bi\j2ee\home\oc4j.jar" -start oracle.oc4j.loader.boot.BootStrap -out "C:\bip.log.txt" -err "C:\bip.err.txt" -description "Oracle BI EE OC4J Service"

• Go to sevices.msc and start ORACLE BIP OC4J service

Setting new Font in BI Publisher 10.1.3.4.1

From time to time there is a need to set up a new font for RTF,HTML or PDF reports in BI Publisher. Fonts could be inserted system wide or per a report.

To insert font for only one report to get it in all those types of reports:

--> Copy font (*.ttf file) to the directory : C:\ORACLE\BIPUBLISHER\jdk\lib\fonts where c:\oracle\bipublisher is where BI Publisher is installed

-->  edit xdo.cfg file of report that is found in c:\ORACLE\BIPUBLISHER\xmlp\XMLP\Reports\"Report Folder"\"Report Name":

<config version="1.0.0" xmlns="http://xmlns.oracle.com/oxp/config/">
    <!-- Properties -->
    <properties>
        <!-- System level properties -->
        <!-- PLEASE SELECT A VALID TEMPFILE DIRECTORY!!! -->
        <property name="system-temp-dir">c:/Temp</property>
        <property name="rtf-circlefull-glyph">Wingdings 2;002;154</property>
        <property name="rtf-circleempty-glyph">Wingdings 2;002;152</property>
        <property name="rtf-checkbox-glyph">Wingdings 2;152;153</property>
 <!-- Font setting -->
    <fonts>
      <!-- Windows Wingdings font -->
      <font family="WingDings 2" style="normal" weight="normal">
       <truetype path="wingdng2.ttf"/> 
      </font
    </fonts>

</config>

Note: in this case WingDings2 font is used. Best case is to use lowecase in scripts and file name on OS side.

--> Edit or check configuration of report. If there is no value put this:

BI Publisher 11.1.1.6.0 Change Catalog Type

After i try to log as super user (or any other user) and try to create new folder in Catalog, i got error:

 

 

" Please select a folder"

 

 

Problem is that in default configuration of BI Publisher 11.1.1.6.0 Catalog type is set to ORACLE BIEE katalog.

 

 

Solution:

 

 

Log on to BI Publisher as Administrator or super user.

 

 

Go to Administration --> Server Configuration --> Catalog --> Catalog Type --> Oracle BI Publisher system folders --> enter Path.

Oracle Business Intelligence 11.1.1.6.0 - Create Database Schemas Using the Repository Creation Utility (RCU)

Here are the steps to install schemas needed to install Oracle BIE 11.1.1.6.

You need to have already installed database. In this example i installed Oracle Database 11R2 on Oracle Enterprise Linux 5.8.

First step is to copy and unzip file : ofm_rcu_linux_11.1.1.6.0_disk1_1of1 downloaded from web page :
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1525270.html

I use Midnight Commander to unzip files on linux, or SFTP already unzipped file to the directory i use for installing software on Linux:

Location of software is

/software/rcuHome

and also did:

chmod -R 777 /software/rcuHome

Go to the directory /software/rcuHome/bin and start: ./rcu

First screen is welcome screen:

Since this is the new database we are going to create new schemas:

Enter Database Connection details

Database Type : Oracle Database (or other)

Host_name : Insert either Host_name or Host_ip address

Port : 1521 (default)

Service_name: SID

Enter username/password for sysdba (preffered) account

If everything you entered is correct you should see next screen:

Next step is to select schemas needed for installation of BIE.

Click the plus sign (+) next to the Business Intelligence component group. Then, click Business Intelligence Platform so that a check appears next to it. This action automatically selects the Metadata Services (MDS) schema (under the AS Common Schemas group), which is also required by Oracle Business Intelligence.

If you have another MDS schema installed to use with Oracle Business Intelligence, clear the Metadata Services (MDS) box and ignore the warning message that appears in the Messages box.

Do not select the Oracle AS Repository Components option, as this configures the RCU to install many other schemas that are not required by Oracle Business Intelligence.

Webcenter Portal and Portal schemas selected as shown on this image are for different purpose and not needed for this installation.

If everything is ok you should get this:

Next step is to enter password for different schemas:

I used same password for all schemas. After that we need to remap each schema to tablespace in database:

Keep everything as suggested and tablespaces will be created in next step:

After we click "OK" installation of schemas start and if everything is ok we get next screen as end of our installation: