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.

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.

 

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.

Increase the Swap Size while installing the Oracle DB

While installing the DB, the Prerequisite check may fail saying Swap Space expected value is XXXX where as the actual value would be XXXX.

To over come this increase the swap size. Here are the steps to increase the swap size.

# How to create a swap partition of 15GB
# possible alternate approach

Logon  as a root user.

       $ dd if=/dev/zero of=/u01/swapfile bs=1024 count=15242880
       $ chmod 600 /u01/swapfile
       $ mkswap /u01/swapfile
       $ swapon /u01/swapfile
       $ echo '/u01/swapfile none swap sw 0 0' >> /etc/fstab

Existing lock /var/run/yum.pid: another copy is running as pid XXXX. Another app is currently holding the yum lock; waiting for it to exit..

When you are searching / installing the RPM and if you ever come across the below exception, 

[root@dhcp-ptp2-10-177-154-84 yum.repos.d]# yum search libaio
Loaded plugins: langpacks
Existing lock /var/run/yum.pid: another copy is running as pid 3339.
Another app is currently holding the yum lock; waiting for it to exit...
  The other application is: PackageKit
    Memory :  25 M RSS (429 MB VSZ)
    Started: Wed Jul  6 14:52:53 2016 - 02:30 ago
    State  : Sleeping, pid: 3339
Another app is currently holding the yum lock; waiting for it to 

Follow the below steps.

cd /var/run/ and you could see a file "yum.pid". Just delete it and try again. Now you can seach / install the RPM.

Not able to install RPM through "yum" utility?

I am trying to search / install rpm through yum utility, when I am searching for it am getting the below exception.

[root@dhcp-blr-kkm-itpark-10fl-10-184-29-195 /]# yum search libaio-devel-0.3.109-12.el7-i686

Loaded plugins: langpacks

http://public-yum.oracle.com/repo/OracleLinux/OL7/UEKR3/x86_64/repodata/repomd.xml: [Errno 14] curl#7 - "Failed connect to public-yum.oracle.com:80; No route to host"

Trying other mirror.

To over come this situation, follow the below steps.

1. Export your Proxy as follows.

[root@dhcp-blr-kkm-itpark-10fl-10-184-29-195 /]# export http_proxy="http://www-XXXXXXXXXX.com:80"

[root@dhcp-blr-kkm-itpark-10fl-10-184-29-195 /]# yum search libaio-devel-0.3.109-12.el7-i686

Loaded plugins: langpacks

ol7_UEKR3                                                                                                                                                                     | 1.2 kB  00:00:00

  2. go to /etc/yum.repos.d/ -> vi public-yum-ol7.repo and edit the below two entries from 0 to 1.

Now try the same.

How to bring your VM in network?

Open your Oracle VM Virtualbox, Select the respective VM -> Right Click, Settings -> Network and enable as follows.

Then logon to your VM, open your browser and give your proxy details.

Now I could connect to the internet.