Extended Support Fee Waiver for Oracle Database 12.1 and 11.2 for Oracle E-Business Suite
refer :
Apr 27
1 Comment
Mar 29
List of users with responsibilities
SELECT d.employee_number EMPLOYEE_ID,d.full_name EMPLOYEE_NAME,a.USER_NAME USERID,e.name POSITION,frv.responsibility_name RESPONSIBILITIES_ASSIGNED,
decode(a.END_DATE,NULL,’ACTIVE’,’INACTIVE’) Status,a.start_date,a.end_date,a.last_logon_date,d.internal_location
FROM apps.fnd_responsibility_vl frv,apps.FND_USER a,apps.FND_USER_RESP_GROUPS_all b,apps. per_all_people_f d,apps.FND_RESPONSIBILITY_TL res,PER_JOBS_VL e,
per_all_assignments_f f
WHERE
d.person_id=f.person_id and
b.responsibility_id = res.responsibility_id
and a.USER_ID=b.USER_ID and b.RESPONSIBILITY_ID=frv.RESPONSIBILITY_ID and a.employee_id=d.person_id
and sysdate between d.effective_start_date and d.effective_end_Date
and sysdate between nvl(frv.start_date,sysdate) and nvl(frv.end_date,sysdate)
AND f.job_id = e.job_id
group by d.employee_number,a.USER_NAME,frv.responsibility_name, d.full_name,b.START_DATE,b.end_date,decode(a.END_DATE,NULL,’ACTIVE’,’INACTIVE’),
a.start_date,a.end_date,a.last_logon_date,e.name,d.internal_location
ORDER BY d.full_name
Java webstart at EBS 12.2.9
I upgraded EBS Version from 12.1.3 to 12.2.9. After upgraded, i planned to setup the Java webstart for EBS 12.2.9 version. As such, i review the document (Doc ID 2188898.1), this document clearly explained about how to setup the java webstart on EBS.
There was many patches noted to apply on EBS version for java webstart. But my case, I have already upgraded to latest version. so all the patches are included whichever required.
Section : 4.2.2 Oracle Forms 10g Technology Patch for Oracle E-Business Suite Release 12.2
the document noted to apply the patch Patch 25441839 but Patch 26825525 already applied during upgrade activity. so no need to apply the patch 25441839 (Doc ID 2554599.1).
you need to follow further steps for Java webstart setup.
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
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
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.
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)
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
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.
DBA 