Oracle Database 10g introduced Database Control (dbconsole) to aid in day to day administration tasks and monitoring. When building a database for use as a repository for Oracle Enterprise Manager Grid Control or the recently […]
Using Oracle Managed Files you can quickly create a database manually with very little upfront effort. Oracle Managed Files greatly simplifies the database creation process because all that is needed is the location in which […]
Prior to Oracle Database 11gR1 in order to create a read only table you had to employ clever uses of triggers, constraints or other methods to prevent the data from being changed. In many of […]
Oracle provides the ORACLE_HOME/bin/dbstart and ORACLE_HOME/bin/dbshut scripts that can be used to start the the databases when the Operating System boots and to stop the databases when shutting down the Operating System.
Database Configuration Assistant (DBCA) provides a graphical interface for database creation and database configuration. This document will detail the creation of a database using the Database Configuration Assistant. The screen shots in this document were […]
This document will detail the steps to clone a database to another host using Oracle Enterprise Manager 11gR1 Grid Control.
Starting with Oracle Database 11gR2 when you create an empty heap organized table in locally managed tablespace segment creation is deferred until the time in which the first row is inserted. Segment creation is also […]
This document will detail multiplexing of control files. Having multiple control files reduces the risk of control file loss due to corruption or accidental removal. In the case of corruption or loss recovery is no […]
To protect against failure of the redo logs, Oracle allows redo logs to be multiplexed. With multiplexed redo logs two or more identical copies can be placed in separate locations. The log writer process (LGWR) […]
It is possible to move/rename the online redo logs should the need arise. This document will detail the steps required to move/rename the online redo logs in an 11gR2 environment on Linux. These steps also […]
It is possible to move and or rename datafiles while the database is online provided the tablespace in which the files belong is a non SYSTEM tablespace and does not contain any active ROLLBACK or […]
It is possible to move/rename the database’s control files should the need arise. This document will detail the steps required to move/rename the control files in an 11gR2 environment on Linux. These steps also apply […]
Using Database Control you can configure RMAN to back up you database to disk or tape with relative ease. This document will detail how to configure RMAN for disk based backups and perform a backup.
A common problem with 10g and higher database is that Database Control fails to start after installation. This more common on desktop and laptop installs but the resolution is the same.