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
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

Oracle 10g to 11g Enhancements (Difference between Oracle 10g and 11g)

Difference between Oracle 10g and 11g 1- Enhanced Automatic Memory Management System Oracle 9i automated …

Leave a Reply

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

DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe