Skip to content

Archive for

Dec 31

java.lang.SecurityException: User: ASADMIN authentication failed

When i trying to undeploy the REST service in UAT and deploy again, i am getting the below error.

 

java.lang.SecurityException: User: ASADMIN authentication failed

Solution :

verify the asadmin given credential correct and roles also.

Run the txkISGConfigurator.xml utility with “ebsSetup” argument.

 

ant -f $JAVA_TOP/oracle/apps/fnd/txk/util/txkISGConfigurator.xml ebsSetup -DforceStop=yes -DforceDataSourceExists=true -DforceAuthenticationProviderExists=true

refer :  Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.2 (Doc ID 1311068.1)

Section 2: Configuring Oracle E-Business Suite Integrated SOA Gateway for REST Services

 

Dec 31

sysadmin user not logging in r12

I am trying to logging in sysadmin user of one of our UAT system, It’s simply loading but not logging in.

I checked the sysadmin user credentials valid. Yes it’s Valid.

 

select fnd_web_sec.validate_login(‘SYSADMIN’,’password’) from dual;

Y

Solution :

I checked any blocking session in database, Yes it’s there . So I kill those sessions afterwards  I can able to login.

select l1.sid, ‘ IS BLOCKING ‘, l2.sid
from v$lock l1, v$lock l2 where l1.block =1 and l2.request > 0
and l1.id1=l2.id1 and l1.id2=l2.id2

 

Dec 30

File export not saved oracle apps r12

Suddenly We couldn’t able to save the file after we did export.

 

Solution :

 

Check your database any one of tablespace space issue in alert log file and add datafile.

Dec 25

APP-FND-00706: Routine FDFADF: Detected a data error

During Payment voucher creation, users getting the below issue.

After click Ok, users getting below error

 

Solution:

 

Workaround :

Increase open_cursor parameter in database and start a new session to do the payment voucher, it’s working now.

 

After we log a SR, Oracle has provided a patch to apply the patch for fixing the issue.

 

After Upgrading To 12.2.9 Forms Fail: “Error APP-FND-00706: Routine Detected A Data Error” (Doc ID 2629037.1)

 

 

Dec 3

Change hostname for EBS 12.2

EBS 12.2 environment running on two servers

Database server and application server

Run preclone on both database tier and application tier

Stop the both services

Database Server :

Hostname : dbs-bah-xxx-yyy.zzzzz.com
Target : dbs-leb-xxx-yyy.zzzzz.com

[root@dbs-bah-xxx-yyy ~]# hostnamectl status
Static hostname: dbs-bah-xxx-yyy.zzzzz.com
Icon name: computer-vm
Chassis: vm
Machine ID: bbb7386b86c44808b6ee2e4b9be95357
Boot ID: ee32a1c8afdd4bd4a935eff51b9a836c
Virtualization: vmware
Operating System: Red Hat Enterprise Linux Server 7.6 (Maipo)
CPE OS Name: cpe:/o:redhat:enterprise_linux:7.6:GA:server
Kernel: Linux 3.10.0-957.el7.x86_64
Architecture: x86-64
[root@dbs-bah-xxx-yyy ~]# vi /etc/hosts
[root@dbs-bah-xxx-yyy ~]# hostnamectl set-hostname dbs-leb-xxx-yyy.zzzzz.com
[root@dbs-bah-xxx-yyy ~]# hostnamectl status
Static hostname: dbs-leb-xxx-yyy.zzzzz.com
Icon name: computer-vm
Chassis: vm
Machine ID: bbb7386b86c44808b6ee2e4b9be95357
Boot ID: ee32a1c8afdd4bd4a935eff51b9a836c
Virtualization: vmware
Operating System: Red Hat Enterprise Linux Server 7.6 (Maipo)
CPE OS Name: cpe:/o:redhat:enterprise_linux:7.6:GA:server
Kernel: Linux 3.10.0-957.el7.x86_64
Architecture: x86-64

