oracle
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| oracle [2026/07/03 05:19] – [EMCC] mduersch | oracle [2026/11/09 10:36] (current) – mduersch | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== ORACLE ====== | ====== ORACLE ====== | ||
| + | |||
| + | ==== ORA-00600 ==== | ||
| + | |||
| + | ORA-00600: Interner Fehlercode, Argumente: [KGL-heap-size-exceeded], | ||
| + | |||
| + | select | ||
| + | | ||
| + | | ||
| + | | ||
| + | from | ||
| + | | ||
| + | | ||
| + | where nam.indx = val.indx and nam.ksppinm like ' | ||
| + | |||
| + | select owner, job_name, program_name from dba_scheduler_jobs where job_name like ' | ||
| + | |||
| + | ==== SGA ==== | ||
| + | SELECT free_space, avg_free_size, | ||
| Line 15: | Line 33: | ||
| --------------------------------------------------------------- | --------------------------------------------------------------- | ||
| EMD upload completed successfully | EMD upload completed successfully | ||
| + | |||
| + | |||
| + | $AGENT_HOME/ | ||
| + | $AGENT_HOME/ | ||
| + | $AGENT_HOME/ | ||
| + | $AGENT_HOME/ | ||
| + | $AGENT_HOME/ | ||
| + | $AGENT_HOME/ | ||
| + | $AGENT_HOME/ | ||
| + | | ||
| + | | ||
| + | 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; | ||
| + | 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 | ||
| + | | ||
| + | ----------------------------------------------- | ||
| + | Platforms list displayed successfully. | ||
| + | |||
| + | |||
| + | ./emcli get_agentimage -destination=/ | ||
| + | oracle@orats1:/ | ||
| + | Platform ID Platform Name | ||
| + | 226 Linux x86-64 | ||
| + | 23 | ||
| + | 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=" | ||
| + | AGENT_HOST_CREDENTIAL=" | ||
| + | AGENT_PORT=" | ||
| + | AGENT_BASE_DIR="/ | ||
| + | AGENT_PLATFORM=" | ||
| + | |||
| + | emcli submit_add_host \ | ||
| + | -host_names=" | ||
| + | -platform=" | ||
| + | -installation_base_directory=" | ||
| + | -credential_name=" | ||
| + | -port=" | ||
| + | -wait_for_completion | ||
| ==== CDB PDB ==== | ==== CDB PDB ==== | ||
| Line 402: | Line 500: | ||
| | | ||
| | | ||
| + | |||
| + | # 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 | ||
| + | | ||
| + | |||
| + | # Transport log | ||
| + | | ||
| + | |||
| + | |||
| + | |||
| # Paramter abfragen | # Paramter abfragen | ||
| | | ||
| Line 482: | 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 ' | ||
| ==== Invalid Components ==== | ==== Invalid Components ==== | ||
| Line 581: | Line 701: | ||
| | | ||
| | | ||
| - | |||
| | | ||
| + | |||
| + | ==== 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, | ||
| + | | ||
| + | | ||
| + | FROM v$session_longops | ||
| + | WHERE time_remaining> | ||
| + | |||
| + | |||
| ==== RESSOURCES ==== | ==== RESSOURCES ==== | ||
| Line 712: | Line 846: | ||
| select PATCH_ID, PATCH_UID, STATUS, ACTION_TIME, | select PATCH_ID, PATCH_UID, STATUS, ACTION_TIME, | ||
| + | ./datapatch -purge_old_metadata | ||
| + | https:// | ||
| + | | ||
| ====== ORACLE 11G ====== | ====== ORACLE 11G ====== | ||
oracle.1783055995.txt.gz · Last modified: by mduersch
