Thursday, May 7, 2020

Troubleshooting: Installation and Configurations of FMW

Issue#1: CFGFWK-60324: Location is not a directory

Domain Configuration time issue


Solution:


Check the domain path which you enter already in use or correct one.

Issue #2: some system prerequisites failed



Extracting the installer . . . . . . . . . . . . . . . . . . Done
Checking if CPU speed is above 300 MHz.   Actual 2194.910 MHz    Passed
Checking swap space: must be greater than 512 MB.   Actual 0 MB    Failed <<<<
Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)
Checking temp space: must be greater than 300 MB.   Actual 11624 MB    Passed

Some system prerequisite checks failed.
You must fulfill these requirements before continuing.
The log is located here: /tmp/OraInstall2020-05-06_11-54-32PM/launcher2020-05-06_11-54-32PM.log.

To Fix this simple you look in to the above output, what check it got failed that is shown with "Failed <<<<" Just use at the end -ignoreSysPrereqs
   java -jar  /u02/fmw_12.2.1.3.0_infrastructure.jar -silent -responseFile /u02/fmw12213_infra.rsp -invPtrLoc /u02/oraInst.loc -ignoreSysPrereqs

Issue: the error message: java.io.IOException: Error writing to server

Navigate to bitools 
cd /opt/domains/bi_domain/bitools/bin
$ ./datamodel.sh uploadrpd -I /tmp/TEMPDIR/new_rpd/Sample.rpd -W MyRPDPassword \
-u weblogic -SI ssi -s localhost
Password:
Post uploadrpd REST with url: http://localhost:9502/api/lcm/v1/si/ssi/rpd/uploadrpd
Please check server logs, such as bi-lcm-rest.log.0 and obis1-diagnostic.log.. or refer to the error message: java.io.IOException: Error writing to server

Fix:
Check whether your bi_domain or OAS domain have the internal SSL enabled if yes, you can handle it two choices:
1. Create Keystore type as  KSS trust store and trust password
2. Disable the SSL from the bi_domain


  ./stop.sh
  ./start.sh
  ./status.sh
  
  ./ssl.sh internalssl false 
  
Now try the RPD deployment.

ODI Studio issue: 

Caused by: org.osgi.framework.BundleException: Exception in org.eclipse.osgi.framework.internal.core.SystemBundleActivator.start() of bundle org.eclipse.osgi.

The fix is here: 
In UNIX/Linux machine: Navigate to $HOME/.odi directory (.odi is a hidden directory).
Delete the "system<ODI version>" folder, with <ODI version> corresponding to your version of ODI, using:
rm -rf system ODIversion e.g ystem12.2.1.3.0
No worry it is just a cache folder

For example, for ODI 12.2.1.3.0, delete "system12.2.1.3.0".
 
Now you can restart ODI Studio by running 

cd $ODI_HOME/studio; ./odi.sh

A new folder system<ODI version> will be created in the home directory.

ODI-1424: Agent host or port cannot be reached

Issue: <ODI-2013> <Ping to agent OracleDIAgent failed with "oracle.odi.runtime.agent.invocation.InvocationException: 
ODI-1424: Agent host or port cannot be reached using

Fix: 
  1. Open the Oracle Data Integrator Studio (odi.sh in the Linux from VNC Viewer) In the left pane : Navigate to Topology >> Agent> oraclediagent
  2. Now check the WebLogic managed server connecting host, port values entered correctly or not if there is mismatch then update it. 
  3. Validate by Test Connection

Issue : CFGFWK-64062: Invalid Template - Parsing The Config-nodemanager.xml Failed!

After upgrade of the domain from FMW 12.1.3 to FMW 12.2.1 in place upgrade completed but the domain remains in the same old FWM installed path. 
To resolve this I've used following steps:
1. Using Configbuilder tool to create mydomain_template.jar 
2. Using config.sh that is configuraiton wizard created domain using 'Custom template" that was created in step 1. 
 
