Difference between revisions of "Oracle"
From Robin-Wiki
(→Oracle 19c) |
|||
| (237 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
| style="border:1px solid #cedff2;" width=33% bgcolor=#FFFFFF valign="top" | | | style="border:1px solid #cedff2;" width=33% bgcolor=#FFFFFF valign="top" | | ||
| − | + | == General == | |
| + | |||
| + | * [[General Oracle]] | ||
| + | * [http://www.oracle.com/us/corporate/contracts/processor-core-factor-table-070634.pdf Core factor license] | ||
| + | * [http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf Price list in dollar] | ||
| + | * [http://www.oracle.com/us/corporate/pricing/exadata-pricelist-070598.pdf Hardware Price list in dollar] | ||
| + | * [[Character set]] | ||
| + | * [[DDL, DML and DCL commands]] | ||
| + | |||
| + | == Oracle Support == | ||
| + | |||
| + | * [[Bra MOS dokument]] | ||
== Basics == | == Basics == | ||
| Line 12: | Line 23: | ||
* [[update]] | * [[update]] | ||
* [[delete]] | * [[delete]] | ||
| + | * [[create]] | ||
* [[index]] | * [[index]] | ||
* [[DB link]] | * [[DB link]] | ||
| + | |||
| + | == Advanced == | ||
| + | |||
* [[lob]] | * [[lob]] | ||
| + | * [[regexp]] | ||
| + | * [[listagg]] | ||
| + | * [[decode]] | ||
| + | * [[case]] | ||
| + | * [[pivot]] | ||
| + | * [[Epoch time]] | ||
| + | * [[group by concatenate]] | ||
| + | * [[Bulk collect forall]] | ||
| + | * [[bind in SQL]] | ||
| + | * [[special characters in select]] | ||
| + | * [[Linux Oracle script]] | ||
| + | * [[Oracle analytics]] | ||
| + | * [[Expired users]] | ||
| + | |||
| + | == Installation == | ||
| + | |||
| + | * [[Oracle environment]] | ||
| + | * [[Oracle preinstall]] | ||
| + | * [[listener.ora]] | ||
| + | * [[tnsnames.ora]] | ||
| + | * [[General init.ora]] | ||
| + | * [[General disklayout]] | ||
| + | * [[Tablespaces initial XE]] | ||
| + | * [[Install 18c databas]] | ||
| + | |||
| + | == Admin == | ||
| + | |||
| + | * [[Archive log]] | ||
| + | * [[Analyze schema tables]] | ||
| + | * [[Connect to database without tnsnames.ora]] | ||
| + | * [[Run oracle job from cron]] | ||
| + | * [[Trace]] | ||
| + | * [[Tablespaces]] | ||
| + | * [[Change database name and DBID]] | ||
| + | * [[Restore inventory]] | ||
| + | * [[Find duplicate rows]] | ||
| + | * [[Test script connecting database, backup]] | ||
| + | * [[Set init parameter inside Oracle]] | ||
| + | * [[Config files outside ORACLE_HOME]] | ||
| + | * [[Block corruption]] | ||
| + | * [[DBMS calibrate]] | ||
| + | * [[Recyclebin]] | ||
| + | * [[Set async IO]] | ||
| + | * [[Show version]] | ||
| + | * [[Show OEM Packs]] | ||
| + | * [[Show feature usage]] | ||
| + | * [[Show database files]] | ||
| + | * [[Oracle schemas]] | ||
| + | * [[Control SQL*Plus]] | ||
| + | * [[Gather system statistics]] | ||
| + | |||
| + | == DB Links == | ||
| + | |||
| + | * [[DB links general]] | ||
| + | |||
| + | == Oracle errors == | ||
| + | |||
| + | * [[ORA-230]] | ||
| + | * [[ORA-235]] | ||
| + | * [[ORA-600]] | ||
| + | * [[ORA-4030]] | ||
| + | * [[ORA-7445]] | ||
| + | * [[ORA-12560]] | ||
| + | * [[RMAN-20223]] | ||
| + | * [[Fatal NI connect error]] | ||
| + | |||
| + | == RMAN errors == | ||
| + | |||
| + | * [[RMAN-6169]] | ||
| + | |||
| + | == Oracle Support == | ||
| + | |||
| + | * [[General analys länkar]] | ||
| + | * [[tfactl]] | ||
| + | |||
| + | == Multitenant == | ||
| + | |||
| + | * [[General Multitenant]] | ||
| + | |||
| + | == Statspack == | ||
| + | |||
| + | * [[Installing statspack]] | ||
| + | * [[Using statspack]] | ||
| + | * [[Report statspack]] | ||
| + | |||
| + | |||
| + | <!---- Middle side ----> | ||
| + | | style="border:1px solid #cedff2;" bgcolor=#FFFFFF width=33% | | ||
| + | |||
| + | == SQL in shell scripts == | ||
| + | |||
| + | * [[Delete and insert files over DB-link]] | ||
| + | |||
| + | == Tuning == | ||
| + | |||
| + | * [[SQL Profile]] | ||
| + | * [[SQL Advisor]] | ||
| + | * [[Segment Advisor]] | ||
== SQL == | == SQL == | ||
| + | * [[Explain plan]] | ||
| + | * [[Fetch SQL and bind variables]] | ||
* [[Find SID and SERIAL#]] | * [[Find SID and SERIAL#]] | ||
* [[Find blocking locks]] | * [[Find blocking locks]] | ||
| + | * [[Find wait classes]] | ||
* [[Search column names]] | * [[Search column names]] | ||
| + | * [[Check backup]] | ||
| + | * [[Show top 10 byte segments]] | ||
| + | * [[Show stale index]] | ||
| + | * [[Fragmentation]] | ||
| + | * [[Chained rows]] | ||
| + | * [[High Water Mark HWM]] | ||
| + | * [[Show constraint info on table]] | ||
| + | * [[Show all datafiles]] | ||
| + | * [[Kill CPU thread]] | ||
| + | * [[Show common DB info]] | ||
| + | * [[Show all constraints]] | ||
| + | * [[Show active sessions]] | ||
| + | |||
| + | == Connecting to Oracle == | ||
| + | |||
| + | * [[Python connect ]] | ||
== PL/SQL == | == PL/SQL == | ||
* [[Search data in columns]] | * [[Search data in columns]] | ||
| + | * [[Find and delete duplicate rows]] | ||
| + | |||
| + | == FlashBack == | ||
| + | |||
| + | * [[Flashback general]] | ||
| + | * [[Restore point]] | ||
| + | |||
| + | == DataGuard == | ||
| + | |||
| + | * [[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 installation]] | ||
| + | * [[RAC DB installation]] | ||
| + | * [[Clone RAC in VmWare]] | ||
| + | * [[RAC General]] | ||
| + | * [[RAC Start/Stop]] | ||
| + | * [[RAC DB Maintenance]] | ||
| + | * [[RAC Network]] | ||
| + | * [[SRVCTL]] | ||
| + | * [[CRSCTL]] | ||
| + | * [[CLUVFY]] | ||
| + | * [[OCRCONFIG]] | ||
| + | * [[OCRCHECK]] | ||
| + | * [[OIFCFG]] | ||
| + | * [[RAC Log files]] | ||
| + | * [[RAC shortcuts]] | ||
| + | * [[RAC active/passive]] | ||
| + | * [[RAC move spfile]] | ||
| + | * [[RAC move OCR/VOTE/+ASM]] | ||
| + | * [[crsstat script]] | ||
| + | * [[mcasttest.pl]] | ||
| + | |||
| + | == 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 add multipath disk]] | ||
| + | * [[ASMLib del multipath disk]] | ||
| + | * [[ASMCMD]] | ||
| + | * [[+ASM]] | ||
| + | * [[+ASM create/add/drop disks]] | ||
| + | * [[ASMCA]] | ||
| + | * [[Byt hostname i ASM]] | ||
| + | |||
| + | == DataPump == | ||
| − | |||
| − | |||
* [[Datapump]] | * [[Datapump]] | ||
| + | |||
| + | == SQL*Loader == | ||
| + | |||
| + | * [[SQL*Loader]] | ||
| + | |||
| + | == SQL*Net == | ||
| + | |||
| + | * [[SQL*Net]] | ||
| + | * [[Listener]] | ||
| + | * [[tnsnames]] | ||
| + | * [[Broken connections]] | ||
| + | |||
| + | == Resource manager == | ||
| + | |||
| + | * [[General resource manager]] | ||
| + | |||
| + | == Golden Gate == | ||
| + | |||
| + | * [[General Golden Gate]] | ||
| + | |||
| + | |||
| + | <!---- Right hand side ----> | ||
| + | | 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 == | ||
| + | * [[RMAN General]] | ||
| + | * [[Block Change Tracking]] | ||
| + | * [[List and report]] | ||
| + | * [[SQL for RMAN summary]] | ||
| + | * [[RMAN crosscheck]] | ||
| + | * [[RMAN validate]] | ||
| + | * [[RMAN cleanup]] | ||
| + | * [[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 offline backup]] | * [[RMAN offline backup]] | ||
| − | * [[RMAN restore]] | + | * [[RMAN incremental for ever backup]] |
| + | * [[RMAN restore until time, limit recovery file]] | ||
| + | * [[RMAN restoretest ASM]] | ||
| + | * [[RMAN restore with Controlfile]] | ||
| + | * [[RMAN restore new node, Controlfile, ASM]] | ||
| + | * [[RMAN restore with Catalog and Networker]] | ||
| + | * [[RMAN restore RAC]] | ||
* [[RMAN duplicate]] | * [[RMAN duplicate]] | ||
| + | * [[RMAN duplicate RAC to single instance]] | ||
| + | * [[RMAN duplicate tape Networker]] | ||
* [[RMAN & Networker]] | * [[RMAN & Networker]] | ||
| + | * [[RMAN & Tivoli/TSM]] | ||
| + | * [[RMAN duplicate tape Tivoli/TSM]] | ||
| + | * [[RMAN script Linux]] | ||
| + | * [[RMAN script Windows]] | ||
| − | == | + | == ODI 12.2.1.3 == |
| − | * [[ | + | * [[Generellt ODI]] |
| + | * [[Start/stop av ODI Studio]] | ||
| + | * [[Start/stop av Node Manager och ODI agent]] | ||
| + | * [[Data kvalitet]] | ||
== OWB 11.2.0.3 == | == OWB 11.2.0.3 == | ||
| − | + | * [[Start/stop OWB server]] | |
* [[Start OWB client]] | * [[Start OWB client]] | ||
* [[Upgrade & install OWB 11.2.0.3]] | * [[Upgrade & install OWB 11.2.0.3]] | ||
| + | * [[Install OWB 11.2.0.4]] | ||
| + | * [[Diverse OWB]] | ||
| + | |||
| + | == Cloud Control 12.1 == | ||
| + | * [[Install Cloud Control server]] | ||
| + | * [[Install Cloud agent]] | ||
| + | * [[Start/stop Cloud Control]] | ||
| + | * [[Inactivity timout console]] | ||
| + | * [[OMS handling]] | ||
| + | * [[Agent handling]] | ||
| + | * [[EM Diag]] | ||
| + | * [[EM RAC drop/create]] | ||
| + | * [[Cloud licensing]] | ||
| + | * [[opmnctl]] | ||
| + | * [[Management packs]] | ||
| + | * [[Reset SYSMAN password]] | ||
| + | |||
| + | == DBMS_SCHEDULER == | ||
| + | |||
| + | * [[Restart scheduler]] | ||
| + | * [[Check scheduler jobs]] | ||
| + | * [[External JOBS Linux]] | ||
| + | * [[External JOBS Windows]] | ||
| + | |||
| + | == Materialized views == | ||
| + | * [[General MVIEWS]] | ||
| + | |||
| + | == Performance == | ||
| + | * [[CPU performance, HW]] | ||
| + | * [[Disk performance, HW]] | ||
| + | |||
| + | == Patch == | ||
| + | * [[Upgrade to Oracle database 11.2.0.3]] | ||
| + | * [[Upgrade to Oracle database 11.2.0.4]] | ||
| + | * [[Upgrade to Oracle database 19.12]] | ||
| + | * [[Upgrade to Oracle database 19.21]] | ||
| + | * [[opatch]] | ||
| + | * [[opatchauto]] | ||
| + | * [[Software Library]] | ||
| + | * [[Relink e2eme when failing]] | ||
| + | * [[Patch subpatch from PSU bundle that fails]] | ||
| + | |||
| + | == UTL == | ||
| + | |||
| + | * [[UTL PL/SQL]] | ||
== Recommended external links == | == Recommended external links == | ||
| Line 58: | Line 364: | ||
* [http://www.jlcomp.demon.co.uk Jonathan Lewis Homepage] | * [http://www.jlcomp.demon.co.uk Jonathan Lewis Homepage] | ||
* [http://jonathanlewis.wordpress.com Jonathan Lewis Scratchpad] | * [http://jonathanlewis.wordpress.com Jonathan Lewis Scratchpad] | ||
| − | + | * [http://www.ixora.com.au/tips IXORA] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
