HowTo

From OraWiki

Contents 1 List of all HowTo's at OraForecast.com 1.1 Hardware 1.1.1 Network related Hardware 1.1.2 Computers 1.2 Operating System 1.2.1 General 1.2.2 Linux 1.2.2.1 SuSE 1.2.2.2 RedHat 1.2.2.3 Ubuntu 1.2.2.4 Breezy 5.10 1.2.2.5 Dapper 6.06 1.2.2.6 Edgy Eft 6.10 1.2.3 Solaris 1.2.4 Windows 1.2.5 Open VMS 1.2.6 AIX 1.3 Shell 1.3.1 KSH 1.3.2 Bash 1.3.3 CygWin 1.4 Database 1.4.1 Oracle 1.4.1.1 Generic Performance 1.4.1.2 Generic Troubleshooting 1.4.1.3 Products using Oracle database 1.4.1.3.1 Oracle Enterprise Manager 1.4.1.3.2 SAP 1.4.1.3.3 HP OpenView 1.4.1.3.4 Quest Toad 1.4.1.3.5 Quest Open Source alternative TOra 1.4.1.3.6 TeamQuest 1.4.1.3.7 UC4 1.4.1.3.8 Schema Manager 1.4.1.4 Installation of Oracle database 1.4.1.4.1 Oracle 7.x 1.4.1.4.2 Oracle 8.x 1.4.1.4.3 Oracle 9.x 1.4.1.4.4 Oracle 10.x 1.4.1.4.5 Oracle 11.x 1.4.1.4.6 Oracle 7.x Parallel Server 1.4.1.4.7 Oracle 8.x Parallel Server 1.4.1.4.8 Oracle 9.x RAC 1.4.1.4.9 Oracle 10.x RAC 1.4.1.4.10 Backup and Recover 1.4.1.4.11 DataGuard 1.4.1.4.12 Fatal Oracle Database Bugs (Performance) 1.4.2 MySQL 1.4.2.1 Products using MySQL databases 1.4.2.1.1 phpBB2 1.4.2.1.2 WikiMedia 1.4.2.1.3 WikiMedia additional modules installed at OraForecast.com 1.4.2.1.4 phpMyAdmin 1.4.3 PostGre 1.4.4 Microsoft SQL Server 1.4.5 Microsoft Access 1.5 Programming Language 1.5.1 C/C++ 1.5.2 HTML 1.5.3 Java 1.5.4 Perl 1.5.5 PL/SQL 1.5.6 PovRAY 1.5.7 PHP 1.5.8 SQL 1.6 Other Servers 1.6.1 HTTP Servers 1.6.1.1 Apache 1.6.1.2 IIS 1.6.2 SMTP/POP3 Server 1.6.2.1 PostFix 1.6.2.2 SuSE Linux Mailserver 1.6.2.3 Courier-POP3/IMAP Mailserver 1.6.2.4 Cyrus- POP3/IMAP Mailserver 1.6.2.5 Squirrel Web Mail 1.6.2.6 Uebimiau Web Mail 1.6.3 DNS 1.6.3.1 Bind 1.6.4 LDAP 1.6.4.1 OpenLDAP 1.6.4.2 Netscape LDAP 1.6.4.3 Proprietary Microsoft LDAP Active Directory 1.6.5 DHCP 1.6.6 SSH 1.6.7 SSL 1.6.8 Tuning of third party products based upon Oracle RDBMS 1.6.8.1 UC4 1.6.8.2 Trustcenter PKI 1.6.8.3 Siebel 1.6.8.4 Seeburger 1.6.8.5 Remedy ARS 1.6.8.6 Insiders Smartfix 1.6.8.7 Prout print services 1.6.8.8 Salomon LVS 1.6.8.9 SAP 1.6.9 Whitepapers

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

• Ubuntu 6.10 Edgy inofficial HowTo

Solaris

Windows

Open VMS

AIX

• ORA-27091: skgfqio: unable to queue I/O ORA-27072

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

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

• How to setup a mailsystem

SuSE Linux Mailserver

Courier-POP3/IMAP Mailserver

Cyrus- POP3/IMAP Mailserver

• Cyrus IMAP HowTo
• Ubuntu 6.10 related installation bug and patch

Squirrel Web Mail

• SquirrelMail WebMail

Uebimiau Web Mail

How to setup Uebimiau Configuration and setup of Uebimiau

DNS

Bind

LDAP

• Use generic phpLDAPadmin tool@OraForecast.com online

OpenLDAP

• OpenLDAP documentation
  
• Nice link which gives an overview if you want to compile OpenLDAP with MySQL
  
• Linux OS authentification via LDAP(German language)
  
• How to install OpenLDAP 2.2.26 for Ubuntu 6.10 Edgy Eft using MySQL
  
• How to install OpenLDAP 2.4.9 for Ubuntu 8.04 hardy using MySQL
  
• How to configure OpenLDAP 2.2.26 at Ubuntu 6.10 Edgy Eft using SSL access
  
• How to use OpenLDAP command line tools
  
• How 2 secure 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

• How to speed up a UC4 system
  
• Relevance of local disk drive of an UC4 application server
  
• UC4 queue analyzer
  
• UC4 analysis of hanging executors

Trustcenter PKI

• How to speed up a Trustcenter PKI system
  

Siebel

• How to speed up a Siebel system
  
• Complete Siebel Performance Session Oracle 8.1.7
  

Seeburger

• How to speed up a Seeburger system
  

Remedy ARS

• How to speed up a Remedy ARS system
  
• Remedy 7.0 fast user login
  
• Plan stability for incident search
  
• Decrease response time of search user in tab position
  
• Decrease response time of search incident number in tab incidents
  
• Decrease response time of most often used incident search
  
• Summary of OraForecast.com recommended indexes for Remedy ARS
  

Insiders Smartfix

• How to speed up a Insiders Smartfix system
  

Prout print services

• How to speed up prout print services system
  

Salomon LVS

• How to speed up a Salomon LVS system
  

SAP

• How to speed up a SAP system
  

Whitepapers

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