How To Install Oracle Using Xmanager

Overview of Installing Oracle Database Software and Creating a DatabaseTo install your Oracle Database software, use Oracle Universal Installer (OUI). OUI is a graphical user interface utility that enables you to install new Oracle Database software. Online Help is available to guide you through the installation process.During the installation process, you are given the opportunity to create a database.

If you choose to do so, then OUI automatically starts Oracle Database Configuration Assistant (DBCA) to guide you through the process of creating and configuring a database.Before you start the installation process, see the following sections for information about prerequisites and installation choices:.If you do not create a database during installation, then you must run DBCA at some point after installation to create a database. Checking PrerequisitesBefore installing the software, OUI performs several automated checks to ensure that your computer fulfills the basic hardware and software requirements for an Oracle Database installation. If your computer does not meet a requirement, then an error message is displayed. The requirements may vary depending upon the type of computer and operating system you are using, but some prerequisites include:.There is a minimum of 1 GB of physical memory.Sufficient paging space is available.The appropriate service packs or patches for your operating system are installed.An appropriate file system format is being used.

Install OptionsYou can choose to create and configure a database, or to only install the database software.You can create a preconfigured database or a custom-configured database during installation. If you choose not to create a database during installation, then you must run DBCA after installation to create a database.Preconfigured databases are based on templates that Oracle provides or that you create. Each Oracle-provided template is optimized for a particular workload type. See for information about the types of preconfigured databases.If you choose to use the Desktop Class installation method, then the general purpose database template is used. To create a custom database in which you configure your own database structure, see. Installation MethodThe installation methods are divided into Desktop Class and Server Class:.Desktop Class—This installation class is most appropriate for laptop or desktop computers.

It includes a starter database and requires minimal configuration.Server Class—This installation class is for servers, such as you would find in a data center, or used to support enterprise-level applications. Choose this installation class if you need access to advanced configuration options.During a Desktop Class installation, you make only basic choices. For a Server Class installation, you choose either typical installation (where you make only basic choices) or advanced installation.During a Desktop Class or a typical installation, Oracle Database automatically installs the sample schemas. Installation TypeWhen you install Oracle Database during basic and advanced installations, you need answers for the questions listed in this section. OUI provides default values for every choice.What type of database edition installation do you want to perform?Your choices are:.Enterprise Edition—This installation type is the full-featured Oracle Database product that provides data management for enterprise-level applications. It is intended for mission-critical, high-security online transaction processing (OLTP) and data warehousing environments.Standard Edition—This installation type is suitable for workgroup or department-level applications, and for small to medium-sized enterprises.

It provides core relational database management services and options and includes an integrated set of management tools, replication, Web features, and facilities for building business-critical applications.Standard One Edition—This installation type is suitable for workgroup, department, or web applications. It provides core relational database management services for single-server environments or highly distributed branch environments. Oracle Standard Edition One includes all the facilities necessary to build business-critical applications.Personal Edition (Microsoft Windows operating systems only)—This installation type installs the same software as the Enterprise Edition, but supports only a single-user, development and deployment environment.What are your database configuration options? Software Installation DirectoriesYou must specify the directory in which the Oracle Database software is installed, or the location where the product binary files are copied from the installation media. You must choose a location that has enough disk space to contain the software and is accessible by the operating system user performing the installation.You also specify the location of the Oracle base directory, which is used by all Oracle software products installed on the server. The first time you install Oracle Database software on a server, you are prompted to specify the location of the inventory directory, called oraInventory.

This directory provides a centralized inventory of all Oracle software products installed on the server. You should use the same value for the Oracle inventory directory each time you perform an Oracle software installation on the server. Database File LocationA database includes several files that store the user data, database metadata, and information required to recover from failures. As an administrator, you decide what kind of storage subsystem to use for these files.

You can select from the following options:.File System—This default option creates database files that are managed by the file system of your operating system. You can specify the directory path where database files are to be stored. Oracle Database can create and manage the actual files.If you are not certain about which option to use, then select File System (the default).Automatic Storage Management—This option enables you to place your data files in Oracle Automatic Storage Management (Oracle ASM) disk groups. If you choose Oracle ASM, then Oracle Database automatically manages database file placement and naming. For environments with a large number of disks, this option simplifies database administration and maximizes performance. Oracle ASM performs software striping and mirroring at the file level for maximum storage flexibility, performance, and availability.Oracle ASM uses an Oracle ASM instance, which is distinct from the database instance, to configure and manage disk groups. A single Oracle ASM instance can provide storage for multiple databases on the same server.For more information, see.

Database IdentifiersThese options include your global database name and system identifier (SID). The SID is a unique identifier that is used to distinguish this instance from other Oracle Database instances that you may create later and run concurrently on your system.The global database name is the full name of the database that uniquely distinguishes it from any other database. The global database name is in the form databasename.databasedomain, for example sales.example.com. The database name portion sales is a simple name you call your database.

The database domain portion example.com specifies the database domain in which the database is located. Together, the database name and domain form the global database name. About Advanced InstallationDuring advanced installations using the Server Class method you are prompted to make the additional choices listed in this section, and the choices for a typical installation.

The installation process provides default values for every choice.This guide describes, but does not document, these additional advanced installation choices. For more information, see for your platform.Product LanguagesYou choose which language the software should use after it is installed.

You can select multiple languages. The default value is English. If you choose a value other than English, it does not change the language used by the installation.Database Configuration TypeYou select a template to use when configuring the database. You can choose either either General Purpose/Transaction Processing or Data Warehousing.Database Configuration OptionsYou can choose how to configure the database created by the installer.

You can select the memory size and management options, the character sets used to store data, the security options for database access, and whether the sample schemas should be installed.To complete the exercises in this guide and related course material, you must install the sample schemas. This data is also used in most examples throughout Oracle Database documentation. Oracle recommends that you install the sample schemas.This choice is a configuration option only during advanced installation. Sample schemas are installed by default during typical or Desktop class installations.Database Management OptionsYou specify whether to manage your database centrally or locally using Oracle Enterprise Manager. Central management enables you to manage multiple targets, such as databases and application servers, using a single interface. Using local management you can manage only a single database instance at a time.To use central management, you must have an Oracle Enterprise Management agent on each host, or computer that has Oracle Database software installed on it. These agents are responsible for monitoring all components on that host.

If an agent is not found on the local host, then this option is disabled during installation.If you are setting up a single database for the first time, then it is recommended that you configure local management with Oracle Enterprise Manager, which is the default. You can later install additional databases and configure central management using Enterprise Manager.Recovery OptionsYou specify whether automated backups should be configured for the database. If you choose this option, you must specify whether the recovery area should be stored on the local file system or in an Oracle ASM disk group. You must also specify the operating system credentials the backup job uses when performing backups.

Note:To use Oracle ASM for recovery area storage, you must have installed Oracle ASM as part of an Oracle grid infrastructure installation and created one or more disk groups before performing the Oracle Database installation.Schema PasswordsWhen you create a database, certain administrative user accounts are created automatically. You are prompted to enter the passwords for the SYS, SYSTEM, SYSMAN, and DBSNMP accounts, which enable you to manage and administer the database. You can use the same password for each account, or specify passwords for each account individually. If you do not enter a secure password, you will receive a warning message during installation.Operating System GroupsAdministrative access to the database is granted by membership in certain operating system groups. You can choose the operating system group to be used for SYSDBA access (typically dba) and SYSOPER access (typically oper).The SYSDBA group identifies operating system user accounts that have database administrative privileges and can log in with SYSDBA access. The SYSOPER group is an optional group for users that should have limited database administrative privileges. See for more information about these groups and privileges.

