Oracle Forms and Reports Services 10.1.2.0.2 - FRM-92101

After some time i get weird error FRM-92101 at long time installed application server. For a long time configuration of AS did not changed and only difference is that i put some new applications. Before that action total number of users at a peak time was around 20-30 and now its 70+ (top number is 110).

Oracle Errror is : FRM-92101: There was a failure in te Forms server during startup. This could happened during invalid configuration. Please look into web-server log file for details.

I have installed Oracle Forms and Reports Services (standalone) 10.1.2.0.2 on Windows Server 2003 SP2 (full updated).

First step was to look on metalink and there i found few notes about the error itself and most common things to do when error occurs. But all that generalization did not help at all as always when Oracle started generalizing.

After reading many posts on OTN i found a solution. On windows server i go to Services (in command prompt type services.cmd). Then i found OPMN service:

Double click on OracleWINFRSProcesManager, select tab "Log On" and then check "Allow Service to interact with Desktop. After that error never shows again:

ESX - Enable SSH support

From time to time there is a need to access ESX beside Vsphere Client. One way is to connect with SSH protocol. To enable SSH protocol you need to go directly to sever console and click "Troubleshooting Options":

and then "Enable Remote Tech Support (SSH)":

A problem is preventing Windows from accurately checking the license for this computer. Error Code: 0x80070002

Check if the following files are present in the System32 Folder

%SystemRoot%\System32\secupd.dat
%SystemRoot%\System32\oembios.dat　
%SystemRoot%\System32\oembios.bin

If any of these files are missing, restore these files, from the setup disk, I386 folder or from another system.


d:\I386>expand oembios.bi_ %SystemRoot%\System32\oembios.bin
d:\I386>expand oembios.da_ %SystemRoot%\System32\oembios.dat

where %SystemRoot% is your windows installation folder (eg. C:\Windows)Reboot the system.

Your problem must be solved. After rebooting some messages about MS software licenses may pop up. Just ignore and reboote once more. If problem with licenses persist than re-register them.

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: