SAP BASIS

Oracle 11g Upgrade UNIX

1. Redo Log Usage col MEMBER format a40 SELECT l.group#, l.bytes/(1024*1024) AS "MEGA", l.status, f.member FROM v$log l, v$logfile f WHERE l.group# = f.group#; 2. DATA Tablespace Usage SELECT A.TABLESPACE_NAME AS "TABLESPACE" , A.BYTES / 1024 / 1024 AS "TOTAL(MB)" , (A.BYTES - NVL(B.FREEBYTES,0)) / 1024 / 1024 AS "Used(MB)" , NVL(B.FREEBYTES,0) / 1024 / 1024 AS "Free(MB)" , ROUND(NVL(B.FREEBYTES..

[대상] - Windows x64 - Oracle 11.2.0.3 [원인] - OPATCH version 11.2.0.3.0의 Bug 13902704 "SRVM.JAR IS LOCKED BY OPATCH 11.2.0.3.0" [해결방안] %ORACLE_HOME%\Opatch\jlib\oracle.opatch.classpath.jar -> oracle.opatch.classpath1.jar 로 수정

Symptom This note contains SAP's recommendations for the optimal configuration of Oracle Database Release 11.2. These parameter recommendations are relevant for all SAP products. This note will be updated regularly once a month. Beyond that, changes will only be made in exceptional cases for critical Oracle parameters. Change history: October 27, 2011: add WIN 11.2.0.1 to _OPTIMIZER_USE_CBQT_STA..

Symptom This note describes how to set events when the Oracle database was started with SPFILE. Other terms event, events, init.ora, init.ora, SPFILE, parameter, Oracle 9i, server parameter fileReason and Prerequisites You are using Oracle 9i or higher and you are using the SPFILE (= binary server side parameter file) as parameter file.Solution (For further information on SPFILEs, see SAP Note 6..

Unable to restore resource manager plan to '': ORA-02097: 지정된 값이 부적당해서 매개변수를 수정할 수 없습니다 ORA-00439: 사용 가능한 기능이 아닙니다: Database resource manager Oracle 10g SE버전에서 RMAN을 사용할 수 없어서 발생하는 Alert Msg. 그냥 무시해도 무방하며, 10.2.0.3에서 Fix되었다. 보기 싫은 사람은 10.2.0.3이상으로 패치를 해주면 해결된다.