Skip to content

Archive for

Aug 27

oracle applications r12 auto start on linux

Step 1: connect as a database os user

su – oradev

startDB.sh edit and saved

#!/bin/sh
. /u01/EBSDEV/db/tech_st/11.2.0/EBSDEV_ebsdev.env
/u01/EBSDEV/db/tech_st/11.2.0/appsutil/scripts/EBSDEV_ebsdev/addbctl.sh start
/u01/EBSDEV/db/tech_st/11.2.0/appsutil/scripts/EBSDEV_ebsdev/addlnctl.sh start EBSDEV

stopDB.sh edit and saved

#!/bin/sh
. /u01/EBSDEV/db/tech_st/11.2.0/EBSDEV_ebsdev.env
/u01/EBSDEV/db/tech_st/11.2.0/appsutil/scripts/EBSDEV_ebsdev/addbctl.sh stop
/u01/EBSDEV/db/tech_st/11.2.0/appsutil/scripts/EBSDEV_ebsdev/addlnctl.sh stop EBSDEV

give execute permission chmod 750 for both file

Step 2: connect as applmgr os user

startAPP.sh edit and saved

#!/bin/sh
. /u01/EBSDEV/apps/apps_st/appl/APPSEBSDEV_ebsdev.env
$ADMIN_SCRIPTS_HOME/adstrtal.sh apps/apps

stopAPP.sh edit and saved

#!/bin/sh
. /u01/EBSDEV/apps/apps_st/appl/APPSEBSDEV_ebsdev.env
$ADMIN_SCRIPTS_HOME/adstpall.sh apps/apps

give execute permission chmod 750 for both file

Step 3: as root, please create file and

/etc/init.d/startEBSDEV

#!/bin/sh
#
# /etc/init.d/R12_EBSDEV
#

### BEGIN INIT INFO
# Provides: Oracle Applications
# Required-Start: $syslog $network $xvfbserver
# Required-Stop:
# Default-Start: 3 5
# Default-Stop: 0 1 2 6
# Description: Start the Oracle Applications server
### END INIT INFO

case “$1” in
start)
su oradev -c “/u01/EBSDEV/scripts_oracle/startDB.sh”
su appldev -c “/u01/EBSDEV/scripts_apps/startAPP.sh”
#rc_status -v
;;
stop)
su appldev -c “/u01/EBSDEV/scripts_apps/stopAPP.sh”
su oradev -c “/u01/EBSDEV/scripts_oracle/stopDB.sh”
#rc_status -v
;;

*)
echo “Usage: $0 {start|stop}”
exit 1
;;
esac

Step 4:

chmod 750 /etc/init.d/startEBSDEV

chkconfig –add /etc/init.d/startEBSDEV

Reference Link

Aug 24

How to get the list of users assigned with responsibilities as per Operating Unit

Query :

SELECT hou.NAME,fpov.profile_option_value org_id,frv.responsibility_name, d.full_name,a.USER_NAME, b.START_DATE,b.end_date
FROM apps.hr_organization_units hou,
apps.fnd_profile_options_vl fpo,
apps.fnd_profile_option_values fpov,
apps.fnd_responsibility_vl frv,apps.FND_USER a,apps.FND_USER_RESP_GROUPS_all b,apps. per_all_people_f d,apps.FND_RESPONSIBILITY_TL res
WHERE
fpov.level_value = frv.responsibility_id and b.responsibility_id = res.responsibility_id
and a.USER_ID=b.USER_ID and b.RESPONSIBILITY_ID=frv.RESPONSIBILITY_ID and a.employee_id=d.person_id
AND fpo.profile_option_id = fpov.profile_option_id
AND fpo.user_profile_option_name = ‘MO: Operating Unit’
AND fpov.profile_option_id = fpo.profile_option_id and res.language = ‘US’
AND hou.organization_id = TO_NUMBER (fpov.profile_option_value)
and sysdate between d.effective_start_date and d.effective_end_Date
and sysdate between nvl(a.start_date,sysdate) and nvl(a.end_date,sysdate) and sysdate between nvl(frv.start_date,sysdate) and nvl(frv.end_date,sysdate)
group by a.USER_NAME,frv.responsibility_name, fpov.profile_option_value , hou.NAME,d.full_name,b.START_DATE,b.end_date
ORDER BY frv.responsibility_name

Aug 11

2 Comments

Why users or sysadmin login is taking time

If users or sysadmin user trying to login in r12, Its taking time for login process. The problem most probably its is something to do with profile option. Please make sure the debug and diagnostics is not enable at the user level for sysadmin user or users.

and  please look this note also

How to Purge WFERROR (System: Error) Workflow Items? (Doc ID 804622.1)

Aug 4

Linux shell script to monitor space usage and send email

script

#!/bin/ksh
LC_ALL=C df -hP | column -t | grep -vE ‘^Filesystem|tmpfs|cdrom’ | awk ‘{ print $5 ” ” $1 }’ | while read output;
do
echo $output
usep=$(echo $output | awk ‘{ print $1}’ | cut -d’%’ -f1 )
partition=$(echo $output | awk ‘{ print $2 }’ )
if [ $usep -ge 90 ]; then
echo “Running out of space \”$partition ($usep%)\” on $(hostname) as on $(date)” |
mailx -s “Alert: Almost out of disk space $usep%” mazar@xxxx.com
fi
done