Oracle Discoverer Installation and Configuration

Oracle Discoverer Installation and Configuration 

The following software should be downloaded.

WebLogic 10.3.6 (Oracle Fusion Middleware 11.1.1.7.0 is certified with WebLogic Server 10.3.6)

Oracle Portal, Forms, Reports and Discoverer 11g 11.1.1.2

Oracle Portal, Forms, Reports and Discoverer 11g Patch Set 6 (11.1.1.7.0) (patch id 16471668)

Installation of Oracle Business Intelligence Discoverer 11g

Installation and validation for the JDK, Ensure you are not using the default JDK (for 64bit OS). In our case we have used JDK 1.7.0.121.15

Setup the Profile for the OS user:

Create the .profile file under the HOME for the OS user with the following entries:

export PS1="\u@\h:$ " 

export PATH=/usr/ccs/bin:/usr/sbin 

export ORACLE_HOME=/dscvr_appl/oracle/disco/Middleware/as_1 

export MW_HOME=/dscvr_appl/oracle/disco/Middleware 

export WLS_HOME=$MW_HOME/wlserver_10.3 

export WL_HOME=$WLS_HOME export JAVA_HOME=/usr/jdk/instances/jdk1.7.0 

export PATH=$JAVA_HOME/bin:$PATH 

export LD_LIBRARY_PATH=/lib/64:$LD_LIBRARY_PATH 

export PATH=$JAVA_HOME/bin:$PATH export CLASSPATH=$JAVA_HOME/lib 

export ORACLE_INSTANCE=/dscvr_appl/oracle/disco/Middleware/asinst_1 

export PATH=$ORACLE_HOME/bin:$PATH 

export TNS_ADMIN=/dscvr_appl/oracle/disco/Middleware/asinst_1/config 

export DOMAIN_HOME=$MW_HOME/user_projects/domains/DiscoDomain 

export PATH=$WL_HOME/server/bin:$DOMAIN_HOME/bin:$ORACLE_INSTANCE/bin:$PATH

WebLogic Installation:

Execute the following to start the installation:

discoverer@node1:$ cd /dscvr_stage/oracle/software/WLS.10.3.6 

discoverer@node1:$ java -jar ./wls1036_generic.jar -log=wls01.log

Discoverer 11.1.1.2 Installation: (Install without configuration)

Please use VNC or any GUI supportable tool to proceed with installation.

bash-4.1$ cd /dscvr_stage/oracle/software/Disco/11112/Disk1 bash-4.1$ ./runInstaller

Change to: Install Software – Do Not Configure

After this is done, please modify the $ORACLE_HOME/jdk/jre/lib/security/java.security to fix the error logged during the installation above. Please refer to the issue log at the bottom in the document.

Install Discoverer 11.1.1.7 Patchset

Post Installation and Configuration

Configuring Newly Created Discoverer

Please use VNC or any GUI supportable tool to proceed with installation.

bash-4.1$ cd $ORACLE_HOME/bin bash-4.1$ ./config.sh

Integrate e-Business Suite R12 with Discoverer 11g

Integrate eBS with Discoverer 11g database connector file (.dbc file), tnsnames.ora configuration as following:

1. Copy the DBC file from the APPS node which located in the $FND_SOURCE directory to the location of the Discoverer server $ORACLE_INSTANCE/config/Discoverer/Discoverer_asinst_1/

2. Copy the TWO_TASK value from the $TNS_ADMIN/tnsnames.ora of the APPS node configuration and place it inside the $TNS_ADMIN/tnsname.ora in the Discoverer node

3. Try sqlplus to connect to the eBS database instance

4. Set Applications Profile Options for Discoverer using AutoConfig Update the var s_disco_url in CONTEXT_FILE and run autoconfig with: <login_page oa_var="s_login_page">https://hr4me.uat.etisalat.corp.ae:4443/OA_HTML/AppsLogin</login_page>

