HowTo

From OraWiki

Jump to: navigation, search

Contents

List of all HowTo's at OraForecast.com

Hardware

Network related Hardware

Computers

Gericom Hummer Pentium 4

Operating System

General

Create a SPAM filter for Novell Evolution to remove kyrillic mails

Linux
  • Watchdog a free software for LINUX health check
SuSE
RedHat
Ubuntu
Breezy 5.10

Breezy Upgrade 2 Edgy Eft

Dapper 6.06

Dapper Upgrade 2 Edgy_Eft

Edgy Eft 6.10
Solaris
Windows
Open VMS
AIX

Shell

KSH

Bash

CygWin

Database

Oracle

Generic Performance

Full Table Scans
Implementation of a Column Store
How to fake an Oracle QEP using stored outlines
How to use an index with no WHERE clause
How to analyze performance issues (Generic, Efficient)
How to analyze and tune SQL*Net
How to size an Oracle database server
How to reduce number of buffer busy waits

Generic Troubleshooting

How to identify long running SQL and kill them

Products using Oracle database
Oracle Enterprise Manager
SAP
HP OpenView
Quest Toad

Can we open Oracle 7 with TOAD version 9.00? Yes, you can.

Quest Open Source alternative TOra

TOra is a TOAD clone for Linux users.

TeamQuest
UC4
Schema Manager

How to manage schema copies between Prod/Test-Integration/Development and Training

Installation of Oracle database
Oracle 7.x
Oracle 8.x
Oracle 9.x
Oracle 10.x
Oracle 11.x

How to install Oracle 11G at UBUNTU 8.04 hardy

Oracle 7.x Parallel Server
Oracle 8.x Parallel Server
Oracle 9.x RAC
Oracle 10.x RAC

How to enable Dead Connection Detection A brief introduction into stable networking for RAC
How to configure TAF A brief introduction into TAF using production and standby RAC
How to add a disk to ASM group A brief instruction how to add a disk to ASM
How to handle ASM problems Some common ASM problems
How to handle shared pool A brief instruction how to manage shared pool and shared pool related problems
How to avoid ASM archiver stucks and hangs on AIX A brief instruction how to manage archiver stucks using Oracle ASM

Backup and Recover

Small Oracle Windows Backup non RMAN A simple generic backup script for Oracle databases
Small Oracle UNIX Backup non RMAN A simple generic backup script for Oracle databases
Small Oracle Backup using RMAN Useful commands to deal with RMAN

DataGuard
Fatal Oracle Database Bugs (Performance)

ASM Oracle Bug# 6139547 ASM/ RAC hangs if DB had an archiver stuck
ASSM Oracle Bug# 6455161 ASSM performance loss, read by other session wait
Index Oracle Bug# 6455161 Expensive index access, high CPU usage, large number of consistent gets
Waits on Cache buffer chain
Waits on buffer exterminate (Automated Memory Management Issues)
CURSOR_SHARING=SIMILAR

MySQL

Howto upgrade MySQL at Ubuntu Linux

Products using MySQL databases
phpBB2
WikiMedia

HowTo 1.4.2.1.2 Wiki file upload problems
HowTo configure WikiMedia to store user data in a LDAP

WikiMedia additional modules installed at OraForecast.com

WikiMedia Modules at OraForecast

phpMyAdmin

PhpMyAdmin source and doku
Required phpMyAdmin post installation task

PostGre

Microsoft SQL Server

Microsoft Access

Programming Language

C/C++

How to set ARRAYSIZE to speed up Oracle networking

HTML

Java

HowTo install Java and Java3D
How to install Jigloo for Eclipse Ubuntu 8.05 hardy
How to manage Oracle LOB's using command line

Perl

PL/SQL

How to count a special char in a varchar
How to monitor index usage

PovRAY

PHP

How to install PHP 5 for Oracle 11 at UBUNTU 8.04 hardy

SQL

Slow LOB access using stored function

Other Servers

HTTP Servers

Apache

Apache2 security
Apache2 manual installation (German language)
Apache2 and SSL nice readme!
Installation of mod_auth_mysql

IIS

SMTP/POP3 Server

How to setup an Ubuntu 6.10 Edgy Eft MailServer OraForecast.com expiriences

PostFix
SuSE Linux Mailserver
Courier-POP3/IMAP Mailserver
Cyrus- POP3/IMAP Mailserver
Squirrel Web Mail
Uebimiau Web Mail

How to setup Uebimiau Configuration and setup of Uebimiau

DNS

Bind

LDAP

OpenLDAP
Netscape LDAP
Proprietary Microsoft LDAP Active Directory

DHCP

SSH

SSL

Create your own certificates (German language)

Tuning of third party products based upon Oracle RDBMS

Some examples of our work. OraForecast.com can analyze and optimize all applications using Oracle RDBMS. We are the most efficient performance experts offering world wide support and high efficiency.

Since we have a broad knowledge of almost any product using Oracle RDBMS we can offer very efficient solutions at low costs.

Don't waste your money with buying hardware. Just ask the experts mailto://performance@OraForecast.com.

UC4
Trustcenter PKI
Siebel
Seeburger
Remedy ARS
Insiders Smartfix
Prout print services
Salomon LVS


SAP

Whitepapers

Complete Performance Manual (archive)
Performance Book (German)
Generic performance article (German)