|
(Tags: Replaced, Rollback) |
| Line 1: |
Line 1: |
| − | <!---- Left hand side ---->
| |
| − | {| width=100% cellpadding=5 cellspacing=5 style="margin: 10px 0px 0px 0px; text-align: justify"
| |
| − | |- 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]]
| |
| − |
| |
| − | == Basics ==
| |
| | | | |
| | * [[select]] | | * [[select]] |
| Line 19: |
Line 4: |
| | * [[update]] | | * [[update]] |
| | * [[delete]] | | * [[delete]] |
| − | * [[create]]
| |
| − | * [[index]]
| |
| − | * [[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 ==
| |
| − |
| |
| − | * [[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]]
| |
| − |
| |
| − | == Multitenant ==
| |
| − |
| |
| − | * [[General Multitenant]]
| |
| − |
| |
| − |
| |
| − | <!---- 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 ==
| |
| − |
| |
| − | * [[Explain plan]]
| |
| − | * [[Fetch SQL and bind variables]]
| |
| − | * [[Find SID and SERIAL#]]
| |
| − | * [[Find blocking locks]]
| |
| − | * [[Find wait classes]]
| |
| − | * [[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]]
| |
| − |
| |
| − | == Connecting to Oracle ==
| |
| − |
| |
| − | * [[Python connect ]]
| |
| − |
| |
| − | == PL/SQL ==
| |
| − |
| |
| − | * [[Search data in columns]]
| |
| − | * [[Find and delete duplicate rows]]
| |
| − |
| |
| − | == FlashBack ==
| |
| − |
| |
| − | * [[Flashback general]]
| |
| − | * [[Restore point]]
| |
| − |
| |
| − | == DataGuard ==
| |
| − |
| |
| − | * [[DataGuard installation]]
| |
| − |
| |
| − | == RAC ==
| |
| − |
| |
| − | * [[RAC installation]]
| |
| − | * [[RAC General]]
| |
| − | * [[RAC Start/Stop]]
| |
| − | * [[RAC DB Maintenance]]
| |
| − | * [[SRVCTL]]
| |
| − | * [[CRSCTL]]
| |
| − | * [[ORACONFIG]]
| |
| − | * [[OCRCHECK]]
| |
| − | * [[RAC Log files]]
| |
| − | * [[RAC shortcuts]]
| |
| − | * [[RAC active/passive]]
| |
| − | * [[RAC move OCR/VOTE/+ASM]]
| |
| − | * [[crsstat script]]
| |
| − |
| |
| − | == ASM ==
| |
| − |
| |
| − | * [[General ASM]]
| |
| − | * [[ASMLib]]
| |
| − | * [[ASMLib add multipath disk]]
| |
| − | * [[ASMLib del multipath disk]]
| |
| − | * [[ASMCMD]]
| |
| − | * [[+ASM]]
| |
| − | * [[+ASM create/add/drop disks]]
| |
| − | * [[ASMCA]]
| |
| − |
| |
| − | == 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 12c ===
| |
| − | * [[Klient anpassningar 11.2 mot databas version 12.2]]
| |
| − |
| |
| − | === Oracle 19c ===
| |
| − | * [[Installation av 19c databas]]
| |
| − | * [[Uppgradera från 18c till 19c]]
| |
| − | * [[Patcha 19.3 till 19.12]]
| |
| − | * [[Byta plats på $ORACLE HOME för 19.3]]
| |
| − |
| |
| − | == RMAN ==
| |
| − |
| |
| − | * [[RMAN General]]
| |
| − | * [[Block Change Tracking]]
| |
| − | * [[List and report]]
| |
| − | * [[RMAN cleanup archive logs]]
| |
| − | * [[RMAN repository]]
| |
| − | * [[RMAN online backup]]
| |
| − | * [[RMAN online backup with Networker]]
| |
| − | * [[RMAN offline backup]]
| |
| − | * [[RMAN restore with Controlfile]]
| |
| − | * [[RMAN restore new node, Controlfile, ASM]]
| |
| − | * [[RMAN restore with Catalog and Networker]]
| |
| − | * [[RMAN duplicate]]
| |
| − | * [[RMAN duplicate RAC to single instance]]
| |
| − | * [[RMAN duplicate tape 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 ==
| |
| − | * [[Start/stop OWB server]]
| |
| − | * [[Start OWB client]]
| |
| − | * [[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]]
| |
| − | * [[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]]
| |
| − | * [[opatch]]
| |
| − | * [[opatchauto]]
| |
| − | * [[Software Library]]
| |
| − |
| |
| − | == Recommended external links ==
| |
| − |
| |
| − | * [http://www.orafaq.com OraFaq]
| |
| − | * [http://www.psoug.org PSOUG]
| |
| − | * [http://asktom.oracle.com Thomas Kyte]
| |
| − | * [http://www.idevelopment.info Jeff Hunter Homepage]
| |
| − | * [http://www.jlcomp.demon.co.uk Jonathan Lewis Homepage]
| |
| − | * [http://jonathanlewis.wordpress.com Jonathan Lewis Scratchpad]
| |
| − | * [http://www.ixora.com.au/tips IXORA]
| |
