Category Database

ORA-00600: internal error code, arguments: [audins:Invalid_param_type_for_binding

Error in Alert Log: Errors in file /u03/app/oracle/diag/rdbms/primeprd/primeprd1/trace/primeprd1_ora_303370.trc (incident=1070393): ORA-00600: internal error code, arguments: [audins:Invalid_param_type_for_binding], [], [], [], [], [],…

RMAN Script for Tape Backup : Tivoli Storage Manager

[sourcecode language=”sql”] run { allocate channel sbt1 type sbt parms ‘ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)’; allocate channel sbt2 type sbt parms ‘ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)’; CONFIGURE DEFAULT…

Generate Excel and PDF in Oracle and Send Report by Email

First Install UTL_MAIL ### To install UTL_MAIL: [code language=”sql”] sqlplus sys/**** @$ORACLE_HOME/rdbms/admin/utlmail.sql @$ORACLE_HOME/rdbms/admin/prvtmail.plb [/code] ### Create a Reporting User ###…