The Sysadmin's Guide to Oracle

Short Topics in System Administration The Sysadmin’s Guide to Oracle Ben Rockwood Published by the USENIX Association 2005 Rik Farrow, Series Editor 13 © Copyright 2005 by the USENIX Association. All rights reserved. ISBN 1-931971-41-2 To purchase additional copies and for membership information, contact: The USENIX Association 2560 Ninth Street, Suite 215 Berkeley, CA USA 94710 orders@usenix.org http://www.usenix.org/ First Printing 2005 USENIX is a registered trademark of the USENIX Association. USENIX acknowledges all trademarks herein. This booklet is dedicated to

the memory of my hero, Bob Larson, who gave more to the UNIX community than most will ever know. Contents Introduction 1 1. Installation and the OFA 3 UNIX Users and Groups 3 Environmental Variables 3 File Locations 4 Memory Parameters 4 Troubleshooting Logs 5 Steps for Installation 5 2. Oracle Basics 7 Create a Database 7 Connect to and Start the Database 9 Create a Table 9 Add Data to the Table 10 Create an Index 10 Query the Table 10 Create and Query a View 10 Destroy Objects 11 Stop the Database 11 Destroy the Database 11 3. Poking Around Inside Oracle 12 The Data Dictionary 13 Essential System Tables 14 The Dollar Views 15 4. Files and Components 16 Database Files 16 Initialization Parameters 17 Oracle Startup 18 Oracle Distribution Files 21 5. Users and Permissions 22 Users and Passwords 22 Adding New Users 23 Privileges, Roles, and Profiles 24 Changing Passwords 26 6. The Listener 27 Configuring the Listener 27 Starting the Listener 28 TNS Resolution 29 Connecting Remotely 30 Troubleshooting TNS 31 7. Oracle Programming 32 SQL 32 PL/SQL 33 Pro*C: The Oracle SQL Precompiler 34 The C Interface: OCI 35 Regarding Perl 36 8....

Website: www.sage.org | Filesize: 84kb
No of Page(s): 6
Download The Sysadmin's Guide to Oracle.pdf