Thursday, January 5, 2012

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

Oracle DBA Startup guide Post 1

First task of an Oracle DBA is to install the Oracle Database. But before installing the database, DBA has to estimate the configuration of the server on which it is going to be installed. He have to keep in mind the bellow points,

  1. Operation System version and compatability
  2. Number and speed of the server
  3. Size of the disk for configuration
  4. Size of Memory( Primary as RAM)
  5. Amount of space for backups
Oracle Enterprise Manager(OEM) Database Control included in oracle database 10g is installed for managing local databases. You need to install OEM grid control ( from Oracle Enterprise Manager CD ) for controlling multiple hosts, database and other oracle services.

Before installing Oracle Database, Oracle Universal Installer( OUI ) does a system compatability check to confirm the hardware, free disk space, OS version and other required utility.

More in next post......

Monday, January 2, 2012

Oracle Apps DBA Future

Now we have come to a stage where Oracle Apps ( E Business Suite) will face a dramatic change in its future.

Previously, Oracle Apps DBA were those persons who knows

  1. Oracle E Business Suite System Administration
  2. Oracle Core DBA Activities
  3. Troubleshooting
  4. Some Unix Knowledge
  5. And some other knowledge
Now Oracle has planed to make it upgraded with Oracle Apps 12.2 which will 
push the DBAs' to update themselves.

More in Next Post.

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...