ow to purge e-mail notifications from the Workflow queue
Some times Due to large number of e-mail notifications to accumulated in the queue Workflow mailer will not start,To fix this issue we need purge the notifications from the Workflow queue.
The below outlines the steps, Please take proper backup before performing the below.
1) You need to update the notifications you do not want sent, in the WF_NOTIFICATIONS table.
2) Check the WF_NOTIFICATIONS table as below. Records where status = 'OPEN' and mail_status = 'MAIL' are notifications that will have an e-mail notification sent.
SQL> select notification_id,status,mail_status,begin_date from WF_NOTIFICATIONS where status = 'OPEN' and mail_status = 'MAIL';
3) This should show you which notifications are waiting to be e-mailed.
4) To update a notification so that it will not get e-mailed. Set the MAIL_STATUS = 'SENT'. The mailer will think the e-mail has already been sent and it will not send it again.
SQL> update WF_NOTIFICATIONS set mail_status = 'SENT' where mail_status = 'MAIL';
-> This will update all notifications waiting to be sent by the mailer.
5) Then run the script wfntfqup.sql to purge the WF_NOTIFICATION_OUT queue and rebuild it with data currently in the WF_NOTIFICATIONS table. This is what purges all notifications waiting in the queue to be sent.Only the ones where mail_status = 'MAIL' and status = 'OPEN' will be placed in the WF_NOTIFICATION_OUT queue and sent by the mailer.
SQL>sqlplus apps/apps_pwd @$FND_TOP/patch/115/sql/wfntfqup APPS APPS_PWD APPLSYS
6) Now you can start your WF Containers and then Mailer
Tuesday, July 26, 2016
How to upgrade JDK and JRE in oracle apps / application R12 /Release 12
1. Replace JDK 6 with 7 on IAS_ORACLE_HOME
A. Apply Patches
16545472
16496713
B. Download JDK 7
Download JDK 7 from the bellow
link
Note: Download only
32 bit version
Download tar file
and use command tar xcvf <filename > to untar a file
C. Replace JDK Home with JDK7 on IAS
cd $IAS_ORACLE_HOME/appsutil
mv jdk jdk_old (Rename JDK6 with
jdk_old)
Copy the downloaded JDK7 to $IAS_ORACLE_HOME/appsutil
Then rename jdk7 folder to jdk
(Ex: mv jdk1.7.0_5 jdk)
D. Install Albany (Display) Font
Move the bellow fonts from
$FND_TOP/resource to $IAS_ORACLE_HOME/appsutil/jdk/jre/lib
cd $FND_TOP/resource
cp ALBANYWT.ttf ALBANWTJ.ttf
ALBANWTK.ttf ALBANWTS.ttf ALBANWTT.ttf $IAS_ORACLE_HOME/appsutil/jdk/jre/lib
ALBANYWT.ttf - Single-byte
characters only
ALBANWTJ.ttf - Unicode font with
Japanese Han Ideographs
ALBANWTK.ttf - Unicode font with
Korean Han Ideographs
ALBANWTS.ttf - Unicode font with
Simplified Chinese Han Ideographs
ALBANWTT.ttf - Unicode font with
Traditional Chinese Han Ideographs
Commands to move
cp $FND_TOP/resource/ALBANYWT.ttf $IAS_ORACLE_HOME/appsutil/jdk/jre/lib/fonts
cp $FND_TOP/resource/ALBANWTJ.ttf $IAS_ORACLE_HOME/appsutil/jdk/jre/lib/fonts
cp $FND_TOP/resource/ALBANWTK.ttf
$IAS_ORACLE_HOME/appsutil/jdk/jre/lib/fonts
cp $FND_TOP/resource/ALBANWTS.ttf
$IAS_ORACLE_HOME/appsutil/jdk/jre/lib/fonts
cp $FND_TOP/resource/ALBANWTT.ttf $IAS_ORACLE_HOME/appsutil/jdk/jre/lib/fonts
2. Replace JDK 6 with 7 on ORACLE_HOME
A. Apply patch on 10.1.2 home
Apply Patch
12848228 and Patch
5659594 to your
10.1.2.3 Oracle Home using Opatch.
A. Replace JDK 6 with 7 in 10.1.2 home
cd $ORACLE_HOME
mv jdk jdk_old (Rename JDK6 with
jdk_old)
Copy the downloaded JDK7 to $ORACLE_HOME/
Then rename jdk7 folder to jdk
(Ex: mv jdk1.7.0_25 jdk)
B. Rename The Following Directories
Cd $ORACLE_HOME
mv mv jre/1.4.2 jre/1.4.2_old
cd $IAS_ORACLE_HOME
mv jre/1.4.2 jre/1.4.2_old
A. Post Patches for Linux platforms
Patch 14703419 ----no post and
pre tasks
Patch 16207165 ---post tasks
Patch 16241466 ----no post and
pre tasks
Patch 16271876 ---post tasks
Post task are performed below
(For Unix/Linux Only)
cd $ORACLE_HOME/lib/stubs
ln -s libjvm-1.7-stub.so
libjvm.so
cd $ORACLE_HOME/forms/lib32
/* Note: if this directory does
not exist, use the following command: */
cd $ORACLE_HOME/forms/lib
$ make -f ins_forms.mk sharedlib
install
cd $ORACLE_HOME/reports/lib32
/* Note: if this directory does
not exist, use the following command: */
cd $ORACLE_HOME/reports/lib
$ make -f ins_reports.mk install
3. Replace JDK 6 with 7 on DB Tier
A. Replace jdk6 on db tier
$ cd $ORACLE_HOME/appsutil
$ mv jre jre_old (Rename old jre
as jre_old)
Copy downloaded jdk7 to $ORACLE_HOME/appsutil
$ mv jre1.7.0_5 jre (Rename jre7
as jre)
4. Post Tasks
Run generate message files, form
files, report files and jar files using adadmin
Navigation to run:
Login as application OS user
adadmin à Generate Applications Files menu(1) à Generate message files(1)
adadmin à Generate Applications Files menu(1) à Generate form files (2)
adadmin à Generate Applications Files menu(1) à Generate report files (3)
adadmin à Generate Applications Files menu(1) à Generate product JAR files (4)
How to start and stop the Oracle OBIEE 11g port 80 configured instance
obiee stopping services for port 80 configured instance
username :: orabi
env file :: obiee.env
Switch to obiee user and export the env.
i)Stop the bi services
$ORACLE_INSTANCE/bin/opmnctl stopall
ii)Stop the OBIEE Managed Server (bi_server1)
$DOMAIN_HOME/bin/stopManagedWebLogic.sh bi_server1
iii)Stop the the WebLogic (WLS) Administration Server
$DOMAIN_HOME/bin/stopWebLogic.sh
iv) kill node manager by ps -ef | grep node (kill the proceess using kill -9 <process ID>
Starting the obieee services
i)Start the WebLogic (WLS) Administration Server in the background
nohup sh $DOMAIN_HOME/bin/startWebLogic.sh > wls_start.log &
ii)Start Node Manager
nohup sh $WL_HOME/server/bin/startNodeManager.sh > startNodeManager.log &
iii)Start the OBI Managed Server
nohup sh $DOMAIN_HOME/bin/startManagedWebLogic.sh bi_server1 > start_bi_server1.log &
iv)bi services
$ORACLE_INSTANCE/bin/opmnctl startall
username :: orabi
env file :: obiee.env
Switch to obiee user and export the env.
i)Stop the bi services
$ORACLE_INSTANCE/bin/opmnctl stopall
ii)Stop the OBIEE Managed Server (bi_server1)
$DOMAIN_HOME/bin/stopManagedWebLogic.sh bi_server1
iii)Stop the the WebLogic (WLS) Administration Server
$DOMAIN_HOME/bin/stopWebLogic.sh
iv) kill node manager by ps -ef | grep node (kill the proceess using kill -9 <process ID>
Starting the obieee services
i)Start the WebLogic (WLS) Administration Server in the background
nohup sh $DOMAIN_HOME/bin/startWebLogic.sh > wls_start.log &
ii)Start Node Manager
nohup sh $WL_HOME/server/bin/startNodeManager.sh > startNodeManager.log &
iii)Start the OBI Managed Server
nohup sh $DOMAIN_HOME/bin/startManagedWebLogic.sh bi_server1 > start_bi_server1.log &
iv)bi services
$ORACLE_INSTANCE/bin/opmnctl startall
How to rname / Relocate the Datafiles in Oracle Apps Database 9i,10g,11g,12c
Step 1: shut down the database
Sql>
shutdown immediate;
Step : start database in mount mode
Sql>
alter database mount;
Step :rename/relocate the datafiles
to new location;
mv /db/EDEV/db/apps_st/data/APPS_OMO02.dbf /db2/EDEV/db/apps_st/data/APPS_OMO02.dbf
mv /db/EDEV/db/apps_st/data/APPS_TS_QUEUES02.dbf
/db2/EDEV/db/apps_st/data/APPS_TS_QUEUES02.dbf
step 4: rename file within database;
Sql>
alter database rename file ‘/db/EDEV/db/apps_st/data/APPS_OMO02.dbf ‘ to
‘/db2/EDEV/db/apps_st/data/APPS_OMO02.dbf’;
Step5 :alter database open;
How to Update the Private IP changes in Oracle apps/ Application after the Abnormal Reboot in AWS Amazon Server
Issue:
After rebooting
the server private IP address got changed.
Solution:
·
Change
private Ip address in /etc/hosts
Previous Private
ipaddress : 10.190.209.135
Present
Private ipadress : 10.6.123.142
Ex : 10.6.123.142 xxsourcing.domain.com xxsourcing
·
Stop
Application services
·
Remove any *.lock files in
$ORA_CONFIG_HOME/10.1.3/j2ee/<group>/persistence/<group_default_group_<number>/
·
Clear the FND_NODES table (EXEC
FND_CONC_CLONE.SETUP_CLEAN;)
·
Run Autoconfig on DB tier
·
Run Autoconfig on Apps tier
·
Start Services
How to change/ configure the Oracle apps Brand Image
LOGO installation and configuration:
1. Copy XX_Logo_(130×58).gif file to OA_MEDIA (/opt/oracle/product/12.0/apps/apps_st/comn/java/classes/oracle/apps/media)
2. System Administrator –> Profile System Values –> Change “Corporate Branding Image for Oracle Applications” value to “/OA_MEDIA/XX_Logo_(130×58).gif”
3. Bounce the apache to effect changes.
1. Copy XX_Logo_(130×58).gif file to OA_MEDIA (/opt/oracle/product/12.0/apps/apps_st/comn/java/classes/oracle/apps/media)
2. System Administrator –> Profile System Values –> Change “Corporate Branding Image for Oracle Applications” value to “/OA_MEDIA/XX_Logo_(130×58).gif”
3. Bounce the apache to effect changes.
How to configure MWA Desktop Client in Oracle apps 11i / R12
Perform
the following steps to install MWA GUI Client on Windows Desktop
1. Create the following directory structures
%MWA_GUI_TOP%\lib
%MWA_GUI_TOP%\log
Ex:
C:\MWA\lib
C:\MWA\log
2. Download and install JDK 1.1.8 in c:\
3. Download the GUI Client patch and unzip it to C:\Temp
e.g.
PATCH_TOP=C:\Temp\4205328
4. Copy
%PATCH_TOP%\j4205328.zip to %MWA_GUI_TOP%\lib
5.Create a .bat file to run the class file
Ex:
set MWA_GUI_TOP=C:\MWA\
set JAVA_TOP=c:\jdk1.1.8
%JAVA_TOP%\bin\java
-classpath %JAVA_TOP%\lib\classes.zip;%MWA_GUI_TOP%\lib\j4205328.zip
oracle.apps.mwa.awt.client.StartGUI
5.Run the .bat file
6.Enter host name as apps11i.enrichit.com
Port
number :10218
Subscribe to:
Posts (Atom)