Why did the instance fail to start?

View the SPFILE parameter settings in the Exhibit.

You issue this command and get errors:
SQL> startup
ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET due to existing internal settings,
see alertlog for more information
Why did the instance fail to start?

View the SPFILE parameter settings in the Exhibit.

You issue this command and get errors:
SQL> startup
ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET due to existing internal settings,
see alertlog for more information
Why did the instance fail to start?

A.
because pga_aggregate_target is not set

B.
because statistics_level is set to basic

C.
because memory_target and memory_max_target cannot be equal

D.
because sga_target and memory_target are both set



Leave a Reply 1

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