Ships from: Nashua, NH
Usually ships in 1-2 business days
Ships from: fallbrook, CA
Usually ships in 1-2 business days
This book provides a powerful set of tools for Oracle database administrators and developers. During their many years of administering, tuning, and troubleshooting Oracle databases, the authors have developed hundreds of useful scripts. Now you can instantly take advantage of their experience by putting these scripts to work at your own site. DBAs and developers are constantly reinventing the wheel. Most Oracle sites have similar requirements, problems, and crises, and at most of these sites DBAs and developers find themselves reinventing the wheel by writing the same kinds of scripts — and too often they're writing them under pressure, in hit-or-miss and error-prone fashion.The scripts in this book are tried-and-true. They've been thoroughly tested in many different environments. You can use them right now to simplify the tasks you perform each day — monitoring databases for reliability, protecting your database against data loss, improving performance, increasing security, and building reports that provide insight into the inner workings of Oracle databases. You can also turn to these scripts in emergencies to diagnose system problems and repair databases when the pressure is on.The book includes:
Database administrators everywhere are faced with the ongoing job of monitoring Oracle databases for continuous reliability, performance, and security. This book provides a central source of previously created, tested, and documented scripts for performing these monitoring tasks. The Windows CD-ROM contains all of the scripts discussed in the book.
Directory: $DBA
File Type: SQL Script
Edit Required: No
Output File: grall_tmp.sql, grall.sql
This script creates and then executes a script to grant the specified username (such as OPS$ORACLE) all privileges to all nonsystern objects in a database.
grantool
Directory: $DBA
File Type: Shell Script
Edit Required: No
Output File: Screen
This script grants SELECT access on required tables to a specific user, for use in running the $TOOLS/dbousers, $TOOLS/dbo_sql, and $TOOLS/locks utilities.
Note that if this procedure has a privilege violation when trying to grant access to the V$ tables, you must first run the grantsys.sql script, which will grant SELECT WITH GRANT OPTION to yourself, and then rerun the grantool script.
The script will prompt for the Oracle SID of the database to be accessed, and the username to be granted SELECT access to the required tables.
grantool.sql
Directory: $DBA
File Type: SQL Script
Edit Required: No
Output File: Screen
This script is called by the grantool script to perform the actual grants, as described in the previous section.
grantsys.sql
Directory: $DBA
File Type: SQL Script
Edit Required: No
Output File: Screen
This script grants to the current user account the privileges required to grant other users access to the $TOOLS/dbo and locksutilities (via the grantools script).
You will use this script when your account (typically, OPS$oracle) does not have the SELECT privilege WITH GRANT OPTION on the required V$ tables. The script will prompt you for the SYS account password.
makeops
Directory: $DBA
File Type: Shell Script
Edit Required: No
Output File: Screen
Syntax: makeops sid newuser
sid
The Oracle SID of the database to be accessed.
The new User ID (less the "OPS$" prefix) to be created.
This script creates a new OPS$ username account for a given user, matching the configuration and privileges of the user's current non-OPS$ account. This allows the DBA to quickly create an OPS$ account for a given user which is otherwise identical to the user's existing account without having to determine and duplicate existing privileges. If an OPS$username account exists, the user can then easily log into the database without having to specify a username or password. Here is an example for SQL*Plus:
sqlplus /
The account is created with an "impossible" password, so that it can only be accessed from the server, and even then only by the sqlplus "/" clause.
Restrictions
$DBA/makeqps.sql
$DBA/copyusis.sql
$TOOLS/define
$T0OLS/fixcase
$DBA/valid_db
III. Scripts for Developers and Designers
8. Database-Design/DDL Utilities
9. Database Developer Utilities
IV. UNIX Utility Scripts
10. General System Utilities
11. Directory and File Management Utilities
12. Memory Usage Reports
V. Appendixes
A. SQL Scripts That Create Oracle Tables
B. Tables Created by SQL Scripts
C. SQL Scripts That Create Output Files
D. Output Files Created by SQL Scripts
Index
Overview
This book provides a powerful set of tools for Oracle database administrators and developers. During their many years of administering, tuning, and troubleshooting Oracle databases, the authors have developed hundreds of useful scripts. Now you can instantly take advantage of their experience by putting these scripts to work at your own site. DBAs and developers are constantly reinventing the wheel. Most Oracle sites have similar requirements, problems, and crises, and at most of these sites DBAs and developers ...