Oracle DBA Startup guide Post 3

Oracle Database 10g is an Relational Database or RDBMS. There are two part of this RDBMS and they are Physical Database and Oracle Instance. Physical files, redo log files and control file are comutatively called as physical database. Oracle instance consists of a big memory area and some background process. It provide a way to the users to do an activity on the data. i.e. to retrive, add, modify or delete.

Data files - Physically stores the data
Redo log file - It contains the changes made to data. It is required for recovery.
Control files - It contains tipical information about database

1. Datafile location
2. Synchronization Information
3. Backup and recovery information

Supporting files i.e. parameter file, password file, alert log are important to database but is not a part of the database.

Naming convention of the database objects

1. Max 30 characters are supported
2. It have to start with a latter
3. Can include latter, number and underscore
4. Should not user reserved words

Oracle DBA Startup guide Post 2

Oracle Database 10g installation CD is required to do a basic installation. Minimum 4 GB free disk space and 250 MB memory is required to do the installed. It can take at around 30 minutes to install the database. It also does some system checks i.e. utility and file permission.

There are various features in instance configuration

• DBCA ( Database configuration assistance)
• Policy based database configuration
• Initialization Parameter

You can create database both using DBCA or manually from command line.

More in next post.......