How to change Export Destination in Discoverer Plus

Hi All


Here the way to change Export Destination in Discoverer Plus.
The default value is C:\Documents and Settings\username\

                                     
Action Plan:
1. Open the pref.txt in $ORACLE_HOME/discoverer/util.
2. Change DefaultExportPath parameter to wanted value (for example: "C:/Discoverer_Reports") from "" (default).

3. Execute ./applypreferences.sh form $ORACLE_HOME/discoverer/util.

4. Re-Login to Discoverer Plus.

5. Retry the export again.

Good luck ...

How to disable Estimate Time in Discoverer Desktop 10g / 11g

Hi All


Here the way to disable the Estimation Time in Discoverer Desktop 10g / 11g.
Some times the Estimate Time takes more time than Report execution.


So here we go:
1. Create file Estimate.txt
2. Write the following to the file:


For Discoverer 10g

Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\ORACLE\Discoverer 10\Database]
"QPPEnable"=dword:00000000


For Discoverer 11g

Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\ORACLE\Discoverer 11\Database]
"QPPEnable"=dword:00000000


3. Save and change the file extension to reg (Estimate.reg).
4. Double click on file and It will write a new entry to your registry.

Thanks a lot for my Dear Friends Efrat and Ofer.
Good Luck and have a fast running reports ...

Error during Oracle Database 11g Release 2 Examples Installation

Hi All


This is the error that I got during the installation of  Oracle Database 11g Release 2 Examples.


Reproduce Issue:
1. Download and extract the  Oracle Database 11g Release 2 Examples to /11G_examples folder
2. cd  /11G_examples/examples
3. ./runInstaller

 Here the Error:

INS-32016  The selected Oracle home contains directories or files.
INS-32018  The selected Oracle home is outside of Oracle base.
INS-32025  The chosen installation conflicts software already installed in the given Oracle home.
INS-32018  Oracle Database Examples can only be installed into an existing Oracle Home. 


Reason:
!!!Seems that this is the Rapid Installer bug!!!


Action Plan (workaround):
1. Go to $ORACLE_HOME/oui/bin
2. Run ./runInstaller.sh

3. Change the source product file to  /11G_examples/examples/stage/product.xml 

 4. Next

 5. Next

 6. Install

 7. Exit. Now Oracle Database 11g Release 2 Examples were installed successfully.

Good Luck ...

EBS with JInitiator 1.1.8.16 throw error after Java update

Hi All

This is the new issue that I found after update Java to version 1.6.0_31.
The following error "Uncaught Java Exeption while persisting the null bean" starting in JInitiator console when log-in to Oracle Application with  JInitiator 1.1.8.16.

Or

java.io.NotSerializableException: java.lang.Thread
        at java.lang.Throwable.<init>(Compiled Code)
        at java.lang.Exception.<init>(Compiled Code)
        at java.io.IOException.<init>(IOException.java:45)
        at java.io.ObjectStreamException.<init>(ObjectStreamException.java:30)
        at java.io.NotSerializableException.<init> (NotSerializableException.java:29)
        at java.io.ObjectOutputStream.outputObject(Compiled Code)
        at java.io.ObjectOutputStream.writeObject(Compiled Code)
        at java.io.ObjectOutputStream.defaultWriteObject(Compiled Code)
        at java.io.ObjectOutputStream.outputObject(Compiled Code)
        at java.io.ObjectOutputStream.writeObject(Compiled Code)
        at sun.beans.ole.OleBeanInterface.saveBean(OleBeanInterface.java:508)

Here the quick workaround:
1. Go to Control panel --> Java -->View

 2. Disable Java

Or you can just downgrade the java to the previous version.

Good Luck...

Start Using Oracle WEB ADI – Release R12

Hi All

Here the small guide to start using Oracle WEB ADI in Release R12.

1.  Enable 'Desktop Integration' responsibility.

After upgrade 11i release to R12 the Oracle Web ADI Responsibility  is not in use. The 'Desktop Integration' responsibility should be used for All ADI functions.

To enable the 'Desktop Integration' responsibility, go to 'System Administrator ' responsibility --> Security --> Responsibility --> Define -->  Look for Desktop Integration and remove 'To' in Effective Dates field.

2. Assign the 'Desktop Integration' responsibility to User.

Go to 'System Administrator ' responsibility --> Security --> User --> Define

3. Update the WEB ADI configuration profiles

BNE Server Log Level	Trace
BNE Server Log Path	$BNE_TOP/log
BNE Servlet Path	/oa_servlets/
BNE UIX Base Path	/OA_HTML/cabo
BNE UIX Physical Directory	Remove any value
BNE Upload Import Directory	$BNE_TOP/upload/import
BNE Upload Staging Directory	$BNE_TOP/upload
BNE Upload Text Directory	$BNE_TOP/upload

• ·         Ensure from back end that the following directories exist with 777 permissions.

chmod -R 777 $BNE_TOP/log

chmod -R 777 $BNE_TOP/upload/import

chmod -R 777 $BNE_TOP/upload

• ·         If any of the directories do not exist, create them and give 777 permissions.
• ·         Bounce the instance after the profile option change.

Useful documentation:

R12:Installing, Configuring and Troubleshooting Web ADI (Web Applications Desktop Integrator) [ID 452452.1]

R12 Oracle Web Adi Responsibility Errors on Create Document Function [ID 428509.1]

Error BNE_UIX_PHYSICAL_DIRECTORY Is Not Configured in R12 When Attempting to Use WebADI Spreadsheet to Create Hierarchies [ID 430991.1]

You can download the script for updating Web ADI profiles HERE .

Good Luck ...

Prepare Operating Systems Requirements for DB or EBS installation

Hi All


As you know there are a lot of  server preparation documentation for each  Oracle DB / EBS release (rpm's ,kernel requirements and etc).
Oracle  Remote Diagnostic Assistant (RDA)  -  is the fast way to prepare and verify  you Operating Systems Requirements for DB 10g/11g or EBS 11i/R12  installation or upgrade.


How it's works:


1. Install RDA
If RDA has not been installed, it can be downloaded from:
Note 314422.1: Remote Diagnostic Agent (RDA) 4 - Getting Started. You just need  download and extract the zip file.

2. Verify Hardware and OS Requirements

Unix   : ./rda.sh  -vT hcve
Windows: ./rda.cmd -vT hcve

You can choose the product preinstallation check. In my case I want to check R12.1 preinstallation on Linux RedHat 5 - 64bit.

In the end of procedure you will get the html report with Test Results and Failure Summary.

Please review it and fix according the output recommendation.

3. Re-run RDA script to check if the issue was resolved.

Useful Documentation:

How to Verify Unix Hardware and OS Requirements for OWB [ID 1375402.1]

Remote Diagnostic Agent (RDA) 4 - Getting Started [ID 314422.1]

Good Luck ...