orcl

업그레이드 전 5560 포트 였는데 패치후에 5561로 변경되었다. EM에서는 5560으로 인식해서 접속 에러 발생 [포트 변경] isqlplusctl stop Edit $ORACLE_HOME/oc4j/j2ee/isqlplus/config/http-web-site.xml isqlplusctl start 5560/isqlplus 으로 정상접속

10.2.0.1 에서 10.2.0.4 로 업그레이드후 EM에 접속이 안됨 ecma -upgrade 에서 오류가발생하여 7368170 apply [/volumes/u01/app/oracle] emca -upgrade db STARTED EMCA at Apr 23, 2009 5:30:14 PM EM Configuration Assistant, Version 10.2.0.1.0 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: ORACLE_HOME for the database to be upgraded: ORACLE_HOME for the database to be upgraded:..

솔라리스 8에 오라클 10.2.0.1 인스톨후 10.2.0.4 패치적용 완료 DB startup시 아래와 같은 메시지의 처리방법 "ORA-00704: bootstrap process failure / ORA-39700: database must be opened with UPGRADE option" SQL> startup ORACLE instance started. Total System Global Area 293601280 bytes Fixed Size 2040088 bytes Variable Size 113254120 bytes Database Buffers 171966464 bytes Redo Buffers 6340608 bytes Database mounted. ORA-01092: ORACLE ..

Server Version Client Version 11.1.0 10.2.0 10.1.0 9.2.0 9.0.1 8.1.7 8.1.6 8.1.5 8.0.6 8.0.5 7.3.4 11.1.0 Yes Yes #6 Yes #6 ES #5 No No No #3 No #3 No #3 No #3 No #3 10.2.0 Yes #6 Yes Yes ES #5 No Was No #3 No #3 No #3 No #3 No #3 10.1.0(#4) Yes #6 Yes Yes ES Was Was #2 No #3 No #3 No #3 No #3 No #3 9.2.0 ES #5 ES #5 ES ES Was Was No No Was No No #1 9.0.1 No No Was Was Was Was Was No Was No Was ..

SQL> select * from v$transportable_platform order by platform_id; PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT ----------- ----------------------------------- -------------- 1 Solaris[tm] OE (32-bit) Big 2 Solaris[tm] OE (64-bit) Big 3 HP-UX (64-bit) Big 4 HP-UX IA (64-bit) Big 5 HP Tru64 UNIX Little 6 AIX-Based Systems (64-bit) Big 7 Microsoft Windows IA (32-bit) Little 8 Microsoft Windows IA (64-bi..

9i 에서 테스트 SQL> select * from aux_stats$ ; no rows selected SQL> exec dbms_stats.create_stat_table('sys','orgstat','users') ; PL/SQL procedure successfully completed. SQL> exec dbms_stats.gather_system_stats(gathering_mode=>'interval',interval=>2,stattab=>'orgstat',statid=>'orgstat') ; PL/SQL procedure successfully completed. SQL> select statid,c1,c2 from orgstat ; STATID C1 C2 ------------------..

9iR2 에서 TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID -------------------- ----------- ------------- ------------ ----------- ---------- ---------- DATABASE 316 1 1 0 0 0 CKPT PROGRESS 4084 4 0 0 0 0 REDO THREAD 228 1 1 0 0 0 REDO LOG 72 5 3 0 0 3 DATAFILE 428 150 41 0 0 162 FILENAME 268 166 48 0 0 0 TABLESPACE 68 150 40 0 0 52 TEMPORARY FILENAME 56 150 1 0 0 1 RM..

http://www.orafaq.com/wiki/X$_Table_Definitions http://yong321.freeshell.org/computer/x$table.html [K]ernel Layer [2]-Phase Commit [G]lobal [T]ransaction [E]ntry X$K2GTE - Current 2PC tx X$K2GTE2 - Current 2PC tx [C]ache Layer [B]uffer Management Buffer [H]ash X$BH - Hash Table Buffer LRU Statistics X$KCBCBH - [C]urrent [B]uffers (buckets) - lru_statistics X$KCBRBH - [R]ecent [B]uffers (buckets)..

DBCA를 통해 ASM구성 1. 명령창을 열고, ASM 인스턴스를 종료시킨 후, pfile을 생성합니다. C:\>set oracle_sid=+asm C:\>sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on 토 5월 24 14:10:36 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. 다음에 접속됨: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL> shutdown abort ASM 인스턴스가 종료되었습니다..

alert log에 나타난 Warning메시지 Starting ORACLE instance (normal) Sun Aug 17 02:07:49 2008 WARNING: EINVAL creating segment of size 0x0000000033720000 fix shm parameters in /etc/system or equivalent LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 LICENSE_MAX_USERS = 0 Starting up ORACLE RDBMS Version: 8.1.7.4.0. System parameters with non-default values: 세마포어 관련 문제인듯하다. SQL> show sga Total System..