Results 1 to 4 of 4

Thread: Managing oracle 9i Database

  1. #1
    Join Date
    Jan 2010
    Posts
    56

    Managing oracle 9i Database

    This is my first step in Managing oracle database.I want a complete code to Create database in Oracle 9i version.Can You explain me about different type of supporting files that are being used in managing the database. What are the need of these files ?? How many ways of creating the database in Oracle 9i. Why we move to the Start up mount and start up no mount.

  2. #2
    Join Date
    May 2008
    Posts
    2,297

    Manually creation of oracle 9i Database

    There are two ways to creating the Database in Oracle 9i :

    1. Manual Creation of Database.
    2. Using DBCA (Database Configuration Assistant)


    Create a Newly and fresh directory structure for the database. After that, copy the init.ora file into a new file called init<SID>.ora into new Folder.

    Now you are ready with a parameter file and don't remember the SID that you have defined with the parameter file.
    If you are a windows user type :
    Set ORACLE_SID = <SID>

    and if Unix operating system then Type:
    Export ORACLE_SID = <SID>

    Now follow these steps:

    sqlplus / as sysdba

    startup nomount pfile = ‘<directory>\init<SID>.ora’

    CREATE DATABASE Zechodb
    Maxinstances 1
    Maxloghistory 1
    Maxlogfiles 8
    Maxlogmembers 10
    Maxdatafiles 20
    Datafile ‘<directory>\Parentdbfile.dbf’
    size 300M reuse autoextend on next 15M maxsize unlimited

    national character set AL16UFT16
    logfile
    group 1 (‘<directory>\redo1.log’) size 50M
    group 2 (‘<directory>\redo2.log’) size 50M
    group 3 (‘<directory>\redo3.log’) size 50M
    default temporary tablespace tmp
    tempfile ‘<directory>\tempdbfile.dbf’
    extent management local uniform size 1M
    undo tablespace Undotbs datafile ‘<directory>\Undodatafile.dbf’
    size 125M reuse autoextend on next 15M maxsize unlimited;


    After all these thing, you need to execute some SQL files that will create some views.

    @<directory>\catalog.sql
    @<directory>\catproc.sql
    @<directory>\catexp.sql


    Change your password of database for security purpose.
    Last edited by Zecho; 21-01-2010 at 10:12 AM.

  3. #3
    Join Date
    Oct 2005
    Posts
    2,393

    Creating oracle 9i Database using DBCA

    The Oracle database also provide a way to create your database very easily.
    There is no need to go and create directory and file. Just click on the buttons and your database will be in front of you after some moments.

    Now we are going to create a database in oracle 9i using DBCA (Database configuration Assistant):

    1. Type DBCA in the terminal and a wizard would be open for you.
    2. There are so many option you would see and select According to your Use.
    3. Actually the every category of database has different steps of creation.
    4. select one of them. for Example : "General purpose".
    5. Click on the next button below .
    6. Insert the name of the database in the Text box .
    7. Specify the parameter that you wanted to set for the instance and configure the different parameters
    8. After another next your creation of database would be started
    9. Just wait for some moments,after that you would be prompted for the password of Administrator of the database.

    After all open the terminal and type :

    Export ORACLE_SID=<SID> //For Linux Users
    Set ORACLE_SID=<SID> // For Windows Users

    and then type sqlplus '/ as sysdba' and start your database.

  4. #4
    Join Date
    May 2008
    Posts
    2,389

    Mount and Nomount of Database

    There are different stages of managing of database.You can divert your database according to use and troubleshooting phases and we are discussing here about two stages of the database: Mount and nomount.

    Oracle instance starts in this way:
    ==> Shut down=>nomount=>mount=>open=
    ll ll
    ===============================
    Mount : Mount stage of the database used when the recovery of database is being performed.In this stage the oracle server process reads the control file and make enable the database for recovery process.
    This command can change the database mode in mount stage :
    SQL>Startup Mount

    Nomount : Nomount is rarely used in the normal processing of database.It is used when we create the database and in this stage the oracle server process reads the parameter file.But we can divert our database using this command:
    SQL> Startup nomount

Similar Threads

  1. Managing the access control in database
    By Carnie in forum Software Development
    Replies: 4
    Last Post: 19-02-2010, 10:03 PM
  2. Managing password file in oracle
    By Usher in forum Software Development
    Replies: 4
    Last Post: 18-02-2010, 10:59 PM
  3. Restoring and managing Control file in oracle
    By Lachlann in forum Software Development
    Replies: 5
    Last Post: 12-02-2010, 09:09 PM
  4. Managing Rollback segment in database
    By Adriana_andros in forum Software Development
    Replies: 4
    Last Post: 08-02-2010, 06:48 PM
  5. Managing users in database
    By LaMarcus in forum Software Development
    Replies: 4
    Last Post: 02-02-2010, 06:46 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,697,172.22772 seconds with 17 queries