Note:The following steps describe the Oracle Universal Installer workflow for a host computer that has no previous Oracle software installed. Note:With Oracle Database, you typically have a single database that hosts multiple applications. You do not need multiple databases to run different applications.

Instead, you separate the objects that support each different application into different schemas in the same database. However, there may be situations in which you want to create multiple Oracle databases on the same host computer. When you do this with DBCA, the new databases typically use the same Oracle home directory as the first database, but store database data files separately from those of the first database.DBCA also enables you to modify a database configuration, delete a database, and more. This section describes the following DBCA tasks:.Online Help is available by clicking Help. It provides information that guides you in selecting configuration options. Step 2 - Database TemplatesThis window enables you to select the type of database to create. You can use DBCA to create a database from templates supplied by Oracle or from templates that you create. The templates contain settings optimized for a particular type of workload.Oracle ships templates for the following two workload types:.General purpose or transaction processing.Data warehouseClick Show Details to see the configuration for each type of database.

Select the template suited to the type of workload your database will support. If you are not sure which to choose, then select the default General Purpose or Transaction Processing template.For more complex environments, you can select the Custom Database option. This option does not use templates and results in a more extensive interview, which means that it takes longer to create your database.For more information about using database templates, see. Step 4 - Management OptionsUse this window to set up your database so it can be managed with Oracle Enterprise Manager. Oracle Enterprise Manager provides Web-based management tools for individual databases, and central management tools for managing your entire Oracle environment.Select Configure Enterprise Manager to use Enterprise Manager.

Then, select one option:.If the Oracle Management Agent is installed on your host computer, then you can choose central management by selecting Register with Grid Control for centralized management and then selecting the Management Service.To manage your database locally, select Configure Database Control for local management. You can then optionally configure e-mail notification of database alerts or a daily backup of the database. Step 6 - Database File LocationsIn this window, specify the type of storage you would like your database to use. For more information, see.Then specify the locations for the Oracle database files. Select one of the following options:.Use Database File Locations from Template—This option instructs DBCA to use the directory information as specified in the template.

Later, you can make modifications to database file names and locations.Use Common Location for All Database Files—This option requires you to specify a new directory for the Oracle home. All the database files are created in this location. Later, you can make modifications to database file names and locations.Use Oracle Managed Files—This option instructs Oracle Database to directly manage operating system files comprising an Oracle database.

You specify the default location, called a database area, for all your files. Oracle Database thereafter automatically creates and deletes files in this location, as required. You can also create multiple copies of your redo and online log files by selecting Multiplex Redo Logs and Control Files.

To learn more about online redo log files and control files, see.Selecting this option enables you to delegate the complete management of database files to the database. You no longer have to specify the file names, their location, or their sizes.

Step 7 - Recovery ConfigurationWhen you create a new database, it is important to configure the database so you can recover your data if a system failure occurs. Online redo log files contain a record of changes that were made to data files. Online redo log files are stored in online redo log groups. You must have at least two online redo log groups for your database. After the online redo log files in a group have filled up, the log writer process (LGWR) switches the writing of redo records to a new online redo log group. Oracle Database can automatically save the inactive group of online redo log files to one or more offline destinations, known collectively as the archived redo log (also called the archive log).

The process of turning online redo log files into archived redo log files is called archiving.Archiving can be performed only if the database is running in ARCHIVELOG mode. A group of online redo log files cannot be reused by the log writer (LGWR) process until the group is archived.

If the database is running in NOARCHIVELOG mode, then when a group becomes inactive after the LGWR process switches to a new group, the inactive group is available for immediate reuse by the LGWR process.The NOARCHIVELOG mode protects a database from instance failure but not from media failure. Only the most recent changes made to the database, which are stored in the online redo log files, are available for instance recovery. To restore a database operating in NOARCHIVELOG mode, you can use only entire database backups taken while the database is closed.

