Difference between revisions of "Oracle"
From Robin-Wiki
(→Installation) |
(→Oracle 19c) |
||
| (48 intermediate revisions by the same user not shown) | |||
| Line 12: | Line 12: | ||
* [[Character set]] | * [[Character set]] | ||
* [[DDL, DML and DCL commands]] | * [[DDL, DML and DCL commands]] | ||
| + | |||
| + | == Oracle Support == | ||
| + | |||
| + | * [[Bra MOS dokument]] | ||
== Basics == | == Basics == | ||
| Line 50: | Line 54: | ||
* [[Tablespaces initial XE]] | * [[Tablespaces initial XE]] | ||
* [[Install 18c databas]] | * [[Install 18c databas]] | ||
| − | |||
== Admin == | == Admin == | ||
| Line 96: | Line 99: | ||
* [[RMAN-6169]] | * [[RMAN-6169]] | ||
| + | |||
| + | == Oracle Support == | ||
| + | |||
| + | * [[General analys länkar]] | ||
| + | * [[tfactl]] | ||
== Multitenant == | == Multitenant == | ||
* [[General Multitenant]] | * [[General Multitenant]] | ||
| + | |||
| + | == Statspack == | ||
| + | |||
| + | * [[Installing statspack]] | ||
| + | * [[Using statspack]] | ||
| + | * [[Report statspack]] | ||
| Line 134: | Line 148: | ||
* [[Show common DB info]] | * [[Show common DB info]] | ||
* [[Show all constraints]] | * [[Show all constraints]] | ||
| + | * [[Show active sessions]] | ||
== Connecting to Oracle == | == Connecting to Oracle == | ||
| Line 152: | Line 167: | ||
* [[DataGuard installation]] | * [[DataGuard installation]] | ||
| + | * [[DataGuard installation 19c]] | ||
== Grid Infrastructure == | == Grid Infrastructure == | ||
| + | * [[Check OJVM för 11.2.0.4]] | ||
* [[PSUjan2016 för 11.2.0.4]] | * [[PSUjan2016 för 11.2.0.4]] | ||
| + | * [[PSUjan2016 för 11.2.0.4 for RAC]] | ||
* [[PSUoct2020 för 11.2.0.4]] | * [[PSUoct2020 för 11.2.0.4]] | ||
| + | * [[PSUoct2020 för 11.2.0.4 for RAC]] | ||
| + | * [[Deinstall PSUoct2020 för 11.2.0.4]] | ||
| + | * [[Deinstall PSUoct2020 för 11.2.0.4 for RAC]] | ||
== RAC == | == RAC == | ||
* [[RAC installation]] | * [[RAC installation]] | ||
| + | * [[RAC DB installation]] | ||
| + | * [[Clone RAC in VmWare]] | ||
* [[RAC General]] | * [[RAC General]] | ||
* [[RAC Start/Stop]] | * [[RAC Start/Stop]] | ||
* [[RAC DB Maintenance]] | * [[RAC DB Maintenance]] | ||
| + | * [[RAC Network]] | ||
* [[SRVCTL]] | * [[SRVCTL]] | ||
* [[CRSCTL]] | * [[CRSCTL]] | ||
| − | * [[ | + | * [[CLUVFY]] |
| + | * [[OCRCONFIG]] | ||
* [[OCRCHECK]] | * [[OCRCHECK]] | ||
| + | * [[OIFCFG]] | ||
* [[RAC Log files]] | * [[RAC Log files]] | ||
* [[RAC shortcuts]] | * [[RAC shortcuts]] | ||
* [[RAC active/passive]] | * [[RAC active/passive]] | ||
| + | * [[RAC move spfile]] | ||
* [[RAC move OCR/VOTE/+ASM]] | * [[RAC move OCR/VOTE/+ASM]] | ||
* [[crsstat script]] | * [[crsstat script]] | ||
| + | * [[mcasttest.pl]] | ||
== ASM == | == ASM == | ||
| Line 180: | Line 208: | ||
* [[Install ASM]] | * [[Install ASM]] | ||
* [[Install ASM on RH 6.10]] | * [[Install ASM on RH 6.10]] | ||
| + | * [[Install RAC ASM on RH 6.10]] | ||
* [[Deinstall ASM on RH 6.10]] | * [[Deinstall ASM on RH 6.10]] | ||
* [[Kurs ASM]] | * [[Kurs ASM]] | ||
| + | * [[ASM SQL]] | ||
* [[ASMLib]] | * [[ASMLib]] | ||
* [[ASMLib add multipath disk]] | * [[ASMLib add multipath disk]] | ||
| Line 217: | Line 247: | ||
<!---- Right hand side ----> | <!---- Right hand side ----> | ||
| style="border:1px solid #cedff2;" bgcolor=#FFFFFF width=33% | | | style="border:1px solid #cedff2;" bgcolor=#FFFFFF width=33% | | ||
| + | |||
| + | === Oracle 11.2 === | ||
| + | * [[Konvert Oracle Standard Edition to Enterprise Edition]] | ||
=== Oracle 12c === | === Oracle 12c === | ||
| Line 223: | Line 256: | ||
=== Oracle 19c === | === Oracle 19c === | ||
* [[Installation av 19c databas]] | * [[Installation av 19c databas]] | ||
| + | * [[Installation av 19c databas på OL 9.4]] | ||
| + | * [[Install 19c database on Redhat 9.2]] | ||
| + | * [[Install 19c database on Oracle Linux 9.3]] | ||
| + | * [[Rename database DBID and name 19c]] | ||
* [[Uppgradera från 18c till 19c]] | * [[Uppgradera från 18c till 19c]] | ||
* [[Patcha 19.3 till 19.12]] | * [[Patcha 19.3 till 19.12]] | ||
* [[Byta plats på $ORACLE HOME för 19.3]] | * [[Byta plats på $ORACLE HOME för 19.3]] | ||
| + | |||
| + | === Oracle 23c === | ||
| + | * [[Oracle 23c free OL8 install]] | ||
== RMAN == | == RMAN == | ||
| Line 232: | Line 272: | ||
* [[Block Change Tracking]] | * [[Block Change Tracking]] | ||
* [[List and report]] | * [[List and report]] | ||
| + | * [[SQL for RMAN summary]] | ||
| + | * [[RMAN crosscheck]] | ||
| + | * [[RMAN validate]] | ||
| + | * [[RMAN cleanup]] | ||
* [[RMAN cleanup archive logs]] | * [[RMAN cleanup archive logs]] | ||
* [[RMAN repository]] | * [[RMAN repository]] | ||
| + | * [[RMAN Backup]] | ||
| + | * [[RMAN backuptest ASM]] | ||
* [[RMAN online backup]] | * [[RMAN online backup]] | ||
* [[RMAN online backup with Networker]] | * [[RMAN online backup with Networker]] | ||
* [[RMAN offline backup]] | * [[RMAN offline backup]] | ||
| + | * [[RMAN incremental for ever backup]] | ||
| + | * [[RMAN restore until time, limit recovery file]] | ||
| + | * [[RMAN restoretest ASM]] | ||
* [[RMAN restore with Controlfile]] | * [[RMAN restore with Controlfile]] | ||
* [[RMAN restore new node, Controlfile, ASM]] | * [[RMAN restore new node, Controlfile, ASM]] | ||
* [[RMAN restore with Catalog and Networker]] | * [[RMAN restore with Catalog and Networker]] | ||
| + | * [[RMAN restore RAC]] | ||
* [[RMAN duplicate]] | * [[RMAN duplicate]] | ||
* [[RMAN duplicate RAC to single instance]] | * [[RMAN duplicate RAC to single instance]] | ||
| Line 271: | Line 321: | ||
* [[Agent handling]] | * [[Agent handling]] | ||
* [[EM Diag]] | * [[EM Diag]] | ||
| + | * [[EM RAC drop/create]] | ||
* [[Cloud licensing]] | * [[Cloud licensing]] | ||
* [[opmnctl]] | * [[opmnctl]] | ||
| Line 293: | Line 344: | ||
* [[Upgrade to Oracle database 11.2.0.3]] | * [[Upgrade to Oracle database 11.2.0.3]] | ||
* [[Upgrade to Oracle database 11.2.0.4]] | * [[Upgrade to Oracle database 11.2.0.4]] | ||
| + | * [[Upgrade to Oracle database 19.12]] | ||
| + | * [[Upgrade to Oracle database 19.21]] | ||
* [[opatch]] | * [[opatch]] | ||
* [[opatchauto]] | * [[opatchauto]] | ||
* [[Software Library]] | * [[Software Library]] | ||
| + | * [[Relink e2eme when failing]] | ||
| + | * [[Patch subpatch from PSU bundle that fails]] | ||
| + | |||
| + | == UTL == | ||
| + | |||
| + | * [[UTL PL/SQL]] | ||
== Recommended external links == | == Recommended external links == | ||
