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;
SQL> select user,account_status from dba_users where username=’SYSMAN';
SQL> alter user sysman account unlock;
It will work after start the dbconsole
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.
ORA-20001 FND_CANT_INSERT_USER_ROLE (USERNAME=SYSADMIN)
has been detected in
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
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.
# “Smart” relay host (may be null)
restart the sendmail service and send the mail is successful
10.x.x.xx — mailbox server
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 information may be found in the service process logfile. "
Increase the OPP timeout parameter in profile
Concurrent:OPP Process Timeout –> 600
The timeout parameter depends on your report, So increase the size upto its complete normal.
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)
When you’re trying to delete files in linux , you receive following error message
bash: /bin/rm: Argument list too long
go to that directory and execute below command
find . -name ‘filename*’ -print0 | xargs -0 rm
You can follow datainstaller and hrglobal apply process from here
sqlplus -s APPS/***** @/u01/EBSUAT/apps/apps_st/appl/per/12.0.0/patch/115/sql/hrrbdeib.sql 2 4
ERROR at line 1:
ORA-04091: table HR.FF_USER_ENTITIES is mutating, trigger/function may not see
ORA-06512: at “APPS.FFDICT”, line 1224
ORA-06512: at “APPS.FFDICT”, line 1901
ORA-06512: at “APPS.FF_USER_ENTITIES_BRI”, line 7
ORA-04088: error during execution of trigger ‘APPS.FF_USER_ENTITIES_BRI’
ORA-06512: at “APPS.HRDYNDBI”, line 5446
ORA-06512: at line 42
HRGLOBAL, HRRBDEIB Failed: ORA-20106: A hrrbdeib worker has failed and ORA-04091: Table HR.FF_USER_ENTITIES is Mutating (Doc ID 357354.1)
ORA-02291: integrity constraint (HR.FF_ROUTE_PARAMETER_VALUES_FK1) violated – parent key not found
Note 375955.1 – HRGLOBAL Troubleshooting Guide
Overview only :
Complete prerequisites on target server see my step by step document
Step 2 :
run adpreclone procedure on database tier and application tier
Step 3 :
copy db, apps, inst to target machine and also change ownership
db — database user
apps,inst — appl user
Step 4 :
take rman backup and copy to target machine
Restore database to target machine using rman
change database name
run database tier
perl adcfgclone.pl dbconfig
run application tier
perl adcfgclone.pl appsTier
When i try integrate EBS and Siebel, its getting below error in siebel
Error invoking service ‘XXACE_CREATE_RECEIPTS_SIEBEL_PortType_2′, method ‘XXACE_RECEIPTS’ at step ‘Transport’.(SBL-BPR-00162)
Operation ‘XXACE_RECEIPTS’ of Web Service ‘http://xmlns.oracle.com/apps/ar/soaprovider/plsql/xxace_create_receipts_siebel/.XXACE_CREATE_RECEIPTS_SIEBEL_Service’ at port ‘XXACE_CREATE_RECEIPTS_SIEBEL_Port’ failed with the following explanation: “User not authorized to execute service.”.(SBL-EAI-04308):
Go to EBS Integrated SOA –> Choose particular interface (Interface type — plsql — Receivable )
revoke sysadmin privilege and then give grant sysadmin privilege again to this object