Difference between revisions of "Oracle"

From Robin-Wiki
(Oracle 19c)
 
(74 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 38: Line 42:
 
* [[Linux Oracle script]]
 
* [[Linux Oracle script]]
 
* [[Oracle analytics]]
 
* [[Oracle analytics]]
 +
* [[Expired users]]
  
 
== Installation ==
 
== Installation ==
  
 +
* [[Oracle environment]]
 +
* [[Oracle preinstall]]
 +
* [[listener.ora]]
 +
* [[tnsnames.ora]]
 
* [[General init.ora]]
 
* [[General init.ora]]
 
* [[General disklayout]]
 
* [[General disklayout]]
 
* [[Tablespaces initial XE]]
 
* [[Tablespaces initial XE]]
 +
* [[Install 18c databas]]
  
 
== Admin ==
 
== Admin ==
Line 61: Line 71:
 
* [[Block corruption]]
 
* [[Block corruption]]
 
* [[DBMS calibrate]]
 
* [[DBMS calibrate]]
 +
* [[Recyclebin]]
 
* [[Set async IO]]
 
* [[Set async IO]]
 
* [[Show version]]
 
* [[Show version]]
Line 88: Line 99:
  
 
* [[RMAN-6169]]
 
* [[RMAN-6169]]
 +
 +
== Oracle Support ==
 +
 +
* [[General analys länkar]]
 +
* [[tfactl]]
 +
 +
== Multitenant ==
 +
 +
* [[General Multitenant]]
 +
 +
== Statspack ==
 +
 +
* [[Installing statspack]]
 +
* [[Using statspack]]
 +
* [[Report statspack]]
  
  
 
<!---- Middle side ---->
 
<!---- Middle side ---->
 
| style="border:1px solid #cedff2;" bgcolor=#FFFFFF width=33% |
 
| style="border:1px solid #cedff2;" bgcolor=#FFFFFF width=33% |
 +
 +
== SQL in shell scripts ==
 +
 +
* [[Delete and insert files over DB-link]]
  
 
== Tuning ==
 
== Tuning ==
Line 118: 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 136: Line 167:
  
 
* [[DataGuard installation]]
 
* [[DataGuard installation]]
 +
* [[DataGuard installation 19c]]
 +
 +
== Grid Infrastructure ==
 +
 +
* [[Check OJVM 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 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]]
* [[ORACONFIG]]
+
* [[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 ==
  
 
* [[General ASM]]
 
* [[General ASM]]
 +
* [[Environment ASM]]
 +
* [[Install ASM]]
 +
* [[Install ASM on RH 6.10]]
 +
* [[Install RAC ASM on RH 6.10]]
 +
* [[Deinstall ASM on RH 6.10]]
 +
* [[Kurs ASM]]
 +
* [[ASM SQL]]
 
* [[ASMLib]]
 
* [[ASMLib]]
 
* [[ASMLib add multipath disk]]
 
* [[ASMLib add multipath disk]]
Line 163: Line 219:
 
* [[+ASM create/add/drop disks]]
 
* [[+ASM create/add/drop disks]]
 
* [[ASMCA]]
 
* [[ASMCA]]
 +
* [[Byt hostname i ASM]]
  
 
== DataPump ==
 
== DataPump ==
Line 178: Line 235:
 
* [[tnsnames]]
 
* [[tnsnames]]
 
* [[Broken connections]]
 
* [[Broken connections]]
 +
 +
== Resource manager ==
 +
 +
* [[General resource manager]]
 +
 +
== Golden Gate ==
 +
 +
* [[General Golden Gate]]
  
  
 
<!---- 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 ===
 +
* [[Klient anpassningar 11.2 mot databas version 12.2]]
 +
 +
=== Oracle 19c ===
 +
* [[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]]
 +
* [[Patcha 19.3 till 19.12]]
 +
* [[Byta plats på $ORACLE HOME för 19.3]]
 +
 +
=== Oracle 23c ===
 +
* [[Oracle 23c free OL8 install]]
  
 
== RMAN ==
 
== RMAN ==
Line 188: 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 210: Line 304:
 
* [[Start/stop av ODI Studio]]
 
* [[Start/stop av ODI Studio]]
 
* [[Start/stop av Node Manager och ODI agent]]
 
* [[Start/stop av Node Manager och ODI agent]]
 +
* [[Data kvalitet]]
  
 
== OWB 11.2.0.3 ==
 
== OWB 11.2.0.3 ==
Line 226: Line 321:
 
* [[Agent handling]]
 
* [[Agent handling]]
 
* [[EM Diag]]
 
* [[EM Diag]]
 +
* [[EM RAC drop/create]]
 
* [[Cloud licensing]]
 
* [[Cloud licensing]]
 
* [[opmnctl]]
 
* [[opmnctl]]
Line 248: 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 ==

Latest revision as of 17:01, 10 January 2025

General

Oracle Support

Basics

Advanced

Installation

Admin

DB Links

Oracle errors

RMAN errors

Oracle Support

Multitenant

Statspack


SQL in shell scripts

Tuning

SQL

Connecting to Oracle

PL/SQL

FlashBack

DataGuard

Grid Infrastructure

RAC

ASM

DataPump

SQL*Loader

SQL*Net

Resource manager

Golden Gate


Oracle 11.2

Oracle 12c

Oracle 19c

Oracle 23c

RMAN

ODI 12.2.1.3

OWB 11.2.0.3

Cloud Control 12.1

DBMS_SCHEDULER

Materialized views

Performance

Patch

UTL

Recommended external links