Why parallel expdp gives unable to write error DATAPUMP With PARALLEL > 1 ON 11.2 RAC

hello, Problem: Datapump on 11.2 RAC with PARALLEL > 1  hits the following errors. ORA-31693: Table data object "IIR_USER"."IDS_00_INUSE" failed to load/unload and is being skipped due to error: ORA-31617: unable to open dump file "/export/expıırdb_04.dmp" for write ORA-19505: failed to identify file "/export/expıırdb_04.dmp" ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or … Continue reading Why parallel expdp gives unable to write error DATAPUMP With PARALLEL > 1 ON 11.2 RAC

Advertisements

Oracle 11g: DDL WAIT Option (DDL_LOCK_TIMEOUT)

Hello,In Oracle 11g, the new initialization parameter DDL_LOCK_TIMEOUT controls the duration (in seconds) for which a DDL statement will wait for a DML lock.The maximum value of 1,000,000 seconds will result in the DDL statement waiting forever to acquire a DML lock. The default value of zero indicates a status of NOWAIT. SQL> show parameter DDL_LOCK_TIMEOUT; NAME … Continue reading Oracle 11g: DDL WAIT Option (DDL_LOCK_TIMEOUT)

ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device

hello, problem : ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device   Linux-x86_64 Error: 28: No space left on device Additional information: 4 Additional information: 981795 Additional information: -1 ORA-31693: Table data object "EBDYSLIVE"."VeriTarihcesi":"SYS_P726" failed to load/unload and is being skipped due to error: ORA-31644: unable to position to block number 842047 … Continue reading ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device

PLS-00201: identifier ‘DBMS_LOCK’ must be declared

The Oracle schema does not have access to the DBMS_LOCK package. solution  : 1. Launch an sqplus / as sysdba 2. Connect/logon to the database, using administrative credentials 3. Run the following script: we are giving grant execute on the packages owner. commands : GRANT execute ON DBMS_LOCK TO packages_owner ( schema_name ) ; have … Continue reading PLS-00201: identifier ‘DBMS_LOCK’ must be declared

ORA-01555 or Alter _highthreshold_undoretention integer

hello, Setting either of this parameter will limit high value of undo retention like as ; Description: _highthreshold_undoretention integer : high threshold undo_retention in seconds connect as sysdba alter system set "_HIGHTHRESHOLD_UNDORETENTION=21600" SCOPE=spfile; you need to close and open database !! SQL> show parameter undo; NAME TYPE ------------------------------------ -------------------------------- VALUE ------------------------------ _highthreshold_undoretention integer 17200 undo_management string … Continue reading ORA-01555 or Alter _highthreshold_undoretention integer

Oracle Grid installation: roothas.pl fails with “Oracle Restart stack is not act

root.sh fails during execution for an Oracle Grid Infrastructure 11.2 installation with following messages . "Oracle Grid installation: roothas.pl fails with “Oracle Restart stack is not act" Solution 1: Clead up the ASM Disks Once you attempt an installation, your ASM disks are marked as being used, so they can no longer be used as … Continue reading Oracle Grid installation: roothas.pl fails with “Oracle Restart stack is not act

PL/SQL: could not find program unit being called– Errors

hello, if you are executing Plsql scripts sometimes you can see this errors. PL/SQL: could not find program unit being called. Solutions : Check that all packages, procedure, Functions,programs, including their package bodies is invalid.  You must change status all invalid object to valid.  plsql> EXEC PCOMFLX_PR.MIGRATION.FULL_MIGRATION(2121); Error : ORA-04063: package body "PCOMFLX_PR.MIGRATION" has errors ORA-06508: … Continue reading PL/SQL: could not find program unit being called– Errors