Step 8 - Database ContentWhen you create your database, you can load it with data using either of the following methods:.Sample Schemas—Select Sample Schemas to include the Sample Schemas ( EXAMPLE) tablespace in your database. Oracle guides and educational materials contain examples based upon the Sample Schemas. Oracle recommends that you include them in your database.Custom Scripts—In the Custom Scripts subpage, optionally specify one or more SQL scripts to run after your database is created. Scripts are useful for performing postinstallation tasks, such as loading custom schemas. Note that if you choose to run scripts after installation, then your scripts must include a connection string that identifies the database. Click Help for more information.

MemoryUse this window to set the initialization parameters that control how the database manages its memory. You can choose from the following methods for memory management:.Typical—This method requires little configuration, and allocates memory as a percentage of total overall physical system memory. Select Typical and enter a percentage value. Click Show Memory Distribution to see how much memory DBCA assigns to the System Global Area (SGA) and the aggregate Program Global Area (PGA).

With this setting, the system automatically tunes many of the memory components of the SGA, and allocates memory to individual PGAs as needed. The system can also dynamically decrease or increase the total amount of memory allocated to the SGA or aggregate PGA, depending on processing demands. The total memory used for the database instance never exceeds the amount you specify. This automatic memory tuning for the instance is known as automatic memory management.

To learn more about PGA and SGA, see.Custom—This method requires more configuration than the Typical option, but gives you more control over how the database instance uses system memory. This option is meant for more experienced database administrators. You can directly specify memory sizes for the SGA and aggregate PGA and their substructures, such as the shared pool and buffer cache.Select one of the following options for customized memory management:.Automatic Shared Memory Management to allocate specific amounts of memory to the SGA and aggregate PGA. With this setting, automatic shared memory management is enabled for the SGA, and memory is allocated to the individual PGAs as needed.Manual Shared Memory Management to enter specific values for each SGA component and the aggregate PGA. This disables automatic shared memory management and enables you to determine how the SGA memory is distributed among the SGA memory components. SizingIn this tab, you specify the smallest block size and the maximum number of operating system user processes that can simultaneously connect to the database.Block Size—Use this list to select the block size, or accept the default.

Oracle Database data is stored in data blocks of the size specified. One data block corresponds to a specific number of bytes of physical space on disk.

Selecting a block size other than the default 8 kilobytes (KB) value requires advanced knowledge and should be done only when absolutely required.While using predefined templates, this list is not enabled because the database will be created with the default block size of 8 KB. While using the custom option, you can change the block size.Processes—In this field, specify the maximum number of processes that can simultaneously connect to the database. Enter a number or accept the default value of 150. The default value for this parameter is appropriate for many environments. The value you select should allow for all background processes, user processes, and parallel execution processes.

Character SetsUse this tab to define the character sets used by your database. Character sets are the encoding schemes used to display characters on your computer screen. The character set determines what languages can be represented in the database.Oracle recommends using Unicode (AL32UTF8) as the database character set. AL32UTF8 is Oracle's name for the UTF-8 encoding of the Unicode standard.

The Unicode standard is the universal character set that supports most of the currently spoken languages of the world. The use of the Unicode standard is indispensable for any multilingual technology, including database processing.After a database is created and accumulates production data, changing the database character set is a time consuming and complex project. Therefore, it is very important to select the right character set at installation time. Even if the database does not currently store multilingual data but is expected to store multilingual data within a few years, the choice of AL32UTF8 for the database character set is usually the only good decision.Even so, the default character set used by Oracle Universal Installer (OUI) and Database Configuration Assistant (DBCA) for the UNIX, Linux, and Microsoft Windows platforms is not AL32UTF8, but a Microsoft Windows character set known as an ANSI code page.

The particular character set is selected based on the current language (locale) of the operating system session that started OUI or DBCA. If the language is American English or a Western European language, then the default character set is WE8MSWIN1252.

Each Microsoft Windows ANSI Code Page can store data from only one language or a limited group of languages, such as only Western European, or only Eastern European, or only Japanese.A Microsoft Windows character set is the default even for databases created on UNIX and Linux platforms because Microsoft Windows is the prevalent platform for client workstations. Oracle Client libraries automatically perform the necessary character set conversion between the database character set and the character sets used by non-Windows client applications.You may also choose to use any other character set from the presented list of character sets. You can use this option to select a particular character set required by an application vendor, or choose a particular character set that is the common character set used by all clients connecting to this database.Because AL32UTF8 is a multibyte character set, database operations on character data may be slightly slower when compared to single-byte database character sets, such as WE8MSWIN1252. Storage space requirements for text in most languages that use characters outside of the ASCII repertoire are higher in AL32UTF8 compared to legacy character sets supporting the language. Note that the increase in storage space concerns only character data and only data that is not in English. Note:AL32UTF8 is a variable-width multibyte character set. Applications connecting to a database that uses AL32UTF8 for character data processing must be correctly programmed to work with such character sets.

Always verify the character set requirements of the applications that use the database. Contact the application vendor and ask for a Unicode-capable version, if your current application version does not support the Unicode standard.National Character Set—In this list, select a character set or accept the default. The national character set, also called NCHAR character set, is the character set used to store and process data of data types NVARCHAR2, NCHAR, and NCLOB. These data types allow storing of Unicode characters in a database that does not have a Unicode database character set.

Unless installation requirements of any of your applications specify otherwise, accept the default value of AL16UTF16 as the national character set. Note:Although this character set is called 'national,' after the SQL standard (ISO/IEC 9075), it is not better suited to support globalized applications than the database character set. Because working with national character set data requires additional API calls in client applications, and because national character set data is not supported by some database components, such as Oracle Text, Oracle recommends that multilingual applications use VARCHAR2, CHAR, and CLOB data types and an Oracle database with the database character set AL32UTF8.Default Language—In this list, select a default database language or accept the default.

The default language determines how the database supports locale-sensitive information such as day and month abbreviations, default sorting sequence for character data, and reading direction (left to right or right to left).Default Territory—In this list, select the name of the territory whose conventions are to be followed for day and week numbering or accept the default. The default territory also establishes the default date format, the default decimal character and group separator, and the default International Standardization Organization (ISO) and local currency symbols.

For example, in the United Kingdom, the default date format is DD-MON-YYYY, where DD is the day of the month (1-31), MON is the abbreviated name of the month, and YYYY is the 4-digit year. Connection ModeUse this window to select the database mode.

You can run the database in either of the following modes:.Dedicated Server Mode—This mode allows a dedicated server process for each user process. Select this option when the number of total clients is expected to be small, for example, 50 or fewer. You might also choose this option when database clients typically make persistent, long-running requests to the database. By default, the database is configured for dedicated server processes.Shared Server Mode—This mode allows several client connections to share a database-allocated pool of resources. Use this mode in configurations in which client load is expected to cause a strain on memory and other system resources. If you choose shared server mode, then you must indicate the number of server processes you want to create when a database instance is started. For more information about setting this parameter, click Help.

How To Install Oracle 10g On Windows

Step 11 - Creation OptionsIn this window, select any of the following options for creating the database:.Create Database—Select this option to create your database now.Save as a Database Template—Select this option to save the database definition as a template to use at a later time.Generate Database Creation Scripts—Select this option to generate a SQL database creation script that you can run at a later time.After you make your choice, click Finish. A confirmation window appears after a short period. Review the Create Database Summary information, then click OK to proceed. Changing the Configuration of a Database Using DBCAYou can use DBCA to change the configuration of an existing database.

