header image
Home arrow Oracle arrow 10g arrow Arch and Admin arrow Steps to create an Oracle database
Steps to create an Oracle database
Steps that should be taken when creating a database in Oracle
  1. Create a recipe: analysis of current system and hardware to plan database
  2. Create a blueprint of the file structure of your database
  3. Prep the operating system, create folder structure based on your blueprint
  4. Create pfile & database creation script
  5. Startup system: startup nomount pfile= if borowing an instance shutdown DB first
  6. Run create database script.
  7. Confirm in data dictionary the creation of the database
    1. SELECT name FROM v$database;
    2. SELECT instance_name FROM v$instance;
  8. Run database_home\RDBMS\admin\catalog.sql as sysdba
  9. Run database_home\RDBMS\admin\catproc.sql as sysdba
  10. Run database_home\sqlplus\admin\pupbld.sql as system
Get noticed online
So you got a site, but does anyone know where to find you?