Identify the reason the instance failed to start.

To implement Automatic Management (AMM), you set the following parameters:

When you try to start the database instance with these parameter settings, you receive the
following error message:
SQL > startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings,
see alert log for more information.
Identify the reason the instance failed to start.

To implement Automatic Management (AMM), you set the following parameters:

When you try to start the database instance with these parameter settings, you receive the
following error message:
SQL > startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings,
see alert log for more information.
Identify the reason the instance failed to start.

A.
The PGA_AGGREGATE_TARGET parameter is set to zero.

B.
The STATISTICS_LEVEL parameter is set to BASIC.

C.
Both the SGA_TARGET and MEMORY_TARGET parameters are set.

D.
The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

Explanation:

Example:
SQL> startup force
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings
ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or
MEMORY_TARGET

Show Hint

Leave a Reply 7

Your email address will not be published. Required fields are marked *

Dilan

Dilan

STATISTICS_LEVEL specifies the level of collection for database and operating system statistics. The Oracle Database collects these statistics for a variety of purposes, including making self-management decisions.

The default setting of TYPICAL ensures collection of all major statistics required for database self-management functionality and provides best overall performance. The default value should be adequate for most environments.

When the STATISTICS_LEVEL parameter is set to ALL, additional statistics are added to the set of statistics collected with the TYPICAL setting. The additional statistics are timed operating system statistics and plan execution statistics.

Setting the STATISTICS_LEVEL parameter to BASIC disables the collection of many of the important statistics required by Oracle Database features and functionality,

Reference,

https://docs.oracle.com/database/121/REFRN/GUID-16B23F95-8644-407A-A6C8-E85CADFA61FF.htm#REFRN10214

Reply