장기기억장치

// public interface : eth6 => eth7, ip : 192.168.0.0 => 192.168.1.0// private interface : eth 5 => eth6, ip : 168.10.0.0 => 168.10.1.0// 01. oifcfg ocr에 interface 이름 변경// 확인# oifcfg getifeth5  168.10.0.0  global  cluster_interconnecteth6  192.168.0.0  global  public// 변경// public , 필요시 ip 대역도 변경# oifcfg setif -global eth7/192.168.1.0:public// private , 필요시 ip 대역도 변경# oifcfg setif -global eth6/16..

// 오라클 설치 중 해당 에러가 난다면 oraInventory/ContextXML/invetory.xml 파일에 설치하고자 하는 디렉터리명으로 들어가있는 홈이 존재하는지 확인할 것!! # vi /u01/app/oraInventory/ContextXML/inventory.xml

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

// window client NLS_LANG 설정실행창 > "regedit" HKEY_LOCAL_MACHINE > SOFTWARE > Oracle > KEYOra****Home1NLS_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” 또는..

# root.sh error when oracle grid rac installation2021/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 complete..

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