Monthly Archives: February 2015

How to enable Exadata writeback Flashcache on cell storage ? (WriteThrough to WriteBack)

How to enable Exadata writeback Flashcache on cell storage ? (WriteThrough to WriteBack) from Anar Godjaev

How to fix “OPatch failed with error code 41” in Exadata X4 Machine

While applying a patch through “opatch”, the prerequisite check might fail with error “CheckActiveFilesAndExecutables” failed. Here is an example of this issue and how it can be resolved. When I tried applying the patch to my database home, the prerequisite check failed and barked out saying that some of the executables were active. It also […]

Drop Oracle Lobs

I dropped all the objects using, select ‘DROP ‘ object_type ‘ ‘ owner ‘.’ object_name ‘;’ from dba_objects where owner in (upper(‘&UserName’)) and object_type in (‘TABLE’, ‘VIEW’, ‘PROCEDURE’, ‘FUNCTION’, ‘PACKAGE’, ‘SEQUENCE’, ‘TRIGGER’) order by object_id desc; But then, lobs were still present. select count(1) from dba_objects where owner = ‘MISLIVE’; COUNT(1) ———- 84 1 row […]

Expdp Error / ORA-31617/ORA-19505/ORA-27037

When trying to expdp the below error appear : expdp anar/xxxxxx directory=TABLE_BACKUP dumpfile=before.dmp logfile=before.log EXCLUDE=table:”IN(‘T_PST_SMSMESSAGELOG’\,’DD_SERVICE_CALL_LOG_X’)” schemas=’OC_UNW’,’OC_ABS’,’OC_ATM’,’OC_SCR’,’OC_SCN’,’OC_SCE’,’OC_RPT’,’OC_PRM’,’OC_POS’,’OC_MSN’,’OC_MSC’,’OC_MRC’,’OC_MON’,’OC_MIS’,’OC_EOC’,’OC_ENT’,’OC_EMV’,’OC_CST’,’OC_CRD’,’OC_CMP’,’OC_CLR’,’OC_BIN’,’OC_WBS’,’OC_VIS’,’OC_TXN’,’OC_TSK’,’OC_SHR’,’OC_SYS’,’OC_CON’,’OC_YKB’,’OC_EOD’,’OC_BPS’ parallel=4 compression=all ORA-31693: Table data object “OC_CON”.”OPERATION_EXECUTION_LOG” failed to load/unload and is being skipped due to error: ORA-31617: unable to open dump file “/backup/before.dmp” for write ORA-19505: failed to identify file “/backup/before.dmp” ORA-27037: unable to obtain file status SVR4 […]

ORA-19705: tag value exceeds maximum length of 31 characters

Error: ORA-19705: tag value exceeds maximum length of 31 characters Details: This error occurs when running a backup Cause:The database either crashed or was shutdown with the ABORT option. Media recovery cannot be enabled because the online logs may not be sufficient to recover the current datafiles. Solution:Supply a shorter tag in the backup script […]

ORU-10027: buffer overflow, limit of bytes

This is caused by the value of the ‘serveroutput’ setting in SQL*Plus. The same error can be seen directly in SQL*Plus as follows: SQL> set serveroutput on size 2000 SQL> […] 12345678901234567890123456789012345678901234567890 12345678901234567890123456789012345678901234567890 begin * ERROR at line 1: ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes ORA-06512: at “SYS.DBMS_OUTPUT”, line 32 ORA-06512: at “SYS.DBMS_OUTPUT”, […]

Move spfile to ASM

Create a copy of the SPFILE in the ASM disk group. If the database is using an SPFILE already, then run these commands: run { BACKUP AS BACKUPSET SPFILE; RESTORE SPFILE TO “+DISK/spfile”; }