op SQL Statements für das Capture
* Dbid - ID der Datenbank
=== Daten aus dem Repository wie... repository.drop_snapshot_range(
low_snap_id => <min_snap_id>
, high_snap_id => <max_snap_id>);
END;
/
</code>
dmin
# User oracle und Grid anlegen bzw prüfen
id oracle
uid=54321(oracle) gid=54321(oinstall) gro... a),54326(kmdba),54330(racdba),54327(asmdba)
ok !
id grid
uid=54322(grid) gid=54321(oinstall) groups=5... from one node to the other
ssh racdb02 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh racdb01 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh racdb02
ssh
ll User Sessions on this DB" skip 2
column inst_id format 99 heading "Inst|ID"
column username format a14 heading "DB User|name"
column sid... us format a8 heading "Status"
select inst_id
, sid
, serial#
, status
, u... ot like '%(P%)%'
order by program
,inst_id
/
ttitle left "User Sessions Summary on this DB
1 : Required Oracle patch "21255373" in home (Doc ID 2308775.1) => BUG 21255373 - CSSD : DUPLICATE RES... efore upgrading Oracle GI and DB to 12.2.0.1 (Doc ID 2180188.1)
Version genau mit OPatch die aktuelle... )
* latest* 12.1.0.2 GI PSU => siehe zuerst Doc ID 1454618.1 => Patch 27468957: GRID INFRASTRUCTURE ... ease/tfa_home/jlib/jewt4.jar' does not exist (Doc ID 2409411.1)
<code bash>
-- sichern
$GRID_HOME/crs
ion On Installed Database Components and Schemas [ID 472937.1]
* How to Check and Enable/Disable Oracle Binary Options [ID 948061.1]
===Ab 11g R2 "chopt disable" beachten... re or EXFSYS schema along with Rules Manager (Doc ID 258618.1)
===== Oracle Workspace Manager =====
<c... ntifier 'SYS.DBMS_CUBE_EXP' must be declared (Doc ID 1328829.1)
=== Quellen ===
* How To Remove the
iel ist das die **"uid=88"**, mit der 88 als User ID dann in der dba_users suchen:
<code sql>
select username from dba_users where user_id=88;
USERNAME
--------
GPI
</code>
==== Trac... et ist:
<code sql>
select trace_type
, primary_id
, qualifier_id1
, qualifier_id2
, waits
, binds
, plan_stats
, instance_name
from
freshed sind, Jobs dazu stoppen!
- siehe Doc ID 1406586.1 - How to Handle Materialized Views When You Upgrade or Clone a Database
- siehe Doc ID 2440801.1 - After DB Upgrade, One More Entry(COLL... Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2)
Für die 19.3 ist aber noch kein RU o... die Node "Invalid x_$ Objects After Upgrade (Doc ID 361757.1)
* https://grepora.com/2019/07/10/inva
evice: $DISK => OS device: /dev/$device with id $majorminor" >> ${BACKUP_DEST}/${ORACLE_DBNAME}... st nicht mehr in der Liste enthalten
Über Device ID etc, prüfen das die Platte auch richtig da ist.
... EPAIR_TIME Attribute Expired (10.1 to 12.1)? (Doc ID 946213.1)
* How to change the DISK_REPAIR_TIME ... timer after disk goes offline from failgroup (Doc ID 1404123.1)
* ASM 11g New Features - How ASM Dis
e for Oracle JDBC High Availability Features (Doc ID 1100024.1) und 390923.1.
Hat man aber keine Einf... )
)
</code>
siehe auch siehe Support Node - Doc ID 733421.1
=== Starten ===
Das administrative Ut... >
</code>
Siehe dazu => Disable FAN events Doc ID 2179568.1
Registierung auf dem ONS auf dem RAC ... lained In Oracle Clusterware/RAC Environment (Doc ID 759895.1)
Web:
* https://westzq1.github.io/or
SS Timeout Computation in Oracle Clusterware (Doc ID 294430.1)
The synchronization services component... tl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ... tl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ... tl query css votedisk
## STATE File Universal Id File Name Disk group
-- -----
PSU, SPU(CPU), Bundle Patches and Patchsets (Doc ID 1454618.1)
==Patchset Jan 2015==
Patch 1995497... M Component Database PSU" (OJVM PSU) Patches (Doc ID 1929745.1)
ACFS Patch für Linux 7
* Patch: 18... ORAchk - Health Checks for the Oracle Stack (Doc ID 1268927.2)
== Cluster Verification Utility ==
... CP Setup Example for Grid Infrastructure GNS (Doc ID 946452.1)
==Installation==
Beide Server müssen
----
==== AWR Berichtsaufruf ====
Snapshot ID's ermitteln und Bericht aufrufen:
<code sql awr_c... skip 2
select dbid
, instance_number
, snap_id
, to_char(end_interval_time,'hh24:mi dd.mm.yyyy... nd_interval_time > trunc(sysdate-1)
order by snap_id, instance_number
/
clear break
ttitle off
set ... e 2000 recsep off
set long 64000
accept snapshot_id_begin number prompt 'Enter Frist Snapshot Begin I
, p_inst_id in number default null
... number;
v_result pls_integer;
v_sys_user_id number;
begin
-- get the sys user id
select user_id into v_sys_user_id
from sys.all_users
where username = 'SYS';
n ===
<code plsql>
SELECT DISTINCT
s.inst_id
, s.username
, u."USER"
, u.tables... HERE s.saddr = u.session_addr
AND s.inst_id = u.inst_id
AND sq.ADDRESS = s.SQL_ADDRESS
AND sq.HASH_VALUE = s.SQL_HASH_VALUE
AND sq.inst_id = s.inst_id
AND u.SQLADDR = sq.ADDRESS
A