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

(more...)

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 (more...)

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.


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 (more...)

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

http://machine:7001/em

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 11.2.0.2 to 12.1.0.2 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';

USERNAME ACCOUNT_STATUS
—————————— ——————————–
SYSMAN EXPIRED

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

USERNAME ACCOUNT_STATUS
—————————— ——————————–
DBSNMP OPEN

 

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;

(more...)

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”

Solution:

add the instance value in /etc/oratab


ORA-20001 FND_CANT_INSERT_USER_ROLE

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

Error :

ORA-20001 FND_CANT_INSERT_USER_ROLE (USERNAME=SYSADMIN)
(ROLENAME=FND_RESP|FND|FND_FUNC_ADMIN|STANDRARD)
(ROUTINE=FND_USER_RESP_GROUPS_API.Insert_Assignment)
has been detected in
FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT

 

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 (more...)