Updated: 19 Jan 2001.
Personal Links
My Oracle7 Oracle Certified Professional
My Oracle8 Oracle Certified Professional
Some of the following website required registered account at http://www.oracle.com/support/
(CSI required) or http://technet.oracle.com/
(anybody can register).
General Internet Websites for Oracle Resources
Oracle Performance
Tuning - General guidelines
Replication Setups
Procedures
Don Burleson Articles
Oracle for Linux - Documentation
Alex
Geldutes - DBAonCall.net - Scripts and Tips for Oracle and Unix
Oracle
Precompilers Online Documentation
Oracle
Technet (Has Oracle documentation for all platforms and versions)
Oracle
Underground Frequently Asked Questions
Performance Tuning - Oracle
Press
Hayden Performance Tuning
Website
Oracle Case Method
Peter
Koletzke's Oracle Stuff
Oracle
Enterprise Manager Oracle Expert User's Guide
Developer/2000
Reports Server
Support Web Center:
Library
Support
Web Center: Library: News and Press Release
JL Comp Home
Page
Free Oracle SQL scripts and DBA tools
/ ORIOLE CORPORATION
Deepak Chebbi's Knowledge
Base
ORACLE User Forum:
RDBMS, SQL & PL/SQL Conference
Oracle FAN
SQLJ -
Oracle Technology Network - Java, Database
Oracle Corporation UK Ltd
| Home
Welcome to Oracle Australasia
Oracle
Opportunities
ORACLE
on NT
Oracle
JDBC Drives - Data Sheet
Tip
& Code
Using
Thin JDBC with Net8
Oracle
JDBC Drives - FAQ
OTN
Sample Code Library - Application-to-DB FrameSet
JDBC
Preface
Oracle Top Articles
Installations White Papers
Multiple
APPL_TOPS with NT and Oracle Applications Release 11 69239.1
How
To Install Application Implementation Wizard (AIW) 69465.1
Converting
Your Oracle Alerts to Oracle Workflow Processes
Near
Term Upgrade/Installation Recommendations
Patching/Patchset
Frequently Asked Questions 62418.1
A
Sample Release 11 Installation 62109.1
Upgrading
To 10.7 Running Apps In Server Partitioning Mode on Vms 60890.1
How
To Change A Shared Applications Module To Fully Installed 52804.1
Oracle
Applications Concepts Release 11 for UNIX (PDF)
FAQs:
Migrating Apps 10.7 from HP-UX 10.20 to HP-UX 11.0
Autoinstall
frequently asked questions 47709.1
Troubleshooting
Unique Constraint Errors During Applications upgrades and Installations.
50602.1
Concsub
utility syntax and explanation of the 'Wait' parameter. 60558.1
Oracle
Applications Near Term Upgrade/Installation Recommendations
Application
10. 7 Server Migration Paths (PDF)
Configuring
Load Balancing Oracle Applications Release 10.7 NCA Windows NT Edition (PDF)
FAQs:
Migrating Apps 10.7 from HP-UX 10.20 to HP-UX 11.0 (PDF)
Oracle
Applications Release 10.7 NCA Network Performance for the Enterprise (PDF)
Oracle
Applications Release 10.7 NCA Migration Strategy (PDF)
Common
Oracle permission problems on Unix
Export/Import
100 Common Questions and Answers
Oracle
Applications for IBM RS/6000 Sizing Guide
Application
Server Partitioning
General
Overview of Rollback Segments
IBM
AIX Tuning Tips (PDF)
Net8 Related Technical Bulletins
GENERAL TOPICS
Two Listeners With Two Oracle7 Databases
On The Same UNIX Server GSX:1005566.6
How To Run Multiple Instances On One Server GSX:1012355.6
Installing SQL*NET For Windows From
A Network Drive GSX:1003483.6
Installing SQL*NET For Windows Onto
A Network Drive GSX:1003520.6
How To Connect To Oracle7 With PowerBuilder GSX:1005104.6
Overview Of SQL*NET V2.X GSX:1018138.6
Connection Hangs Using SQL*NET TCP/IP V2 On Windows GSX:1006813.6
ORACLE_SID VS TWO_TASK On SQL*NET V2 For UNIX GSX:1015197.4
How To Check That SQL*NET V2 Protocol Adapters
Are Linked GSX:1005051.6
Port Number Changes Each Time Listener Is Started GSX:1020519.6
Common SQL*NET Compatability Questions GSX:1005093.6
NET8 Compatability Matrix Note: 46051.1
The BEQUEATH Protocol Adapter Note:16653.1
Load Balancing And Failover Note:50509.1
IPC Explained Note:29232.1
Listener Hanging Intermittently Note:52808.1
ERRORS
ORA-12154 With SQL*NET V2 GSX:1004114.6
ORA-12203 Using SQL*NET V2 GSX:1015259.4
TNS-12545 With SQL*NET V2 GSX:1003489.6
ORA-12203 With SQL*NET V2 On UNIX GSX:1004153.6
ORA-12203 Or ORA-03113 Using Database Links GSX:1003984.6
ORA-12500 GSX:1012134.6
ORA-12500 Connecting Through SQL*NET V2 Listener GSX:1028712.6
ORA-12500 Connecting To Unix Via SQL*NET V2 GSX:1004121.6
ORA-03113 Using SQL*NET V2 GSX:1009295.6
ORA-1034 ORA-7429 GSX:1004646.6
ORA-1034 ORA-7429 Connecting With SQL*NET GSX:1017463.6
TNS-12546 Using SQL*NET IPC On UNIX GSX:1007484.6
TNS-12547 Connecting With SQLNET V2 GSX:1004135.6
TNS-12547 Using SQL*NET TCP/IP V2 GSX:1005622.6
ORA-3121 Connecting With SQLNET V2 GSX:1013392.6
TNS-12560 Using SQL*NET V2 TCP/IP On UNIX GSX:1005782.6
ORA-12203 ORA-12538 ORA-12560 GSX:1030898.6
TNS-12542/TNS-12560/TNS-00512 Starting Listener GSX:1005739.6
TNS-12224/TNS-12541/TNS-12560 Running 'LSNRCTL STAT' GSX:1013420.6
TNS-01169 Stopping Or Getting The Status Of The Listener GSX:1015154.4
TNS-12537 Using SQL*NET V2 On Windows GSX:1006311.6
TNS-12537 TNS-12547 When Starting Listener GSX:1009396.6
ORA-12571 Starting Application Or Connecting With SQL*NET GSX:1034987.6
ORA-12570/ORA-12571 Using SQL*NET V2 GSX:1015430.4
ORA-12505 Connecting Invalid SID Specified GSX:1006411.6
ORA-12505 Connecting Using SQL*NET V2 GSX:1005576.6
Getting An ORA-12223 When Trying To Connect GSX:1014739.6
ORA-12223 Using SQL*NET V2 GSX:1008370.6
MULTI THREADED SERVER (MTS)
How To Configure Multi-Threaded Server(MTS) On A Unix Server Note:61395.1
Multi-Threaded Server (MTS) Configuration And OperationNote:16656.1
O7 Taking Advantage Of Multi-Threaded Server Note:61326.1
RDBMS Configured For Multi Threaded Server
Still getting Dedicated Server GSX:1005997.6
MTS Only Servicing 1 Connection If A
Database Link Is Used GSX:1017409.6
Install Hangs After Creating INIT.ORA GSX:1024690.6
ORAINST Hanging When Choosing MTS GSX:1021186.6
Multi-Threaded Server Diagnostics GSX:1005259.6
FAQ On Multi-Threaded Server Note:47684.1
DEAD CONNECTION DETECTION (DCD)
What Is Dead Connection Detection (DCD) GSX:1013364.6
Common Questions About Dead Connection Detection (DCD) GSX:1018160.6
Dead Connection Detection (DCD) Won't Work GSX:1006809.6
Dead Connection Detection (DCD) Feature Of SQL*NET V2 GSX:1004985.6
NET8
NET8 Troubleshooting Checklist Note:46052.1
NET8 New Features - Quick Reference Note:46049.1
NET8 Socket Usage Note:47927.1
'Unhanded Exception Error In JAVA.EXE' Running
NET8 Assistant GSX:1033929.6
Overview Of NET8'S Connection Manager GSX:1029127.6
NET8 Tracing GSX:1030488.6
Configuring NET8 For External Procedure
Calls In ORACLE8 GSX:1033759.6
JAVA(TM) Runtime Environment For NET8 GSX:1034764.6
NET8 Hostname Naming Adapter Note:47369.1
NET8 Compatibility Matrix Note: 46051.1
CONFIGURATION AND EXAMPLE FILES
Overview Of Configuration Steps For SQL*NET V2 GSX:1017459.6
Overview Of Network Manager GSX:1006314.6
An Overview Of Network Manager V3.0 GSX:1019137.6
How To Save To Database Using Network Manager GSX:1007487.6
What Is SQL*NET Easy Config? How Does It Work? GSX:1016832.6
Example Of SQLNET.ORA File GSX:1006437.6
TNSNAMES.ORA File For TCP/IP GSX:1036070.6
TNSNAMES.ORA File For SPX GSX:1006432.6
LISTENER.ORA File Example On NETWARE GSX:1010145.6
LISTENER.ORA File On UNIX GSX:1004902.6
LISTENER.ORA Example File For WINDOWS NT GSX:1009383.6
SQL*NET V2 Configuration On UNIX GSX:1004052.6
SQL*NET V2 Configuration Hints GSX:1006505.6
Location Of SQL*NET V2 Configuration Files GSX:1017723.6
Automatic Startup And Shutdown Of SQL*NET Listeners Note:16123.1
ORACLE NAMES SERVER
Overview Of Oracle8's Oracle Names V8 GSX:1030422.6
CONFIGURING ORACLE NAMES V8 without EDO Note:60535.1
CONFIGURING ORACLE NAMES V8 with EDO Note:60660.1
Overview Of Oracle Names V2 GSX:1014922.4
Configuring V2 DDO Names Server Note:45596.1
Steps For Configuring Oracle Names V2
Using Network Manager V3 GSX:1015590.4
Configuration Of Oracle Names V2
With Dynamic Discovery GSX:1024682.6
NNO Errors Starting Up Names Server GSX:1007943.6
Overview Of NET8 Hostname Adapter GSX:1033658.6
MULTI-PROTOCOL INTERCHANGE (MPI)
When Is The Multi-Protocol Interchange (MPI) Needed GSX:1009147.6
ORA-12699 Using MPI To Connect To Server GSX:1013241.6
ORA-12203 Using MPI (Multi Protocol Interchange) GSX:1011861.6
MOBILE AGENTS
What Is Oracle Mobile Agents GSX:1031720.6
Oracle Mobile Agents
- Technical Questions And Answers GSX:1006424.6
What Addresses Are Used To Initialize Agents GSX:1007411.6
TRACE AND PERFORMANCE TUNING
NET8 Tracing GSX:1030488.6
SQL*NET V2 Tracing GSX:1011114.6
SQL*NET V2 Tracing For Desktop And UNIX GSX:1009384.6
Turning On Tracing For Multi Threaded Server(MTS) GSX:1015176.4
Tuning SQL*NET For Better Performance GSX:1005123.6
How can SQL*NET V2 Performance Be Improved GSX:1018693.6
Oracle Technical Support Bulletins
ORACLE8 CONCEPTS
Application
Failover CR 181872
Application
Server Partitioning and Partition CR 181877
Basics
of the Object Option CR 181874
Checkpoint
Algorithm CR 181870
Cost
Based Optimizer ("CBO") Enhancements CR 181871
NET8
CR 181875
New
Rowid Format CR 181880
Oracle8
introduces a new multiple buffer pool CR 181869
Parallel
DML (Insert, Update, Delete) CR 181878
Partitioning
CR 181876
Reverse
Key Indexes CR 181879
Useful
Alter Commands in Oracle8 CR 181868
ADMINISTRATION
How
To Make A Copy Of A Database On The Same Unix Machine Note
18070.1
Copying
an Oracle7 database on OpenVMS Note 30349.1
Causes
And Solutions To Ora-1555 "Snapshot Too Old" Note
40689.1
LKdbname
- The MOUNT Lock File Note 50594.1
SQL
DIAG- Determining Dependency Information (Oracle7) Note
30485.1
SQL
DBA - Manually Coalescing Free Space Note
31116.1
Foreign
Keys - Table & Index Dependencies Note
39392.1
Retrieving
Data from the Database Note 39383.1
Delete_commit
Procedure Note 37777.1
Capturing
Index_Stat Information Note 35492.1
Diagnosing
Database Hanging Issues Note 61552.1
Read-Only
Tablespaces Note 33402.1
Recreating
Database Objects Note 30910.1
Rollback
Segment Needs Recovery Note 28812.1
Truncate
Command in 7.1 Note 28722.1
Corruption:
DBVERIFY
- Database file Verification Utility (7.3.2 onwards) Note
35512.1
ORA-1578
and Data Block Corruption Note 28814.1
ORA-1578
Checklist Note 61624.1
Handling
Data Block Corruption (ORA-1578) in Oracle 7 Note
34371.1
Locking:
TX
Transaction locks - Example wait scenarios Note
62354.1
What
to do with "ORA-60 Deadlock Detected" Errors Note
62365.1
ORA-1575
Timeout waiting for Space Management Enqueue Note
33567.1
Example
Table Locks During Referential Integrity Enforcement Note
38373.1
(V7)
Referential Integrity And Locking Note 33453.1
Memory:
Fundamentals
of the Large Pool Note 62140.1
Internal
Latch Contention Note 22908.1
Shared
Pool Calculation Note 61340.1
Security:
Identifying
PC Clients in V$SESSION Note 39333.1
DBA
(Connect Internal) Privilege on Oracle7 Note 18089.1
SYSDBA
and SYSOPER Privileges in Oracle8 and Oracle7 Note
50507.1
Role
Restrictions Note 11740.1
BACKUP/RECOVERY
Archiving:
Archiver
Best Practices Note 45042.1
Recovery:
QREF
Hot backups from OS MIRRORS Note 47422.1
Recovering
a Dropped Table from a Full Database Backup Note
15475.1
Incomplete
Media Recovery On Parallel Server Note 16575.1
How
To Recover A Database Having Added A Datafile Since The Last Backup Note
29430.1
Recovering
A Dropped Table From A Full Database Backup Note
61330.1
Standby:
Switchover
Between Primary and Standby Databases Note 39673.1
Hot
Standby DB info in 7.3 Note 33236.1
Standby
Database Prior to 7.3 Note 31406.1
Recovery Manager (RMAN):
Parallelizing
Backups using Legato Storage Manager & Recovery Manager Note
Note 60952.1
Testing
Legato Storage Manager and Recovery Manager without a tape device Note
60967.1
Getting
started with Server-Managed Recovery (SMR) and RMAN Note
50875.1
Parallel
Features with Server-Managed Recovery (SMR) and Recovery Manager(RMAN)
Note 52576.1
RMAN:
Restore and Recovery of a NOARCHIVELOG database Note
61801.1
Enterprise Backup Utility (EBU):
Migrating
to Recovery Manager from EBU Note 47423.1
DISTRIBUTED/REPLICATION
Replication:
Creating
a Replication Environment in Oracle 8.0.X Note
62398.1
7.3
Synchronous Data Propagation Example Note 43029.1
SQL
Sample script to setup repadmin user DBA synonyms Note
43001.1
Printing
Deftran/Defcall/Deferror Entries In A Replicated Environment GSX
1022011.6
Interoperability
between the Replication Releases V7 and V8 Note
60927.1
Print
Out Arguments of Errored Transactions in 7.3.x Note
62088.1
Upgrading
Replication Databases from v7.3.x to v7.3.x Note
50573.1
Diagnosis
of Replication Setup Problems Note 33515.1
Top
Issues For Symmetric Replication Note 47813.1
7.3
DBMS_RECTIFIER_DIFF Package Example Note 43033.1
Conflict
Resolution Example - Minimum Value Note 43024.1
Conflict
Resolution Example - Latest Timestamp Note 43010.1
Procedural
Replication Setup Example Note 43009.1
Snapshots:
Top
Issues For Read-Only Snapshots Note 47811.1
Frequently
Asked Questions For Read-Only Snapshots Note 47810.1
NLS
Code
Pages For We8iso8859p9 Character Set Note 16559.1
Nlsrtl
2.3 Supported Character Sets Note 16128.1
How
Computers Process Different Languages Note 15383.1
Export/Import
And NLS Considerations Note 15095.1
Code
Pages For We8iso8859p1 Character Set Note 14786.1
NLS_Lang/Cde
Production 3 For Ms-Windows Note 14325.1
Oracle
And Unicode Q&A Note 14079.1
NLS
Sort Characteristics CR 88679
NLS
Language Dependent Features CR 88678
NLS
Port Specific Supported Character Sets Note 13971.1
NLS
Supported Languages And Territories Note 13881.1
Linguistic
Sorting Of Data In Oracle7 Note 13882.1
NLS
Supported Message Files Oracle7 Note 13883.1
Dump
Sql Command For NLS Debugging Note 13854.1
NLS
7-Bit/8-Bit Conversion Note 13855.1
NLS
On Dos Vs.Windows Note 13853.1
National
Language Support CR 58762
OTHERS
Context:
Oracle
ConText Option Note 43474.1
Migration:
Upgrading
to Oracle 7.3 - Important things to check Note
61975.1
Oracle
8.X -> 8.X Upgrade scripts to run Note 62291.1
Oracle
7.X -> 7.X Upgrade scripts to run Note 33318.1
Checklist
for Migrating from Oracle7 to Oracle8 on UNIX Note
47290.1
Parameters:
PARAMETER
INIT.ORA DB_DOMAIN () Note 30710.1
PARAMETER
INIT.ORA LOG_ARCHIVE_DEST () Note 30748.1
Misc:
Locating
Resursive Sessions Note 62003.1
Caching
Oracle Sequences Note 62002.1
ORA-1647
in Oracle 7.x Note 61995.1
Oracle
Mutating Table Problem CR 104200
Partitions:
Introduction
to Partition Views in Oracle 7.3 () Note 33593.1
Partition
views in 7.3 Note 43194.1
Partition
Views and the use of indexes (7.1 & 7.2) Note
28426.1
PERFORMANCE/TUNING
Performance:
Library
Cache And Shared Pool Tuning Note 61623.1
Systemwide
Tuning using UTLESTAT Reports in Oracle7/8 Note
62161.1
Main
issues affecting the Shared Pool on Oracle 7 and 8 Note
62143.1
Issues
affecting the Buffer Cache and DBWR in Oracle7/8 Note
62172.1
Introduction
to Tuning Oracle7 / Oracle8 Note 61998.1
Sql Tuning:
Interpreting Explain plan Note 46234.1
Hints
and Subqueries Note 62364.1
Using Use_Concat Hint To Override A Full Table Scan With In/Or Statements Note
17214.1
Setting
SQL Trace in the Oracle Tools Note 15160.1
Interpreting
Raw SQL_TRACE and DBMS_SUPPORT.START_TRACE output () Note
39817.1
Determining
the execution plan for a distributed query Note
33838.1
SQL
DIAG - Select to show Optimizer Statistics for CBO Note
31412.1
SQL
Tuning FAQ Note 47736.1
Cost
Based Optimizer - Common Misconceptions and Problems Note
35934.1
Index
Space usage Note 33343.1
SQL
Tuning TOP 20 Issues Note 47742.1
Automatic
Explain Plan Note 39341.1
SERVER TOOLS
Exp/Import:
ORA-904
when exporting a 7.3.3 database Note 62322.1
Export/Import
And Nls Considerations Note 15656.1
V7.
Exporting Procedures, Packages and Triggers Note
17839.1
QREF
Export/Import/SQL*Load large files in Unix - Quick Reference Note
30528.1
Exporting/Importing
From Multiple Tapes Note 2035.1
Exporting
to tape on unix system Note 30428.1
Unix
Script: IMPSHOW2SQL - Extracting SQL from an EXPORT file Note
29765.1
SqlLoader:
NT/95
Loading Binary Files With Sql*Loader Note 61713.1
NT/95
Loading Text Files With Sql*Loader Note 61714.1
SQL*Loader
FAQ Note 48718.1
Server Manager:
Server
Manager --- TOP 20 Issues Note 47842.1
STORAGE
2Gb
or Not 2Gb - File limits in Oracle Note 62427.1
SQL
DIAG- Who owns TEMP Segments in V7 Note 40758.1
How
Oracle Allocates Extents when altering PCTINCREASE Note
15251.1
ALERT
Using UNLIMITED Extent Format Note 50380.1
ALERT
Failed Operations may leave TEMPORARY Segments Note
38388.1
Removing
`stray` TEMPORARY Segments Note 35513.1
If you have comments or suggestions, email me at magpeter@yahoo.com