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.

APEX Listener stop responding after some time

After some time or server restarts i tried to get APEX page live. After trying to access login page i got error:

"Requested url

http://apextest:7001/apex/f is currently unavailable."

I found that the problem is when APEX listener is started it created file named apex-config.xml in current TEMP file in Windows.

There are two solutions.

First one is to go to page :

http://wlstest:7001/apex/listenerconfigure and re-instantiating APEX listener.

Another solution is to follow Oracle manual for Apex listener and unzip apex.war, edit web.xml file so param-name config.dir is enabled, and enter any value (C:\apex_config\...). Zip everything and redeploy apex.war and restat apex web aplication (Weblogic server component).

How to display image as a logo in APEX application?

Step1: Upload image:

Go to Home -> Application Builder -> Application 100 > Shared Components -> Images -> Create

Select Application to associate image with. Browse image location on disk and click update.

Step2:

Home -> Application Builder -> Application 100 -> Shared Components -> Admin

Step3:

Home -> Application Builder -> Application 100 -> Edit Application Definition

Select Logo Tab

Select image as Logo Type (or Text if you want to implement cliskcable Logo)

Use next substitution to get logo to page: #WORKSPACE_IMAGES#imagr_name.jpg

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: