Archive for the ‘Oracle Concepts’ Category

Oracle Parameter Files

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 [...]

Continue reading »

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 [...]

Continue reading »

Follow

Get every new post delivered to your Inbox.