ORA-28056: Writing audit records to Windows Event Log failed

I am trying to recover a table using by RMAN but I am getting the below issue

Database version : 12.2.0.1.0

OS : Windows 10

Error :

RMAN> RECOVER TABLE TBSPIR.’TEST’
2> UNTIL time “to_date(’14-JUL-2019 14:20:10′,’DD-MON-YYYY HH24:MI:SS’)”
3> AUXILIARY DESTINATION ‘C:\app\tbspir’
4> REMAP TABLE ‘TBSPIR’.’TEST’:’TEST_PREV’;

 

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/16/2019 11:16:42
RMAN-04006: error from auxiliary (more...)

reclaim reserved available free space on linux

reclaim reserved available free space

 

[root@dbs-xxx-4-131 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol01
65G 2.7G 59G 5% /
/dev/mapper/VolGroup01-LogVol00
679G 35G 609G 6% /u01
/dev/sda1 996M 46M 899M 5% /boot
tmpfs 7.8G 0 7.8G 0% /dev/shm
/dev/sdc1 886G 200M 841G 1% /Backup

 

 

[root@dbs-ruh-4-131 ~]# tune2fs -m 0 /dev/sdc1
tune2fs 1.39 (29-May-2006)
Setting reserved blocks percentage to 0% (0 blocks)

[root@dbs-xxx-4-131 ~]# df -h
Filesystem (more...)

java.lang.RuntimeException: Connection refused

Workflow notification mailer not starting after auto config run on ebs 12.1.

Solution :

check your workflow notification mailer as advanced tab, can you able to reach the outbound and inbound server. If not, check outbound email server name with port and inbound server name with port. If those information was correct, Still you have issue then Can you try to reach the outbound and inbound servers with port from application servers.

Oracle database 19c step by step installation guide on oracle linux 7.6

Oracle database 19c installation document

Oracle Database 19c step by step installation guide on Oracle Linux 7.6

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”

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

VMware free self paced e-learning course

https://mylearn.vmware.com/mgrReg/plan.cfm?plan=33611&src=so_5a314d05ddb83&cid=70134000001SkJd