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], [], [], [], [], [],…
Category Uncategorized
Error : ORA-00600: internal error code, arguments: [KGL-heap-size-exceeded], Heap size 518675K exceeds notification threshold (51200K) DDE: Problem Key ‘ORA 600…
Oracle 11.2.0.2 contains enhancements 9282521 and 9239863 named “Library cache: mutex X” for objects highly contended for. Part I and…
Now that I have got your attention with my sales pitch. Let me quote a sales pitch we have heard…
The page has expired. Click OK to continue. This we can read if our Cloud Control session has expired. The…
If you have worked in any sort of Enterprise big or small, most likely you have worked on a Relational…
Done it .. 1. Here is the customer feedback form – customer enters feedback text and presses submit feedback button…
Recently I had a requirement to send a HTML based email from my apex application. The HTML content was actually…
This error is mostly due to a mismatch in the Java system classes. It happened to us when we cloned…
Quick post more for myself as I seem to continually forget how to construct a proper EXCLUDE on the command…
— If doing on Source Server — ::12c–>sqlplus “/as sysdba” set head off pages 0 feed off echo off verify…
We want to make a test database from production database. And our production database is on ASM and our test…
spool index_rebuild.sql select ‘alter index ‘||owner||’.’||index_name ||’ rebuild online nologging;’ from dba_indexes where owner=upper(‘SAMPLE’); spool off
IntroI recently had a situation where I was troubleshooting a system that had fallen victim to some intermittent and very…
Query to Select the First Day and Last Day of the Current Month select trim(to_date(last_day(sysdate),’DD/MM/YYYY’)) as lastday from dual; select…
The new PL/SQL procedure REDEF_TABLE in Oracle 12c lets you redefine a table online in a single step. It can…
One of the amazing features of Oracle Database 12c is that now you can do a logical restore from…
This is caused by a mismatch between the character set in which the table radm_fptm$ is created and in which…
Every DBA knows that: SQL*Plus is a powerful tool, but its output is often almost unreadable. Do we have to…
Here is a quick tutorial on how to set up LDAP authentication with Oracle Application Express 4.1.1. Let’s assume that…
Oracle 12c TDE on RAC Database with Physical Standby RAC. The Oracle Database Home has Multiple Instances, due to which…
I had my database streams capture process stuck at WAITING FOR DICTIONARY REDO : FIRST SCN 52170068520 status when re-starting the capture…
I’ve come across many posts in the OTN forums wherein the OP faces sync issues between the Physical Standby and…