orcl

"orclXDB" is needed for XML database, and is set by DISPATCHERS initialization parameter. Try, as sysdba SQL> show parameter DISPATCHERS "orcl_XPT" : in 10g a service with name _XPT is automatically configured in addition to normal service names, and is intended for use within Data Guard environments. alter sytem set "__dg_broker_service_names" = '' ; 히든파라미터 보기 set lines 140 col parameter format..

10g 에서 log_archive_start = true 로 설정시에 ORA-32004: obsolete and/or deprecated parameter(s) specified 로 나온다. 해당 parameter를 제거하기 위해서 alter system reset log_archive_start scope=spfile sid='*'; sid='*'; 옵션을 안주면 에러 발생한다 SQL> alter system reset log_archive_start scope=spfile ; alter system reset log_archive_start scope=spfile * 1행에 오류: ORA-00905: 누락된 키워드

이번 버전이랑 차이점은 별로 없는거 같고 failed_login_attempts 가 default 로 10으로 설정되어 있다. RESRESPROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT ------------------------------ ------------------------------ ---------------- ----------------- DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED DEFAULT CPU_PER_SESSION KERNEL UNLIMITED DEFAULT CPU_PER_CALL KERNEL UNLIMITED DEFAULT LOGICAL_REA..

Enterprise Manager 10g에서 관리탭의 백업,복구등 설정시에 Host 아이디,암호를 입력해야 한다. Host Credentials 먼저 설정 - 관리도구 - 로컬 보안 설정 - 로컬정책 - 사용자권한할당 - 일괄작업으로 로그인 에 해당유저를 추가해 주면 된다. start - settings - control panel - Administrative Tools - Local Security Policy - local policies - user right assignment - "log on as a batch job"

9i까지는 link$,user_db_links 에서 password 컬럼에 패스워드를 text로 보여주었지만, 10gR2 부터는 null로 나타난다. 보안상의 이유로 저렇게 했겠지만,,DBA 입장에서는 영~~ 불편하다. [예제] SQL> set long 100000 SQL> select dbms_metadata.get_ddl('DB_LINK','DBL_TEST') from dual ; DBMS_METADATA.GET_DDL('DB_LINK','DBL_TEST') -------------------------------------------------------------------------------- CREATE DATABASE LINK "DBL_TEST" CONNECT TO "TEST" IDENTI..

2009년 12월 29일 긴급으로 내려온 내용. http://hanlee79.tistory.com/25 아래의 쿼리를 수행시켜서 Max_resaonable_scn 패치를 적용해야합니다. 패치번호 : 9243179 CURRENT MAX DIFF 11580207351847 11580251258880 43907033 -> OK col current_scn for 999,999,999,999,999,999 col max_resonable_scn for 999,999,999,999,999,999 col DIFF for 999,999,999,999,999,999 SELECT current_scn, max_resonable_scn, (max_resonable_scn - current_scn) "DIFF" FROM (..

http://tahiti.oracle.com/ Search and Download Oracle Database, Application Server, and Collaboration Suite Documentation

환경 : 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..