DB/__Oracle & Scripts & Log (4) 썸네일형 리스트형 Protected: Presentation Scripts Protected: Presentation Scripts PLAIN TEXT CODE: #!/bin/bash ################################################################################ # Script Name: check_alert_log.sh # # # # Oracle Shell Scripting, Chapter 12 # # # # Usage: check_alert_log.sh SID # # # # Notes: If ORACLE_SID is set in the environment then the SID argument is # # optional # # # # This script is from the book Oracle Shel.. ORACLE_SID를 변경하는 방법 ORACLE_SID를 변경하는 방법 (SID 를 RC817UT에서 RC817NEW로 변경) 1. 먼저 변경하고자 하는 SID를 v$thread 로 확인한다. SQL> select instance from v$thread; INSTANCE ---------------- RC817UT 1 row selected. 2. DB를 shutdown한다. (shutdown normal or immediate) 3. Full backup을 받는다.(All control, redo, data files backup) 1) datafiles SQL> select file_name from dba_data_files; FILE_NAME -------------------------------------------------.. INVALID OBJECT 컴파일 하기 제목 : INVALID OBJECT 컴파일 하기 방법1 ) utlrp.sql 을 통한 재컴파일 하기 : 만약 utlrp.sql로 수행이 안될 경우에는 여러번 수행하면 재컴파일 됩니다. 10G 에서 utlrp.sql을 통한 Object recompile 하기 SYS@TGDOM>@$ORACLE_HOME/rdbms/admin/utlrp.sql COMP_TIMESTAMP UTLRP_BGN 2007-08-28 10:47:08 COMP_TIMESTAMP UTLRP_END 2007-08-28 10:48:10 Invoking Ultra Search Install/Upgrade validation procedure VALIDATE_WK ===============================================.. ORA-00600: internal error code, arguments: [12333] Applies to: Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 10.2.0.3 Information in this document applies to any platform. Purpose The purpose of this Note is to explain bugs filed for ORA-00600 [12333] error against specific Oracle database versions, and explain the symptoms of each bug, workarounds if any and references the patch available at the time this article was written. Scope T.. 이전 1 다음