장기기억장치

# vmgmt# 원하는 위치에 script를 놓고 사용한다.SCRIPT_DIR=/usr/local/scriptsCOMMAND=$1HEAD="###########################################\n################# My VM ###################\n###########################################";TAIL="###########################################";TXT_FILE="$SCRIPT_DIR/.remote_vmaddr.txt"SED=/usr/bin/sedSSH=/usr/bin/sshif [ -z $COMMAND ];thenecho 'ERROR : Please input your comman..

// 한글 버전 // 영문 버전

-- The script for check Object creation DDL before Migration SET trimspool ON SET heading off; SET feedback off; SET linesize 300 SET echo off; SET pages 10000; SET long 90000; COL DDL FORMAT A10000 execute DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'SQLTERMINATOR',true); EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'STORAGE',false); EXECUTE DB..

// window client NLS_LANG 설정 실행창 > "regedit" HKEY_LOCAL_MACHINE > SOFTWARE > Oracle > KEYOra****Home1 NLS_LANG 설정 변경 // 원격에서는 이상이 없는데 로컬 cmd창에서 깨지는 상태라면 chcp 값과 locale을 의심해봐야한다.

// 19c 에서 impdp, expdp 시 발생하는 에러 ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-39155: error expanding dump file name "c:\Users\Administrator\dp_conv\conv_metadmp" ORA-48128: opening of a symbolic link is disallowed SQL> alter system set "_disable_directory_link_check"=TRUE scope=spfile; SQL> alter system set "_kolfuseslf"=TRUE scope=spfile; SQL> shutdown immediate;..

// ORA-39352: Wrong number of TRANSPORT_DATAFILES impdp system/***** directory=dp_conv dumpfile=convdmp transport_datafiles='+DATA/ORADB/DATAFILE/conv_test01dbf' Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production ORA-39002: invalid operation ORA-39352: Wrong number of TRANSPORT_DATAFILES specified: expected 1, received 2 # 옵션추가 metrics=n exclude=statistics

Exception String: Error in invoking target 'agent nmhs' of makefile '/u01/app/oracle/product/11.2.0/db_1/sysman/lib/ins_emagent.mk'. See '/u01/app/oraInventory/logs/installActions2021-04-19_03-13-59PM.log' for details // 시스템상에 Oracle 11g R2를 Install하는 동안 “Error in invoking target 'agent nmhs' of makefile - during 11g Installation”과 같은 오류가 보고되는 경우 그냥 무시를 하고 진행해도 되지만 “$ emctl status dbconsole” 또는 ..

보호되어 있는 글입니다.

// version 10.15 // occur AccessExclusivLock on table when recover using recover_target_time // 데이터베이스 사용자가 실수로 table drop을 했다고 가정하여 복구 테스트 // base backup -bash-4.2$ pg_basebackup -D /postgres/basebackup/backup_20210315 -p 5401 -F t -z -bash-4.2$ ls -l /postgres/basebackup/backup_20210315 -rw-r--r--. 1 postgres postgres 15531124 Mar 15 15:45 base.tar.gz -rw-------. 1 postgres postgres 18432 Mar ..

# root.sh error when oracle grid rac installation 2021/03/12 10:25:54 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'. PROCL-00041: Oracle Local Registry is incorrectly configured clsu-00600: Internal Error [(:CLSUG00122:)] [5] [OLR error] [41] [Error retrieving olrconfig_loc property.] CRS-4046: Invalid Oracle Clusterware configuration. CRS-4000: Command Create failed, or completed..