User Tools

Site Tools


oracle

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
oracle [2026/03/06 09:25] – mduerschoracle [2026/11/09 10:36] (current) – mduersch
Line 1: Line 1:
 ====== ORACLE ====== ====== ORACLE ======
 +
 +==== ORA-00600 ====
 +
 +ORA-00600: Interner Fehlercode, Argumente: [KGL-heap-size-exceeded], [0x0AEDAA8C0], [0], [524312368], [], [], [], [], [], [], [], []
 +
 +  select
 +   nam.ksppinm NAME,
 +   nam.ksppdesc DESCRIPTION,
 +   val.KSPPSTVL
 +  from
 +   x$ksppi nam,
 +   x$ksppsv val
 +  where nam.indx = val.indx and nam.ksppinm like '%kgl_large_heap_%_threshold%';
 +
 +  select owner, job_name, program_name from dba_scheduler_jobs where job_name like 'AQ_JOB%';
 +
 +==== SGA ====
 +  SELECT free_space, avg_free_size, used_space, avg_used_size, request_failures, last_failure_size  FROM v$shared_pool_reserved;
 +
 +
 +==== EMCC ====
 +
 +  oracle@mytesthost:/oracle/product/agent/agent_24.1.0.0.0/bin # ./emctl control agent runCollection mytesthost:host   DiscoverTargets
 +  Oracle Enterprise Manager 24ai Release 1
 +  Copyright (c) 1996, 2024 Oracle Corporation.  All rights reserved.
 +  ---------------------------------------------------------------
 +  EMD runCollection completed successfully
 +
 +  oracle@mytesthost:/oracle/product/agent/agent_24.1.0.0.0/bin # ./emctl upload agent
 +  Oracle Enterprise Manager 24ai Release 1
 +  Copyright (c) 1996, 2024 Oracle Corporation.  All rights reserved.
 +  ---------------------------------------------------------------
 +  EMD upload completed successfully
 +
 +
 +  $AGENT_HOME/bin/emctl getmetric agent sorame01.intern.hessen.de,host,Load
 +  $AGENT_HOME/bin/emctl getmetric agent sorame01.intern.hessen.de,host,CPUUsage 
 +  $AGENT_HOME/bin/emctl getmetric agent sorame01.intern.hessen.de,host,Processes
 +  $AGENT_HOME/bin/emctl listplugins agent -type all 
 +  $AGENT_HOME/bin/emctl pingOMS
 +  $AGENT_HOME/bin/emctl upload agent
 +  $AGENT_HOME/bin/emctl status agent
 +  
 +  
 +EMCC Log Files:
 +
 +  1- EM Agent NOHUP file. (emagent.nohup)
 +  2- EM Agent log file. (gcagent.log)
 +  3- EM Agent Perl Trace file. (emagent_perl.trc)
 +  4- Standard emctl command operation log file. (emctl.log)
 +  5- EM Agent SDK trace file. (gcagent_sdk.trc)
 +  6- EM Agent MDU log. (gcagent_mdu.log) 
 +  7- EM OMS main trace file for the OMS Console (emgc) application. (emoms.trc)
 +  8- EM OMS main log file for the OMS Console (emgc) application. (emoms.log)
 +  9- EM OMS main log file for the OMS pbs (empbs) application. (emoms_pbs.log)
 +  10- EM OMS main trace file for the OMS pbs (empbs) application. (emoms_pbs.tc)
 +
 +
 +Promoted Discovered Error und emcli
 +
 +  SQL> connect / as sysdba
 +  SQL> show parameter job_queue_processes;  --->Verify the current value of job queue process.
 +  SQL> alter system set job_queue_processes = 0; (Note: Please track the existing value before making it to 0)
 +  SQL> connect sysman/
 +  SQL> exec emd_maintenance.remove_em_dbms_jobs;
 +  SQL>exec gc_interval_partition_mgr.partition_maintenance; 
 +  SQL> connect / as sysdba
 +  SQL> alter system set job_queue_processes = 300; (Note: Set the value which was verified before making it to 0)
 +  SQL> connect sysman/
 +  SQL> exec emd_maintenance.submit_em_dbms_jobs;
 +  SQL> commit;
 +
 +
 +==== EMCLI ====
 +
 +  ./emcli login -username=sysman
 +
 +  ./emcli get_supported_platforms
 +    -----------------------------------------------
 +    Version = 24.1.0.0.0
 +     Platform = Linux x86-64 
 +    -----------------------------------------------
 +    Platforms list displayed successfully.
 +
 +
 +./emcli get_agentimage -destination=/u01/app/oracle/agent_software -platform=”Linux x86-64″ -version=”
 +  oracle@orats1:/oracle/product/em24ai/oraclehome/oms_home/bin # emcli list_add_host_platforms -all
 +  Platform ID  Platform Name
 +  226          Linux x86-64
 +  23           Oracle Solaris on SPARC (64-bit) [Agent Software Unavailable]
 +  46           Linux x86 [Agent Software Unavailable]
 +  211          IBM S/390 Based Linux (31-bit) [Agent Software Unavailable]
 +  212          IBM AIX on POWER Systems (64-bit) [Agent Software Unavailable]
 +  233          Microsoft Windows x64 (64-bit) [Agent Software Unavailable]
 +  267          Oracle Solaris on x86-64 (64-bit) [Agent Software Unavailable]
 +  209          IBM: Linux on System z [Agent Software Unavailable]
 +  541          Linux ARM 64-bit [Agent Software Unavailable]
 +
 +
 +ADD AGENT:
 +  AGENT_HOST="my-host.localdomain"
 +  AGENT_HOST_CREDENTIAL="NC_HOST_MY_HOST"
 +  AGENT_PORT="3872"
 +  AGENT_BASE_DIR="/u01/app/oracle/product/agent13c" 
 +  AGENT_PLATFORM="226"
 +
 +  emcli submit_add_host \
 +    -host_names="${AGENT_HOST}" \
 +    -platform="${AGENT_PLATFORM}" \
 +    -installation_base_directory="${AGENT_BASE_DIR}" \
 +    -credential_name="${AGENT_HOST_CREDENTIAL}" \
 +    -port="${AGENT_PORT}" \
 +    -wait_for_completion
  
 ==== CDB PDB ==== ==== CDB PDB ====
