orcl

관련 Parameter pga_aggregate_target = 1073741824 PARAMETER DESCRIPTION SESSION_VALUE INSTANCE_VALUE -------------------- -------------------------------------------------- ------------------ ------------------ _smm_max_size maximum work area size in auto mode (serial) 52428 52428 _smm_px_max_size maximum work area size in auto mode (global) 314571 314571 _pga_max_size Maximum size of the PGA memor..

환경 : AIX 5.3 9.2.0.8 1. $ORACLE_HOME/bin/emca 실행 - management server 구성 2. OMS 시작 - oemctl start oms - oemctl status oms OMS Login : sysman/oem_temp $ oemctl status oms OEMCTL for AIX: Version 9.2.0.1.0 Production Copyright (c) 1998, 2002, Oracle Corporation. All rights reserved. The Oracle Management Server on host [xxxxxx] is functioning properly. The server has been up for 0 00:06:24.303 Targ..

Log into SQLPlus as APPLSYS user and execute the following: exec DBMS_AQADM.STOP_QUEUE('FND_CP_GSM_IPC_AQ'); exec DBMS_AQADM.DROP_QUEUE('FND_CP_GSM_IPC_AQ'); exec DBMS_AQADM.DROP_QUEUE_TABLE('FND_CP_GSM_IPC_AQTBL'); exec DBMS_AQADM.CREATE_QUEUE_TABLE(queue_table => 'FND_CP_GSM_IPC_AQTBL', - queue_payload_type => 'SYSTEM.FND_CP_GSM_IPQ_AQ_PAYLOAD', - sort_list => 'priority,enq_time', - multiple_c..

10.2.0.4에서 발생 7354358 패치수행 -> 7603479 패치수행 -> 정상완료 Refresh From Metalink Job fails with ORA-12899 : value too large for column "SYSMAN"."MGMT_ARU_PRODUCTS"."PRODUCT_NAME" Checking Oracle MetaLink authorization. MetaLink Username: ********** MetaLink Password: ********** Patch Search URL: http://updates.oracle.com Updating OEM repository with latest release table data from Oracle MetaLink. - Exce..

업그레이드 전 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 ------------------..