Customer Reviews

Unix for Oracle Dbas Pocket Reference

5 star:		(6)
4 star:		(5)
3 star:		(3)
2 star:		(0)
1 star:		(1)

 

 

I found this book useful to write UNIX scripts for Oracle DBA tasks, specially performance tuning. The entire book is filled of 'tricks' (like how to kill a oracle user-process in unix,etc) some of them not very useful. I expect to find some more practical examples on backup (unix-generic oracle backup scripts), oracle architecture on unix, net8, oracle installation, utilities like export (I mean, why don't show an example of how to use UNIX pipe when you make an export file greater than 2gb?), etc. Also, it lacks of explanation about UNIX admin commands critical for any Oracle DBA who in almost one situation has to be the UNIX system administrator, like booting, file system administration, etc. I mean some generic examples could be enough. Needs to be improved.

This book is great for understanding how to write UNIX scripts for managing Oracle in UNIX. Many of the scripts are easy to run, and there are excellent examples to show how to write customized UNIX sctipts. This book really simplifies UNIX and concentrates on the UNIX that I need to know as the DBA. It is easy to read and a very useful reference book.

I was very impressed with this book. I am always forgetting UNIX command syntax, and this book helped me to remember the commands that I need. It also has lot's of great tips, and techniques for managing Oracle. Overall, this is one of my most-used Oracle books! Highly recommended.

This book is loaded with the information needed by the DBA in the UNIX environment. There are many scripts with description of the commands and what they are doing. I like the way commands, used on other UNIX platforms (Solaris, AIX, HP-UX, etc), are included. I am delighted this book provided commands that are new to me, and provide critical information that was previously unavailable.

This is a book that should be in the pocket of all Oracle dbas
beginners in unix, and specially those fighting with several
flavors of unix.
If you are an experienced oracle dba working with Windows NT
or Open VMS and new in unix, these book can help you.
It's reading is easy ē, since the book contains the basics that an oracle dba need to know in order to begin working with unix as soon as possible.

Not so good for those using Solaris as many Solaris
server monitoring, management and logs commands
are missing. This is surprising since after putting
in so much effort, it would have been trivial to find
out the corresponding commands in Solaris.

Originally being an NT oracle dba, this book time and again gives just what I need know for the Unix environment. After using the book for a year, now (it just saved me again), I just want others to know this book is worth it.

Concise. You can learn how to tuning not only Oracle side also on Unix side. Some useful command and scripts you can customize to fit your environment! But you must know unix command and shell script before you read this book.

It is organised for various Unix platforms, it provides some useful and essential commands for developers to conduct ad-hoc administrative or investigation works.Also, there is another pocket book named "Oracle DBA Checklists", it introduces some essential steps for trouble shooting and achieving a specific task like recovering from loss of control files.

This is a very helpful book which provides a basic overview of using Unix running Oracle. Perhaps the best feature of this book is that the author has spent lot of time providing only the most useful and salient Unix scripts for the Oracle DBA. You will not find any unnecessary or redundant information in this book. In fact, I highly recommend all Oracle DBAs to read this book and memorize all its ideas.

Here are some of the best tips:
1)Script to kill all Oracle processes.
2)Place a SQL * Plus script in a Unix Shell Wrapper
3)Ensure that only the Oracle user can run a Unix shell script
4)Execute a SQL*Plus Script on all the instances in the enterprise.
5)Automatically delete old trace and audit files
6)Copy TNSnames.ora to all the Unix servers in the enterprise
7)Detect when Oracle is not accepting connections and send alert