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/09/11 07:22] – [Environement] 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;
  
  
Line 38: Line 56:
   9- EM OMS main log file for the OMS pbs (empbs) application. (emoms_pbs.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)   10- EM OMS main trace file for the OMS pbs (empbs) application. (emoms_pbs.tc)
 +
  
 Promoted Discovered Error und emcli Promoted Discovered Error und emcli
Line 54: Line 73:
  
  
 +==== 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 ====
oracle.1789111366.txt.gz · Last modified: by mduersch