For example, you can:.Register the database with Grid Control.Configure Database Control alert notification via e-mail.Enable daily disk backups to the recovery area.Change default security settings.Change server mode from dedicated to shared, or the reverse.Add database options that were not previously configured (for example, Oracle Label Security or Oracle OLAP)To change the configuration of a database using DBCA:.Start DBCA as described in.In the Operations window, select Configure Database Options and click Next.Follow the instructions in the DBCA guided workflow. Managing Templates with DBCADBCA templates are XML files that contain information required to create a database. Templates are used in DBCA to create new databases and duplicate existing databases.

The information in templates includes database options, initialization parameters, and storage attributes (for data files, tablespaces, control files, and online redo log files).Templates can be used just like scripts, but they are more powerful than scripts because you have the option of duplicating a database. Duplication saves time because you copy the files of an existing database, referred to as a seed database, to the correct locations.Templates are stored in the following directory: ORACLEHOME/assistants/dbca/templates.

Table 2-1 DBCA Template Types TypeFile ExtensionIncludes Data FilesDatabase StructureSeed.dbcYesThis type of template contains both the structure and the physical data files of an existing database, referred to as the seed database. Your new database starts as a copy of the seed database, and requires only the following changes:.Name of the database.Destination of the data files.Number of control files.Number of online redo log groups.Initialization parametersOther changes can be made after database creation using custom scripts that can be invoked by DBCA, command-line SQL statements, or Oracle Enterprise Manager Database Control.The data files for the seed database are stored in compressed RMAN backup format in a file with a.dfb extension. The seed database control file is stored in a file with.ctl extension. (This file is needed only when storing data files in Oracle Automatic Storage Management (Oracle ASM) disk groups or as Oracle Managed Files.) The.dbc file contains the location of the seed database data files and contains the source database name used to mount the control file.Nonseed.dbtNoThis type of template is used to create a new database.

It contains the characteristics of the database to be created. Nonseed templates are more flexible than their seed counterparts because all data files and online redo log files are created to your specification, and names, sizes, and other attributes can be changed as required. Table 2-2 Oracle-Provided DBCA Templates and Their Corresponding Workloads TemplateWorkloadData warehouseUsers perform numerous, complex queries that process large volumes of data. Response time, accuracy, and availability are key issues.These queries ( SELECT statements) range from a fetch of a few records to queries that sort thousands of records from many different tables.General Purpose or Transaction processingMany concurrent users perform numerous transactions that require rapid access to data.

Availability, speed, concurrency, and recoverability are key issues.Transactions consist of reading ( SELECT statements), writing ( INSERT and UPDATE statements), and deleting ( DELETE statements) data in database tables.Custom databaseThis template allows you maximum flexibility in defining a database because you can change any of the settings for the database being created. Creating Templates Using DBCAFollow the instructions in this section to create your own templates.To create templates:.Start DBCA as described in.In the Operations window, select Manage Templates and click Next.In the Template Management window, select Create a database template and one of the following options, and click Next.From an existing templateUsing an existing template, you can create a new template based on the predefined template settings. You can add or change any template settings such as initialization parameters, storage parameters, or whether to use custom scripts.From an existing database (structure only)You can create a new template that contains structural information from an existing database, including database options, tablespaces, data files, and initialization parameters.

User-defined schemas and their data will not be part of the created template. The source database can be either local or remote. Select this option when you want the new database to be structurally similar to the source database, but not contain the same data.From an existing database (structure as well as data)You can create a new template that has both the structural information and physical data files of an existing database.

Databases created using such a template are identical to the source database. User-defined schemas and their data will be part of the created template. The source database must be local.

Select this option when you want a template from which you can create an exact replica of the source database.When creating templates from existing databases, you can translate file paths into Optimal Flexible Architecture (OFA) or maintain existing file paths. OFA is a set of file naming and placement guidelines for Oracle software and databases. Using OFA is recommended if the target computer on which you plan to create a database using the template has a different directory structure than computer on which the template was defined.

Standard file paths can be used if the target computer has a directory structure that is similar to the directory structure on the source computer.Follow the instructions in the DBCA guided workflow to create your template.