But it got the issue with reading domain template saying that " in loading config-nodemanager.xml file"
Solution:
As a workaound, remove the config-nodemanager.xml file from the generated template jar, then use that template to create a new domain.
 mkdir temp_jar; cd temp_jar # copy template jar here
  jar xvf mydomain_template.jar
  rm config-nodemanager.xml mydomain_template.jar
  jar cvf mydomain_template.jar ./* 
  

Issue boot properties not found for a managed server

If the managed server unable to start when there is no boot.properties found then it get failed to start. Solution: As a workaround for copy the security folder from the AdminServer copy to the managed server folder.
cp ../servers/AdminServer/security ../servers/ODI_server1/ -r
  ls -l ../servers/ODI_server1/
  

How to get the RCU DB Schema Password using WLST?

This is simple execute the $MW_HOME/oracle_common/common/bin/wlst.sh script to enter into WLST  shell. 

Simple 3 steps you need to perform.
  1. get the domain path into a variable 'domain'
  2. using the domain get the service
  3. Using the Weblogic security library run the decrypt function on service
  4. finally, print the clear text password

 domain = "/opt/12.1.3_odi_home/user_projects/domains/base_domain"
 service = weblogic.security.internal.SerializedSystemIni.getEncryptionService(domain)
 encryption = weblogic.security.internal.encryption.ClearOrEncryptedService(service)
 print encryption.decrypt("{AES}ysA9HONq3bVSNMvndUg2zLTnMkn93NQC6kk2BJDOC5g=")
 exit()
Note: The encrypted line picked from the WebLogic config.xml file.
WLST Decrypt

Saturday, May 2, 2020

Oracle Business Inteligence OBIEE 12c Installation

Hi, all this is another post exciting silent mode installation, which we highly encourage the whole Oracle World to use this automation trick to save a lot of time and cost. As part of the OBIEE installation enables us to develop the reports for  Analytics & Visuals





In this post we will be covering the following:

Assumptions
Pre-requisites
Create OBIEE responsefile
Installation

Assumptions

Your VM/machine has enough space and memory and CPU capacities to run the OBIEE12c. Familiar with basic statistics to understand the Analytics reports.

Pre-requisites

OBIEE latest version and its dependencies are altogether given on the same page OTN downloads.
JDK 1.8 131 subversion is required to run this installation process, with the latest version
Middleware Infrastructure
# Install JDK
cd /u01; tar -xzvf /tmp/jdk-8u202-linux-x64.tar.gz

export JAVA_HOME=/u01/jdk1.8.0_202
export PATH=$JAVA_HOME/bin:$PATH

#CHEKCK Java version
java -version
java version "1.8.0_202"
Java(TM) SE Runtime Environment (build 1.8.0_202-b26)
Java HotSpot(TM) 64-Bit Server VM (build 25.202-b26, mixed mode)

# Install fmw 12.2.1.3 infrastructure 
response=/u01/temp/wls12213/fmw.rsp
java  -jar fmw_12.2.1.3.0_infrastructure.jar -silent -responseFile $response -invPtrLoc /u01/inventory/oraInst.loc

Now all pre-requisites are insalled good to go for OBIEE installation. Download the OBIEE 12.2.1.4 files available on Oracle edelivery OSDC:

  • V975340-01_1of2.zip
  • V975340-01_2of2.zi

Create OBIEE responsefile

Remember that there are two options for Installation Types:
One more important thing is the oracle home location. This can be an existing Oracle Home that is used for Oracle Middleware Infrastructure or a new Oracle Home completely fresh installation on a first VM.
  • BI Platform Distribution 
  • BI Platform Distribution with Samples.

[ENGINE]
Response File Version=1.0.0.0.0
[GENERIC]
DECLINE_AUTO_UPDATES=true
ORACLE_HOME=/u01/Middleware
INSTALL_TYPE=BI Platform Distribution with Samples

Installation

./bi_platform-12.2.1.4.0_linux64.bin -silent -responseFile /opt/software/obi12.2.1.4.rsp \
  -invPtrLoc /opt/software/oraInst.loc -ignoreSysPrereqs

OBIEE 12.2.1.4.0 installation progressed & Successful

Next steps: We can configure the bi_domain which contains 'AdminServer' and 'bi_server1'. Happy to help you!! Hope you enjoyed this post, for more support contact us ==> Keep writing your experiances with OBIEE silent mode installation.