5. Set Applications Profile Options in Oracle E-Business Suite

Navigate to the Profile > System form

Query the %Discoverer% profile options

ICX: Discoverer Launcher -- URL that points to Discoverer Plus Servlet.

ICX: Discoverer Viewer Launcher -- URL that points to Discoverer Viewer Servlet

ICX: Discoverer use Viewer -- Specify whether Discoverer Viewer should be launched instead of Discoverer Plus (default).

Example

ICX: Discoverer Launcher =https://dsicoverer.nizamappsdba.com:8890/discoverer/plus?Connect=[APPS_SECURE] 

ICX: Discoverer Viewer Launcher = https://dsicoverer.nizamappsdba.com:8890/discoverer/viewer?Connect=[APPS_SECURE]

6.Run the "Generate Business Views by Application" Concurrent Program

Regenerate your Business Views by running the "Generate Business Views by Application" concurrent program using the Business View Setup responsibility:

Logon to Oracle E-Business Suite as SYSADMIN

Choose the "Business Views Setup" responsibility

Navigate to Reports > Run > Pick Single Request > "Generate ALL Business Views"

In case you don't have "Business Views Setup" responsibility assigned to SYSADMIN user, please do the following:

Logon to Oracle E-Business Suite as SYSADMIN

Choose the "System Administrator" responsibility.

Navigate to Security > User > Define and add responsibility "Business Views Setup" to user SYSADMIN.

7. Recompile APPS objects

Recompile all objects in the APPS schema using adadmin.

Issue Log:

7.1 Error while installing Oracle Portal, Forms, Reports and Discoverer

During the installation of Oracle Forms 11gR2 on Solaris 11 on a Sparc 64 bit, we encountered the following error:

[2017-08-22T12:12:08.573+04:00] [OUI] [NOTIFICATION] [] [OUI] [tid: 19] [ecid: 0000Ls8yFd18HvBprW_AiY1PayFW00000A,0] End output from spawned process.

[2017-08-22T12:12:08.574+04:00] [OUI] [NOTIFICATION] [] [OUI] [tid: 19] [ecid: 0000Ls8yFd18HvBprW_AiY1PayFW00000A,0] ----------------------------------

[2017-08-22T12:12:08.575+04:00] [OUI] [NOTIFICATION] [] [OUI] [tid: 19] [ecid: 0000Ls8yFd18HvBprW_AiY1PayFW00000A,0] Exception thrown from action: make[[

Exception Name: MakefileException

Exception String: Error in invoking target 'frmweb_install frmcmp_install frmcmpb_install frmctrl_install' of makefile '/dscvr_appl/oracle/disco/Middleware/as_1/forms/lib/ins_forms.mk'. See '/export/home/appldscvr/oraInventory/logs/install2017-08-22_11-55-11AM.log' for details.

Exception Severity: 1]]

Reference to Oracle Forms And Reports 11.1.2.2.0 Installation Fails On Solaris Sparc 11.3 With the Error "Error in invoking target 'frmweb_install frmcmp_install frmcmpb_install frmctrl_install' of makefile" (Doc ID 2191376.1)

Apply the following:

1. Ignore all the errors and continue with the install.

2. Set following env variables to the following:

export PS1="\u@\h:$ "

export PATH=/usr/ccs/bin:/usr/sbin

export ORACLE_HOME=/dscvr_appl/oracle/disco/Middleware/as_1

export MW_HOME=/dscvr_appl/oracle/disco/Middleware

export WLS_HOME=$MW_HOME/wlserver_10.3

export WL_HOME=$WLS_HOME

export JAVA_HOME=/usr/jdk/instances/jdk1.7.0

export PATH=$JAVA_HOME/bin:$PATH

export LD_LIBRARY_PATH=/lib/64:$LD_LIBRARY_PATH

export PATH=$JAVA_HOME/bin:$PATH

export CLASSPATH=$JAVA_HOME/lib

