 |
|
Oracle Tips by Burleson |
Chapter 1
Oracle Instance Internals Scripts
-
NONE - Oracle does not refer to Oracle Internet
Directory for Enterprise User Security information.
-
PASSWORD - Oracle tries to connect to the
enterprise directory service using the database password stored in
the database wallet. If that fails, then the Oracle Internet
Directory connection fails and the database will not be able to
retrieve enterprise roles and schema mappings upon enterprise user
login.
-
SSL - Oracle tries to connect to Oracle
Internet Directory using SSL.
The log_archive_config
parameter
The log_archive_config parameter enables or disables the sending of redo logs to remote
destinations and the receipt of remote redo logs, and specifies the
service provider names (SP_NAME) for each database in the Data Guard
configuration.
Values:
-
SEND - Enables the sending of redo logs to
remote destinations
-
NOSEND - Disables the sending of redo logs to
remote destinations
-
RECEIVE - Enables the receipt of remotely
archived redo logs
-
NORECEIVE - Disables the receipt of remotely
archived redo logs
-
DG_CONFIG - Specifies a list of up to 9 service
provider names (defined with the SP_NAME initialization parameter)
for all of the databases in the Data Guard configuration.
-
NODG_CONFIG - Eliminates the list of service
provider names previously specified with the DG_CONFIG option
The above is from the bestselling book
Mike Ault’s Oracle Internals Monitoring & Tuning Scripts.
It's only $49.95and you can download all the scripts immediately:
|
|
|
Need an Oracle Health Check?
Does your boss blame you for an Oracle performance problem?
Need to prove that your database is properly optimized?
BC Oracle performance guru's can quickly verify every aspect of your
Oracle database and provide a complete certification that your database
is fully optimized. |

|
|