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

Diagnostic-Code: SMTP; 550 host unknown

When we’re trying to send mail to localdomain through mailx from linux box. It says “Diagnostic-Code: SMTP; 550 host unknown”  and mail not sent.

Solution :

Edit sendmail.cf

# “Smart” relay host (may be null)
DS[10.x.x.xx]

restart the sendmail service and send the mail is successful

10.x.x.xx — mailbox server

 

 

 

 


account analysis report OPP timeout error

While taking account analysis report one year time period, It was taking more time to finish the report completed with warning.

" +------------- 1) PUBLISH -------------+
Beginning post-processing of request 5011707 on node EBSUAT at 29-JAN-2015 14:50:32.
Post-processing of request 5011707 failed at 29-JAN-2015 14:57:32 with the error message:
The concurrent manager has timed out waiting for the Output Post-processor to finish this request.

Check that there are enough Output Post-processor service processes running.
More  (more...)

Support Id : Autoconfig EBS

You want to willing to know more details about Autoconfig

Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12 (Doc ID 387859.1)

 


delete argument too long linux

When you’re trying to delete files in linux , you receive following error message

bash: /bin/rm: Argument list too long

Solution :

go to that directory and execute below command

find . -name ‘filename*’ -print0 | xargs  -0 rm