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.