Akadia Information Technology
Contents
Oracle Tips
of the Week 1999 - 2003
Oracle Installation and
Configuration
Oracle Publications (PDF)
Oracle Publications (HTML)
Oracle Scripts
Microsoft SQL
Server 2000 / .NET Framework / C#
Unix, Linux & Apache
Publications
Java & XML Publications
Windows 2000 & NT
Publications
Networking,
Firewall & Secure Shell (SSH) Publications
Perl, DBI (Database Interface for
Perl) & CGI Publications
Figures
HTML Document including
more Tips
HTML Document including
one Tip
Code Listing or Textfile
Code
for Download.
PDF
Document for Download.
Oracle Tips of the Week for
2003 ... in progress
Many more Oracle Tips of the Week
for the Year 2002
Many more Oracle Tips of the Week
for the Year 2000
Many more Oracle Tips of the Week
for the Year 2001
Many more Oracle Tips of the Week
for the Year 1999 Short Installation Guide Oracle9i on W2K Short Installation Guide Oracle8i on NT4 Short Installation Guide Oracle9i on Linux Short Installation Guide Oracle8i on Linux Short Installation Guide Oracle9i on Solaris Short Installation Guide Oracle8i on Solaris Oracle
Scripts Akadias
Oracle Survival Guide Useful Unix
Commands in the Oracle Environment Akadias Oracle
Tuning Guide Possible
Client Connections (ODBC, JDBC) Oracle
Migration HowTo Akadias
Sendmail Survival Guide Collection of the new Features Oracle 8i Oracle Frequently Asked Questions Collection of the new Features Oracle 8 DB Applications with Oracle 8i - Perl - DBI
Oracle Access with Apache /
Tomcat
Oracle Access with Apache / JServ
Oracle Servlet Engine OSE for Oracle 9i
Backup and Recovery Cookbook with
Recovery-Methods
Table- and Indexpartitioning with Oracle 8 (many
examples)
Extensive Explanation of the Cost
Based Optimizer
Migration of Oracle 7.3.3 to 7.3.4 using the
Migration Utility
Migration of Oracle 8.1.x to 8.1.7 using
the Migration Utility (x < 7)
Connecting to Oracle 9
using the Microsoft .NET
Framework
Oracle Database Access using .NET Data
Providers
Introduction and Examples to
Oracle Advanced Queueing
Remove
obsolete Datafiles from a Tablespace and Data
Dictionary
Global Statistics vs.
Histograms with DBMS_STATS Package
Named Parameters within
JDBC
The Secrets of Materialized Views (OLAP)
How to implement a multiuser, lockingfree
Primary Key Generator
How to implement Materialized Views and
Dimensions
Diagnostic tools for debugging the RDBMS, one is Event
Tracing
The Secrets
of Dimensions (OLAP)
Treewalking with SQL (Hierarchical
Structures)
Analytic
Functions in Oracle 8i and 9i
Creating XML
Documents with PL/SQL
Parallel Clause and Small
Tables
Using SQL Loader with an UTF8
Characterset Database
Mutating Table Problems
with DELETE CASCADE
Logging deleted Rows on
Cascading Delete without Mutating Table Error
How to specify the WHERE clause for
UPDATE / DELETE ?
Show current and valid NLS
settings
How to measure Index Selectivity, how to
choose Composite Indexes
Troubleshooting Oracle Database Links
Optimizing Oracle's Sort Areas to reduce Disc
I/O
How to verify the Highwater Mark of a
Table ?
Debugging PL/SQL Code with
SQL-Navigator
Using of DECODE instead of IF-THEN-ELSE
How to call an external Procedure from
PL/SQL
Using of Database-Triggers with DML-Retrun
Values
How to code my own Password Verifcation
Rotine with Oracle-8
Date Handling in Oracle, Function of TRUNC
(SYSDATE)
Handling of NULL und empty Strings, Queries with
NOT NULL and ' '
How to check Long-Running-Jobs (PL/SQL
Procedures)
How to setup a Standby DB
for Disaster Recovery System under Oracle8i
How to work with several tables with the same Name
(Private Synonyms)
How to eliminate an Attribut from an Oracle 7 / 8
Table
NLS-Settings on Windows-NT / Unix for
EE8ISO8859P2 Characterset
Switch a Database from WE8ISO8859P1 to the
EE8ISO8859P2
Default NLS Date- and Number Formats (Dynamik
SQL-Script)
Here you find an ISO8859P1 (so called Latin 1)
Characterset Table
How to move a Tablespace File
How to install Designer/2000 Release 1.3 for
Oracle 7 and Oracle 8
How to create a dynamic SQL-Script to create the
Tablespaces
Set an Environment Variable which is found in the
Oracle Data Dictionary
How to generate the Controlfiles,
DB-Documentation, Controlfile-Recovery
Documentation on High-Availability
Concepts
How to report Constraint Errors to an EXCEPTION
table
Full Database Export and Import to Duplicate a
Database
Duplexing Offline Redologfiles with
Oracle-8
Understanding Oracle's Execution
Plan using EXPLAIN PLAN
Read a file word by word using
DBMS_LOB
Non-Interactive Oracle Patch
Installation
Using Oracle's Parallel Execution
Features
Net8 Connect-Time Failover (Overview, Setup,
Example)
Checkpoint Tuning and
Troubleshooting
Net8 Transparent Application Failover (Overview,
Setup, Example)
Dynamically changing
the WHERE clause, without actually changing it!
Send Email with Attachments
from PL/SQL using Java Stored Procedures
Binary Large Objects in Oracle8i SQL
Server 2000 Programming Summary DB Access
using .NET Data Providers Using Assemblies in Microsoft .NET Oracle and SQL-Server 2000 - compared
Materialized Views in SQL
Server 2000
Connecting to SQL Server 2000 from Windows / Unix
using JDBC
Connecting to Oracle 9
using the Microsoft .NET
Framework Many tips to
RedHat Linux 6.0 / 6.1 / 6.2 / 7.0 / 7.1 / 8.0 Many tips to
SUN Solaris 2.6 / 2.7 / 2.8 Unix Tips,
Utilities and Tools Postfix Tips
(Architecture, Configuration, Trobleshooting) Useful Unix
Commands in the Oracle Environment Akadias
Sendmail Survival Guide
Sun Solaris Application
Packaging
Sendmail Tips (Architecture, Configuration,
Trobleshooting)
Simple Shell Script to backup your
Files
How to setup an E-Mail Relay Host with
sendmail
How to configure SAMBA under Linux with RAS
(PPP) on NT4
How to setup automatic mail answering
(vacation program with sendmail)
Configuring Postfix as a Primary or Secondary
Backup MX Host
Intrusion Detection with Tripwire
Webalizer produces easily configurable usage reports in HTML format
Automatically
rotating your Log Files
Wget - non-interactively retrieving files
from the Web
Installing Webmail Horde /
IMP with SSL
Time Synchronization with
NTP
Free Unix Tools like Secure Shell under Windows
(CYGWIN)
Prevent fraudulent use of your Apache proxy
web server
How to setup a Webmail Proxy with SSL /
Apache
Apache's Features to manipulate URL's (Redirect,
Rewrite, Proxy-Server) Tips for Java and
Java Servlet Programming New
Features JDBC 2.0 introduced by SUN Microsystems
Java Exceptions by Example
XML Processing using XERCES Java Parser
Send Email
from Java (JavaMail Package)
Hiding
Recipient List in
the "To:" Line of your Mailtool
How to convert a MS-Word document to a PDF file
?
How to find out which DLL's this Win (NT,9x) executable is
using ?
How to read the Win NT4 Registry from a
Perl Program
How to save / restore the W2K Registry
Help -
cannot start any executable on Windows!
Removing Invalid Entries
in the Add/Remove Programs Tool
Support Printer Drivers for W2K and NT on your
Printer Server
How to start a Windows Program as
NT-Service
Troubleshooting Samba and Windows 2000
with nbtstat, net view, net use
Keeping Time on Windows
How to exchange E-mails between Mail Tools
?
How to use and configure CVS and WinCVS (Concurrent
Version System)
Free Unix Tools like Secure Shell under Windows
(CYGWIN)
Remote Copy with SSH, X11 Forwarding with
SSH
SSH and SCP - How to arrange to log in
without typing a password
SSH2 suite: SFTP and
SCP
Net8 access trough a firewall with port
forwarding using SSH
How to connect Net8 and Java clients using
TCP/SSL
How to connect 2 ... n SSH Tunnels
How to generate an RSA based identity for
SSH
MD5 - message digest (fingerprint, checksum)
Email Security using Public Key
Cryptography
How to setup a Webmail Proxy with SSL /
Apache
Cable Modem Internet Access with dynamic
DNS
Automatic Dynamic DNS
Update
NMAP - protect your important machines from crackers
IP-Routing, classless subnets, calculate
network- and broadcast address
What's a firewall proxy server, how does it
work
Prevent fraudulent use of your Apache proxy
web server
How to verify whether DNS is working correctly
Apache's Features to manipulate URL's (Redirect,
Rewrite, Proxy)
How to setup DNS Forwarding
How to install a CISCO Router /
Firewall
DNS hardening and often seen configuration
errors
How to setup a Bridged Cisco
Router / Firewall