Startup the database:

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address ‘(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbs-bah-xxx-yyy.zzzzz.com)(PORT=1586)))’
SQL> SQL> exit

[orauat@dbs-leb-xxx-yyy admin]$ mkdir -p LEBUAT_dbs-leb-xxx-yyy
[orauat@dbs-leb-xxx-yyy admin]$ cd LEBUAT_dbs-leb-xxx-yyy/
[orauat@dbs-leb-xxx-yyy LEBUAT_dbs-leb-xxx-yyy]$ pwd
/u01/app/oracle/db/tech_st/12c/network/admin/LEBUAT_dbs-leb-xxx-yyy
[orauat@dbs-leb-xxx-yyy LEBUAT_dbs-leb-xxx-yyy]$ cd ..
[orauat@dbs-leb-xxx-yyy admin]$ cd LEBUAT_dbs-bah-xxx-yyy
[orauat@dbs-leb-xxx-yyy LEBUAT_dbs-bah-xxx-yyy]$ ls
listener_ifile.ora listener.ora sqlnet_ifile.ora sqlnet.ora tnsnames.ora
[orauat@dbs-leb-xxx-yyy LEBUAT_dbs-bah-xxx-yyy]$ cp -r * /u01/app/oracle/db/tech_st/12c/network/admin/LEBUAT_dbs-leb-xxx-yyy

Replace with new hostname
[orauat@dbs-leb-xxx-yyy LEBUAT_dbs-bah-xxx-yyy]$ cd /u01/app/oracle/db/tech_st/12c/network/admin/LEBUAT_dbs-leb-xxx-yyy
[orauat@dbs-leb-xxx-yyy LEBUAT_dbs-leb-xxx-yyy]$ ls
listener_ifile.ora listener.ora sqlnet_ifile.ora sqlnet.ora tnsnames.ora

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 4294967296 bytes
Fixed Size 2932632 bytes
Variable Size 2667577448 bytes
Database Buffers 1610612736 bytes
Redo Buffers 13844480 bytes
Database mounted.
Database opened.

[orauat@dbs-leb-xxx-yyy ~]$ lsnrctl start LEBUAT

perl adbldxml.pl

perl adconfig.pl

Changed hostname for Application Server:

hostname : ebs-bah-xxx-yyy.zzzzz.com
target hostname : ebs-leb-xxx-yyy.zzzzz.com

removed the directory of fs2, fs1/FMW_Home, fs1/inst and fs_ne

[appluat@ebs-leb-xxx-yyy bin]$ perl adcfgclone.pl appsTier

Copyright (c) 2002, 2015 Oracle Corporation
Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.60

***********************************************************
In AD-TXK Delta 7, we recommend you clone the run and patch
file systems in a single operation using the ‘dualfs’ option.
Separate cloning of the run and patch file systems will be deprecated
************************************************************

Enter the APPS password :

Enter the Weblogic AdminServer password :

Do you want to add a node (yes/no) [no] :

Running: Context clone…

Log file located at /u01/LEBUAT/fs1/EBSapps/comn/clone/bin/CloneContext_1203103249.log

Target System File Edition type [run] :

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [ebs-leb-xxx-yyy] :

Target System Database SID : LEBUAT

Target System Database Server Node [ebs-leb-xxx-yyy] : dbs-leb-xxx-yyy

Target System Database zzzzz Name [zzzzz.com] :

Target System Base Directory : /u01/LEBUAT

Target System Base Directory set to /u01/LEBUAT

Target System Current File System Base set to /u01/LEBUAT/fs1

Target System Other File System Base set to /u01/LEBUAT/fs2

Target System Fusion Middleware Home set to /u01/LEBUAT/fs1/FMW_Home

Target System Web Oracle Home set to /u01/LEBUAT/fs1/FMW_Home/webtier

Target System Appl TOP set to /u01/LEBUAT/fs1/EBSapps/appl

Target System COMMON TOP set to /u01/LEBUAT/fs1/EBSapps/comn

Target System Instance Home Directory [/u01/LEBUAT] :

