Friday , July 21 2017
Home / Oracle DBA / STEPS to create database manually

STEPS to create database manually

STEPS to create database manually

  1. Copy any existing database p file to a new name. If no database exists on this server, use p file of another database which is residing on another server.
  1. Open p file with vi editor and do necessary changes like changing database name, dump locations etc and save it.
  1. Create necessary directories as mentioned in p file.
  1. Copy the database creation script to the server and edit it to your need.
  1. Export the SID
    $ export ORACLE_SID=dev
  1. Start the instance in no mount phase using the p file
    SQL> startup nomount
  2. Execute create database script
    SQL> @db.sql
  3. Once database is created, it will be opened automatically.
  4. Execute the catalog.sql and catproc.sql scripts
    SQL> @$ORACLE_HOME/rdbms/admin/catalog.sql
    SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql
  5. Finally add this database entry to oratab file.
Note: Sometimes, we may get error “Oracle Instance terminated. Disconnection forced”. This is due to the reason that undo tablespace name mentioned in pfile is different from the one mentioned in database creation script.
Read More:
ORACLE 11g DATABASE ARCHITECTURE
SHARED SERVER ARCHITECTURE
DATABASE OPERATING MODES

Comments

comments

Check Also

DATA BASE LINKS

DATABASE LINKS: What are the db links? create a link from one database to another …

Leave a Reply

Your email address will not be published. Required fields are marked *