Oracle error-20001:APP-FND-01972:Error in FND_USER_RESP_GROUPS_API. Update_ Assignment. Cannot update this row because thee is no direct assignment of the user XXX to the role

Error:-

When attempting to add or remove an end_date  for a responsibility that is assigned to a user an error occurs.

Oracle error-20001:APP-FND-01972:Error in FND_USER_RESP_GROUPS_API. Update_ Assignment.
Cannot update this row because thee is no direct assignment of the user XXX to the role FND_RESP\CSM\OMFS_PLAM\STANDARD in the workflow user/Role table.
has been detected in FND_USER_RESP_GROUP_API.UPDATE_ASSIGNMENT.

Cause:-

The problem was caused by invalid data in the workflow user/Role table.

Solution:-

To implement the solution, please execute the following steps:

1. Go into the responsibility: System administrator.

2. Navigate to Requests > Run

3. Select request ''Workflow Directory Services User/Role Validation' and submit
    1. Run the program " Workflow Directory Services User/Role Validation" once with the following parameters:

        Fix Dangling User/Roles

            Default Batchsize=10000
            Fix Dangling User/Roles=Yes
            Add Missing User/Role Assignments=No

    2. After it completes, Add Missing User/Role Assignments

            Default Batchsize=10000
            Fix Dangling User/Roles=No
            Add Missing User/Role Assignments=Yes

4. Retest the issue by trying to update the responsibility..

5. Migrate the solution as appropriate to other environments.

ORA-01031 occurs during Post Install / De-install steps [or] Oracle DB componenet JAVAVM becomes invalid after patching

While running db post install steps running into below issues and the OJVM component becomes invalid.
 
Error:-

