|
| | All errors and updates are listed below.
Please note we only list changes that were published after the "FIRST
PUBLIC RELEASE", which was build 011. Corporate customers with site
licenses might have different editions of the book with chapters not available
to other customers. The reason for this is explained on my web site.
Build 036: 2008-11-09
 | Chapter 12 - described the Health Check Monitoring File. |
| Chapter 38 - added section "Miscellaneous OEM Agent Commands".
This stuff was already in the book, but very hard to find. Also, see the new
Chapter 43. |
| Chapter 41 - all the stuff related to Oracle Text was organized into this
new chapter. |
| Chapter 43 - all of the miscellaneous utility commands like emctl, srvctl,
and crsctl were consolidated into this one chapter. If I didn't know
where else to put it, then it went into Chapter 43. |
| The following sentences were corrected:
OLD: at the instance level. You can activate a different resource plans on each instance.
NEW: at the instance level, and you can activate a different resource plan on each instance.
OLD: Suppose you have three databases named ALPHA and BETA ...
NEW: Suppose you have two databases named ALPHA and BETA ...
OLD: If level 1 does not any resources at all ...
NEW: If level 1 does not use any resources at all ...
OLD: suppose you want all instance except MARK4 ...
NEW: suppose you want all instances except MARK4 ...
OLD: Repeated the above steps to create all of your additional groups.
NEW: Repeat the above steps to create all of your additional groups.
OLD: To activate plan go to the Resource Plans page ...
NEW: To activate a plan go to the Resource Plans page ... |
Build 035: 2008-06-27
| Added notes regarding starting the database read-only. |
| Added notes regarding DBA daily tasks. |
| Added notes regarding init.ora parameter CONTROL_FILES. |
| Added notes regarding init.ora parameters PARALLEL*. |
| RMAN: added notes regarding incomplete recovery. |
| RMAN: documented restoring corrupted blocks using the BLOCKRECOVER
command. |
| RMAN: documented hiding credential within command files. |
| ASM: added the GMON background process. |
| ASM: added the hidden init.ora parameters _asm_ausize
and _asm_stripesize. |
| ASM: added a section on Oracle 11g New Features. |
| Added section "Library Cache Purge". |
| Added section "Library Cache Threshold Warning". |
| Removed the sentence "Hmmm, [this Oracle feature] seems a bit buggy" by request. |
| Added notes about SQL Server 2008 New Features, and a price comparison
between SQL Server 2008 and Oracle 11g. |
| Consolidated notes on gathering optimizer statistics against partitioned
objects into one new section. |
| In chapter 20 added notes on sample schemas BI, HR, IX, OC, OE, PM, and SH. |
| In chapter 35 the section "Parameters" was moved out of the
discussion of Import and then updated to note which parameters are used with
Export, Import, or both. |
Build 034: 2008-03-02
| Spell check. It is amazing how many of the past updates contained
misspelled words that were not caught by Microsoft Word's automatic spell check
utility. |
| Chapter 12 (Database Files) - added notes on creating and dropping redo
log groups and members. |
| Chapter 14 (ASM) - more examples, and improved documentation of the ASMCMD
which is only available in 10.2 and higher. |
| Chapter 17 (Solari) - in the CRONTAB section documented logging behavior. |
| Chapter 18 - documented OPTIMIZER_INDEX_CACHING, OPTIMIZER_INDEX_COST_ADJ,
DB_KEEP_CACHE_SIZE, and DB_RECYCLE_CACHE_SIZE. The cache parameters
were described elsewhere in the book, but not extensively and not in the
"right" place according to customers. |
| Chapter 24 - updated description of oratab's "W". |
| Chapter 30 - updated the descriptions of "pre-defined roles". |
| Chapter 34 - added several examples of using the ALTER TABLESPACE and DROP
TABLESPACE commands. |
| Chapter 36 (Partitioning) - reorganized the whole chapter. |
| Chapter 37 (RMAN) - added more examples. |
Build 033 - INTERNAL USE ONLY
Build 032 - 2007-11-10
| In Chapter 3 the terminal release numbers and patchset numbers were
updated. |
| In Chapter 3 the description of Oracle 11g was updated. |
| In Chapter 7 added overviews of Oracle Streams and Oracle Data Guard to
the section "Description of Core Features and Options". |
| In Chapter 15 were it stated "Oracle does not support SSL to the database when using a JDBC Thin driver",
this is only true for Oracle 10.1 and earlier. A new feature of
Oracle 10.2 is support for SSL connections over JDBC Thin driver. Good luck
meeting all pre-requisites and setting it up correctly. |
| In Chapter 17 "Solaris" the operating system requirements were
updated, and we documented the process of listing and adjusting the maximum
number of processes on Solaris. |
| In chapter 18 "init params" we added notes and tips to the
following parameters: COMPATIBLE, SGA_MAX_SIZE, and SGA_TARGET. The
description of LOG_BUFFER in Oracle 10.2 was clarified. |
| In Chapter 29 "Flashback" added descriptions of all standard
directories found in the FRA. Actually these are notes pulled together
from various other parts of the book, but now it is a lot easier to get the
info. |
| Corrections to discussion of schemas WK_TEST and WKSYS. |
| Corrections in the chapter on Migration pertaining to Oracle Streams. |
| Clarifications in the discussions of private and public database links. |
| The discussion of sequences was updated to include CURRVAL. Frankly,
I didn't think anyone bothered to use CURRVAL so I did not document it
before. |
| The section on GATHER_TABLE_STATS was updated with more examples. |
| The section on GATHER_INDEX_STATS was formatted as Heading 4 but it should
have been Heading 3. This was corrected. |
Build 031 - 2007-07-17
| The chapter title pages were corrupted during printing for chapters 3, 11,
and 17. All title pages were fixed in Build 031. No other changes or
additions were made to the book. |
Build 030 - 2007-07-01
| In chapter 2 the examples for creating database links contained hidden
characters that prevented you from copy/pasting them into SQL*Plus.
This has been fixed. |
| In chapter 11 documented the Oracle background processes PSPn and FMON,
and the Oracle-supplied background process FMPUTL. Also provided a
table that illustrates when each of the most common background processes are
spawned during the startup process; this information was consolidated from
other chapters. |
| In chapter 16 "Windows Issues" update the chapter on Windows Issues with new 64-bit compatibility
information, the latest information about Windows Vista, and updated
information about memory management. |
| In chapter 16 "Windows Issues" all information about Windows
Server 2003 was re-organized into its own section. The latest
information from Microsoft and Oracle was incorporated into the book. |
| In chapter 24 "Database Startup" documented the STARTUP
EXCLUSIVE command. This had been loosely discussed in the chapter on
RAC. |
| In chapter 26 "The Recycle Bin" updated the section "Clearing the Recycle Bin". |
| In chapter 30 the description of the DBA and RESOURCE roles did not
mention the fact that granting these roles to a user implicitly granted the
UNLIMITED TABLESPACE system privilege. Now it does. |
| In chapter 33 "SQL*Plus" added the section "Connecting to a
Database with SSL". |
| In chapter 33 "SQL*Plus" added the section "Accepting User
Input". |
| In chapter 33 "SQL*Plus" added the section "Changing Your
Password". |
| A bunch of editorial corrections (spelling, grammar, etc.) |
Build 029 - 2007-04-20
| The PDF file's properties says Build 026. Please update to correct
build number. |
| In the section "Flashback Database Log Files" added a quick
formula for estimating storage space requirements. The only formula
provided by Oracle requires that you already be using Flashback Database for
a while, and let Oracle calculate running averages. My new formula
assumes you are not yet using Flashback Database and therefore cannot use
Oracle's formula. |
| In chapter 6 (New Features) documented the DML Error Logging feature,
which is new in 10.2. |
| In chapter 6 (New Features) documented the SQL*Plus Proxy User Login
feature, which is new in 10.2. |
| In chapter 6 (New Features) added examples for Oracle Net Easy Connect. |
| In chapter 16 (Windows Issues) added section "File System
Limitations" to document maximum volume and file sizes on FAT, FAT32,
and NTFS. |
| In chapter 16 (Windows Issues) updated the certification status for Microsoft Windows Vista. |
| In chapter 18 (init params) the discussion of init.ora parameter LOG_BUFFER was split into two
sections for 10.1 and 10.2, because starting in 10.2 Oracle auto-sets the
parameter. |
| In chapter 18 (init params) added description of view V$PARAMETER_VALID_VALUES, which is
new in 10.2. |
| Page 599 change "Solaris SPART" to "Solaris SPARC". |
| In chapter 31 (Auditing) added clarifications. |
| In chapter 34 (SQL) added level 5 section to discuss IN versus EXISTS. |
| In chapter 38 (RAC) added examples of Oracle Net files. By
customer request these examples were copied from the chapter on Oracle Net
and then clarified for RAC. Also added sample init.ora parameters that
relate to the Oracle Net config files, and described their
inter-relationships. |
| Chapter 38 - updated information on maximum file sizes when using Veritas
File System (VxFS). |
Build 028 - 2007-03-26
| Documented ORA-600 [kzasqlbindlob1],[22923]. |
| Chapter on Oracle DataPump was enhanced to include notes about DataPump's
inability to export audit trail data (or any other data from dictionary
schemas), and an example of how to initiate exports from within PL/SQL
blocks. Also elaborated on the Master Control Table. |
| Documented a change in the AUD$ table: column TIMESTAMP# has been
obsoleted and is no longer populated, so you should be using the new column
NTIMESTAMP#. |
| Added a "tip" to the section on using RMAN Tags to restore
specific backups. |
| The discussion of RMAN tags in chapter 37 was modified to be more
explanatory. |
| Updated section on TimesTen to make a note about version 7 released in Feb
2007. |
| Corrected typos in the example of using COUNT, MIN, and MAX on page 1007. |
| Expanded on the Oracle Scheduler section named "Jobs".
Added information concerning external jobs, as well as provided numerous
examples of listing jobs, creating, updating, disabling, and deleting jobs. |
| In the section on Oracle Express Edition added a URL for more information. |
Build 027 - 2007-03-10
| An example was added to the RMAN chapter for backing up using tags, and
restoring from a particular backup by specifying the tag in the restore
command. |
| Chapter 33 (SQL*Plus) was updated to have a discussion of hiding your
username and password from prying eyes. This was added as new section
"Hiding Your Identity". |
| Pages 132 and 133 on PostgreSQL were updated. |
| The description of the Sun T2000 was enhanced. |
| The certification matrix for Oracle RAC on Vertias SF/RAC was updated. |
| In the chapter about ASM a note was made about Symantec offerig a free
"Basic Edition" of Veritas Storage Foundation for Windows, Linux,
Solaris, and AIX customers. This freeware does not support RAC or
provide Oracle-specific support. |
Build 026 - 2007-02-21
| Documented Windows Vista in terms of Oracle 10g certification and maximum
RAM and CPU support. |
| Documented the TSMSYS schema. |
| Added ORA-12640 to chapter on error codes, to talk about a bug that Oracle
introduced in patchset 10.2.0.2. |
| Added note about port 1158 being the first Database Control port number
used in Oracle 10.2, whereas 5500 was the first port used by Database
Control in 10.1. |
| Chapter 2 received numerous changes, updates, and additions to its discussion of database
objects. For example, all discussions of
Index-Organized Tables (IOT) were consolidated into one new section, and greatly
expanded upon. Also, additional information was added to the
discussions of tables, indexes, constraints, and views. |
| Chapter 2 was also updated as all
information about External Tables (scattered throughout the book) was
consolidated into one easy to read section. |
| In the chapter on DataPump, the examples at the end of the chapter were
clarified and expanded upon. Also, added notes about taking consistent
exports in DataPump, and added notes about the fact that tablespaces do not
get imported from full exports when using schema-level imports, causing many
imports to fail. |
| In the chapter on Upgrades and Migrations, updated the discussion of RMAN
commands DUPLICATE and CONVERT. |
| In the RMAN chapter: fixed typos in the "connection" examples. One of them had
"connect / connect", for example. Also, updated the discussions of backing up the FRA and
freeing-up space in the FRA. |
| In the chapter on RMAN: clarified the process of backing up in
NOARCHIVELOG mode; clarified the process of backing up databases when files
expected by RMAN are not present and would normally cause RMAN to fail
(i.e., discussed the SKIP INACCESSIBLE clause); and significantly clarified
the discussion of backing up archived redo logs. |
| Page 1097, the command CONFIGURE RETENTION POLICY TO RECOVERY WINDOW 1
DAYS was missing the word OF. It should say "WINDOW OF 1
DAYS". |
Build 025 - 2007-01-01
| The 10.2 command "emca -config dbcontrol db" was missing "-repos
create". |
| The discussion of the 10.2 "emca" command were updated to
include a note about Oracle not accepting the password for DBSNMP or SYSMAN,
for no apparent reason. The solution is to enclose the password in
quotes. |
| Typos in description of parameter REMOTE_LOGIN_PASSWORDFILE. |
| Typos in description of Solaris 10 projects. |
| The example on page 1014 said "dev" was the local (target)
database. It should read local (source) database. |
| In the description of Advanced Replication (AR) is was noted that despite
many hints from Oracle that Streams is replacing AR, there is still no end
date for AR. In fact, AR still exists in Oracle 11x. |
| The chapter on RMAN makes more clear how to configure OEM Database Control
to work with your RMAN recovery catalog and target databases. |
| The chapter on DataPump makes more clear how to use the NETWORK_LINK
parameter. |
| Cross-references (hyperlinks) were added on the first page of each
chapter. These links go to the top-level
sections in the chapter. However, these links are only useful in .DOC
files, not PDF files. This is due to
technical limitations of our PDF generation software, PdfFactory Pro. |
Build 024 - 2006-12-04
| Updated several sections where Oracle Managed Files and/or the Flash
Recovery Area are discussed to be more clear. Edits were made on pages
354, 361, 367, and 397. |
| In the section RMAN and the Flash Recovery Area, added an example of
configuring Oracle to write backups to the FRA. |
| Created section "Using RMAN to Reclaim Space in the FRA" on page
1,016. |
| It was noted there are two sections in Chapter 11 to discuss the same
thing; the sections are named Flashback Buffer and Flashback Database
Buffer. Confirmed, but deferred "fixing" this issue until a
later release. |
| Regenerated the table of contents to pickup new sections. |
| The chapter on Solaris was reworked to organize the steps for creating a
new Solaris 10 server. |
| Modified the descriptions of init.ora parameters DB_BLOCK_CHECKING,
DB_BLOCK_CHECKSUMS, REMOTE_ARCHIVE_ENABLE, and REMOTE_LOGIN_PASSWORDFILE as they have significantly
changed between versions 10.1 and 10.2. |
| The discussions and examples of configuring Oracle to auto-start on system
boot for UNIX servers were consolidated into a new section within the
chapter on database startup. |
| Posted free copies of the Table of Contents and a sample chapter on web
site. |
Build 023 - 2006-10-28
| Added chapter on RMAN as Chapter 37. |
| Added chapter on Upgrading and Migrating as Chapter 38. |
| The old chapter on RAC/Veritas/WebLogic is now Chapter 39. |
| Added an example to the section on Protecting the Oracle Listener. |
| Updated the list of requirements for Oracle Database Vault. |
| In Chapter 17 (Solaris Issues) numerous examples were not formatted /
boxed. That was fixed. Also, added VI editing commands for Change Word and Search Backwards. |
| In Chapter 17 (Solaris Issues) renamed section "Kernel Parameters" to "Kernel Parameters
for Solaris 9 and Earlier". |
| In Chapter 17 (Solaris Issues) added section "Resource Controls for Solaris 10". |
| In the section on Globalization / Unicode, you said Oracle 10g R2
supported Unicode 4.0. It is really 4.01. |
| The first two paragraphs in section "The CHARACTER SET Clause"
were updated. A new paragraph was added to the end of the same
section. |
| In section "The ARCHIVELOG Clause" please add a note about byte
ordering. It should state that columns using AL16UTF16 always use Big
Endian byte ordering. |
| In section "The CHARACTERSET Clause" added a tip about CLOBs
using UCS-2 Big Endian encoding in Oracle 9i, and AL16UTF16 in Oracle 10g,
and the fact that both are the same. |
| Added terms to Glossary: db file sequential read, db file scattered read,
db file direct read, and recovery catalog database. |
| In the chapters on database startup and shutdown, added sections on using
RMAN to do startups and shutdowns. |
| Added new STARTUP FORCE alert log information for Oracle 10.2. |
| Added a note about dynamic controlfile resizing, new in 10.2. |
| Added a note that the max number of instances identifiers in a 10.2
controlfile is 1055. |
| Added a note that the max number of partitions per table or index in 10.2
is 1024K-1. |
| Updated the notes about RMAN's NULL compression to be more accurate;
reworded to make clear how it works in 10.1 versus 10.2. |
Build 022 - 2006-10-02
| The section heading "Using the SQL*Plus SHOW Command to Inspect
Parameters" was not listed in the Table of Contents. |
| Users requested additional information about using EMCA with 10.2 RAC. |
| Users requested additional information about Veritas SF/RAC 5.0. |
| Spelling corrections. For example, SELECT_CATALLOG_ROLE was fixed. |
| In discussion of Bigfile Tablespaces on page 148, it said the max file size is 4 TB
times the database block size. It was corrected to says 4 billion
times database block size. |
| Added example of creating and dropping a Bigfile Tablespace. |
Build 021 - 2006-08-27
| Added section "Using SSL with JDBC Connections". |
| Added section "Moving and Renaming Database Files". |
| Added section "Reconfigure the Oracle Listener to Accommodate Connection Pools". |
| Added section "Installing 4 GB Might Not Give You 4 GB" in the
chapter on Windows Issues. |
Build 020 - 2006-07-20
| Added section "Replication Notes for Sequences" in Chapter 2. |
| Added section "Schema Level Triggers" in Chapter 2. |
| Added section, "Using Database Links for Streams Replication". |
| Added section, "TDE Replication Issues". |
| Added section, "Flashback Database System Requirements". |
| Reworded section, "Enabling / Disabling the Recycle Bin". |
| Reworded section, "Streams Pool". |
| Reworded section, "STREAMS_POOL_SIZE". |
| Updated section "Oracle Express Edition" to include a list of
unsupported features and options. |
| Grammatical changes on pages 939 - 1,031. |
Build 019 - 2006-07-16
| Added descriptions of Oracle Content DB, Oracle Records DB, and Oracle
TimesTen In-Memory DB. |
| The discussions of configuring and removing OEM Database Control were
split into separate sections for 10g Releases 1 and 2. |
| Grammatical changes on pages 473 - 938. |
| Altered format of headers - previously the book had different headers on
even and odd pages. |
| Removed "filler" pages from between chapters. |
| Added to the section on Troubleshooting OEM Database Control. |
Build 018 - INTERNAL
Build 017 - 2006-06-14
| Grammatical changes on pages 301-472. |
| Clarified using LOG_ARCHIVE_DEST_N as failover and overflow destinations. |
| Reworded the section, Setting Processor Affinity in Chapter 16. |
Build 016 - INTERNAL
Build 015 - 2006-04-25
| In section on OEM DB Control added pre-config checklist. |
| In section on Data Pump Export added pre-execute checks. |
| Added descriptions of Oracle Audit Vault, Oracle Database Vault, Oracle Secure
Enterprise Search, and Oracle Secure Backup. |
| Grouped information about Oracle RAC with Veritas SF/RAC into a new
chapter. Added information about WebLogic with RAC. |
| Updated notes on EMCA, XMLDB, DBSNMP, and SYSMAN. |
| Updated notes on QMNn and AQ_TM_PROCESSES. |
Build 014 - INTERNAL
Build 013 - 2006-04-11 - See below:
| New section: Check Your Audit Settings. |
| Updated section on Sequence Generators to be more clear about CACHE. |
| Updated section on XML DB Installation to be more clear. |
| Grammatical changes on pages 112-300. |
| Rebuilt Table of Contents. |
Build 012 - 2006-03-27 - See below:
| Added process for resizing on-line redo log files. |
| Added init.ora parameter SESSION_CACHED_CURSORS. |
| Updated init.ora DB_BLOCK_SIZE with upgrade notes. |
| Grammatical changes on pages 107-111. |
Build 011 - FIRST PUBLIC RELEASE.
Build 010 - INTERNAL ONLY.
Build 009 - INTERNAL ONLY.
Build 008 - INTERNAL ONLY.
Build 007 - INTERNAL ONLY.
Build 006 - INTERNAL ONLY.
Build 005 - INTERNAL ONLY.
Build 004 - INTERNAL ONLY.
Build 003 - INTERNAL ONLY.
Build 002 - INTERNAL ONLY.
Build 001 - INTERNAL ONLY. |
