Parameter Files Oracle must read either an initialization parameter file or a server parameter file(SPFILE) to start an instance. These files contain list of initialization parameters and a value for each parameter. Server Parameter Files Initialization Parameter Files In the platform-specific default location, Oracle Database locates your initialization parameter file by examining filenames in the [...]
Archive for the ‘Oracle Concepts’ Category
28 Nov
Oracle Shutdown Concepts
Shut down the database to make operating system offline backups of all physical structures and to have modified static initialization parameters take effect when restarted. SHUTDOWN [NORMAL | TRANSACTIONAL | IMMEDIATE | ABORT ] SHUTDOWN NORMAL Normal is the default shutdown mode.Normal database shutdown proceeds with the following conditions: • No new connections can be [...]