장기기억장치

-- 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..

RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 03/08/2021 05:02:07 ORA-00283: recovery session canceled due to errors RMAN-11003: failure during parse/execution of SQL statement: alter da..

Steps to attempt to force the database open: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 1) Backup the database while the database is closed. 2) Disable this database from EM if running. We also need to disable RAC to avoid Auto restart. 3) If your datafiles are from different points in time, it is best to try to use system tablespace datafiles at a similar timestamp to the OLDEST files you hav..