Creating Oracle Database Manually

All posts relating to Oracle database administration.

Moderator: Tim...

Posts: 1
Joined: Wed Feb 20, 2013 12:19 pm

Creating Oracle Database Manually

Postby taoqir.hassan » Wed Feb 20, 2013 12:24 pm

i am new to Oracle DBA question is that How to create oracle database Manually (without using Oracle DBCA),and how many parameters are to set?
Thanks in Advance

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Creating Oracle Database Manually

Postby Tim... » Wed Feb 20, 2013 2:39 pm


The answer to this is simple, but I will break it down a little.

1) You shouldn't. Oracle recommend you create all databases using the DBCA.

2) If you want to see how to do it without using the DBCA, you should run the DBCA, but at the end you are asked if you want to save your setup as scripts and/or create the database now. Saving the scripts allows you to see exactly what the DBCA does to create the database, which will answer your question.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 2 guests