Oracle Apex is a modern framework to quickly develop and deploy web apps sitting on top of Oracle Database. Apex…
Category Database
So you have got your Oracle APEX instance up and running and you want to customize your first app. The…
This error most likely occurred when you duplicated a database and the DB_NAME parameter in spfile is not matching the…
Upgrade from Exadata X4-2 11g (11.2.0.4) to Exadata X7-2 12CR1 (12.1.0.2.0) : ASM to ASM Oracle Database 11.2.0.3and 11.2.0.4 to…
Source Database ————— ::: Directory Structure ::: ORACLE_HOME : E:\oracle\product\10.2.0\db_1 RMAN Backup : E:\rman_backup_full Control Files : E:\oradata\ecc DataFiles: E:\oradata\ECC…
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], [], [], [], [], [],…
Error : ORA-00600: internal error code, arguments: [KGL-heap-size-exceeded], Heap size 518675K exceeds notification threshold (51200K) DDE: Problem Key ‘ORA 600…
Now that I have got your attention with my sales pitch. Let me quote a sales pitch we have heard…
If you have worked in any sort of Enterprise big or small, most likely you have worked on a Relational…
This error is mostly due to a mismatch in the Java system classes. It happened to us when we cloned…
— If doing on Source Server — ::12c–>sqlplus “/as sysdba” set head off pages 0 feed off echo off verify…
spool index_rebuild.sql select ‘alter index ‘||owner||’.’||index_name ||’ rebuild online nologging;’ from dba_indexes where owner=upper(‘SAMPLE’); spool off
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…
Oracle 12c TDE on RAC Database with Physical Standby RAC. The Oracle Database Home has Multiple Instances, due to which…
Being a DBA requires us many a times to step outside our role and solve a problem in a smart…
Downloadable free tool from MOS for doing a Security assessment for Oracle Database (compatible with 10.2,11.2,12) https://support.oracle.com/epmos/faces/DocumentDisplay?id=2138254.1
The Unified Auditing in Oracle 12c can Grow the SYSAUX table to a large size. In our case it grew…
[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…
The Below Script will generate output if percentage of tablespace space left free is less tan 20%. You can easily…
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 ###…
The script below can be used to check the Disk Group Space Free and also Check Directory sizes for each…