Showing posts with label Oracle APPS. Show all posts
Showing posts with label Oracle APPS. Show all posts

Monday, 19 February 2018

Errors while applying 12.2.7 RUP Patch (24690690) in Oracle E-Business Suite 12.2

System got hanged while applying 12.2.7 RUP Patch (24690690) and adop exits with the errors.

Error:

1) All workers are failed with the Java error..
2) Invalid objects count is increased to 56k.

Troubleshooting:

1) Cleared the invalid objects by using utlrp.sql
2) Run the auto config on DB node
3) Start the patching activity again.

In step (3) while running auto config in database node exists with the below error.

ORA-01400: cannot insert NULL into ("APPLSYS"."FND_NODES"."NODE_NAME")

Adop error message: 

ERRORMSG: Cannot identify any valid application tier nodes in ADOP_VALID_NODES table. Ensure AutoConfig has been run on all nodes.

To resolve this error need to follow the below steps:

Step 1:
drop synonym apps.fnd_nodes;
create synonym apps.fnd_nodes for applsys.fnd_nodes;
drop synonym apps.fnd_oam_context_files;
create synonym apps.fnd_oam_context_files for applsys.fnd_oam_context_files;

Step 2:
Change the worker status to restart using adcrtl utility.

Step 3:
Run auto config again in database node. (Auto config completed without any errors)

Step 4:
Restart the patching activity.

adop phase=apply apply_mode=downtime patches=24690690 abandon=no restart=yes workers=16


Thursday, 15 February 2018

ORA-04063: package body "SYS.DBMS_STATS" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS"

After applying the patch (26925311: DATABASE PATCH SET UPDATE 12.1.0.2.180116)  in Oracle Database 12.1.0.2. We have faced below errors while executing the post patch installation steps.

Error:

We try to compile the invalid objects using utlrp.sql after applying the patch got the below error.

Warning: XDB now invalid, could not find xdbconfig
ORDIM INVALID OBJECTS: ORDIMDPCALLOUTS - INVALID - PACKAGE BODY

ERROR at line 1:
ORA-04063: package body "SYS.DBMS_STATS" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS"
ORA-06512: at "SYS.UTL_RECOMP", line 875
ORA-06512: at line 4

SQL> select comp_name, version, status from dba_registry;

--------------------------------------------------------------------------------------------------
COMP_NAME VERSION                                                           STATUS
------------------------------ -------------------------------------------------------------------
Oracle Machine Generated Data  12.1.0.2.0                                VALID
Oracle Text  12.1.0.2.0                                                                 VALID
OLAP Catalog 11.2.0.3.0                                                             OPTION OFF
Spatial 12.1.0.2.0                                                                          INVALID
Oracle Multimedia 12.1.0.2.0                                                       INVALID
Oracle XML Database 12.1.0.2.0                                                 INVALID
Oracle Database Catalog Views 12.1.0.2.0                                   VALID
Oracle Database Packages and Types 12.1.0.2.0                          INVALID
Oracle Real Application Clusters 12.1.0.2.0                                OPTION OFF
JServer JAVA Virtual Machine 12.1.0.2.0                                    VALID
Oracle XDK 12.1.0.2.0                                                                 VALID
Oracle Database Java Packages 12.1.0.2.0                                   VALID
OLAP Analytic Workspace 12.1.0.2.0                                         VALID
Oracle OLAP API 12.1.0.2.0                                                       INVALID


Fix:

SQL> shutdown immediate;
SQL> startup restrict
SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
SQL> @?/rdbms/admin/utlrp.sql

Shutdown and restart the database in normal mode.

SQL> select comp_name, version, status from dba_registry;

--------------------------------------------------------------------------------------------------
COMP_NAME VERSION                                                           STATUS
------------------------------ -------------------------------------------------------------------
Oracle Machine Generated Data  12.1.0.2.0                                VALID
Oracle Text  12.1.0.2.0                                                                 VALID
OLAP Catalog 11.2.0.3.0                                                             OPTION OFF
Spatial 12.1.0.2.0                                                                         VALID
Oracle Multimedia 12.1.0.2.0                                                     VALID
Oracle XML Database 12.1.0.2.0                                               VALID
Oracle Database Catalog Views 12.1.0.2.0                                   VALID
Oracle Database Packages and Types 12.1.0.2.0                      VALID
Oracle Real Application Clusters 12.1.0.2.0                                OPTION OFF
JServer JAVA Virtual Machine 12.1.0.2.0                                    VALID
Oracle XDK 12.1.0.2.0                                                                 VALID
Oracle Database Java Packages 12.1.0.2.0                                   VALID
OLAP Analytic Workspace 12.1.0.2.0                                         VALID
Oracle OLAP API 12.1.0.2.0                                                      VALID

ORA-29548: Java system class reported: release of Java system classes in the database (12.1.0.2.0 1.6) does not match that of the oracle executable (12.1.0.2.180116 1.6)

