장기기억장치

$ srvctl stop database -d ORADB # +OLD_DG diskgroup이 offline 상태 확인$ crsctl stat res -t$ renamedg dgname=OLD_DG newdgname=NEW_DG verbose=true asm_diskstring=/dev/oracleasm/disks/ASMDISK*// asm_diskstring=' /dev/oracleasm/disks/ASMDISK01, /dev/oracleasm/disks/ASMDISK02...' # +NEW_DG diskgroup mount$ asmcmd mount NEW_DG$ asmcmd lsdg # modify database parameter file OLD_DG -> NEW_DG$ vi pfileORADB.o..

# LIMA 0.22.0 upgrade 후 FATA 에러 발생  -- socket_vmnet 설치$ brew search socket_vmnet==> Formulaesocket_vmnet$ brew install socket_vmnet                     :==> Summary🍺  /opt/homebrew/Cellar/socket_vmnet/1.1.4: 15 files, 125.8KB==> Running `brew cleanup socket_vmnet`...Disable this behaviour by setting HOMEBREW_NO_INSTALL_CLEANUP.Hide these hints with HOMEBREW_NO_ENV_HINTS (see `man brew`). $ vi ~..

// Altibase Database Level Monitoring Tool 추가되었으면 하는 기능 있으면 댓글 남겨주세요. https://github.com/chess-drive/MRT

// cluster_by_rowid // clustering factor 가 낮을 때 사용하면 빠른 결과 도출 select /*+ ordered use_nl(b) rowid(b) */ b.* from (select /*+ index(emp emp_X1) no_merge */ rowid rid from emp where ename = 'SCOTT' order by rowid) a, emp b where b.rowid = a.rid ; -- after 12c select /*+ cluster_by_rowid(e) index(e emp_x1) */ * from emp e where ename = 'SCOTT' ;

보호되어 있는 글입니다.

// ORA-00600: internal error code, arguments: [kgfz_getDiskAccessMode:ntyp], [0], [], [], [], [], [], [], [], [], [], [] // 에러 원인 Database가 RAC에서 Single로 변경된 후 RAC binaries 옵션 disabled 하지 않아서 발생 // 해결 방안 $ make -f ins_rdbms.mk rac_off

/usr/bin or /usr/local/bin 에 실행권한주고 넣어서 사용 # /bin/bash # ptrace if [ ! -d /tmp/ptrace ]; then mkdir /tmp/ptrace fi PTDIR=/tmp/ptrace DATETIME=$(date +%Y%m%d%H%M%S) COMMAND=$1 if [ -z $COMMAND ]; then echo 'ERROR : Please input your command' echo '[ trace / show / stop / help ]' else if [ "$COMMAND" = "help" ]; then echo 'ptrace option [param]' echo 'option : [ trace / show / stop ]' elif [ "$COM..

/usr/bin or /usr/local/bin 에 실행권한 주고 넣어서 사용 # /bin/bash # pm COMMAND=$1 if [ -z "$COMMAND" ]; then echo "Please input [on/off/stat/show] at first variable"; else if [ "on" == "$COMMAND" ]; then sudo pmset -c disablesleep 0; elif [ "off" == "$COMMAND" ]; then sudo pmset -c disablesleep 1; elif [ "stat" == "$COMMAND" ]; then export SLEEP_STAT=`pmset -g | grep SleepDisabled | awk '{printf $2}'`; if..

// rman set newname format (파일 명명법) %b: Specifies the file name without the directory that it locates. %N: Specifies the tablespace name %f: Specifies the absolute file number of a datafile %I: Specifies DBID %U: Specifies system generated unique filename // as a following format: data-D-%d_id-%I_TS-%N_FNO-%f // archivelog log_archive_format %s: log sequence number %S: log sequence number, zero ..

보호되어 있는 글입니다.