Target System Instance Top set to /u01/LEBUAT/fs1/inst/apps/LEBUAT_ebs-leb-xxx-yyy

Do you want to preserve the Display [0.0] (y/n) : n

Target System Display [ebs-leb-xxx-yyy:0.0] :

Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [disabled] :

Do you want the target system to have the same port values as the source system (y/n) [y] ? :
Validating if the source port numbers are available on the target system..
Complete port information available at /u01/LEBUAT/fs1/EBSapps/comn/clone/bin/out/LEBUAT_ebs-leb-xxx-yyy/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /usr/tmp
3. /u01/LEBUAT/db/tech_st/11.2.0/appsutil/outbound/LEBUAT_ebsprodleb
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :
The new APPL_TOP context file has been created :
/u01/LEBUAT/fs1/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml
Check Clone Context logfile /u01/LEBUAT/fs1/EBSapps/comn/clone/bin/CloneContext_1203103249.log for details.

Running Rapid Clone with command:

Running:
perl /u01/LEBUAT/fs1/EBSapps/comn/clone/bin/adclone.pl java=/u01/LEBUAT/fs1/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/LEBUAT/fs1/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/LEBUAT/fs1/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/LEBUAT/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /u01/LEBUAT/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/LEBUAT/fs1/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml -stage /u01/LEBUAT/fs1/EBSapps/comn/clone -log /u01/LEBUAT/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply – Tue Dec 3 10:33:28 2019

/u01/LEBUAT/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/java:/u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/u01/LEBUAT/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/LEBUAT/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/LEBUAT/fs1/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml -stage /u01/LEBUAT/fs1/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/LEBUAT/fs1/inst/apps/LEBUAT_ebs-leb-xxx-yyy/admin/log/clone/ApplyAppsTier_12031033.log
/ 0% completed

start the service

[appluat@ebs-leb-xxx-yyy scripts]$ ./adstrtal.sh apps/password

[appluat@ebs-leb-xxx-yyy scripts]$ perl adpreclone.pl appsTier

[appluat@ebs-leb-xxx-yyy scripts]$ ./adstpall.sh apps/password

copy the files to fs2

[appluat@ebs-leb-xxx-yyy fs1]$ cp -r EBSapps/ /u01/LEBUAT/fs2/

[appluat@ebs-leb-xxx-yyy bin]$ perl adcfgclone.pl appsTier

Copyright (c) 2002, 2015 Oracle Corporation
Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.60

***********************************************************
In AD-TXK Delta 7, we recommend you clone the run and patch
file systems in a single operation using the ‘dualfs’ option.
Separate cloning of the run and patch file systems will be deprecated
************************************************************

Enter the APPS password :

Enter the Weblogic AdminServer password :

Do you want to add a node (yes/no) [no] :

Running: Context clone…

Log file located at /u01/LEBUAT/fs2/EBSapps/comn/clone/bin/CloneContext_1203135510.log

Target System File Edition type [run] : patch

Enter the full path of Run File System Context file : /u01/LEBUAT/fs1/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml

Provide the values required for creation of the new APPL_TOP Context file.

Target System Fusion Middleware Home set to /u01/LEBUAT/fs2/FMW_Home

Target System Web Oracle Home set to /u01/LEBUAT/fs2/FMW_Home/webtier

Target System Appl TOP set to /u01/LEBUAT/fs2/EBSapps/appl

Target System COMMON TOP set to /u01/LEBUAT/fs2/EBSapps/comn

Target System Instance Top set to /u01/LEBUAT/fs2/inst/apps/LEBUAT_ebs-leb-xxx-yyy

Target System Port Pool [0-99] : 66

Checking the port pool 66
done: Port Pool 66 is free
Report file located at /u01/LEBUAT/fs2/inst/apps/LEBUAT_ebs-leb-xxx-yyy/admin/out/portpool.lst
The new APPL_TOP context file has been created :
/u01/LEBUAT/fs2/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml
Check Clone Context logfile /u01/LEBUAT/fs2/EBSapps/comn/clone/bin/CloneContext_1203135510.log for details.