We have faced the below error while applying the below patch in Oracle E-Business Suite 12.2.7 (Upgrade).

Patch: adop phase=apply patches=25828573 hotpatch=yes

Issue: 
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 6
ORA-29548: Java system class reported: release of Java system classes in the
database (12.1.0.2.0 1.6) does not match that of the oracle executable

(12.1.0.2.180116 1.6)

Fix:
SQL> sho user
USER is "SYS"
SQL> @?/javavm/install/update_javavm_db.sql
SQL> SET FEEDBACK 1
SQL> SET NUMWIDTH 10
SQL> SET LINESIZE 80
SQL> SET TRIMSPOOL ON
SQL> SET TAB OFF
SQL> SET PAGESIZE 100
SQL>
SQL> alter session set "_ORACLE_SCRIPT"=true;

Session altered.

SQL>
SQL> -- If Java is installed, do CJS.
SQL>
SQL> -- If CJS can deal with the SROs inconsistent with the new JDK,
SQL> -- the drop_sros() call here can be removed.
SQL> call initjvmaux.drop_sros();

Call completed.

SQL>
SQL> create or replace java system;
  2  /

Java created.

SQL>
SQL> update dependency$
  2    set p_timestamp=(select stime from obj$ where obj#=p_obj#)
  3    where (select stime from obj$ where obj#=p_obj#)!=p_timestamp and
  4          (select type# from obj$ where obj#=p_obj#)=29  and
  5          (select owner# from obj$ where obj#=p_obj#)=0;

0 rows updated.

SQL>
SQL> commit;

Commit complete.

SQL>
SQL> alter session set "_ORACLE_SCRIPT"=false;

Session altered.

SQL> select dbms_java.get_jdk_version() from dual;

DBMS_JAVA.GET_JDK_VERSION()
--------------------------------------------------------------------------------
1.6.0_181

1 row selected.


SQL> select dbms_java.longname('TEST') from dual;

DBMS_JAVA.LONGNAME('TEST')
--------------------------------------------------------------------------------
TEST

1 row selected.

Wednesday, 7 February 2018

Kernel of proper version is not found on node "test" [Expected = "2.6.39" ; Found = "2.6.32-300.3.1.el6uek.x86_64"]

The following error occurred while installing Oracle E-Business Suite 12.2.7 (Database pre-install checks failed).

Error:

ERROR: [Result.addErrorDescription:624]  Kernel of proper version is not found on node "test" [Expected = "2.6.39" ; Found = "2.6.32-300.3.1.el6uek.x86_64"]

Fix:

The following are the steps needed to install the rpm using public-yum, with sample output from an Oracle Linux 6 installation:

1. As an authorized user (such as root), retrieve the file that configures repository locations:
# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-ol6.repo
For Oracle Linux 5 or 7, users should replace 'public-yum-ol6.repo' in the command above with 'public-yum-el5.repo' or 'public-yum-ol7.repo' respectively.

2. Using a text editor, change the field 'enabled=0' to 'enabled=1' for the repositories corresponding to the machine's operating system while also enabling the 'addons' channel. Here's an example of a repo file's entries:

[ol6_latest]

name=Oracle Linux $releasever Latest ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1


[ol6_addons]

name=Oracle Linux $releasever Add ons ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/addons/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1



[ol6_UEK_latest]

name=Latest Unbreakable Enterprise Kernel for Oracle Linux $releasever ($basearch)

baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL6/UEK/latest/$basearch/

gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1


3.Update all packages and then install the pre-install rpm by running the following yum commands:

# yum update


# yum install oracle-ebs-server-R12-preinstall 
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package oracle-ebs-server-R12-preinstall.x86_64 0:1.0-3.el6 will be installed
--> Processing Dependency: libstdc++-devel for package: oracle-ebs-server-R12-preinstall-1.0-3.el6.x86_64
--> Processing Dependency: libXp(x86-32) for package: oracle-ebs-server-R12-preinstall-1.0-3.el6.x86_64
..
Transaction Summary
================================================================================
Install     176 Package(s)
Upgrade      11 Package(s)
Total download size: 168 M
Is this ok [y/N]: y
Downloading Packages:
..

Dependency Updated:
  db4.x86_64 0:4.7.25-18.el6_4                                                 
  db4-utils.x86_64 0:4.7.25-18.el6_4                                           
  glib2.x86_64 0:2.26.1-3.el6                                                 
  glibc.x86_64 0:2.12-1.132.el6                                               
  glibc-common.x86_64 0:2.12-1.132.el6                                         
  libblkid.x86_64 0:2.17.2-12.14.el6                                           
  libgcc.x86_64 0:4.4.7-4.el6                                                 
  libstdc++.x86_64 0:4.4.7-4.el6                                               
  libuuid.x86_64 0:2.17.2-12.14.el6                                           
  nss-softokn-freebl.x86_64 0:3.14.3-9.el6                                     
  util-linux-ng.x86_64 0:2.17.2-12.14.el6                                     
Complete!
 
Versions listed above are an example - actual versions may be different based on updates to the packages.

Detailed log and backup files are available under /var/log/oracle-ebs-server-R12-preinstall.

Tuesday, 6 February 2018

libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory at java.lang.ClassLoader$NativeLibrary.load(Native Method)

This error occur while trying to  ./rapidwiz-version in Oracle linux 6, and resulting the Wrong package version.

Issue:

Rapid Install Wizard will now launch the Java Interface.....

Exception in thread "main" java.lang.UnsatisfiedLinkError: /u01/Stage122/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.load0(Unknown Source)
at java.lang.System.load(Unknown Source)
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at sun.security.action.LoadLibraryAction.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
at sun.awt.DebugHelper.<clinit>(Unknown Source)
at java.awt.Component.<clinit>(Unknown Source)
Could not find the main class: oracle.apps.ad.rapidwiz.RIWizard.  Program will exit.

Fix:

First we need to remove the old package using that resulting the issue :

rpm -e package name

[root@11111111 yum.repos.d]# rpm -qa | grep -i libaio*
libaio-devel-0.3.107-10.el6.x86_64
libaio-0.3.105-2.x86_64
libaio-0.3.107-10.el6.x86_64
[root@11111111 yum.repos.d]# rpm -e libaio-0.3.105-2.x86_64

Install the required package from the below link :

http://rpm.pbone.net/index.php3/stat/4/idpl/5543656/dir/startcom_5/com/libXi-1.0.1-3.1.i386.rpm.html

http://rpm.pbone.net/index.php3/stat/4/idpl/8118337/dir/startcom_5/com/libXi-1.0.1-3.1.x86_64.rpm.html

If Still issue is not resolved follow the below steps:

1. copy repo from https://public-yum.oracle.com/public-yum-ol6.repo to /etc/yum.repos.d/

2. enable addons channel in .repo file.

3. yum install oracle-ebs-server-R12-preinstall -y

above steps will cover dependencies and let you install EBS.



Tuesday, 1 August 2017

How to find the OPP log file location in oracle application 11i/R12.1 and R12.2

Below script to find the OPP log file location in oracle E-Business Suite.

Script:

SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name
FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp
WHERE fcpp.processor_id = fcp.concurrent_process_id
AND fcpp.action_type = 6
AND fcpp.concurrent_request_id = &&request_id;

Wednesday, 26 July 2017

Growth of oracle database size in day, week and month wise

Below query to get the database size growth in day, week and month wise.

Query:

set linesize 210
set linesize 210
COL "Database Size" FORMAT a13
COL "Used Space" FORMAT a11
COL "Used in %" FORMAT a11
COL "Free in %" FORMAT a11
COL "Database Name" FORMAT a13
COL "Free Space" FORMAT a12
COL "Growth DAY" FORMAT a11
COL "Growth WEEK" FORMAT a12
COL "Growth DAY in %" FORMAT a16
COL "Growth WEEK in %" FORMAT a16
SELECT
(select min(creation_time) from v$datafile) "Create Time",
(select name from v$database) "Database Name",
ROUND((SUM(USED.BYTES) / 1024 / 1024 ),2) || ' MB' "Database Size",
ROUND((SUM(USED.BYTES) / 1024 / 1024 ) - ROUND(FREE.K / 1024 / 1024 ),2) || ' MB' "Used Space",
ROUND(((SUM(USED.BYTES) / 1024 / 1024 ) - (FREE.K / 1024 / 1024 )) / ROUND(SUM(USED.BYTES) / 1024 / 1024 ,2)*100,2) || '% MB' "Used in %",
ROUND((FREE.K / 1024 / 1024 ),2) || ' MB' "Free Space",
ROUND(((SUM(USED.BYTES) / 1024 / 1024 ) - ((SUM(USED.BYTES) / 1024 / 1024 ) - ROUND(FREE.K / 1024 / 1024 )))/ROUND(SUM(USED.BYTES) / 1024 / 1024,2 )*100,2) || '% MB' "Free in %",
ROUND(((SUM(USED.BYTES) / 1024 / 1024 ) - (FREE.K / 1024 / 1024 ))/(select sysdate-min(creation_time) from v$datafile),2) || ' MB' "Growth DAY",
ROUND(((SUM(USED.BYTES) / 1024 / 1024 ) - (FREE.K / 1024 / 1024 ))/(select sysdate-min(creation_time) from v$datafile)/ROUND((SUM(USED.BYTES) / 1024 / 1024 ),2)*100,3) || '% MB' "Growth DAY in %",
ROUND(((SUM(USED.BYTES) / 1024 / 1024 ) - (FREE.K / 1024 / 1024 ))/(select sysdate-min(creation_time) from v$datafile)*7,2) || ' MB' "Growth WEEK",
ROUND((((SUM(USED.BYTES) / 1024 / 1024 ) - (FREE.K / 1024 / 1024 ))/(select sysdate-min(creation_time) from v$datafile)/ROUND((SUM(USED.BYTES) / 1024 / 1024 ),2)*100)*7,3) || '% MB' "Growth WEEK in %",
ROUND(((SUM(USED.BYTES) / 1024 / 1024 ) - (FREE.K / 1024 / 1024 ))/(select sysdate-min(creation_time) from v$datafile)*30,2) || ' MB' "Growth MONTH",
ROUND((((SUM(USED.BYTES) / 1024 / 1024 ) - (FREE.K / 1024 / 1024 ))/(select sysdate-min(creation_time) from v$datafile)/ROUND((SUM(USED.BYTES) / 1024 / 1024 ),2)*100)*30,3) || '% MB' "Growth MONTH in %"
FROM (SELECT BYTES FROM V$DATAFILE
UNION ALL
SELECT BYTES FROM V$TEMPFILE
UNION ALL
SELECT BYTES FROM V$LOG) USED,
(SELECT SUM(BYTES) AS K FROM dba_free_space) FREE
GROUP BY FREE.K;

Query to get the Custom Tables List in oracle application

Below query to get the list of custom tables in oracle application.

Query:

select object_name,
   object_type
from all_objects
where 1=1
and object_type='TABLE'
and status='VALID'
and object_name like 'XXCUST%';

Query to get list of Custom Form List in oracle application

Below query to get the list of Custom Form List in oracle application.

Query:

SELECT  DISTINCT forms.form_name,
         formstl.user_form_name,
         func.function_name,
         func.user_function_name,
         fm.menu_name,
         menu.prompt menu_prompt,
         menu.description,
         restl.responsibility_name
        -- FORMSTL.language
  FROM   fnd_form FORMS,
         fnd_form_tl FORMSTL,
         fnd_form_functions_VL FUNC,
         fnd_menu_entries_VL MENU,
         FND_MENUS FM,
         fnd_responsibility RES,
         fnd_responsibility_tl RESTL
 WHERE     1=1
         and forms.form_id = formstl.form_id
         and func.form_id = forms.form_id
         and menu.function_id = func.function_id
         and menu.menu_id=fm.menu_id
         and res.menu_id = menu.menu_id
         and res.responsibility_id = restl.responsibility_id
         and UPPER(forms.form_name) like 'XXCUST%'      
         order by 1;

Query to get list of Custom Concurrent Programs in oracle applications

Below query to get the list of Custom Concurrent Programs in oracle applications.

Query:

SELECT   DISTINCT fcp.user_concurrent_program_name "Concurrent Program Name",
fa.application_name,
fcp.concurrent_program_name conc_short_name,
decode( fef.execution_method_code, 'H','Host',
'I', 'PLSQL Stored Procedure',
'P', 'Report',
'L', 'SQL Loader',
'Q','SQL*Plus',
'A','Spawned',
'K','Java Concurrent Program',
'B','Request Set Stage Function',
'S','Immediate',
'J','Java Stored Procedure',
'M','Multi-Language Function',
fef.execution_method_code) "execution method",
fef.executable_name,
fcp.description "Concurrent Program Description",
fef.executable_name"Executable Name",
fef.description "Executable Description",
fef.execution_file_name ,
fcp.enabled_flag
,FCP.CREATION_DATE
FROM fnd_executables_form_v fef,
                fnd_concurrent_programs_VL fcp,
                fnd_application_tl fa
WHERE fcp.application_id=fef.application_id
and fa.application_id=fcp.application_id
AND fef.executable_id=fcp.executable_id
AND UPPER(fcp.user_concurrent_program_name) like 'XXCUST%'
ORDER BY 4;

Sunday, 23 April 2017

RC-50004: Fatal: Error occurred in ApplyDatabase:

While installing application R12.1.1, we got the below error.

Error:

RC-50004: Fatal: Error occurred in ApplyDatabase:

Control file creation failed

Cannot execute configure of database using RapidClone

RW-50010: Error: - script has returned an error:   1
RW-50004: Error code received when running external process.  Check log file for details.
Running Database Install Driver for TEST instance

Additional errors recorded in the "addlnctl.txt"

lsnrctl: error while loading shared libraries: /u01/DEV/db/tech_st/11.1.0/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied

Fix:

Following steps should be followed:

a) Switch SELinux from the default "Enforcing" mode that it is running in, to the "Permissive" mode. Contact Unix/Linux Admin for the same.

b) Clean up the File System (DB Tier, Application Tier & Inventory). Review the Note: How To Locate the Log Files and Troubleshoot Rapid Install for Release 12.0.x and 12.1.x (Doc ID 452120.1) for Cleanup instructions.

c) Run Rapidwiz.

Thursday, 23 March 2017

URL validation failed. The error could have been caused through the use of the browser's navigation buttons ( the browser Back button or refresh, for example). If the error persists, Please contact system administrator.

When we are trying to access the Oracle E-Business Suite R12.2.5 forms in Internet Explorer 10, we are getting below error.

Error:

'URL validation failed. The error could have been caused through the use of the browser's navigation buttons ( the browser Back button or refresh, for example). If the error persists, Please contact system administrator.'

Fix:

There could be multiple reasons for the issue, but in our scenario adding this Login URL into trusted sites can resolved my issue. 

Navigation:

  • Goto Internet Options
  • Security
  • Trusted sites
  • Sites
  • Add this website to the zone.

Wednesday, 15 March 2017

Applications DBA Online Patching Tool (adop)

Oracle E-Business Suite Maintenance Guide for a full description of adop features, operation, and usage.

The phase parameter specifies the parts (phases) of the online patching cycle to be executed. The five standard phases are executed in the order shown below.

Standard phases:
prepare      - Prepare the instance for patch application.
apply        - Apply patches (to the patch edition).
finalize     - Ready the instance for cutover.
cutover     - Make the patch edition the new run edition.
cleanup     - Drop obsolete objects and data from old editions.

There are also three special phases, for use when needed.

Special phases:
abort             - Abort the current online patching cycle.
actualize_all - Create actual copies of all code objects in the patch edition.
fs_clone        - Copy the run file system to the patch file system.

General parameters applicable to all phases:

workers=<number> [default: computed]
Number of parallel workers used to execute tasks.  Default value is computed principally according to number of available CPU cores.

input_file=<file_name>
As well as being entered directly on the command line, adop parameters can be specified in a text file, with one <parameter>=<value> on each line of the file.  Command line parameters override input file parameters.

loglevel=(statement|procedure|event|warning|error|unexpected)
[default: event]
Controls the level of diagnostic log detail displayed on the console.

prompt=(yes|no)  [default: yes]
Specifies whether adop should prompt for user input on warnings. By default adop will ask user whether to continue or exit on some warning messages.  If this parameter is set to "no" adop will remain fully non-interactive, and will continue past any warning messages without user confirmation.

Phase-specific parameters control operation of a particular phase:

Apply parameters:
patches=<patch#>[,<patch#>...]
patches=<patch_directory>:<driver>[,<patch_directory>:<driver>...]
This parameter specifies a comma-separated list of patches to be applied.  Patches can be specified either as the patch number or by the patch directory and driver file.  All patches are expected to be in the $PATCH_TOP directory on all tiers.  Patches are applied serially unless the merge=yes parameter is specified.

restart=(yes|no)  [default: no]
Use restart=yes to resume the previous failed apply command from where processing terminated.

abandon=(yes|no)  [default: no]
Use abandon=yes to abandon the previous failed apply command and start a new apply command.

apply_mode=(online|downtime|hotpatch)  [default: online]
Use online mode to apply a patch to the patch edition during an online patching cycle; downtime mode to apply a patch to the run edition when application services are down; and hotpatch mode to apply a patch to the run edition when application services are up. Only use hotpatch mode when explicitly directed by documentation.

apply=(yes|no)  [default: yes]
To run adop in test mode (without applying any patches), use apply=no

 options=<patch_option>[,<patch_option>...]
 Advanced options to control patching behavior.
       
See adop -examples for details.
flags=<patch_flag>[,<patch_flag>...]
 Advanced flags to control patching behavior.
 See adop -examples for details.

Finalize parameters:

finalize_mode=(full|quick)  [default: quick]
Quick mode will provide the shortest execution time, by skipping non-essential actions. Full mode performs additional actions such as gathering statistics that may improve performance after cutover.

Cutover parameters:

mtrestart=(yes|no)  [default: yes].
Specifies whether to restart application tier servers after cutover. Leave at default unless you need to perform manual steps during the cutover downtime.

cm_wait=<minutes>  [default: forever]
Specifies the number of minutes to wait for Concurrent Manager shutdown.  Adop cutover starts by requesting a concurrent manager shutdown and then waits for in-progress requests to complete.
If Concurrent Manager does not shutdown within the specified time limit, remaining concurrent requests will be killed and cutover will proceed.

Cleanup parameters:

cleanup_mode=(full|standard|quick)  [default: standard]
Quick mode provides the shortest execution time, by skipping non-essential actions. Standard mode performs additional processing to drop obsolete code objects from old editions.
Full mode performs additional processing to drop empty database editions and unused table columns.

Fs_clone parameters:

force=yes/no [default: no]
Use force=yes to restart a previous failed fs_clone command from the beginning.  By default fs_clone will restart where it left off.

Command flags:

-status [<session_id>]
Display status of the latest adop session, or a specified session.

-validate
Runs ADOP validations for verifying the current system state.

-examples
Display extended help information with common usage examples.

-help
This help screen.

How to check the adgrants version in oracle database

Below script to check the adgrants version in oracle database.

Script:

SELECT DISTINCT RPAD(h.filename,15) ,
  RPAD(g.version,20) ,
  RPAD(TRUNC(c.end_date),12) ,
  RPAD(a.bug_number,10) ,
  RPAD(e.patch_name,10) ,
  RPAD(b.applied_flag,4) "File:vers:Date:Bug:Patch:Apply"
FROM ad_bugs a,
  ad_patch_run_bugs b,
  ad_patch_runs c,
  ad_patch_drivers d ,
  ad_applied_patches e,
  ad_patch_run_bug_actions f ,
  ad_file_versions g,
  ad_files h
WHERE a.bug_id              = b.bug_id
AND b.patch_run_id          = c.patch_run_id
AND c.patch_driver_id       = d.patch_driver_id
AND d.applied_patch_id      = e.applied_patch_id
AND b.patch_run_bug_id      = f.patch_run_bug_id
AND f.patch_file_version_id = g.file_version_id
AND g.file_id               = h.file_id
AND h.filename LIKE 'adgrants.sql'
ORDER BY 1 DESC;

Output:










Tuesday, 14 March 2017

How to check Oracle Application Modules Licensed or Not.

Below script to find Oracle Application Modules are Licensed or Not.

Script:

SELECT fat.application_name
      ,fa.application_id
      ,fpi.patch_level
      ,decode(fpi.STATUS,'I','Licensed', 'N','Not Licensed','S','Shared','Undetermined') STATUS
      ,fpi.*
FROM fnd_product_installations fpi
      ,fnd_application fa
      ,fnd_application_tl fat
WHERE fpi.application_id = fa.application_id
AND fat.application_id = fa.application_id
AND fat.LANGUAGE = 'US';

Output:


Tuesday, 7 March 2017

FRM-92095: Oracle JInitiator version too low.

Getting below error while trying to access the oracle forms.












Cause:

Latest version of Java installed and forms version is not compatible with currently installed JAVA.

Fix:

  1. Check and validate the version of java installed in your system.
  2. If you already installed latest version of JAVA, Please go and uninstall(via Control Panel > Add/Remove Software)
  3. Download the latest version of 1.8 (like 1.8.0_25 to 1.8.0_29) and install.
  4. Then try open the application again with same browser.
Navigation:

  • Goto Control Panel.
  • Search Java
  • Click on Java
  • Goto Java --> User
  • And add runtime parameters.




















  • We need to set -Djava.vendor="Sun Microsystems Inc." under Run-time Parameters.
  • Click ok and click Apply.
  • And clear the java cache.
  • Try to open the forms.

Monday, 13 June 2016

FRM-92101:There was a failure in the forms server during startup.

After upgrading to EBS 12.1.3 the following error appears when launching forms:

FRM-92101:There was a failure in the forms server during startup.

CAUSE:

Incorrect soft link to ldflags.

The ldflags softlink pointed to an incorrect file :
ls -atlr $ORACLE_HOME/lib32/ldflags

$ORACLE_HOME/lib32/ldflags ===> Patch Directory/RUP4XB6/apps/tech_st/10.1.2/lib/ldflags

SOLUTION:

Please execute the following steps to resolve the issue:
  • Point the link to $ORACLE_HOME/lib/ldflags.
  • Change into $ORACLE_HOME/forms/lib32 directory.
  • Relink Forms : (make -f ins_forms.mk install)
  • Restart the Forms-Server and retest the login.

Thursday, 19 May 2016

Utility /Script To Check The Techstack Component Versions (Forms, Http Server, JDK, Framework, Database, etc)

Below steps to know How to find the versions of technology stack components (Forms, iAS, Framework, JDK, OJSP, Database, etc.)?

Script:

$ADPERLPRG $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP -contextfile=$CONTEXT_FILE -appspass=apps -outfile=$APPLTMP/Report_App_Inventory.txt -reporttype=text

Output:

Report file location:  /u002/app/applmgr/RYSAAV3/fs1/inst/apps/RYSAAV3_rysigo04/appltmp/Report_App_Inventory.txt gene   rated successfully.

TXK Technology Inventory Report for EBS Release 12

  Date :Thu May 19 21:09:22 2016
  Hostname :krishna.apps
  Enabled Services:Root Service, Web Administration, Web Entry Point
  Services, Web Application Services, Batch Processing Services
  Instance :TEST
  Platform :LINUX 64-bit
  Tier :APPS
  OS release :2.6.32-300.39.2.el5uek
  DB Host :krishna.apps
  Context File
  :/u002/app/applmgr/TEST/fs1/inst/apps/*******/appl/admin/*******_04.xml (120.401.12020000.9.1202010.10)
  Report File
  :/u002/app/applmgr/TEST/fs1/inst/apps/********/appltmp/Report_
  App_Inventory.txt
  XML Definition
  File:/u002/app/applmgr/TEST/fs1/EBSapps/appl/fnd/12.0.0/html/txkInvent
  ory.xml (120.13.12020000.2)

Weblogic Service Properties :
  Oracle Weblogic Server version                   10.3.6.0
  JDK version on Weblogic Server node              1.7.0_85 (64-Bit)
  Oracle Smart Update version on FMW Home          3.3.0.0
  OCM version on FMW Home (utils)                  Not Configured

HTTP Service Properties:
  Oracle HTTP Server version                       11.1.1.9.0
  Sun JDK client version                           1.6.0_27
  JDK version on HTTP server node                  1.7.0_85
  Oracle JDBC driver version using JAVA API        11.2.0.3.0
  (oracle.jdbc.driver.OracleDriver)
  Oracle AOLJ version                              Roll Up Patch J
  Oracle BC4J version                              10.1.3.43.6
  Oracle BiBeans version                           3.1.1.10
  Oracle HTTP client version                       10h
  Java object cache                                11.1.1.2.0
  Oracle JRAD libraries version                    10.1.3
  Oracle MDS version                               9.0.6.0.0_50
  OA Framework version                             12.2.0
  Oracle help web version                          2.0.13
  Oracle XML driver version                      
  Oracle UIX version                               11_1_1_7_0
  OPatch version on Oracle HTTP Server Oracle Home 11.1.0.12.9
  OCM version on Oracle HTTP Server Oracle Home    Not Configured
  OPatch version on Oracle Common Oracle Home      11.1.0.12.9

Forms Service Properties:
  Developer 10g version                            10.1.2.3.0
  DB client (RSF) library version in 10.1.2        10.1.0.5.0
  oracle home
  JDK version used by AD utilities on forms node   1.7.0_85
  Oracle Application Server patchset version       10.1.2.3.0
  OPatch version on 10.1.2 Oracle Home             1.0.0.0.64
  OCM version on 10.1.2 Oracle Home                Not Configured
  JDK version used by Developer 10g                1.7.0_85-b15

Concurrent Processing Service Properties:
  JDK on concurrent processing node                1.7.0_85
  JDK version used by AD utilities on CP node      1.7.0_85

Code Inventory of Weblogic Server Home:
(/u002/app/applmgr/RYSAAV3/fs1/FMW_Home/wlserver_10.3):
  Oracle WebLogic Sever overlay patch for          -
  10.3.6.0.7 which requires WLS10.3.6.0.7 PSU
  (Patch Number : 17572726 , Patch ID : FCX7) in
  the environment
  S8H6                                             -
  1LRI                                             -
  BLTG                                             -
  TTEM                                             -
  CW9T                                             -
  Oracle WebLogic Sever overlay patch for          -
  10.3.6.0.7 which requires WLS 10.3.6.0.7 PSU
  (Patch Number: 17572726 , Patch ID :FCX7) in
  the environment
  7FC9                                             -
  Y5AP                                             -
  YVDZ                                             -
  YHJK                                             -
  32I2                                             -
  FCX7                                             -
  S9MN                                             -
  Oracle WebLogic Sever overlay patch for          -
  10.3.6.0.7 which requires WLS10.3.6.0.7 PSU
  (Patch Number: 17572726 , Patch ID :FCX7) in
  the environment
  VKXF                                             -
  2GYW                                             -
  Oracle WebLogic Sever overlay patch for          -
  10.3.6.0.7 which requires WLS10.3.6.0.7 PSU
  (Patch Number: 17572726 , Patch ID :FCX7) in
  the environment.
  CIH8                                             -

Code Inventory of OHS Oracle Home:
(/u002/app/applmgr/TEST/fs1/FMW_Home/webtier):
  7663342                                          Wed May 18 15:18:23 PDT 2016
  7572595                                          Wed May 18 16:03:27 PDT 2016
  7427144                                          Wed May 18 15:17:57 PDT 2016
  20922780                                         Wed May 18 16:02:23 PDT 2016
  6599470                                          Wed May 18 15:17:49 PDT 2016
  13417321                                         Wed May 18 16:03:04 PDT 2016
  7707476                                          Wed May 18 15:18:13 PDT 2016
  6750400                                          Wed May 18 15:18:56 PDT 2016
  7695070                                          Wed May 18 16:02:48 PDT 2016
  6845838                                          Wed May 18 15:19:12 PDT 2016
  7393921                                          Wed May 18 15:18:32 PDT 2016

Code Inventory of Oracle Common Oracle Home:
(/u002/app/applmgr/TSET/fs1/FMW_Home/oracle_common):
  17284368                                         Wed May 18 16:04:11 PDT 2016
  20484781                                         Wed May 18 16:03:54 PDT 2016

Code Inventory of C-Oracle Home:
(/u002/app/applmgr/TEST/fs1/EBSapps/10.1.2)
  5261796                                          Thu Nov 15 23:30:46 PST 2012
  11780669                                         Thu Nov 15 23:49:04 PST 2012
  12848228                                         Thu Nov 15 23:59:32 PST 2012
  14825718                                         Wed May 18 16:16:44 PDT 2016
  16778382                                         Wed May 18 16:21:11 PDT 2016
  9974899                                          Thu Nov 15 23:46:06 PST 2012
  12898423                                         Thu Nov 15 23:52:39 PST 2012
  13417321                                         Wed May 18 16:26:37 PDT 2016
  16241466                                         Wed May 18 16:11:11 PDT 2016
  15900214                                         Wed May 18 16:23:08 PDT 2016
  7695070                                          Thu Nov 15 23:50:49 PST 2012
  8943095                                          Wed May 18 16:23:38 PDT 2016
  3559326                                          Thu Mar 26 08:42:23 PDT 2009
  5651245                                          Thu Dec 09 15:03:33 PST 2010
  12887068                                         Thu Nov 15 23:52:13 PST 2012
  8339196                                          Thu Nov 15 23:29:45 PST 2012
  5394728                                          Thu Mar 26 08:42:47 PDT 2009
  8557019                                          Thu Nov 15 23:37:31 PST 2012
  8300196                                          Wed May 18 16:20:42 PDT 2016
  5917053                                          Thu Mar 26 08:41:08 PDT 2009
  17653437                                         Wed May 18 16:10:25 PDT 2016
  17645157                                         Wed May 18 16:11:54 PDT 2016
  12379038                                         Thu Nov 15 23:49:45 PST 2012
  12434128                                         Thu Nov 15 23:42:23 PST 2012
  8528194                                          Wed May 18 16:22:16 PDT 2016
  10152652                                         Wed May 18 16:12:43 PDT 2016
  16271876                                         Wed May 18 16:09:41 PDT 2016
  14353879                                         Wed May 18 16:14:13 PDT 2016
  8447875                                          Thu Nov 15 23:45:14 PST 2012
  5604120                                          Wed May 18 16:21:36 PDT 2016
  16209520                                         Wed May 18 16:17:06 PDT 2016
  7140405                                          Thu Mar 26 08:42:04 PDT 2009
  16275529                                         Wed May 18 16:19:01 PDT 2016
  6400501                                          Sun Dec 12 22:26:47 PST 2010
  7016961                                          Thu Mar 26 08:40:17 PDT 2009
  17907988                                         Wed May 18 16:24:17 PDT 2016
  18620223                                         Wed May 18 16:24:54 PDT 2016
  9273888                                          Thu Nov 15 23:45:40 PST 2012
  19434967                                         Wed May 18 16:25:55 PDT 2016
  14374587                                         Wed May 18 16:13:52 PDT 2016
  4047619                                          Wed May 18 16:19:57 PDT 2016
  5659594                                          Wed May 18 16:22:39 PDT 2016
  12828135                                         Thu Nov 15 23:44:19 PST 2012
  6371228                                          Thu Mar 26 08:41:41 PDT 2009

Ref: (Doc ID 601736.1)

Friday, 13 May 2016

oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.fnd.wf.worklist.server.NotificationsAM'.

In Production, all of a sudden users started getting: Could not load application module

In most jsp's users are getting the following error:
oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.fnd.wf.worklist.server.NotificationsAM'.

## Detail 0 ##
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_TRANSACTION_ID.

The users can login ok and are able to navigate through forms as well.

Fix:

icx_transactions table needs to be cleared.

Please follow the below steps to schedule a concurrent request to purge the inactive sessions periodically (once in a week for high traffic instances):
  1.  Login using sysadmin
  2.  Navigate to Requests ---> Run
  3.  In the Form that opens run/schedule "Purge Inactive Sessions" request.
A job should be scheduled to run this request at least weekly.

Ref: (Doc ID 1577877.1)

Wednesday, 11 May 2016

ORA-01403: no data found / ORA-06512: at "APPS.FND_NET_SERVICES"

We are getting below error when attempting to run autoconfig on DB tier.

Issue:

java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.FND_NET_SERVICES", line 877
ORA-06512: at line 1

SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level

Cause:

Table DUAL existed not owned by SYS.

Table DUAL not owned by SYS should not exist as this can cause issues with EBS.

Fix:

Remove table DUAL not owned by SYS

The existence of this can be checked using:

SQL> column OWNER format a15;
SQL> column OBJECT_NAME format a20;
SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED from dba_objects where object_name='DUAL';







Ref: (Doc ID 2054876.1)