Alter System Scope, SID and Container
ALTER SYSTEM SET When we issue ALTER SYSTEM SET to modify parameter, some scope clauses can be used to specify how new value is applied… Read More »Alter System Scope, SID and Container
PFILE and SPFILE
When the SPFILE is Missing
When you met the following situation, you are about to restore the spfile for your database.SQL> startup open;ORA-01078: failure in processing system parametersORA-01565: error in… Read More »When the SPFILE is Missing
Search Order of Parameter File for Startup
Shared SPFILE You might have noticed that the newly created SPFILE for a RAC database was not taking effective after restarts. And I think you… Read More »Search Order of Parameter File for Startup