Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 37 views

    Less03 DB Dbca

    Uploaded by

    Andrei Cruz
    This document discusses how to create an Oracle database. It describes using the Database Configuration Assistant (DBCA) to create a database, listener, and database design template. It also covers planning the database structure and storage, configuring the listener, and using the DBCA for additional tasks like deleting a database.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPTX, PDF, TXT or read online from Scribd

    Less03 DB Dbca

    Uploaded by

    Andrei Cruz
    37 views20 pages
    This document discusses how to create an Oracle database. It describes using the Database Configuration Assistant (DBCA) to create a database, listener, and database design template. It also covers planning the database structure and storage, configuring the listener, and using the DBCA for additional tasks like deleting a database.

    Original Description:

    Original Title

    Less03 Db Dbca

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses how to create an Oracle database. It describes using the Database Configuration Assistant (DBCA) to create a database, listener, and database design template. It also covers planning the database structure and storage, configuring the listener, and using the DBCA for additional tasks like deleting a database.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    37 views20 pages

    Less03 DB Dbca

    Uploaded by

    Andrei Cruz
    This document discusses how to create an Oracle database. It describes using the Database Configuration Assistant (DBCA) to create a database, listener, and database design template. It also covers planning the database structure and storage, configuring the listener, and using the DBCA for additional tasks like deleting a database.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    of 20

    Creating an Oracle Database

    Objectives

    After completing this lesson, you should be able to do the following: Create a database by using the Database Configuration Assistant (DBCA) Create a listener by using the Oracle Net Configuration Assistant (NetCA) Create a database design template with the DBCA Generate database creation scripts with the DBCA

    3-2

    Planning the Database

    As a DBA, you must plan: The logical storage structure of the database and its physical implementation:
    How many disk drives do you have? What type of storage is being used? How many data files will you need? (Plan for growth.) How many tablespaces will you use? What types of information will be stored? Are there any special storage requirements due to type or size?

    Overall database design Database backup strategy


    3-3

    Databases: Examples

    Data warehouse:
    Research and marketing data State or federal tax payments Professional licensing (doctors, nurses, and so on)

    Transaction processing:
    Store checkout register system Automatic teller machine (ATM) transactions

    General purpose:
    Retail billing system (for example, for a software house or a nursery)

    3-4

    Configuring the Listener

    3-5

    Configuring the Listener

    3-6

    Configuring the Listener

    3-7

    Database Configuration Assistant (DBCA)

    3-8

    Using the DBCA to Create a Database

    3-9

    Using the DBCA to Create a Database


    3

    3 - 10

    Using the DBCA to Create a Database


    5

    3 - 11

    Using the DBCA to Create a Database


    8

    3 - 12

    Using the DBCA to Create a Database

    10

    3 - 13

    Using the DBCA to Create a Database


    11

    12

    3 - 14

    Password Management

    3 - 15

    Creating a Database Design Template

    3 - 16

    Using the DBCA to Delete a Database


    1

    3 - 17

    Using the DBCA for Additional Tasks

    3 - 19

    Summary

    In this lesson, you should have learned how to use the DBCA to: Create a database Create a database design template Create a listener Generate database creation scripts

    3 - 20

    Practice 3 Overview: Using the DBCA


    This practice covers the following topics: Creating the ORCL database by using the DBCA Unlocking the HR schema Note: Completing database creation and unlocking the HR schema are critical for all following practices. Optional: Creating the ORCL database design template by using the DBCA Creating database creation scripts by using the DBCA

    3 - 21

    You might also like