1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

i need help ..very important

Discussion in 'System Administration & Application DBA' started by Nora, Jun 3, 2014.

  1. Nora

    Nora Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    hello guys . i have these questions and i am not experienced in oracle administrator , but i have these question and i don't know the answer, i need academic answer , i hope really you can help :( :rolleyes:

    I've been asked as a DBA to create an Oracle database as part of a company application that meets the following requirements with the best performance:

    Server Hardware Specifications

    1. Oracle 11gis installed.
    2. Operating System is Windows Server.
    3. Four disk drives (C, D, E and F).
    4. Your server total RAM is 2 GB.

    Application Specifications
    5. Small size ERP application.
    6. The application consists of the following modules:
    a. Human Resources Module
    b. Finance Module .
    c. Sales Module .
    7. 6 employees are only allowed to connect concurrently to the database using their company desktops. No access is allowed from the internet.
    8. No Java option is required with the application or database.

    Database Specifications
    9. Database name should be G5.
    10. Database Memory:
    a. Our oracle database systemwide usable memory shall be 25% of the server memory.
    b. Our oracle database systemwide usable memory shall not exceed 25% of the server memory during its lifetime.
    c. Automatic Memory Management is enabled.
    11. The database should not accept more than 75 database files during its lifetime.
    12. Automatic undo management is required.
    13. The database should be available 7/7 days, and 24/24 hours.
    14. No data loss is allowed during the database lifetime.


    REQUESTS

    Please answer the following questions with respect to all the previous requirements:

    Server Mode
    1 What is the best server connection mode for our database? Justify your answer.

    SettingInitialization Parameters
    2 What is the initialization parameter file type you are going to use? Justify your answer.
    3 What are the values of DB_NAME and DB_DOMAIN?
    4 What is the best value for LARGE_POOL_SIZE? Justify your answer.
    5 What is the best value for JAVA_POOL_SIZE? Justify your answer.
    6 What are the required initialization parametersrelated to memory that should be used to create the database?List these parameters with suitable values.
    7 What is the value of CONTROL_FILES?
    8 What is the value of DB_BLOCK_SIZE? Justify your answer.
    9 What is the value of PROCESSES? Justify your answer.
    10 List the initialization parameters related to the Undo management with their suitable values.
    11 What is the value of COMPATIBLE?
    12 How can you satisfy the specification number 11?

    Logical & Physical Structures
    13 List all the required tablespaces with respect to all the previous conditions, justify your answer.
    14 List all the required Log and control files with their location considering all the specifications especially 13 & 14.
    15 How can you satisfy specification 14? Justify your answer.

    Database Creation
    16 Write the CREATE DATABASE script.

    ...........................................................
    i hope i post my question in the right section , I will be very appreciated if you help me , this is so important for me :)
    Regards
    ^_^
     
  2. ocprep

    ocprep Forum Advisor

    Messages:
    277
    Likes Received:
    76
    Trophy Points:
    410
    Location:
    Orlando, Florida
    The answer is that you should do your own school assignments.
     
  3. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.

    The response to your questions is simple: address to documentation and you will find responses.

    ANSWER:

    http://docs.oracle.com/cd/E11882_01/index.htm

    For start :

    2 Day DBA


    Note:
     
    Nora likes this.
  4. Nora

    Nora Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    well , i want to do my school assignments , but really i have a lack of study and i have no time to finish it at the right time :(
    anyway thanks for the replay
     
  5. Nora

    Nora Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    if i had enough time and experience , i would definitely solve them by myself , but i have a lot of assignments and i couldn't solve this :'( i only have 1 day in order to deliver this assignment.
     
  6. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Search in documentation of the description of parameters - won't take a lot of time and you will be able to perform itself jobs and to gain new knowledge.

    For eample :

    DB_NAME
    Compatibility
     
    Nora likes this.