This document outlines the steps to manually create an Oracle database named "db02" including:
1) Choosing a database name and creating the necessary filesystem;
2) Creating an initialization parameter file and environment file;
3) Running a script to create the database; and
4) Performing post-creation steps like running catalog.sql and catproc.sql scripts before shutting down and restarting the database.
Copyright:
Attribution Non-Commercial (BY-NC)
Available Formats
Download as DOC, PDF, TXT or read online from Scribd
This document outlines the steps to manually create an Oracle database named "db02" including:
1) Choosing a database name and creating the necessary filesystem;
2) Creating an initialization parameter file and environment file;
3) Running a script to create the database; and
4) Performing post-creation steps like running catalog.sql and catproc.sql scripts before shutting down and restarting the database.
This document outlines the steps to manually create an Oracle database named "db02" including:
1) Choosing a database name and creating the necessary filesystem;
2) Creating an initialization parameter file and environment file;
3) Running a script to create the database; and
4) Performing post-creation steps like running catalog.sql and catproc.sql scripts before shutting down and restarting the database.
Copyright:
Attribution Non-Commercial (BY-NC)
Available Formats
Download as DOC, PDF, TXT or read online from Scribd
This document outlines the steps to manually create an Oracle database named "db02" including:
1) Choosing a database name and creating the necessary filesystem;
2) Creating an initialization parameter file and environment file;
3) Running a script to create the database; and
4) Performing post-creation steps like running catalog.sql and catproc.sql scripts before shutting down and restarting the database.
Copyright:
Attribution Non-Commercial (BY-NC)
Available Formats
Download as DOC, PDF, TXT or read online from Scribd
Think of Database name......................................................................................................II Create respective filesystem as same as previous one........................................................II Create initialization parameter file......................................................................................II Create Environmental file...................................................................................................II Create Database script .......................................................................................................III Run create database script..................................................................................................III Post creation steps..............................................................................................................IV Why?..................................................................................................................................IV Shutdown and startup the Database...................................................................................IV ..........................................................................................................................................IV
Document Prepared by: Nikhil Rangaraju
Oracle NAIO
NOTE: Database was created with the same user.
I Think of Database name
Oracle_Sid = db02
Create respective filesystem as same as previous one
Now run the script using following command . db02.env
Create Database script
Createdb.sql located in ORACLE_BASE
create database db02 logfile group 1 ('/u01/oracle9i/oradata/db02/log01.rdo') size 10m, group 2 ('/u01/oracle9i/oradata/db02/log02.rdo') size 10m datafile '/u01/oracle9i/oradata/db02/system01. dbf' size 100m autoextend on next 512k maxsize 120m default temporary tablespace temp tempfile '/u01/oracle9i/oradata/db02/temp01.dbf' size 10m autoextend on next 5m maxsize 20m undo tablespace UNDOTBS1 datafile '/u01/oracle9i/oradata/db02/undo01.dbf' size 10m autoextend on next 5m maxsize 60m character set WE8ISO8859P1 national character set AL16UTF16 ;
Login as SYSDBA
Command: Sqlplus ‘/as sysdba’
Startup the database in nomount mode
Command: Startup nomount
Run create database script
III Command: @Createdb.sql
Post creation steps
Run catalog.sql and catproc.sql scripts located in ORACLE_HOME/rdbms/admin/
