|
Steps to create an Oracle database |
Steps that should be taken when creating a database in Oracle
Create a recipe: analysis of current system and hardware to plan database Create a blueprint of the file structure of your database Prep the operating system, create folder structure based on your blueprint Create pfile & database creation script Startup system: startup nomount pfile= if borowing an instance shutdown DB first Run create database script. Confirm in data dictionary the creation of the database SELECT name FROM v$database; SELECT instance_name FROM v$instance;
Run database_home\RDBMS\admin\catalog.sql as sysdba Run database_home\RDBMS\admin\catproc.sql as sysdba Run database_home\sqlplus\admin\pupbld.sql as system |