Monotor Allert Log Query ..

Query to monitor Alert Log report of last n days.

SET linesize 500 pagesize 500
col RECORD_ID FOR 9999999 head ID
col MESSAGE_TEXT FOR a120 head Message
col ORIGINATING_TIMESTAMP for a20 head Date


SELECT to_char(originating_timestamp,'DD-MM-RR HH24:MI:SS') "Time", message_text
FROM X$DBGALERTEXT
WHERE originating_timestamp > systimestamp - &Days
AND
regexp_like(message_text, '(TNS-|ORA-|error)');

 

 

 

How to access Oracle Apps R12/11i on Linux Machine (Mozilla Firefox)

How to access Oracle Apps 11i/R12 forms from Linux VM or Linux machine?

In you to access forms from Linux client, Three steps are installed (You can skip first if Mozilla is installed on your Linux client) –

 

1. Install Mozilla Browser

 

2. Install JRE on client machine (JRE version to install will depend on Server configuration, 

Identify which version of JRE you need on client machine

– For 11i/R12 : Login to server as application o.s. user (applmgr), set environment variable and run grep plugin $CONTEXT_FILE   (If you get output like 1.5.0_13 you need JRE 1.5.0 patchset 13, if its 1.5.0_10 you need 1.5.0 patchset 10; or for 1.4.2_04 you need 1.4.2 patchset 4 )

3. Use JRE installed above on client machine in Browser (Mozilla) Plugin 

 

1. Install FireFox Mozilla

– Download Mozilla for Linux from http://www.mozilla.com/en-US/firefox/all.html#en  firefox-2.0.0.7.tar.gz

– “gunzip -d firefox-2.0.0.7.tar.gz” (You will get unzipped file with name as firefox-2.0.0.7.tar)

– Extract tar file as “tar -xvf  firefox-2.0.0.7.tar”

– This will create directory called “firefox” which is under you will see executable called “firefox“; Use this executable to start FireFox on Linux machine.

2. Install JRE on client machine

–Download JRE  5.0 Update 10 (change this as per your server plugin version shown above; I am on 12.0.0 hence 1_5.0.10) for Linux from http://java.sun.com/products/archive/j2se/5.0_10/index.html  ”jre-1_5_0_10-linux-i586-rpm.bin”

 

 

– ”chmod 755 jre-1_5_0_10-linux-i586-rpm.bin”

 

 

– ./jre-1_5_0_10-linux-i586-rpm.bin  (You will be asked to accept license agreement , click enter and when prompted to accept license enter Yes)

– This will install jre 1.5.10 in linux machine under /usr/java  and plugin is installed under /usr/java/jre1.5.0_10/plugin/i386/ns7/libjavaplugin_oji.so

 

3. Configure JRE Plug-in in browser

– Go to Mozilla FireFox plug-in directory which is $location_where_you_unziped_firefox_directory/plugins and create soft link like

– ln -s /usr/java/jre1.5.0_10/plugin/i386/ns7/libjavaplugin_oji.so ./libjavaplugin_oji.so