Line 76: Line 189:
          or network_service_banner like '%Crypto-checksumming service adapter%')          or network_service_banner like '%Crypto-checksumming service adapter%')
   and TYPE <> 'BACKGROUND';    and TYPE <> 'BACKGROUND'; 
 +
 +==== Audit Trail ====
 +
 +  SELECT os_username AS "OS User", 
 +       username AS "DB User", 
 +       userhost AS "Machine", 
 +       timestamp AS "Date", 
 +       returncode AS "Error Code"  
 +  FROM dba_audit_session 
 +  WHERE returncode != 0 ORDER BY timestamp DESC;  
  
 ==== Grants by User ==== ==== Grants by User ====
Line 377: Line 500:
    select * from v$block_change_tracking;     select * from v$block_change_tracking; 
    select dest_id, destination, status, error, transmit_mode from v$archive_dest where destination is not null;    select dest_id, destination, status, error, transmit_mode from v$archive_dest where destination is not null;
 +
 +   # Anfragen
 +   col DB_UNIQUE_NAME for a10
 +   col OPEN_MODE for a20
 +   col DATABASE_ROLE for a20
 +   col LOG_MODE for a10
 +   set lines 200
 +   select DBID,NAME,LOG_MODE,OPEN_MODE,DATABASE_ROLE,SWITCHOVER_STATUS,DB_UNIQUE_NAME,RESETLOGS_TIME from V$database;
 +
 +   # Transport log
 +   select process, pid, status from v$managed_standby where process='RFS';
 +
 +
 +
    # Paramter abfragen    # Paramter abfragen
    ==========================    ==========================
Line 457: Line 594:
 restore archivelog from sequence 9301 until sequence 9311; restore archivelog from sequence 9301 until sequence 9311;
   RMAN> restore archivelog from sequence 9301 until sequence 9311;   RMAN> restore archivelog from sequence 9301 until sequence 9311;
 +  
 +Backup Pieces:
 +
 +  column handle format a40
 +  column size_mb format a30  
 +  column status format a30
 +  column completion_time a40
 +  SELECT handle, bytes / 1024 / 1024 / 1024 AS size_gb, status, completion_time from  v$backup_piece where handle like '%full%' 
  
 ==== Invalid Components ==== ==== Invalid Components ====
Line 556: Line 701:
    V$SESSION - This gives detailed session information about all connected Oracle users.    V$SESSION - This gives detailed session information about all connected Oracle users.
    V$SESSION_EVENT - This is used to show the number of session waits and session timeouts.    V$SESSION_EVENT - This is used to show the number of session waits and session timeouts.
- 
  
    SELECT username, elapsed_time, plsql_exec_time, sql_text, cpu_time, rm_last_action, rm_last_action_reason, rm_last_action_time, rm_consumer_group FROM v$sql_monitor WHERE username is not null;    SELECT username, elapsed_time, plsql_exec_time, sql_text, cpu_time, rm_last_action, rm_last_action_reason, rm_last_action_time, rm_consumer_group FROM v$sql_monitor WHERE username is not null;
 +
 +==== Long running Statements v$session_longops ====
 +  
 +  col opname for a20
 +  col username for a20
 +  col prozent for clear 
 +  col time_remaining for clear 
 +
 +  SELECT opname, username, 
 +     to_char(start_time,'DD-MON-YYYY HH24:MI:SS'),
 +     (sofar/totalwork)*100 prozent, time_remaining 
 +     FROM v$session_longops
 +     WHERE time_remaining>0;
 +  
 +
 ==== RESSOURCES ==== ==== RESSOURCES ====
  
Line 687: Line 846:
   select PATCH_ID, PATCH_UID, STATUS, ACTION_TIME, DESCRIPTION from DBA_REGISTRY_SQLPATCH;   select PATCH_ID, PATCH_UID, STATUS, ACTION_TIME, DESCRIPTION from DBA_REGISTRY_SQLPATCH;
  
 +  ./datapatch -purge_old_metadata
 +  https://mikedietrichde.com/2025/02/28/final-blog-post-about-datapatch-cleanup-and-purge/ 
 +  
  
 ====== ORACLE 11G ====== ====== ORACLE 11G ======
oracle.1772789158.txt.gz · Last modified: by mduersch