Oracle 11g Stream: Change Stream Dump Location

Problem:

Non critical error ORA-48180 caught while writing to trace file "/usr2/app/oracle/diag/rdbms/GOWEEKENDCA/GOWEEKENDCA/trace/GOWEEKENDCA_ora_1436.trc"
Error message: SVR4 Error: 28: No space left on device
Additional information: 1
Writing to the above trace file is disabled for now on...
Errors in file /usr2/app/oracle/diag/rdbms/GOWEEKENDCA/GOWEEKENDCA/trace/GOWEEKENDCA_ora_1436.trc:
ORA-19502: write error on file "/usr2/app/oracle/admin/GOWEEKENDCA/dpdump/streams_setup_2013_5_28_14_22_50_896.dmp", block number 3617537 (block size=4096)
ORA-27063: number of bytes read/written is incorrect
SVR4 Error: 28: No space left on device

Analysis:

In the Stream setup scripts, you can find below snippet, ORA_EM_STRM_DPUMP_10205 is the key to fix the problem. /usr2 ran out of space, either increase ORA_EM_STRM_DPUMP_10205 space or to map it to somewhere with enough space.

dbms_file_transfer.put_file(
source_directory_object => '"ORA_EM_STRM_DPUMP_10205"',
source_file_name => 'streams_setup_2013_5_28_14_22_50_896.dmp',
destination_directory_object => '"ORA_EM_STRM_DPUMP_10205"',
destination_file_name => 'streams_setup_2013_5_28_14_22_50_896.dmp',
destination_database => 'GOWEEKENDCA');

the directory is defined in dba_directories, but you cannot update it directly.

Solution:

Do below on both of source and destination instance accordingly

SQL> DROP DIRECTORY ORA_EM_STRM_DPUMP_10205;

Directory dropped.

SQL> create directory ORA_EM_STRM_DPUMP_10205 as '/dbfs/admin/GOWEEKENDCA/dpdump';

Directory created.