Skip to content
Advertisements

Archive for

How to upload alert in r12

FNDLOAD Upload

FNDLOAD apps/password 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XX_Probation_period_alert15days.ldt ALR_ALERTS APPLICATION_SHORT_NAME=XXACE Alert_name=”Probation Period Alert 15 Days”

FNDLOAD Download

FNDLOAD apps/password 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct XX_Probation_period_alert15days.ldt ALR_ALERTS APPLICATION_SHORT_NAME=XXACE Alert_name=”Probation Period Alert 15 Days”

Advertisements

How to calculate archivelog growth per day

archivelog size each day

select trunc(COMPLETION_TIME) TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB from V$ARCHIVED_LOG group by trunc(COMPLETION_TIME) order by 1;

archivelog size each hour

alter session set nls_date_format = ‘YYYY-MM-DD HH24′;

select trunc(COMPLETION_TIME,’HH24′) TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB from V$ARCHIVED_LOG group by trunc (COMPLETION_TIME,’HH24’) order by 1;

Drop all synonym from owner

Drop all synonym from owner

set head off
set newpage none
set pagesize 9999

spool drop_synonym.sql

select ‘drop synonym ‘|| OWNER ||’.’ ||OBJECT_NAME || ‘;’ from dba_objects where OWNER =’OWNER’ and OBJECT_TYPE =’SYNONYM’;

spool off

Databaselink extract

Database link extract

 

SELECT DBMS_METADATA.GET_DDL(‘DB_LINK’,a.db_link,a.owner) FROM dba_db_links a;

 

 

compile jsp in r12

Stop application service

cd $FND_TOP
[appltrng@ebsdev bin]$ perl ojspCompile.pl –compile –flush -p 2

we need to check compiled successfully

start application service