Differences

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

--- oracle [2025/07/03 09:34] – [Sessions (to kill?)] mduersch
+++ oracle [2026/07/14 10:24] (current) – [Dataguard related] mduersch
@@ Line 1: / Line 1: @@
 ====== ORACLE ======
+==== 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
+==== CDB PDB ====
+Befehle
+  SHOW CON_NAME
+  ALTER SESSION SET CONTAINER=pdb1;
+  SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;
+  SELECT PDB_ID, PDB_NAME, STATUS FROM DBA_PDBS ORDER BY PDB_ID;
+  SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDBS;
+==== ACLs ====
+ACLs abfragen:
+  SET LINESIZE 150
+  COLUMN host FORMAT A40
+  COLUMN acl FORMAT A50
+  SELECT host, lower_port, upper_port, acl
+  FROM   dba_network_acls
+  ORDER BY host;
+  SET LINESIZE 150
+  COLUMN acl FORMAT A50
+  COLUMN principal FORMAT A20
+  COLUMN privilege FORMAT A10
+  SELECT acl,
+       principal,
+       privilege,
+       is_grant,
+       TO_CHAR(start_date, 'DD-MON-YYYY') AS start_date,
+       TO_CHAR(end_date, 'DD-MON-YYYY') AS end_date
+  FROM   dba_network_acl_privileges
+  ORDER BY acl, principal, privilege;
+Source: https://oracle-base.com/articles/12c/fine-grained-access-to-network-services-enhancements-12cr1
 ==== Spool ====
@@ Line 40: / Line 91: @@
          or network_service_banner like '%Crypto-checksumming service adapter%')
   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 ====
@@ Line 210: / Line 271: @@
   ,OSUSER,MACHINE, substr(PROGRAM,1,32) PROGRAM, to_char(LOGON_TIME,'DD.MM.yyyy HH24:MI:SS')LOGON_TIME
    from gv$session
-   where type='USER'
+   where type='USER';
    # Danach ggf:
@@ Line 322: / Line 383: @@
 ==== Dataguard related ====
+   SELECT DEST_ID, DESTINATION, STATUS, GAP_STATUS, ARCHIVED_THREAD#, ARCHIVED_SEQ#, APPLIED_THREAD#, APPLIED_SEQ#, FROM V$ARCHIVE_DEST_STATUS WHERE STATUS <> 'INACTIVE'
    select database_role, open_mode from v$database;
    select processm, status, sequence# from v$managed_standby;
@@ Line 339: / Line 402: @@
    select * from v$block_change_tracking;
    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
    ==========================
@@ Line 532: / Line 609: @@
    select LOG_MODE from v$database;
    select name from V$database;
+   # flashbackquery
+   select count(1) from somewhere
+                 AS OF TIMESTAMP TO_TIMESTAMP('2025-12-12 16:00', 'YYYY-MM-DD HH24:MI:SS')
+           where
+                 something is NULL;
 ==== GRANTS ====