View the Exhibit and examine the parameter settings in your server-side parameter file(SPFILE). When you tried to start

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

View the Exhibit and examine the parameter settings in your server-side parameter file(SPFILE). When you tried to start

Post by answerhappygod »

View the Exhibit and examine the parameter settings in your server-side parameter file(SPFILE). When you tried to start the database instance, you received the following error:SQL> startup -ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more informationWhy did the instance fail to start?Exhibit:

A. Because the PGA_AGGREGATE_TARGET parameter is not set
B. Because the STATISTICS_LEVEL parameter is set to BASIC
C. Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal
D. Because both the SGA_TARGET and MEMORY_TARGET parameters are set.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply