create DB
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: create DB

  1. #1
    Join Date
    Jun 2003
    Posts
    108

    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

  2. #2
    Join Date
    Aug 2003
    Location
    Virginia
    Posts
    392

    create db.....

    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
    Rick

    Sigh.....those were the days my friend, I thought they'd never end.
    I too remember when this place was coo.


  3. #3
    Join Date
    Jun 2003
    Posts
    108
    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.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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

  5. #5
    Join Date
    Jun 2003
    Posts
    108
    Thanx dave,,, a lot of info in this

  6. #6
    Join Date
    Aug 2003
    Location
    Virginia
    Posts
    392
    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
    Rick

    Sigh.....those were the days my friend, I thought they'd never end.
    I too remember when this place was coo.


  7. #7
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: create DB

    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?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  8. #8
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439

    Re: Re: create DB

    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...
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  9. #9
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Re: Re: create DB

    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...
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  10. #10
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439

    Re: Re: Re: Re: create DB

    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?

    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.
    Last edited by jmodic; 01-11-2004 at 03:00 PM.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width