JAR CODE SIGN
1.###KEY CREATION####adjkey -initialize -keysize 2048 -alias LKcorp
2.####CSR CREATION#####keytool -sigalg SHA256withRSA -certreq -keystore adkeystore.dat -file adkeystore.csr -alias LKcorp
3.######CSR VALIDATION#####openssl req -text -noout -verify -in adkeystore.csr
***BEFORE THAT REMOVE .dat file and adsign.txt file*****NE_BASE LOCATION**
3.###IMPORT###adjkey -keystore adkeystore.dat -storepass myxuan -import -alias LKcorp -trustcacerts -file adkeystore64.cer
4.###KEY VIEW###keytool -list -v -keystore adkeystore.dat
5.###INCASE OF USING KEYTOOL###
keytool -import -file adkeystore64.cer -trustcacerts -alias LKcorp -keystore adkeystore.dat -storepass oraclest -keypass oracle12 -v
(or)
keytool -import -trustcacerts -alias LKcorp -file LK*Corporation.p7b -keystore adkeystore.dat -storepass oraclest -keypass oracle12 -v
6.###KEY VIEW###keytool -list -v -keystore adkeystore.dat
7.REGEN PRODUCT JAR USING ADADMIN
##############################################################################
The most current version of this document can be obtained through My Oracle Support Knowledge Document 1591073.1.
############VALIDATION#####
[applmgr@server scripts]$ cd $COMMON_TOP/java/classes/oracle/apps/fnd/jar
[applmgr@server jar]$ jarsigner -verify -verbose -certs fndall.jar|head -10
Req-history.sql
REM +======================================================================+
REM
REM File Name: reqhistory.sql
REM
REM Description:
REM Query To Check Concurrent Program Run History
REM
REM Notes:
REM Usage: sqlplus <apps_user/apps_passwd> @reqhistory.sql
REM
REM Input Required :
REM Number of days and User Concurrent Program Name
REM
REM +======================================================================+
ACCEPT NO_DAYS PROMPT "Enter Number of Days for History: ";
ACCEPT USER_CONC_PROG_NAME PROMPT "Enter User Concurrent Program Name: ";
clear columns
set lines 180
set pages 100
col Parameters for a20 WORD_WRAPPED
set pages 100
col "Conc Program Name" for a30 WORD_WRAPPED
col "Started at" for a20
col "Completed at" for a20
col "Username" for a10 WORD_WRAPPED
SELECT distinct t.user_concurrent_program_name "Conc Program Name",
r.REQUEST_ID "Request ID",
to_char(r.ACTUAL_START_DATE,'dd-MON-yy hh24:mi:ss') "Started at",
to_char(r.ACTUAL_COMPLETION_DATE,'dd-MON-yy hh24:mi:ss') "Completed at",
decode(r.PHASE_CODE,'C','Completed','I','Inactive','P','Pending','R','Running','NA') "Phasecode",
decode(r.STATUS_CODE, 'A','Waiting', 'B','Resuming', 'C','Normal', 'D','Cancelled', 'E','Error', 'F','Scheduled', 'G','Warning', 'H','On Hold', 'I','Normal', 'M',
'No Manager', 'Q','Standby', 'R','Normal', 'S','Suspended', 'T','Terminating', 'U','Disabled', 'W','Paused', 'X','Terminated', 'Z','Waiting') "Status",r.argument_text "Parameters",
u.user_name "Username",
--ROUND ((v.actual_completion_date - v.actual_start_date) * 1440,
-- 2
-- ) "Runtime (in Minutes)"
round(((nvl(v.actual_completion_date,sysdate)-v.actual_start_date)*24*60),2) "ElapsedTime(Mins)"
FROM
apps.fnd_concurrent_requests r ,
apps.fnd_concurrent_programs p ,
apps.fnd_concurrent_programs_tl t,
apps.fnd_user u, apps.fnd_conc_req_summary_v v
WHERE
r.CONCURRENT_PROGRAM_ID = p.CONCURRENT_PROGRAM_ID
AND r.actual_start_date >= (sysdate - &NO_DAYS)
--AND r.requested_by=22378
AND r.PROGRAM_APPLICATION_ID = p.APPLICATION_ID
AND t.concurrent_program_id=r.concurrent_program_id
AND r.REQUESTED_BY=u.user_id
AND v.request_id=r.request_id
--AND r.request_id ='2260046' in ('13829387','13850423')
and t.user_concurrent_program_name like '&USER_CONC_PROG_NAME'
order by to_char(r.ACTUAL_COMPLETION_DATE,'dd-MON-yy hh24:mi:ss') desc;
undef NO_DAYS
undef USER_CONC_PROG_NAME
INSTANCE-WORKINGSLOW
NODE_NAME SUPPORT_DB SUPPORT_CP SUPPORT_ADMIN SUPPORT_WEB SUPPORT_FORMS STATUS HOST DOMAIN
--------------- ------------ ------------ --------------- ------------ --------------- ---------- --------------- --------------------
AUTHENTICATION N N N N N
LUPIN-PROD N Y Y Y Y Y LUPIN-PROD lupin.com
LUPIN-PROD-server2 N Y Y Y Y Y LUPIN-PROD-server2 lupin.com
LUPIN-PROD-dbserver Y N N N N Y LUPIN-PROD-dbserver lupin.com
NO LOCKS
=========
SQL> select name from v$database;
NAME
---------
DEV1EBS
SQL> set pages 300 lines 300
SELECT inst_id, DECODE(request,0,'Holder: ','Waiter: ')|| sid sess, id1, id2, lmode,request, type
FROM GV$LOCK WHERE (id1, id2, type) IN (SELECT id1, id2, type FROM GV$LOCK WHERE request>0)
ORDER BY id1, request;SQL> 2 3
no rows selected
NO CPU PERFORMANCE EFFECTED ON DB AND CM NODE AS WELL
================================================
[appldev1@LUPIN-PROD-server2 ~]$ CONCSUB apps/apps_dev1 SYSADMIN 'System Administrator' SYSADMIN WAIT=N CONCURRENT FND FNDSCURS > rleq.txt
[appldev1@LUPIN-PROD-server2 ~]$ cat rleq.txt
Submitted request 16270034 for CONCURRENT FND FNDSCURS
CONCURENT_REQUEST STATUS CHECKING
=================================
col USER_CONCURRENT_PROGRAM_NAME for a20
col CONCURRENT_PROGRAM_ID for a20
col REQUEST_ID for a20
col ACTUAL_START_DATE for a10
col REQUEST_ID for a40
spool healthcheck.txt
set lines 300
select a.user_concurrent_program_name,a.CONCURRENT_PROGRAM_ID ,REQUEST_ID,REQUEST_TYPE,PHASE_CODE,STATUS_CODE,ACTUAL_START_DATE,COMPLETION_TEXT from fnd_concurrent_programs_tl a, fnd_concurrent_requests b
where a.concurrent_program_id=b.concurrent_program_id and program_application_id=0 and REQUEST_ID=&ID;
spool off;
exit;
1656591
USER_CONCURRENT_PROG CONCURRENT_PROGRAM_ID REQUEST_ID R P S ACTUAL_STA COMPLETION_TEXT
-------------------- --------------------- ---------- - - - ---------- --------------------
Активные пользовател ########## ########## C C 02-JUN-20 Normal completion
и
Usuarios Activos ########## ########## C C 02-JUN-20 Normal completion
Aktivni korisnik ########## ########## C C 02-JUN-20 Normal completion
Active Users ########## ########## C C 02-JUN-20 Normal completion
Aktywni użytkownicy ########## ########## C C 02-JUN-20 Normal completion
Aktívni používatelia ########## ########## C C 02-JUN-20 Normal completion
6 rows selected.
col OWNER for a10
col DIRECTORY_NAME for a30
col DIRECTORY_PATH for a30
col ORIGIN_CON_ID for a10
select * from dba_directories where DIRECTORY_NAME like '%&DIRNME%';
Enter value for dirnme: XXGLO_PA_DRAFT_INV_DIR