Monday 30 March 2020

Function not available to this responsibility. Change Responsibilities or contact your System Administrator



Add the custom path to file

$INST_TOP/ora/10.1.2/forms/server/default.env

XXCUSTOM=/u01/app/EBS/apps/apps_st/appl/xxcustom/12.0.0

Saturday 28 March 2020

isgagent.properties

ISG_SOA_EXTERNAL_URL=http://pft.adpentest.pension.gov.ae:8010
ISG_SOA_INTERNAL_URL=http://pft.adpentest.pension.gov.ae:8010
ISG_SOA_ADMIN_SERVER_URL=http://pft.adpentest.pension.gov.ae:7026
ISG_SOA_ADMIN_USER=ASADMIN
ISG_SOA_ORACLE_HOME=%s_soa_oracle_home%
ISG_AGENT_JNDI_NAMES=EBS
EBS.ISG_RUNTIME_CONTEXT=AGENT
EBS.ISG_TEMP_DIRECTORY_LOCATION=/u01/app/EBS/fs_ne/inst/EBS_pft1/soa/
EBS.ISG_EBS_EXTERNAL_URL=http://pft.adpentest.pension.gov.ae:80
EBS.ISG_EBS_INTERNAL_URL=http://pft.adpentest.pension.gov.ae:80
javax.xml.parsers.DocumentBuilderFactory=oracle.xml.jaxp.JXDocumentBuilderFactory
EBS.ISG_EBS_ADMIN_SERVER_URL=http://pft1.adpentest.pension.gov.ae:7026
#EBS.ISG_CLEAR_JPUB_CACHE=YES

Friday 27 March 2020

There is already an ACTIVE ADOP CYCLE with session id : SP2-0640: Not connected adpreclone cannot be run with pending ADOP session


To resolve the issue test the following steps in a development instance and then migrate accordingly:
1. Download Patch 22271970: ADPRECLONE.PL FAILS ON DELTA 7 along with any required pre-req patches.
2. Apply Patch 22271970 along with any required pre-req patches per the readme instructions.
3. Retest adpreclone.pl and confirm the script runs to completion.

adcfgclone.pl appsTier autoconfig is failing on patch file systemORA-12514: TNS:listener does not currently know of service requested in connect descriptor

1.Source RUN File system environment.

. EBSapps.env Run

2. - As apps user disable logon trigger

exec ad_zd.ALTER_LOGON_TRIGGER('DISABLE');
commit;

3. - Source PATCH file system env

4. Run AutoConfig

5. Connect to run filesystem by sourcing run fs environment
6. - As apps user enable logon trigger

exec ad_zd.ALTER_LOGON_TRIGGER('DISABLE');
commit;

The Server is not able to service this request: [Socket:000445]Connection rejected, filter blocked Socket, weblogic.security.net.FilterException: [Security:090220]rule 2

Trying to access weblogic admin server getting, after I ran ETCC for EBS R12.2

The Server is not able to service this request: [Socket:000445]Connection rejected, filter blocked Socket, weblogic.security.net.FilterException: [Security:090220]rule 2



In order to fix this issue, please take a backup config.xml in your domain, then remove the following lines:

Example:
/u01/app/EBS/fs2/FMW_Home/user_projects/domains/EBS_domain_EBS/config/config.xml

 oracle.apps.ad.tools.configuration.wls.filter.EBSConnectionFilterImpl
 . * * allow
 0.0.0.0/0 * * deny
 true

 Once done, save and restart the services.

Thursday 26 March 2020

RMAN-06556: datafile 1 must be restored from backup older than SCN


Issue - When recovering database until SCN, recovery failed with error  RMAN-03002 and RMAN-06556

using channel ORA_DISK_8
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/17/2018 20:53:35
RMAN-06556: datafile 1 must be restored from backup older than SCN 5761437810

Solution -
Below scripts useful to identify the SCN for the data files can be recovered -
1.
select  min(FHSCN) "LOW FILEHDR SCN", max(FHSCN) "MAX FILEHDR SCN", max(FHAFS) "Min PITR ABSSCN"from X$KCVFH ;

LOW FILEHDR SCN  MAX FILEHDR SCN  Min PITR ABSSCN
---------------- ---------------- ----------------
5761438110       5761438110       0

2.

SQL> select file#, status, checkpoint_change# from v$datafile where STATUS like '%SYS%';

     FILE# STATUS  CHECKPOINT_CHANGE#
---------- ------- ------------------
         1 SYSTEM          5761438110



RMAN>  recover database until scn 5761438110;

Starting recover at 17-JUL-18
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8

starting media recovery
media recovery complete, elapsed time: 00:00:00

Finished recover at 17-JUL-18

Wednesday 11 March 2020

Test

LicenseKey: CJ2PFCQ6P49Q4WHQT2D03GNTVX2AN5DG6FWD04YL4QW625KT391J9YF38VKB92SNBWNW-RU-BOARD-BD
SiteMessage: cr2384

Number of Visitors