Scribd Logo
Upload

Welcome to Scribd!

  • 40 views

    Oca Dba

    Uploaded by

    abolatahia257
    - A standard Oracle Database 10g installation requires 1 GB RAM and 1.5 GB swap space. It includes one seed database template and additional products can be installed from other CDs. - Optimal Flexible Architecture (OFA) organizes software, data, and administrative files to avoid bottlenecks and facilitate tasks like backups. It supports switching between databases and managing database growth. - OFA compliant directory structures use mount points like /u01 for software, home directories like /u01/app/oracle, and version-specific software directories like /u01/app/oracle/product/10.2.0.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Oca Dba

    Uploaded by

    abolatahia257
    40 views2 pages
    - A standard Oracle Database 10g installation requires 1 GB RAM and 1.5 GB swap space. It includes one seed database template and additional products can be installed from other CDs. - Optimal Flexible Architecture (OFA) organizes software, data, and administrative files to avoid bottlenecks and facilitate tasks like backups. It supports switching between databases and managing database growth. - OFA compliant directory structures use mount points like /u01 for software, home directories like /u01/app/oracle, and version-specific software directories like /u01/app/oracle/product/10.2.0.

    Original Description:

    bnbnbv

    Original Title

    OCA DBA

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    - A standard Oracle Database 10g installation requires 1 GB RAM and 1.5 GB swap space. It includes one seed database template and additional products can be installed from other CDs. - Optimal Flexible Architecture (OFA) organizes software, data, and administrative files to avoid bottlenecks and facilitate tasks like backups. It supports switching between databases and managing database growth. - OFA compliant directory structures use mount points like /u01 for software, home directories like /u01/app/oracle, and version-specific software directories like /u01/app/oracle/product/10.2.0.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    40 views2 pages

    Oca Dba

    Uploaded by

    abolatahia257
    - A standard Oracle Database 10g installation requires 1 GB RAM and 1.5 GB swap space. It includes one seed database template and additional products can be installed from other CDs. - Optimal Flexible Architecture (OFA) organizes software, data, and administrative files to avoid bottlenecks and facilitate tasks like backups. It supports switching between databases and managing database growth. - OFA compliant directory structures use mount points like /u01 for software, home directories like /u01/app/oracle, and version-specific software directories like /u01/app/oracle/product/10.2.0.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    Installation: System Requirements

    A standard installation can be completed on a computer with 1 GB of RAM and 1.5 GB of


    swap space or larger.
    Some installation details:
    - Oracle Database 10g ships only one seed database template.
    - Duplicated files are removed.
    - Many other products and demonstrations are installable from additional CDs.
    Note: An Enterprise Edition installation type that includes a standard seed database is referred to
    as a standard installation.
    OFA is designed to:
    Organize large amounts of complicated software and data on the disk to avoid device
    bottlenecks and poor performance
    Facilitate routine administrative tasks, such as software and data backup, which are often
    vulnerable to data corruption
    Facilitate switching between multiple Oracle databases
    Adequately manage and administer database growth
    Help eliminate fragmentation of free space in the data dictionary, isolate other
    fragmentation, and minimize resource contention
    Using Optimal Flexible Architecture
    Mount point syntax: Name all mount points by using the /pm syntax, The examples of mount points are
    /u01 and /u02.
    Home directories syntax: Name all home directories by using the /pm/h/u syntax, The examples of
    OFA-compliant home directories are:
    /u01/app/oracle
    /u01/home/oracle

    Software directories syntax: Store each version of the Oracle software in a directory matching
    the pattern: /pm/h/u/product/v. An OFA-compliant installation of the Oracle Database
    10g version 10.2.0 looks like:
    /u01/app/oracle/product/10.2.0

    Naming subdirectories syntax: To facilitate the organization of administrative data, you should
    store database-specific administration files in subdirectories matching the pattern:
    /h/admin/d/a/. Here, h is the Oracle software owners home directory, admin is a literal,
    d is the database name, and a is a subdirectory for each of the database administration files. The
    following is a list of these administration file subdirectories:
    adhoc: Ad hoc SQL scripts for a particular database
    arch: Archived redo log files
    adump: Audit files (Set the AUDIT_FILE_DEST initialization parameter to the adump
    directory. Clean out this subdirectory periodically.)
    Bdump: Background process trace files
    Cdump: Core dump files
    Create: Programs used to create the database
    Exp: Database export files
    Logbook: Files recording the status and history of the database
    Pfile: Instance parameter files
    udump: User SQL trace files

    File-naming syntax: The following naming convention for database files ensures that they are
    easily identifiable:
    Control files: /pm/q/d/controln.ctl
    Redo log files: /pm/q/d/redon.log
    Data files: /pm/q/d/tn.dbf
    The variables used in these file names are:
    pm: A mount point name as described previously
    q: A string distinguishing the Oracle data from all other files (commonly named ORACLE
    or oradata)
    d: The value of the initialization parameter, DB_NAME (the database name)
    t: An Oracle tablespace name
    n: A two-digit string
    Note: Do not store files other than control files, redo log files, or data files associated with the d
    database in the /pm/q/d/path.
    Setting Environment Variables
    ORACLE_BASE: Specifies the base of the Oracle directory structure for OFA. Use of this
    is optional, but if used, this can facilitate future installations and upgrades. It is a directory
    path, as shown in this example:

    /u01/app/oracle

    ORACLE_HOME: Specifies the directory containing the Oracle software. It is a directory


    path, as shown in this example:

    $ORACLE_BASE/product/10.2.0/db_1

    ORACLE_SID: The initial instance name (by default, ORCL).

    NLS_LANG: Specifies the initial National Language Support (NLS) settings for a session
    in the form of language_territory.character set. For example, a setting of:
    AMERICAN_DENMARK.WE8MSWIN1252

    You can query the actual NLS settings of your current session using:
    select * from nls_session_parameters;

    You might also like