Starting up an Oracle Database Instance

When starting the database instance, we need to select the state in which it starts.

1. NOMOUNT
2. MOUNT
3. OPEN

1. NOMOUNT: An instance is typically started only in NOMOUNT mode during database creation, during re-creation of control files, or during certain backup and recovery scenarios.

How to configure Oracle 11g enterprise manager (OEM DBConsole) for an existing database?

1. cd $ORACLE_HOME/bin/
2. Command to drop the existing configuration
• emca -deconfig dbcontrol db -repos drop
3. Command to create
• emca -config dbcontrol db -repos create

What does i, g and c in oracle 8i, 9i, 10g, 11g and 12c stand for?

The i in oracle 8i and 9i stands for INTERNET and the g in 10g and 11g stands for GRID because from 10g onwards oracle supports grid architecture.

A relational database management system (DBMS) from Oracle, which runs on more than 80 platforms. Introduced in the late 1970s, Oracle was the first database product to run on a variety of platforms from micro to mainframe. The Oracle database is Oracle's flagship product, and version 11g was introduced in 2007.