Welcome to my blog...

Hello

I created this blog to share my minimal knowledge with others on the issues I came across, the POC's I did, Installations & Configurations I did on Oracle Fusion Middleware, OBIEE and Oracle Primavera Applications.

LinkedIn: https://in.linkedin.com/pub/vinoth-kumar-subramani/18/260/7b9

Technical Issues and Solutions

Tuesday, December 19, 2017

OIM - User password - List of users whose password got changed by whom and when.

Below is the query to find out the list of users whose password got changed by whom and when.

To get the details, you should log on to OIM schema and then run the below query.



SELECT A.USR_LOGIN AS USERLOGIN,
       A.usr_first_name,
      A.usr_last_name,
      A.usr_type,
      U.USR_LOGIN AS UPDATEDBY,
      to_char(A.PWH_CREATE,'dd/mm/yyyy hh24:mi:ss') as TIME FROM
      (SELECT U.USR_LOGIN,
            PWH_CREATEBY,
            u.usr_first_name,
            u.usr_last_name,
            u.usr_type,
            P.PWH_CREATE FROM PWH P,
           USR U WHERE P.USR_KEY= U.USR_KEY) A,
           USR U WHERE A.PWH_CREATEBY = U.USR_KEY AND A.PWH_CREATE > SYSDATE - 1;

This query list the users whose password got changed by whom and when for past 24 hrs.





Friday, March 17, 2017

How to redirect the Weblogic log files to a customized location.


I want all my logs to be captured under /fmw_log/bpm/<specificserver>/<log_file>
  
Redirect .out file to a customized location:
 
Change the heap values and redirect the .out log files to the customized location for bpm_server1.

Go to -> <Domain_Name>-> Environment -> Servers -> bpm_server1 -> Configuration -> Server Start -> Arguments -> enter the value as shown below.

-Xmx7168M -Xms7168M -Xmn3584M -XX:PermSize=1792M -XX:MaxPermSize=1792M -verbose:gc -XX:+PrintHeapAtGC -Xloggc:/fmw_log/bpm/bpm_server1/verbosegc.txt -XX:+PrintGCTimeStamps -XX:+PrintGCDetails -Dweblogic.Stdout=/fmw_log/bpm/bpm_server1/bpm_server1.out
Redirect .log file to a customized location:
 
Redirect the AdminServer log file to a customized location.

<Domain_Name> -> Environment -> Servers -> AdminServer -> Logging -> General -> Log file name: /fmw_log/bpm/AdminServer/AdminServer.log

Redirect the bpm_server1 log file to a customized location 

<Domain_Name> -> Environment -> Servers -> bpm_server1 -> Logging -> General -> Log file name: /fmw_log/bpm/bpm_server1/bpm_server1.log

Redirect Diagnostic log file to a customized location: 


Update the customized log file location for diagnostic log files in all the servers as below.








Thursday, January 12, 2017

BPM workspace is too slow and getting exception as :/bpm/workspace path:/bpm/workspace spec-version:2.5]] Servlet failed with Exception

BPM workspace is too slow and getting the below exception in the logs.

[ServletContext@1474070115[app:OracleBPMWorkspace module:/bpm/workspace path:/bpm/workspace spec-version:2.5]] Servlet failed with Exception
java.lang.IllegalStateException: Response already committed
  at weblogic.servlet.internal.ServletResponseImpl.objectIfCommitted(ServletResponseImpl.java:1629)



1. Login to the em console
2. Right click on soa-infra
3. Goto Administration ->SystemMBean Browser
4. Goto Application Defined MBeans
5. Find Oracle.as.soainfra.config ->Expand "Server: <your bpm_server name>"
6. Goto SoaInfraConfig -> click on soa-infra
7. Find the Property ServerURL, enter value as http://<hostname>:<bpm_portnumber>
8. Click on Apply

Some blogs, may say just to enter  http://<hostname>. The workspace URL will load, but you were not able to login with your admin or any other login credentials.

So, update http://<hostname>:<bpm_portnumber>

Application goes to "Remove Initializing" state in Weblogic Admin Console (12.2.1.2)

I am in Weblogic 12.2.1.2. When I undeploy and redeploy an application (updated version / with (or) without modifications), the application goes to "Remove Initializing" state.

It was mentioned as a bug in 12.1.x.

The workaround is as follows.

1. Undeploy the application
2. Restart the server
3. Deploy the application and start the same.