Skip to content

oracle applications r12 auto start on linux

Step 1: connect as a database os user

su – oradev edit and saved

. /u01/EBSDEV/db/tech_st/11.2.0/EBSDEV_ebsdev.env
/u01/EBSDEV/db/tech_st/11.2.0/appsutil/scripts/EBSDEV_ebsdev/ start
/u01/EBSDEV/db/tech_st/11.2.0/appsutil/scripts/EBSDEV_ebsdev/ start EBSDEV edit and saved

. /u01/EBSDEV/db/tech_st/11.2.0/EBSDEV_ebsdev.env
/u01/EBSDEV/db/tech_st/11.2.0/appsutil/scripts/EBSDEV_ebsdev/ stop
/u01/EBSDEV/db/tech_st/11.2.0/appsutil/scripts/EBSDEV_ebsdev/ stop EBSDEV

give execute permission chmod 750 for both file

Step 2: connect as applmgr os user edit and saved

. /u01/EBSDEV/apps/apps_st/appl/APPSEBSDEV_ebsdev.env
$ADMIN_SCRIPTS_HOME/ apps/apps edit and saved

. /u01/EBSDEV/apps/apps_st/appl/APPSEBSDEV_ebsdev.env

give execute permission chmod 750 for both file

Step 3: as root, please create file and


# /etc/init.d/R12_EBSDEV

# 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

case “$1” in
su oradev -c “/u01/EBSDEV/scripts_oracle/”
su appldev -c “/u01/EBSDEV/scripts_apps/”
#rc_status -v
su appldev -c “/u01/EBSDEV/scripts_apps/”
su oradev -c “/u01/EBSDEV/scripts_oracle/”
#rc_status -v

echo “Usage: $0 {start|stop}”
exit 1

Step 4:

chmod 750 /etc/init.d/startEBSDEV

chkconfig –add /etc/init.d/startEBSDEV

Reference Link

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
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

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)

Linux shell script to monitor space usage and send email


LC_ALL=C df -hP | column -t | grep -vE ‘^Filesystem|tmpfs|cdrom’ | awk ‘{ print $5 ” ” $1 }’ | while read output;
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%”

Disable cache obiee 11g

You can able to disable the cache from Fusion middleware enterprise manager console. No need to manul edit in NQSConfig.ini file


Go to :

Business Intelligence –> coreapplication –> select Capacity Management tab –> Select Performance tab –> click “Lock and Edit configuration”  –> deselect the cache enabled –> apply –> activate changes

Restart the BI services

ora-20011-Approximate ndv failed : ora-00600

When you’re run adstats.sql script on database, you should get this error if not set the ORA_NLS10 path in environment. So please set the path and restart the database

ORA_NLS10=/u01/app/oracle/db/tech_st/12c/nls/data/9idata; export ORA_NLS10

12c upgrade overview of oracle applications 12.1.3

This step by step document will guide to upgrade the database version from to of oracle applications 12.1.3

12c upgrade overview of oracle applications 12

Enterprise Manager is not able to connect to the database instance

Solution :

check the sysman and dbsnmp account status, If expired, please activate
SQL> select username,account_status from dba_users where username =’SYSMAN’;

—————————— ——————————–

SQL> select username,account_status from dba_users where username =’DBSNMP’;

—————————— ——————————–


So sysman account has been expired.  Please activate with old password and also Please check if this account has been locked, please unlock this account.


SQL> alter user sysman identified by Admin123;

User altered.

SQL> select user,account_status from dba_users where username=’SYSMAN’;

—————————— ——————————–

SQL> alter user sysman account unlock;

User altered.


It will work after start the dbconsole



No Oracle instances were discovered do you want to enter one

While try to configure Backup exec agent in database server

“No Oracle instances were discovered do you want to enter one”


add the instance value in /etc/oratab


I am getting below error message when I am trying to add Functional Administrator responsibility to sysadmin user.

Error :

has been detected in


Solution :

If we trying to assign particular responsibility to user but we can’t and also It seems look like the user has been already assigned that responsibility but user can’t able to access that responsibility. To overcome this issue, there is a concurrent request that does sync up of such users and responsibility in R12 version.

Concurrent request :

Workflow Directory Services User/Role Validation  with parameters 10000, yes, yes, no

This request would check all users and assigned responsibilities and should sync up users with attached responsibilities , users should be able to view assigned responsibility now

workflow directory services


Get every new post delivered to your Inbox.

Join 157 other followers