SQL> BEGIN
  2
  3      initjvmaux.drop_sros();
  4
  5      EXECUTE IMMEDIATE 'create or replace java system';
  6
  7      update dependency$
  8        set p_timestamp=(select stime from obj$ where obj#=p_obj#)
  9        where (select stime from obj$ where obj#=p_obj#)!=p_timestamp and
10              (select type# from obj$ where obj#=p_obj#)=29  and
11              (select owner# from obj$ where obj#=p_obj#)=0;
12
13  -- Check the validity of JAVAVM and let the registry be updated accordingly.
14
15      initjvmaux.validate_javavm;
16
17  -- Add a row in registry$history to indicate this script was run.
18
19      EXECUTE IMMEDIATE 'insert into registry$history
20                         (action_time, action, namespace, version, id, comments)
21                         values(SYSTIMESTAMP, ''jvmpsu.sql'', ''SERVER'',
22                                ''11.2.0.4.1OJVMBP'', 0, ''APPLIED jvmpsu.sql'')';
23
24  END;
25  /
BEGIN
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.INITJVMAUX", line 535
ORA-06512: at line 3

Solution:-


cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dv_off
cd $ORACLE_HOME/bin
relink all

REP-3000: Internal error starting Oracle Toolkit

Scenario:

=========

Active Users concurrent request Errored out.

Log file shows the following error:

==================================

APPLLCSP Environment Variable set to :

Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

American_America.UTF8

'.,'

Enter Password:

REP-3000: Internal error starting Oracle Toolkit.

REP-3000: Internal error starting Oracle Toolkit.

REP-0069: Internal error

REP-57054: In-process job terminated:Terminated with error:

REP-3000: Internal error starting Oracle Toolkit.

Following things needs to be checked :

====================================

Check $CONTEXT_FILE display variable. If this is correct we can ignore this and if there is any change then run autoconfig.

Now check the reports.sh file inside the apps $ORACLE_HOME/bin

Display variable to set DISPLAY=192.168.1.20:1.0; export DISPLAY

If still issue persists then follow the below step.

Solution:

=========

1. From Unix Run the following command:

$ /usr/lpp/X11/bin/xinit /usr/lpp/X11/bin/mwm -multiscreen -- :1 -vfb -force -x abx -x dbe -x GLX &

2. Bounce the Applications service/report server to take effect.

12.1 Change Password Via FNDCPASS Fails With Error 'ORA-29548 release of classes.bin in the database does not match that of the oracle executable has been detected in FND_WEB_SEC.VALIDATE_PASSWORD' After OJVM Patch (Doc ID 2186339.1)

Error:-

E-Business Suite 12.1.3 Application Object Library, Basic Sysadmin Functions, Maintenance issues (Post clone activities)

System Administrator reports the following errors when running FNDCPASS:
FNDCPASS apps/ 0 Y system/ USER SYSADMIN

Oracle error -29548: ORA-29548: Java system class reported: release of classes.bin in the database does not match that of the oracle executable has been detected in FND_WEB_SEC.VALIDATE_PASSWORD.

Solution:-

To resolve the issue test the following steps in a development instance and then migrate accordingly:

1. Confirm with the instance owner whether Oracle JVM patches were recently applied.
2. Check the readme from the latest OJVM PSU patch installed, and follow post installation instructions (eg. postinstall.sql or datapatch referenced above).
3. Run utlrp.sql.
4. Retest the FNDCPASS command and confirm the password is changed successfully.

 

Oracle Enterprise Manager : EM Key is not configured properly

Oracle Enterprise Manager

login as user oracle
# su - oracle

$ emctl start dbconsole

after completed, then url of OEM is appeared. https://my-hostname:1158/em
but, when i open via browser, i got error message :

503 service unavailable,
"The Em Key could not be configured. The Em Key was not found in Management Repository."

so, simple way to solve this problem is : recreate Oracle Enterprise Manager

$ emca -deconfig dbcontrol db -repos drop
$ emca -config dbcontrol db -repos create

FRM-92101: There was a failure in form server during startup

R12 after clone/patch/upgrade Error -FRM-92101

Error:-

After cloning R12 instance on TEST instance and when I started services normally, an error apprears when access the forms, getting the following error

FRM-92101: There was a failure in the Forms Server during startup. This could happen due to invalid configuration. Please look into the web-server log file for details

Java Exception
oracle.forms.net.ConnectionException:Forms sessionfailed during startup:no response from runtime process
at oracle.forms.net.ConnectionException.createConnectionException(Unknown Source)
at oracle.forms.net.HTTPNStream.getResponse(Unknown source)
at oracle.forms.net.HTTPNStream.doFlush(Unknown Source)
at oracle.forms.net.HTTPNStream.flush(Unknown Source)
at java.io.DataOutputStream.flush(Unknown source)
…………………………………………………………..

I have looked into the forms server log file which is given below

$LOG_HOME/ora/10.1.3/opmn/forms_default_group_1/formsstd.out

and found the following error

FormsServlet init():
configFileName: /u01/DEV/inst/apps/DEV_mkhots06/ora/10.1.2/forms/server/appsweb.cfg
testMode: false
Oracle Containers for J2EE 10g (10.1.3.4.0) initialized
ListenerServlet init()

Cause:-

Implementation Restriction: Cannot directly access remote package variable or cursor.

Solution:-

$cd $ADMIN_SCRIPTS_HOME

$adstpall.sh apps/

Then

$cd $ORACLE_HOME/forms/lib

$make -f ins_forms.mk install

Then restarted the services using adstrtal.sh apps/

Now there is no issue of form errors and was able to access the forms from my TEST instance.

Script to check tablespace used and free space in oracle database

set lines 132
set pages 105
set pause off
set echo off
set feedb on

column "TOTAL ALLOC (GB)"      format 9,999,990.00
column "TOTAL PHYS ALLOC (GB)" format 9,999,990.00
column "USED (GB)"             format 9,999,990.00
column "FREE (GB)"             format 9,999,990.00
column "% USED"                format 990.00

select
   a.tablespace_name,
   a.bytes_alloc/(1024*1024*1024) "TOTAL ALLOC (GB)",
   a.physical_bytes/(1024*1024*1024) "TOTAL PHYS ALLOC (GB)",
   nvl(b.tot_used,0)/(1024*1024*1024) "USED (GB)",
   (nvl(b.tot_used,0)/a.bytes_alloc)*100 "% USED"
from
   (select
      tablespace_name,
      sum(bytes) physical_bytes,
      sum(decode(autoextensible,'NO',bytes,'YES',maxbytes)) bytes_alloc
    from
      dba_data_files
    group by
      tablespace_name ) a,
   (select
      tablespace_name,
      sum(bytes) tot_used
    from
      dba_segments
    group by
      tablespace_name ) b
where
   a.tablespace_name = b.tablespace_name (+)
and
   a.tablespace_name not in
   (select distinct
       tablespace_name
    from
       dba_temp_files)
and
   a.tablespace_name not like 'UNDO%'
order by 1;