export ORACLE_INSTANCE=/dscvr_appl/oracle/disco/Middleware/asinst_1

export PATH=$ORACLE_HOME/bin:$PATH

export TNS_ADMIN=/dscvr_appl/oracle/disco/Middleware/asinst_1/config

export DOMAIN_HOME=$MW_HOME/user_projects/domains/DiscoDomain

export PATH=$WL_HOME/server/bin:$DOMAIN_HOME/bin:$ORACLE_INSTANCE/bin:$PATH

3. Disable PKCS11 for all Java processes run with a particular Java installation by editing the $ORACLE_HOME/jdk/jre/lib/security/java.security file as follows:

a. Comment out the first security provider, PKCS11

# List of providers and their preference orders (see above):

#security.provider.1=sun.security.pkcs11.SunPKCS11 ${java.home}/lib/security/sunpkcs11-solaris.cfg

security.provider.2=sun.security.provider.Sun

security.provider.3=sun.security.rsa.SunRsaSign

security.provider.4=com.sun.net.ssl.internal.ssl.Provider

security.provider.5=com.sun.crypto.provider.SunJCE

security.provider.6=sun.security.jgss.SunProvider

security.provider.7=com.sun.security.sasl.Provider

security.provider.8=org.jcp.xml.dsig.internal.dom.XMLDSigRI

security.provider.9=sun.security.smartcardio.SunPCSC

b. Renumber the rest of the listed security providers, such that number 2 becomes number 1, number 3 becomes number 2, and so on, as follows:

# List of providers and their preference orders (see above): #security.provider.1=sun.security.pkcs11.SunPKCS11 ${java.home}/lib/security/sunpkcs11-solaris.cfg

security.provider.1=sun.security.provider.Sun

security.provider.2=sun.security.rsa.SunRsaSign

security.provider.3=com.sun.net.ssl.internal.ssl.Provider

security.provider.4=com.sun.crypto.provider.SunJCE

security.provider.5=sun.security.jgss.SunProvider

security.provider.6=com.sun.security.sasl.Provider

security.provider.7=org.jcp.xml.dsig.internal.dom.XMLDSigRI

security.provider.8=sun.security.smartcardio.SunPCSC

4. Execute the following:

cd $ORACLE_HOME/forms/lib/

/usr/ccs/bin/make -f $ORACLE_HOME/forms/lib/ins_forms.mk frmweb_install frmcmp_install frmcmpb_install frmctrl_install ORACLE_HOME=/dscvr_appl/oracle/disco/Middleware/as_1

cd $ORACLE_HOME/procbuilder/lib/

/usr/ccs/bin/make -f $ORACLE_HOME/procbuilder/lib/ins_procbuilder.mk dejvm_install ORACLE_HOME=/dscvr_appl/oracle/disco/Middleware/as_1

cd $ORACLE_HOME/reports/lib/

/usr/ccs/bin/make -f $ORACLE_HOME/reports/lib/ins_reports.mk libso_install proxy_install runm_install server_install cgi_install cli_install conv_install qv_install install ORACLE_HOME=/dscvr_appl/oracle/disco/Middleware/as_1

cd $ORACLE_HOME/forms/lib/

/usr/ccs/bin/make -f $ORACLE_HOME/forms/lib/ins_forms.mk frmbld_install ORACLE_HOME=/dscvr_appl/oracle/disco/Middleware/as_1

References

MOS Note Description

1074326.1 Using Discoverer 11.1.1 with Oracle E-Business Suite Release 12

1099996.1 How To Start/Stop A Discoverer 11g Unix/Linux Environment Via Command-line

2191376.1 Oracle Forms And Reports 11.1.2.2.0 Installation Fails On Solaris Sparc 11.3 With the Error "Error in invoking target 'frmweb_install frmcmp_install frmcmpb_install frmctrl_install' of makefile"

Screenshots

--------------