ORACLE board

25 October 2010

OS Shall command from Oracle

create or replace procedure host( cmd in varchar2 )
as
    status number;
begin
    dbms_pipe.pack_message( cmd );
    status := dbms_pipe.send_message( 'HOST_PIPE' );
    if ( status <> 0 ) then raise_application_error( -20001, 'Pipe error' );
    end if;
end;

22 October 2010

ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [KELTNFY-LDMINIT]

OS: OEL 5.5
RDBMS: Oracle 10.2.0
Before installing Oracle server do all the jobs with server network (ip, host_naming, etc.) in order to avoid getting error above.

21 October 2010

Oracle External tables

1) Create Oracle Directory
2) Put file (txt, csv) into Directory

Risk management

28 September 2010

Standby monitor

select * from V$ARCHIVE_GAP

27 September 2010

Standby log errors

Error

FAL[client]: Failed to request gap sequence 
 GAP - thread 1 sequence 2-101
 DBID 2236488982 branch 665833900
FAL[client]: All defined FAL servers have been attempted.

Solution
crosscheck archivelog all;

22 September 2010

SGA exceeds 2GB on Linux 32bit

1. edit init.ora

use_indirect_data_buffers=true 
db_block_size=8192 
db_block_buffers=1048576 # 8Gb
shared_pool_size=1415577600 #2831155200 - 2G