понедельник, 23 января 2012 г.

rac: shutdown all instances immediate

--
-- Check shutdown option for each instance (default - immediate)
--
oracle@rac1:~> crs_stat -p ora.rac.rac1.inst | grep -i stop_mode
USR_ORA_STOP_MODE=immediate
--
-- Stop immediate (if USR_ORA_STOP_MODE<>immediate)
-- 
srvctl stop database -d <db_name> -o immediate

Update BLOB

set define off DECLARE    vb1 CLOB := 'long text';    vb2 CLOB :=                 'long text';    vb3 CLOB :=              ...