Monday, December 28, 2015

Xming and Putty confirguration for X11


Install Xming Server:

 http://www.astro.yale.edu/astr255/xming-install/xming-install.html

Install Putty:


















Install X11 packages on  Linux:


root> yum install xauth



root>yum install xorg-x11-apps.x86_64

Thursday, December 3, 2015

Renaming Composite and BPEL process


Renaming Composite:

http://yatanveersingh.blogspot.com/2011/04/how-to-rename-composite-in-oracle-soa.html

Renaming BPEL Process:


https://blogs.oracle.com/middleware/entry/renaming_bpel_process_names

Wednesday, February 18, 2015

Purging Queue/Topic messages

Purging Queue/Topic messages.
1.Find out stuck messages are reside on which JMS server
2.Go to that JMS server->monitoring->Active Destinations.
3.Select JMSserver@Queue/Topic
4.Click Consumption and Pause
5.Go to the Queue/Topic Message and delete

6.Resume consumption for that JMSserver@Queue/Topic

Wednesday, November 19, 2014

List DB Sessions and Kill



Query to list DB Sessions:

Login as sys  user.

SELECT s.inst_id,
       s.sid,
       s.serial#,
       p.spid,
       s.username,
       s.program
FROM   gv$session s
       JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE  s.type != 'BACKGROUND';




Kill DB Session:

SQL>ALTER SYSTEM KILL SESSION 'sid,serial#';                                                                

Tuesday, October 21, 2014

VBOX_E_FILE_ERROR (0x80BB0004) Component: Appliance Interface


Problem:

Could not open the current file in the archive (VERR_TAR_CHKSUM_MISMATCH). Result Code: VBOX_E_FILE_ERROR (0x80BB0004) Component: Appliance Interface: IAppliance {3059cf9e-25c7-4f0b-9fa5-3c42e441670b}

Scenario:

When trying to import oracle prebuilt VM into Oracle virtual box.  We encouter this exception.

Solution:

1. Check md5 checksum on the downloaded files.
2. Uncheck disk drive, usb while import.
3. Make sure Oracle virtual box version.  Make sure you import appliance into the Virtual Box mentioned on the website.