Oracle Database HOWTO

Paul Haigh, paul@nailed.demon.co.uk

1. Introduction

• 1.1 Version History
• 1.2 Copyright
• 1.3 Disclaimer
• 1.4 Aim of the HOWTO
• 1.5 Requirements
• 1.6 News From Oracle Corporation

2. Installing the Oracle Software

• 2.1 Server Preparation
• 2.2 Installing from CDROM
• 2.3 Post Installation Tasks

3. Creating a Database

• 3.1 Create the Initialisation File
• 3.2 Creating the Database Install Script
• 3.3 Running the Database Installation Script
• 3.4 Starting the Database
• 3.5 Stopping the Database
• 3.6 Create a Default User

4. Configuring SQL*Net on the Server

• 4.1 tnsnames.ora
• 4.2 listener.ora
• 4.3 sqlnet.ora
• 4.4 Starting and Stopping the Listeners

5. Client Configuration

• 5.1 Windows Clients
• 5.2 Unix Clients

6. Automatic Startup and Shutdown

• 6.1 dbstart & dbstop
• 6.2 init.d & rc.d

7. Other Bits

• 7.1 Intelligent Agent

8. Troubleshooting

• 8.1 I cannot create a database when using Oracle 7.2.x.
• 8.2 I'm getting segmentation faults in svrmgrl under version 7.3.4.x.

9. Credits