Running Rapid Clone with command:

Running:
perl /u01/LEBUAT/fs2/EBSapps/comn/clone/bin/adclone.pl java=/u01/LEBUAT/fs2/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/LEBUAT/fs2/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/LEBUAT/fs2/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/LEBUAT/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /u01/LEBUAT/fs2/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/LEBUAT/fs2/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml -stage /u01/LEBUAT/fs2/EBSapps/comn/clone -log /u01/LEBUAT/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply – Tue Dec 3 13:56:28 2019

/u01/LEBUAT/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/java:/u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/oui/share.jar:/u01/LEBUAT/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/LEBUAT/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/LEBUAT/fs2/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml -stage /u01/LEBUAT/fs2/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/LEBUAT/fs2/inst/apps/LEBUAT_ebs-leb-xxx-yyy/admin/log/clone/ApplyAppsTier_12031356.log
| 0% completed

Looking for incomplete CLONE record in ad_adop_session_patches table

The CLONE record status is no rows selected

[appluat@ebs-leb-xxx-yyy LEBUAT]$ . ./EBSapps.env run

E-Business Suite Environment Information
—————————————-
RUN File System : /u01/LEBUAT/fs1/EBSapps/appl
PATCH File System : /u01/LEBUAT/fs2/EBSapps/appl
Non-Editioned File System : /u01/LEBUAT/fs_ne

DB Host: dbs-leb-xxx-yyy.zzzzz.com Service/SID: LEBUAT

Sourcing the RUN File System …

[appluat@ebs-leb-xxx-yyy LEBUAT]$ cd $ADMIN_SCRIPTS_HOME
[appluat@ebs-leb-xxx-yyy scripts]$ pwd
/u01/LEBUAT/fs1/inst/apps/LEBUAT_ebs-leb-xxx-yyy/admin/scripts
[appluat@ebs-leb-xxx-yyy scripts]$ ./adstrtal.sh apps/password

You are running adstrtal.sh version 120.24.12020000.11

Enter the WebLogic Server password:

Service started with new changed hostname.

Dec 1

2 Comments

java.lang.Exception: RC-50007: Could not create cloning stage area

I am trying to run adpreclone.pl for dbTier but I am getting the below error during the stage creation.

StackTrace –
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at oracle.apps.ad.clone.util.CloneProcessor.run(Unknown Source)
at java.lang.Thread.run(Thread.java:682)
Caused by: java.lang.Exception: RC-50007: Could not create cloning stage area at /u01/app/oracle/db/tech_st/12c/appsutil/clone/
Raised by oracle.apps.ad.clone.util.CreateCloningStage
at oracle.apps.ad.clone.util.CreateCloningStage.<init>(CreateCloningStage.java:155)
at oracle.apps.ad.clone.util.CreateCloningStage.<init>(CreateCloningStage.java:116)
at oracle.apps.ad.clone.util.CreateCloningStage.<init>(CreateCloningStage.java:101)
at oracle.apps.ad.clone.StageDBTechStack.doStage(StageDBTechStack.java:285)
at oracle.apps.ad.clone.StageDBTechStack.<init>(StageDBTechStack.java:272)
at oracle.apps.ad.clone.StageDBTier.<init>(StageDBTier.java:156)
… 6 more

 

Solution :

set the below noted environment in context file instead of path set “/u01/app/oracle/db/tech_st/12c/appsutil/clone/jre//bin/java”

 

the path should be like below

<JDK_TOP oa_var=”s_jdktop”>/u01/app/oracle/db/tech_st/12c/jdk/jre/</JDK_TOP>
<JRE_TOP oa_var=”s_jretop”>/u01/app/oracle/db/tech_st/12c/jdk/jre/</JRE_TOP>

After that, you need to do the autoconfig(adconfig.pl) for database tier and then i tried to run adpreclone.pl, it’s successful.