Oracle

General General Oracle Core factor license Price list in dollar Hardware Price list in dollar Character set DDL, DML and DCL commands Oracle Support Bra MOS dokument Basics select insert update delete create index DB link Advanced 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

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 Show active sessions Connecting to Oracle Python connect PL/SQL Search data in columns Find and delete duplicate rows FlashBack Flashback general Restore point DataGuard DataGuard installation DataGuard installation 19c DataGuard general 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 PSUjan2025 för 19c PSUjan2025 för 19c, patcha innan installation PSUjan2025 för 19c 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 RAC backup/restore DB/GRID files Clone RAC in VmWare RAC General RAC Start/Stop RAC DB Maintenance RAC Network SRVCTL CRSCTL CLUVFY OCRCONFIG OCRCHECK OLSNODES OIFCFG RAC Log files RAC shortcuts RAC active/passive RAC move spfile RAC move OCR/VOTE/+ASM crsstat script ACFS unmount/mount mcasttest.pl iptables for RAC ASM General ASM Environment ASM Install ASM Install ASM on OL 9.5 Install ASM on OL 8.10 Install ASM on RH 8.10 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 disk ASMLib add multipath disk ASMLib del multipath disk ASMCMD +ASM +ASM create/add/drop disks ASMCA ACFS Byt hostname i ASM ASM db_recovery_file_dest_size full DataPump Datapump SQL*Loader SQL*Loader SQL*Net SQL*Net Listener tnsnames Broken connections Resource manager General resource manager Golden Gate General Golden Gate

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 Oracle Linux 8.10 Installation av 19c databas RedHat 8.10 Installation av 19c databas på OL 9.5 med ASM Installation av 19c databas på OL 9.4 Installation av 19c databas på Red Hat 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 General Block Change Tracking List and report SQL for RMAN summary RMAN crosscheck RMAN validate RMAN cleanup RMAN cleanup archive logs RMAN repository RMAN Backup RMAN backuptest ASM RMAN online backup RMAN online backup with Networker RMAN offline backup RMAN incremental for ever backup RMAN 19c EE incremental for ever backup test 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 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 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 Upgrade to Oracle database 19.26 opatch opatchauto opatch auto fails Software Library Relink e2eme when failing Patch subpatch from PSU bundle that fails UTL UTL PL/SQL Recommended external links OraFaq PSOUG Thomas Kyte Jeff Hunter Homepage Jonathan Lewis Homepage Jonathan Lewis Scratchpad IXORA