oracle_datenbank
Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen RevisionVorhergehende ÜberarbeitungNächste Überarbeitung | Vorhergehende ÜberarbeitungLetzte ÜberarbeitungBeide Seiten der Revision | ||
oracle_datenbank [2020/01/28 15:57] – [Die Oracle Datenbank Welt] gpipperr | oracle_datenbank [2024/01/10 17:48] – [Der Oracle Connection Manager] gpipperr | ||
---|---|---|---|
Zeile 18: | Zeile 18: | ||
* 1988 Version 6 | * 1988 Version 6 | ||
* 1997 Version 7 | * 1997 Version 7 | ||
- | * 1997 Verision | + | * 1997 Version |
* 1998 Version 8i | * 1998 Version 8i | ||
* 2001 Version 9i | * 2001 Version 9i | ||
- | * 2003 Verison | + | * 2003 Version |
* 2007 Version 11g | * 2007 Version 11g | ||
* 2013 Version 12c | * 2013 Version 12c | ||
* 2018 Version 18 => siehe auch => Release Update Introduction and FAQ (Doc ID 2285040.1) | * 2018 Version 18 => siehe auch => Release Update Introduction and FAQ (Doc ID 2285040.1) | ||
- | * 2019 Version 19c ( ist im Endeffekt eine 12.2.0.3 und das letzte Release der Oracle DB 12c Produktfamilie | + | * 2019 Version 19c ( ist im Endeffekt eine 12.2.0.3 und das letzte Release der Oracle DB 12c Produktfamilie |
+ | * 2020 Version 20c (nur in der Cloud als preview) | ||
+ | * 2021 Version 21 (NUR noch als PDB!) | ||
+ | * usw. | ||
* Siehe auch hier => http:// | * Siehe auch hier => http:// | ||
Zeile 37: | Zeile 40: | ||
+ | Bzgl. dem Ende des Supports siehe Node => Release Schedule of Current Database Releases (Doc ID 742060.1) | ||
+ | |||
+ | {{ : | ||
+ | Stand 2021 | ||
+ | |||
+ | {{ : | ||
+ | ( MOS Note: 742060.1 | ||
+ | |||
+ | |||
+ | Die Datenbank Version auslesen => * [[dba: | ||
+ | |||
+ | |||
+ | Das Data Dictionary abfragen => https:// | ||
Zeile 61: | Zeile 77: | ||
---- | ---- | ||
+ | |||
+ | |||
+ | |||
+ | ---- | ||
+ | |||
+ | |||
+ | ===== Lizenz Fragen ===== | ||
+ | |||
+ | * [[dba: | ||
+ | * [[dba: | ||
+ | * [[http:// | ||
+ | * [[dba: | ||
+ | | ||
+ | * Gute Zusammenfassung => https:// | ||
+ | |||
+ | |||
+ | Oracle Database 12.1.0.2 Standard Edition (SE2) - einschränkungen - Sollten auch noch für die Version 18 gelten! | ||
+ | |||
+ | siehe => http:// | ||
+ | <code bash> | ||
+ | Oracle Database Standard Edition 2 may only be licensed on servers that | ||
+ | have a maximum capacity of 2 sockets. When used with Oracle Real Application Clusters, Oracle Database Standard Edition 2 may only be | ||
+ | licensed on a maximum of 2 one-socket servers. In addition, notwithstanding any provision in Your Oracle license agreement to the | ||
+ | contrary, each Oracle Database Standard Edition 2 database may use a maximum of 16 CPU threads at any time. When used with Oracle Real | ||
+ | Application Clusters, each Oracle Database Standard Edition 2 database may use a maximum of 8 CPU threads per instance at any time. The | ||
+ | minimums when licensing by Named User Plus (NUP) metric are 10 NUP licenses per server | ||
+ | |||
+ | </ | ||
+ | |||
+ | VMware Problem => https:// | ||
+ | |||
+ | |||
+ | ---- | ||
+ | |||
===== Oracle einfach bedienen und administrieren ===== | ===== Oracle einfach bedienen und administrieren ===== | ||
Zeile 81: | Zeile 131: | ||
* [[dba: | * [[dba: | ||
- | Die Job Steuerung der Datenbank: | ||
- | * [[dba: | + | ---- |
- | * [[dba: | + | |
- | * [[dba: | + | |
+ | =====Die Job Steuerung der Datenbank===== | ||
+ | * [[dba: | ||
+ | * [[dba: | ||
+ | * [[dba: | ||
+ | * [[dba: | ||
+ | * [[dba: | ||
+ | * [[dba: | ||
+ | * [[dba: | ||
---- | ---- | ||
Zeile 161: | Zeile 216: | ||
* [[dba: | * [[dba: | ||
* [[dba: | * [[dba: | ||
+ | * [[dba: | ||
Berechtigungsprobleme: | Berechtigungsprobleme: | ||
Zeile 172: | Zeile 228: | ||
=== An der Datenbank anmelden === | === An der Datenbank anmelden === | ||
+ | |||
+ | * [[dba: | ||
* [[dba: | * [[dba: | ||
Zeile 228: | Zeile 286: | ||
siehe => " | siehe => " | ||
- | |||
- | === Der Oracle Connection Manager === | ||
- | |||
- | * [[dba: | ||
- | |||
---- | ---- | ||
- | ===== Lizenz===== | + | ===== Der Oracle Connection Manager |
- | * [[dba: | ||
- | * [[dba: | ||
- | * [[http:// | ||
- | * [[dba: | ||
- | | ||
- | * Gute Zusammenfassung => https:// | ||
+ | * [[dba: | ||
- | Oracle | + | * [[dba: |
- | siehe => http:// | + | * [[dba:sqlnet_cman_connection_manager_tdm_21c|Oracle |
- | <code bash> | + | |
- | Oracle | + | |
- | have a maximum capacity of 2 sockets. When used with Oracle Real Application Clusters, Oracle Database Standard Edition 2 may only be | + | |
- | licensed on a maximum of 2 one-socket servers. In addition, notwithstanding any provision in Your Oracle | + | |
- | contrary, each Oracle Database Standard Edition 2 database may use a maximum of 16 CPU threads at any time. When used with Oracle Real | + | |
- | Application Clusters, each Oracle Database Standard Edition 2 database may use a maximum of 8 CPU threads per instance at any time. The | + | |
- | minimums when licensing by Named User Plus (NUP) metric are 10 NUP licenses per server | + | |
- | </ | + | * [[dba:sqlnet_cman_connection_manager_rest_api_21c|Oracle 21c -Das Rest API Interface des CMAN,Oracle Connection Manager, nützen ]] |
- | + | ||
- | VMware Problem => https:// | + | |
Zeile 289: | Zeile 328: | ||
* [[dba: | * [[dba: | ||
* [[dba: | * [[dba: | ||
+ | * [[dba: | ||
+ | * [[dba: | ||
Alternativen: | Alternativen: | ||
Zeile 391: | Zeile 432: | ||
===== Benutzer Verwaltung ===== | ===== Benutzer Verwaltung ===== | ||
- | | + | === MS AD Integration === |
+ | |||
+ | | ||
+ | * [[dba: | ||
+ | |||
+ | |||
+ | |||
+ | === Weitere Themen === | ||
* [[dba: | * [[dba: | ||
+ | |||
* [[dba: | * [[dba: | ||
Zeile 554: | Zeile 604: | ||
- | Leistet Oracle Support für den Betrieb der DB auf VMware? | + | Leistet Oracle Support für den Betrieb der DB auf VMware? |
Siehe | Siehe | ||
Zeile 560: | Zeile 610: | ||
* => Oracle Linux Support Policies for Virtualization and Emulation (Doc ID 417770.1) | * => Oracle Linux Support Policies for Virtualization and Emulation (Doc ID 417770.1) | ||
- | => Im Prinzip Nein, Praktisch aber wohl ja. | ||
Zeile 577: | Zeile 626: | ||
* [[dba: | * [[dba: | ||
+ | |||
+ | |||
+ | ===Ansible im Oracle Umfeld=== | ||
+ | |||
+ | Ansible (https:// | ||
+ | |||
+ | * [[linux: | ||
Zeile 582: | Zeile 638: | ||
Einfach mal ohne das ganze Installationsdrama arbeiten => fertige Docker Images verwenden => https:// | Einfach mal ohne das ganze Installationsdrama arbeiten => fertige Docker Images verwenden => https:// | ||
+ | |||
+ | |||
+ | ====23c==== | ||
+ | |||
+ | Oracle Datenbank 23c | ||
+ | |||
+ | * [[dba: | ||
+ | |||
+ | |||
+ | ====21c==== | ||
+ | |||
+ | Oracle Datenbank 21c Linux | ||
+ | |||
+ | * [[dba: | ||
+ | |||
+ | * [[dba: | ||
+ | |||
+ | |||
+ | ====19c==== | ||
+ | |||
+ | Basis Vorbereitung: | ||
+ | * [[linux: | ||
+ | |||
+ | |||
+ | Oracle Datenbank 19c Unter MS Windows | ||
+ | |||
+ | * [[dba: | ||
+ | |||
Zeile 592: | Zeile 676: | ||
- | Oralce | + | Oracle |
* [[dba: | * [[dba: | ||
+ | |||
====12c==== | ====12c==== | ||
Zeile 708: | Zeile 793: | ||
**TDE** | **TDE** | ||
* [[sec: | * [[sec: | ||
+ | |||
+ | **Log4j** | ||
+ | * [[sec: | ||
+ | |||
| | ||
**Passwort** | **Passwort** | ||
Zeile 785: | Zeile 874: | ||
===Allgemein=== | ===Allgemein=== | ||
+ | |||
+ | |||
+ | ==Ideen== | ||
+ | |||
+ | |||
+ | Tactics and Techniques representing the MITRE ATT& | ||
+ | |||
+ | * https:// | ||
+ | |||
==Produktvergleiche Sicherheitsoftware== | ==Produktvergleiche Sicherheitsoftware== | ||
Zeile 818: | Zeile 916: | ||
* [[dba: | * [[dba: | ||
+ | |||
+ | Support Nodes: | ||
+ | |||
+ | * Oracle 19c - Complete checklist for Manual Upgrade for upgrading Oracle 12.x, 18c Container database (CDB) to Oracle 19c (19.x) (Doc ID 2549866.1) | ||
====18c==== | ====18c==== | ||
Zeile 839: | Zeile 941: | ||
* [[dba: | * [[dba: | ||
+ | |||
+ | |||
+ | * [[dba: | ||
+ | |||
====11g R1 nach 11g R2 ==== | ====11g R1 nach 11g R2 ==== | ||
Zeile 860: | Zeile 966: | ||
==Wichtige Support Dokumente der Datenbank für die Versionsverwaltung== | ==Wichtige Support Dokumente der Datenbank für die Versionsverwaltung== | ||
+ | Security: | ||
+ | * https:// | ||
+ | |||
- | * Oracle Database - Overview of Database Patch Delivery Methods (Doc ID 1962125.1) | ||
- | * Quick Reference to RDBMS Database Patchset Patch Numbers [ID 753736.1] | ||
- | * Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets (Doc ID 1454618.1) | ||
* Release Schedule of Current Database Releases (Doc ID 742060.1) | * Release Schedule of Current Database Releases (Doc ID 742060.1) | ||
- | * OPatch - Where Can I Find the Latest Version of OPatch? [Video] (Doc ID 224346.1) | + | |
- | * Oracle | + | 12.1 und kleiner |
- | * RAC PATCHING QUICK REF: Applying CRS PSU, CRS Bundle, GI PSU, Windows Bundles 10.2 - 11.2 (Doc ID 1446371.1) | + | * Oracle |
- | + | ||
* Patch für 11.2.0.4 => Database 11.2.0.4 Proactive Patch Information (Doc ID 2285559.1) | * Patch für 11.2.0.4 => Database 11.2.0.4 Proactive Patch Information (Doc ID 2285559.1) | ||
+ | * RAC PATCHING QUICK REF: Applying CRS PSU, CRS Bundle, GI PSU, Windows Bundles 10.2 - 11.2 (Doc ID 1446371.1) | ||
+ | ab 12.2 | ||
+ | * Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2) | ||
+ | 19c | ||
+ | * Oracle Database 19c Proactive Patch Information(2521164.1) | ||
+ | |||
+ | **Welche Pache müssen on top auf den RU eingespielt werden?** | ||
+ | * Oracle Database 19c Important Recommended One-off Patches (Doc ID 555.1) | ||
+ | |||
+ | OPatch | ||
+ | |||
* OPatch Patch Number: 6880880 | * OPatch Patch Number: 6880880 | ||
+ | * Primary Note For OPatch (Doc ID 293369.1) | ||
+ | * OPatch - Where Can I Find the Latest Version of OPatch? [Video] (Doc ID 224346.1) | ||
+ | * https:// | ||
+ | |||
+ | Checks: | ||
* Check Scripts: hcheck.sql - Script to Check for Known Problems in Oracle8i, Oracle9i, Oracle10g, Oracle 11g and Oracle 12c (Doc ID 136697.1) | * Check Scripts: hcheck.sql - Script to Check for Known Problems in Oracle8i, Oracle9i, Oracle10g, Oracle 11g and Oracle 12c (Doc ID 136697.1) | ||
Zeile 878: | Zeile 999: | ||
- | == rollback | + | == Patch Rollback |
Linux | Linux | ||
Zeile 915: | Zeile 1036: | ||
Siehe Lizenzinformation unter => https:// | Siehe Lizenzinformation unter => https:// | ||
+ | |||
+ | Gute Übersicht => https:// | ||
==== Installation ==== | ==== Installation ==== | ||
Zeile 977: | Zeile 1100: | ||
srvctl .... | srvctl .... | ||
</ | </ | ||
+ | |||
+ | ==19c== | ||
+ | |||
+ | * [[dba: | ||
+ | * [[dba: | ||
==12c== | ==12c== | ||
Zeile 1059: | Zeile 1187: | ||
+ | |||
+ | ---- | ||
+ | |||
+ | ===== Multitenant Architecture - Plugable Database ===== | ||
+ | |||
+ | Ab Oracle 21 ein Muss! Oracle 19c letzte Version mit " | ||
+ | |||
+ | Lizenz => siehe https:// | ||
+ | a given container database at any time"// | ||
+ | |||
+ | Bei jeder Option sind dann also 3 Plugable Datenbank pro DB in der Basis Lizenz enthalten. | ||
+ | |||
+ | |||
+ | * [[dba: | ||
---- | ---- | ||
Zeile 1130: | Zeile 1272: | ||
Installation | Installation | ||
+ | * [[dba: | ||
* [[dba: | * [[dba: | ||
Zeile 1203: | Zeile 1346: | ||
* http:// | * http:// | ||
* http:// | * http:// | ||
+ | * http:// | ||
oracle_datenbank.txt · Zuletzt geändert: 2024/01/10 17:54 von gpipperr