new database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: new database

  1. #1
    Join Date
    Nov 2000
    Posts
    51
    Hi, I am new on Oracle. Can any one give me ideas on brand new database installation on Solaris, the oracle version will be 8.1.7.

    Thanks!

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    1. The Oracle Installer GUI is pretty straight forward and easy to use. You can create a sample database from there.

    2. Make sure you have the appropriate permissions and that you have set the /etc/system parameters correctly. These are outlined in the Installation Guide.

    3. With 8.1.7, I like to install from Disk instead of CD-ROM. Create a directory, say /tmp/oinstall and create two sub-directories; /tmp/oinstall/Disk1 and /tmp/oinstall/Disk2 (Case is VERY important). Then, install from /tmp/oinstall/Disk1/runInstaller.sh
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2000
    Posts
    51
    Thank you. After the installation, the dafault database is created, if I want to create db with different structure, do I need to drop all the db files including control file, redo log and .dbf files? then I run the create db script to create the new database, and run the catalog.sql and catproc.sql?


  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    There is another GUI that helps you create a new database. I believe it is called dbassist.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Nov 2000
    Posts
    51
    Thanks!

    But in what mode I should run the scripts to create the db, db nomount or db open?

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Using dbassist, database startup/shutdown, etc is taken care of for you...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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