create DB

Hi DBAs,

I have a doubt on create DB (Manually).

While we install the oracle the database is creating automatically.

Then why should we go for a manual database creation.

This is a basic but i am bit confused.

Can anyone clarify this.

Thanx

Hello SRI DBA.

When you install Oracle on your system, for the first time, and you choose to have the first database created, Oracle places the data files in one directory while placing the files related to DBA in another directory, both of which are placed in, yet another directory. The general setup is like this for datafiles c:\oracle\oradatat\db_name, likewise the setup is like this for dba related files c:\oracle\admin\db_name.

When you create a database manually you can "specify" where you want ALL of your files to be located, for example, when I create a database here is how I lay it out c:\db_name, then follows all of the directorys inside the db_name directory. There will be files that must be fetched from c:\oracle\ora_whatever, but the gist, for me, is convenience

Hop I helped.

Rick

Hi Rick,

Thanx for ur reply. What will happen when we recreate the DB manually.

Can u explain me the process, i mean init file and other things.

Thanx in advance.

well you do the same as what dbca does, but you do it yourself.

You have to create the init file, you have to create the directory structure. basically you have to know what you are doing

best bet is to read the manual http//tahiti.oracle.com

Thanx dave,,, a lot of info in this

Hello SRI DBA.

Davey23UK said it, creating a database manually gives the dba more controll over creating the structure, the majority of the files, and where those files are located.

See here.

Manually
c:
ACME--->data, create, pfile, udump, cdump, bdump, control1, control2, redo1, redo2, backup, scripts. This is just the start. Keep in mind, as Davey23UK stated, when you create a database manually you must also create the pfile, and that will be determined by what parameters will be required by those needs of the people you work for.

Creating a database automatically forces the dba to have to wade through 3 directories, it's sub-directories to manage the database, creating a database manually places the bulk of the files in
ONE ONE directory, of course it's sub-dirctories as well.

It's ease of management.

Rick

Quote:

---

Originally posted by sri_dba
Hi DBAs,

I have a doubt on create DB (Manually).

While we install the oracle the database is creating automatically.

Then why should we go for a manual database creation.

This is a basic but i am bit confused.

Can anyone clarify this.

Thanx

---

So, what is the question?

Quote:

---

Originally posted by julian
So, what is the question?

---

"...
Then why should we go for a manual database creation.
..."

It lacks the question mark though... ;)

Quote:

---

Originally posted by jmodic
"...
Then why should we go for a manual database creation.
..."

It lacks the question mark though... ;)

---

It sounded to me more like a retorical question :-)

I have created 100s of databases, never used the assistant though...

Quote:

---

Originally posted by julian
I have created 100s of databases, never used the assistant though...

---

Created hundreds of database, huh? So I guess your entire DBA's career is more or less concentrated around new databases creation, isn't it? Or was that number slightly exagerated? :p

I've not created even close to one hundred databases in my entire Oracle life (which is allready deep into its second decade now), however I have created quite a few of them with the help of Oracles's "database assistant" since it was made available in 8i. And I say thank god they provided such a tool. Maybe not for someone who creates at least one new database everery day (given it a second thought, I think this tool was ment in particular for them!), but for a typical DBA such an assistant is a god-sended tool, particulary when it enables him to save creation scripts and browse to them (and probably manualy change few bits in them) before running them.

And if you realy never used it as you say, then I assure you you are wasting your time by creating them manualy. Realy, you should give it a try some day... ;) You'd be surprised what interesting options this assistant provide - in particular those templates are made just for the type of DBAs that are forced to create hundreds or thousands of databases.

Quote:

---

Originally posted by jmodic
Created hundreds of database, huh? So I guess your entire DBA's career is more or less concentrated around new databases creation, isn't it? Or was that number slightly exagerated?

---

No, the number is not exagerated. Yes, hundreds of databases. What's so strange??

Please feel free to use whatever assistants you want. I prefer to type myself the Oracle commands.

so the saga continues !!..

I really admire Julian's way of typing in Oracle Commands, it only impoves us rather than using stupid tools..