How to track container id belongs to which soa server

Many times we faced an issue where messages piling up in resequencer and from mediator container id lease table we found that there is one container ID which is not getting refreshed (renewal) and holding messages. Now in order to fix this we first need to track that bad container ID belongs to which specific soa server in order to take appropriate action on that server only.

This can be identified by increasing TRACE log level of mediator. Below are the steps;

  1. Login to EM console.
  2. Go to Log Configuration of SOA Infra
  3. Put TRACE 32 at oracle.soa.mediator.dispatch and save the changes.

Note: It does not require restart of the server.

Check soa server diagnostic logs where below string starts coming by which we can identify this is the container ID.

Renew container id [BC0S40987623G43K12368TY243P321]

Posted in AIA, Container ID, Mediator, Resequencer | Tagged , , , , , | Leave a comment

Unable to import DB table using DBAdapter in JDeveloper 111117

Though you might be finding this post silly but trust me I had to struggle a lot to find this issue in one of my team machine.

We had installed Jdev 11117 and for SOA Extension Plugin, we was having a download zip file, so used that but that caused issue mismatch. Though Jdev did not prompt me any warning for version mismatch but later while using DBAdapter, we found that we were unable to import the table or other things were not working properly.

To fix this issue, we installed the SOA extension plugin from the update which was compatible with Jdev11117.

So my learning is, always download the plugin from updates ūüôā

Posted in Jdeveloper, SOA | Leave a comment

Configure Xming to display OFM installer UI

While running the Oracle installer on unix box, you might see below error message. This is normally come when UI display on machine is disabled.

Error: – Checking monitor: must be configured to display at least 256 colors >>> Could not execute auto check for display colors using command /usr/bin/X11/xdpyinfo. Check if the DISPLAY variable is set.
Failed <<<< Some requirement checks failed. You must fulfill these requirements before.

Follow below setups to fix this issue

Download Xming setup to your local directory and Launch Xming using XLaunch.exe

 

 

 

 

You will see Xming server running on your task bar.

Setup putty to configure X11–>Enable X11 forwarding; also provide value at X display location as

localhost:0

Log-In server in same session and now you will be able to see installer UI screen.

 

Posted in Weblogic | Leave a comment

Renew or Replace Default SSL certificates of OHS with signed certificates from CA

I have came across a requirement in my project where I need to renew the existing SSL certificates of OHS. Same steps can also be used in case of replacing the default SSL certificates. Below are the major steps which needs to be done;

1. Open Oracle Wallet Manager GUI and create an empty wallet.

2. Create certificate request by adding certificate to that wallet. It will ask for many details but most important is common name which is the server name and can be found in httpd.conf file.

3. After wallet is created with Export that wallet and it will act as CSR (certificate signing request) which needs to be send to CA (certificate authority).

4. Once CA approves then signed certificates will be given by CA. Import those certificates using OWM in the above created wallet.

5. Save the wallet as cwallet.sso file in <instance_home>/config/OHS/<instance_name> directory.

6. Update the new wallet created above in OHS config files i.e. httpd.conf and ssl.conf files.

7. Restart OHS.

Posted in CA, certficates, OHS, OWM, SSL | Tagged , , , , | Leave a comment

OSB Project import error ‚Äď The jar that is being imported is an unsupported version of the product

This is a very common error you will be seeing while importing an OSB project.

You will be seeing this error when you will try to import a higher version of jar file in your OSB which is installed on lower version. Like a jar file which was created on OSB 11.1.7 and you are trying to import in OSB 11.1.6 or lower version of installation.

1

To fix this issue, open the jar file using 7-zip or some other tool and edit your ExportInfo file (as highlited in below screen shot) by providing a OSB version you are running with.
Save the change and you will be all set to import the file.

2

 

Posted in OSB | Tagged , , | Leave a comment

Schedule Blackout in Oracle Enterprise Manager (OEM) 12c

Blackouts allow Enterprise Manager administrators to suspend all data collection activity on one or more monitored targets. The primary reason for blacking out targets is to allow Enterprise Manager administrators to perform scheduled maintenance on those targets.

Login in OEM 12c and click on Enterprise à Monitoring à Blackouts

 

Click on “Create” to have a new blackout. If you have already existing blackouts and want a copy of same, you can use “Create like” too.

Fill blackout details and click on Add target. From the popup, select the target for which blackout needed.

 

Select the blackout options.

 

Select the scheduling options.

Review the information and you are all set.

Posted in Uncategorized | Leave a comment

Oracle BAM report and DO migrate from one environment to other

Oracle provided an in-built tool (i-command) which is used to import and export the report/data objects from one environment to other environments.

This utility will be available under <Middleware>/Oracle_SOA1/bam/bin

In order to export BAM report artifacts from one environment to other environment, we have to first execute the setDomainEnv.sh to set the domain environment variables.

Navigate to /oracle/user_projects/domains/dev_soa_domain/bin and run setDomainEnv.sh file with below command

. ./setDomainEnv.sh

Now since the environment variable are set,

Navigate to <MW Home>/Oracle_SOA1/bam/bin
where we have i-command utility available.

Execute the below command to export the data objects.
Execute the icommand in below format.

./icommand -CMD EXPORT -NAME “/<DO folder>/<DO Name>” -file <DO name>.xml

Example:-

./icommand -CMD EXPORT -NAME “/TestReport/Test_Report” file ¬†Test_Report_DO.xml

Execute the below command to export the reports available under my shared reports
./icommand -cmd export -name “/public/Report/<Folder>/Test_Report” -type report -file Test_Report.xml

Now you will be having the exported DO and report in BIN folder. Move these files to new environment and execute below command.

Note: – Make sure you execute . ./setDomainEnv.sh script before running icommand utility.

Execute the below command to impot the data objects and reports
./icommand -CMD IMPORT -file <file location>/ Test_Report_DO.xml

Update Existing Report

./icommand -cmd import -mode overwrite -file Test_Report.xml

Update existing Dataobject

./icommand -cmd import -mode update -file Test_Report_DO.xml

Posted in BAM | Tagged , , | Leave a comment