* Oracle Database Grid Infrastructure 12.2.0.1.0 for Linux x86-64, 2.8 GB ; V840012-01.zip => https://... **6880880**: OPatch patch of version 12.2.0.1.13 for Oracle software releases DB 12.1.0.x and DB 18.x;... **6880880**: OPatch patch of version 11.2.0.3.19 for Oracle software releases 11.2.0.x and 18.x (APR 2... 8 Release Update 12.2.0.1.180417 includes updates for both the Clusterware home and Database home that
ease 12c R2 :
<code cmd>
Oracle Database Gateway for ODBC
Oracle Database Gateway for ODBC can be
installed and used on a machine different from the mach...
It is not necessary to obtain a separate license for the machine running Oracle Gateway for ODBC
</code>
=> Sehr gut, nur die RDBMS Lizenz ist dafür notwe
grade zu Problemen führen!
== Container Database for Oracle Grid Infrastructure Management Repository ... ort Dokument => Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchs... * Patch: 18321597 (Patch 18321597: ACFS SUPPORT FOR RHEL7 AND OL7 )
==OPatch utility version 12.1.0... Patch 6880880: OPatch patch of version 12.1.0.1.6 for Oracle software releases 12.1.0.x (JAN 2015)
*
ktivieren von des Archive log , Flashback Log und Force Logging Modus
* Primary DB - Standby Redo Log... DB- Aktivieren von Archivelog , Flashback Log und Force Logging==
Als SYS User an der DB anmelden (OS... as sysdba
SYS@SQL>select DATABASE_ROLE,LOG_MODE,FORCE_LOGGING,FLASHBACK_ON from v$database;
DATABASE_ROLE LOG_MODE FORCE_LOGGING FLASHBACK_ON
---------------- ---------
ancy (mirroring)" Optionen:
* High Redundancy - for each primary extent, there are two mirrored extents
* Normal Redundancy - for each primary extent, there is one mirrored (secon... aufgesetzt worden => Siehe [[vmware:iscsi_target_for_shared_disks|iSCSI Target für das Bereitstellen ... tten überschreiben um den ASM Stempel loszuwerden
for i in $disks;do
dd if=/dev/zero of=$i bs=1M count=
em mit OPatch - The opatch minimum version check for patch failed ===
In einer 11.2.0.4 Umgebung oh... rsconfig_params
The opatch minimum version check for patch /home/oracle/Downloads/patch/25476126/24732075 failed for /u01/app/11.2.0.4/grid
The opatch minimum version check for patch /home/oracle/Downloads/patch/25476126/23054
---------------------------- Check the Scheduler for the statistic job -------------------------------
column job_name format a30 heading "Job|Name"
column run_count format 99999 heading "Run|Count"
column failure_count format 99999 heading "Failure|Count"
column last_st
* Optional: DR$IDX_DOCUMENTS_DOCS**$O** (ab 12c Forward Indexing für Highlightning, Snippet,Markup Fu... * Optional: DR$IDX_DOCUMENTS_DOCS**$D** (ab 12c Forward Indexing , kompletter Text als PlainText Spal... Verfügung und es können die wichtigsten MS Office Formate (offiziell bis zur Version 2010) und PDF gel... s/dr0defin.sql "GERMAN";
exit
#Lock the account for security
sqlplus / as sysdba
alter user ctxsys ac
130 pagesize 200 recsep OFF
column owner format a20
column object_name format a30
column column_name format a25
column equality_preds format 999 heading "equ"
column equijoin_preds format 999 head
r Sessions on this DB" skip 2
column inst_id format 99 heading "Inst|ID"
column username format a14 heading "DB User|name"
column sid format 99999 heading "SID"
column serial# format 99999 heading "Serial"
column machine format a30
se ausarbeiten/erfüllen
* SPfile der DB in Text Format exportieren
* AutoTasks der Datenbank stoppe... Database Installation Guide
11g Release 2 (11.2) for Oracle Solaris]]
====Betriebssystem Voraussetz... ginal Anleitung sorgfältig prüfen!):
\\\
Patches for Oracle Solaris 10:
* 120753-06: SunOS 5.10: Mi... :
Angepasst werden mussten:
* Kernel parameter for "tcp_smallest_anon_port" = 9000
* Kernel param
le Umgebung einstellen
- Sicherstellen, das X-Forwarding auf die eigene Maschine funktioniert
-...
V983339-01.iso - Oracle Linux Release 7 Update 7 for x86 (64 bit), 4.4 GB
<code >
SHA-1 3EF94628CF102... Patch/opatch apply
..
Is the local system ready for patching? [y|n]
y
User Responded with: Y
...
Patc... ener
-----------------------------------
LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 04-DEC-
Marked SYSTEM TABLESPACE As LOCAL_TEMP_TABLESPACE For Few Database Users (Doc ID 2385430.1), der intern... blespace (Big File Type! ) sein, mit der Option " FOR ALL " oder " FOR LEAF " angelegt.
Dieser Tablespace kann dann lokal auf jeden Cluster Knoten liegen u... gen eines Big File temporary Tablespace mit der "for all" Klausel für alle Instancen:
create local te
f ausgeblendet werden)
* Eine Sequence für eine fortlaufende ID der Tabelle SYSTEM.ora_error_seq wird... -----------------
Creating Error Log Tab for SQL Errors over the complete DB
------------... l_txt (v_sql_text);
IF v_count >= 1
THEN
FOR i IN 1 .. v_count
LOOP
v_stmt := v_stmt || v_sql_text (i);
END LOOP;
END IF;
FOR n IN 1 .. ora_server_error_depth
LOOP
IF or