This chapter covers the following topics:
The Oracle Database software is available on installation media or you can download it from the Oracle Technology Network (OTN) Web site. In most cases, you use the graphical user interface (GUI) provided by Oracle Universal Installer to install the software. However, you can also use Oracle Universal Installer without the GUI by supplying a response file with silent or noninteractive mode.
Note:
Windows Server 2008 and Windows Server 2008 R2 require Administrator privileges at the command prompt.See Also:
"Managing User Accounts with User Account Control on Windows Server 2008 and Windows Server 2008 R2"Complete the requirements described in Chapter 2, "Oracle Database Preinstallation Requirements" and "Reviewing Component-Specific Installation Guidelines" before you begin the installation.
Next, consider the following issues:
Following are the installation considerations on Windows Server 2008 and Windows Server 2008 R2:
Open a command prompt with Administrator privileges.
Use the separate installation media available for Windows Server 2008 and Windows Server 2008 R2.
If you must perform multiple installations of Oracle Database, then you may want to use either of the following methods to install Oracle Database:
Response files: At each node, you run Oracle Universal Installer from the command line using silent or noninteractive mode and you supply a response file to provide information Oracle Universal Installer needs. The response file is a text file containing the settings you normally enter in the Oracle Universal Installer GUI dialog boxes.
Cloning the Oracle home of an existing Oracle Database installation: With this method, you install one instance of Oracle Database, and then clone its Oracle home for each additional installation.
See Also:
"Cloning an Oracle Home"See Also:
"Upgrade Considerations" before running Oracle Universal Installer
"Pre-Installation Tasks for Installing Oracle Real Applications Clusters on Windows-Based Systems" in Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide before running Oracle Universal Installer
Follow these steps when other components exist on your computer:
Log on as a member of the Administrators group for the computer on which you want to install Oracle components.
If you are installing on a Primary Domain Controller (PDC) or a Backup Domain Controller (BDC), log on as a member of the Domain Administrators group.
Delete the ORACLE_HOME
environment variable if it exists. See the Microsoft online help for more information about deleting environment variables.
Back up any databases you must upgrade. Review "Upgrade Considerations".
If you are installing in an existing Oracle Database 10g release 2 (10.2) home, stop all Oracle services.
If any Oracle services (their names begin with Ora) exist and have the status Started, then stop them. In particular, ensure that all Oracle listener services are stopped.
See Also:
Your Microsoft online help for more information about stopping servicesInstallations of Oracle Database on computers with 1 GB of RAM and 2 GB of virtual memory have the following limitations:
Computers with 256 MB of memory cannot run Oracle Database Upgrade Assistant, Oracle Database Configuration Assistant, or Oracle Net Services Configuration Assistant during an Oracle Universal Installer installation session.
Depending on how many applications are being run on the computer, you must further increase the paging file size or reduce the size of the System Global Area (SGA) if you run out of virtual memory. If temporary files and the paging file are both stored on the same physical drive, the space requirements for one may limit the size of another. If your system has limited free space, first install the Oracle Database software. After the installation is finished, create a database with Oracle Database Configuration Assistant.
Do not install the database on computer systems that barely meet the minimum memory and virtual memory requirements, 256 MB and 512 MB respectively. Depending on the installation type you choose, follow these guidelines:
Select Basic Installation and deselect Create Starter Database.
Select Advanced Installation, select Do not create a starter database from the Select Database Configuration window.
Select Advanced Installation, select the Custom installation type from the Select Installation Type window, and select No on the Create Database window when prompted to create the database.
Cancel Oracle Database Configuration Assistant from the Configuration Assistants window.
After installation, run the appropriate configuration assistant for your needs:
To create a new database, run Oracle Database Configuration Assistant. From the Start menu, select Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools, then Database Configuration Assistant.
To upgrade an existing database, run Oracle Database Upgrade Assistant. From the Start menu, select Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools, then Database Upgrade Assistant.
Review the following guidelines before starting Oracle Universal Installer:
Do not use Oracle Universal Installer from an earlier Oracle release to install components from this release.
If Oracle Clusterware or Oracle Real Application Clusters is installed on the system, Oracle Universal Installer displays the Specify Hardware Cluster Installation Mode window. You must select Local Installation on this window, unless you want to install Oracle Real Application Clusters.
See Also:
Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for your platform, available on the Oracle Clusterware installation mediaProducts not installed by default: select Advanced Installation and then the Custom installation type. These products are:
To configure Oracle Label Security to use Oracle Internet Directory, choose the Oracle Internet Directory option when running Oracle Database Configuration Assistant. If you are installing Oracle Label Security in an existing Oracle home, then shut down each database in the Oracle home.
If you reinstall Oracle software into an Oracle home directory where Oracle Database is installed, you must also reinstall any components, such as Oracle Partitioning, that were installed before you began the reinstallation.
The Oracle Database software is available on installation media, or you can download it from the Oracle Technology Network (OTN) Web site. You can access and install Oracle Database by using the following scenarios:
Installing on Remote Computers Through Remote Access Software
Downloading Oracle Software from the Oracle Technology Network Web Site
If the computer where you want to install Oracle Database does not have a DVD drive, then you can perform the installation from a remote DVD drive. You must complete the following steps:
To use the remote DVD drive it must allow shared access. To set this up, perform these steps on the remote computer that has the DVD drive:
Log in to the remote computer as an Administrator user.
Start Windows Explorer.
Right-click the DVD drive letter and select Sharing (or Sharing and Security).
Click the Sharing tab and do the following:
Select Share this folder.
In Share name, give it a share name such as dvd
. You use this name when you map the DVD drive on the local computer. Under "Step 2: On the Local Computer, Map the DVD Drive" see Step d under Step 1.
Click Permissions. You need at least read permission for the user who will be accessing the drive to install Oracle Database.
Click OK when you are finished.
Insert the Oracle Database installation media into the DVD drive.
Perform these steps on the local computer to map a remote DVD drive and to run Oracle Universal Installer from the mapped drive:
Start Windows Explorer on the local computer.
From the Tools menu, select Map Network Drive to display the Map Network Drive dialog box.
Select a drive letter to use for the remote DVD drive.
In Folder, enter the location of the remote DVD drive using the following format:
\\remote_hostname\share_name
where:
remote_hostname
is the name of the remote computer with the DVD drive.
share_name
is the share name that you entered in Step 4 of the previous procedure. For example:
\\computer2\dvd
If you must connect to the remote computer as a different user, then click different user name, and enter the user name.
Click Finish.
Run Oracle Universal Installer from the mapped DVD drive.
Go to the "Installing the Oracle Database Software" section.
If you want to install and run Oracle Database on a remote computer (that is, the remote computer has the hard drive and runs Oracle Database components), but you do not have physical access to the computer, you still can perform the installation on the remote computer if it is running remote access software such as VNC or Symantec pcAnywhere. You also need the remote access software running on your local computer.
You can install Oracle Database on the remote computer in one of two ways:
If you have copied the contents of the Oracle Database DVD to a hard drive, you can install the software from the hard drive.
You can insert the DVD into a drive on your local computer, and install the software from the DVD.
If you have copied the contents of the Oracle Database DVD to a hard drive, you can install the software from the hard drive.
To install the software on a remote computer from a hard drive:
Ensure that the remote access software is installed and running on the remote and local computers.
Share the hard drive that contains the Oracle Database DVD.
On the remote computer, map a drive letter to the shared hard drive. You use the remote access software to do this on the remote computer.
Through the remote access software, run Oracle Universal Installer on the remote computer. You access Oracle Universal Installer from the shared hard drive.
Go to the "Installing the Oracle Database Software" section.
You can insert the DVD into a drive on your local computer, and install from the DVD.
To install the software on a remote computer from a remote DVD drive:
Ensure that the remote access software is installed and running on the remote and local computers.
On the local computer, share the DVD drive.
On the remote computer, map a drive letter to the shared DVD drive. You use the remote access software to do this on the remote computer.
These steps are described in the "Installing from a Remote DVD Drive" section.
Through the remote access software, run Oracle Universal Installer on the remote computer. You access Oracle Universal Installer from the shared DVD drive.
Go to the "Installing the Oracle Database Software" section.
You can download the installation files from the Oracle Technology Network (OTN) and extract them on your hard disk.
To download the installation files:
Use a browser to access the Oracle Technology Network software download page:
http://www.oracle.com/technology/software/
Navigate to each of the download pages for the product to install.
On each download page, identify the required disk space by adding the file sizes for each required file. The file sizes are listed next to the file names.
Select a file system with enough free space to store and expand the files. In most cases, the available disk space must be at least twice the size of each compressed file.
On the file system that you just selected, create a parent directory for each product you plan to install, for example OraDB10g
, to hold the installation directories.
Download all of the installation files to the directories that you just created.
Verify that the files you downloaded are the same size as the corresponding files on Oracle Technology Network.
Extract the files in each directory that you just created.
After you have extracted the required installation files, see the "Installing the Oracle Database Software" section.
To copy the contents of the installation media to a hard disk:
Create a directory on your hard drive. For example:
c:\> install\database
Copy the contents of the installation media to the directory that you just created.
After you have copied all of the required installation files, see the "Installing the Oracle Database Software" section.
In most cases, you use the graphical user interface (GUI) provided by Oracle Universal Installer to install Oracle Database. The instructions in this section explain how to run the Oracle Universal Installer GUI to perform most database installations.
See Also:
"Installing Automatic Storage Management" to install Oracle Database and use Automatic Storage Management
Appendix C, "Installing and Configuring Oracle Database Using Response Files" to install Oracle Database using response files and silent or noninteractive mode, without the GUI. It also explains how to clone an existing Oracle home. These methods are useful if you must perform multiple installations of Oracle Database.
To install the Oracle Database software:
Log on as a member of the Administrators group to the computer on which to install Oracle components.
If you are installing on a Primary Domain Controller (PDC) or a Backup Domain Controller (BDC), log on as a member of the Domain Administrators group.
If you are installing Oracle Database on a computer with multiple homes or multiple aliases, use System in the Control Panel to create the ORACLE_HOSTNAME
system environment variable. Set this variable to point to the host name of the computer on which you are installing Oracle Database.
Insert Oracle Database installation media and navigate to the database
directory. Alternatively, navigate to the directory where you downloaded or copied the installation files.
Use the same installation media to install Oracle Database on all supported Windows platforms.
Double-click setup.exe
to start Oracle Universal Installer.
In the Welcome window, select either Basic Installation or Advanced Installation, and then answer the prompts as needed.
See Also:
"Oracle Database Installation Methods" for more information about the Basic and Advanced installation methodsThe subsequent windows that appear, which are listed in Table 3-1, depend on the installation method you have chosen. The order in which the windows appear depends on the options you select.
Follow these guidelines to complete the installation:
Do not install Oracle Database 10g Release 2 (10.2) software into an existing Oracle home that contains Oracle9i or earlier software.
Follow the instructions displayed in the Oracle Universal Installer windows. If you need additional information, click Help.
When prompted for a password, follow these guidelines:
Make the password be between 8 and 30 characters long.
Use the database character set for the password's characters, which can include the underscore (_), dollar ($), and pound sign (#) characters.
Do not start passwords with a numeral.
Do not use a user name for a password.
Do not use Oracle reserved words for the password.
Do not use change_on_install
for the SYS
account password.
Do not use manager
for the SYSTEM
account password.
Do not use sysman
for the SYSMAN
account password.
Do not use dbsnmp
for the DBSNMP
account password.
If you choose to use the same password for all the accounts, do not use change_on_install
, manager
, sysman
, or dbsnmp
as a password.
Have the password include at least 1 alphabetic, 1 numeric, and 1 punctuation mark character
Do not use simple or obvious words, such as welcome, account, database, and user for the password.
Note:
You must remember the passwords that you specify.Do not modify the Java Runtime Environment (JRE) except by using a patch provided by Oracle Support Services. Oracle Universal Installer automatically installs the Oracle-supplied version of the JRE. This version is required to run Oracle Universal Installer and several Oracle assistants.
If you encounter errors while installing the software, see Appendix F for information about troubleshooting.
If you chose an installation type that runs Oracle Database Configuration Assistant and Oracle Net Configuration Assistant in interactive mode, you must provide detailed information about configuring your database and network.
If you need assistance when using the Oracle Database Configuration Assistant or Oracle Net Configuration Assistant in interactive mode, click Help on any window.
Note:
If you chose a default installation, Oracle Database Configuration Assistant and Oracle Net Configuration Assistant do not run interactively.When the configuration tools finish, click Exit, then click Yes to exit from Oracle Universal Installer.
When Oracle Enterprise Manager Database Control opens a Web browser, enter the user name and password you created during the installation.
You can log in as SYS
, SYSTEM
, or SYSMAN
. If you log in as SYS
, then you must connect as SYSDBA
. Enter the password you specified for the account during installation.
Optionally, delete the OraInstall
date_time
directory to remove the temporary files that were created during the installation process. The OraInstall
date_time
directory holds about 45 MB of files. This directory is created in the location set by the TEMP
environment variable setting.
Restarting your computer also removes the OraInstall
date_time
directory.
See Chapter 4, "Oracle Database Postinstallation Tasks" for information about tasks that you must complete after you have installed Oracle Database.
Table 3-1 Oracle Universal Installer Windows
Follow the procedures in this section to install and configure Automatic Storage Management (ASM), and to install Oracle Database so that it can use ASM. If you do not plan to use Automatic Storage Management, use the procedure in "Installing the Oracle Database Software" to install Oracle Database.
This section covers the following topics:
Step 1: Reviewing Automatic Storage Management Installation Considerations
Step 3: Installing Oracle Database to Use with Automatic Storage Management
Step 4: Testing the Automatic Storage Management Installation
When you install Automatic Storage Management, follow these guidelines:
Before you begin the installation, ensure that you have completed the steps in "Preparing Disk Groups for an Automatic Storage Management Installation" to prepare a disk partition to use for the ASM disk groups.
Oracle recommends that you install Automatic Storage Management into its own Oracle home, regardless of whether you plan to have one or multiple database instances. Installing Automatic Storage Management into its own Oracle home helps ensure higher availability and manageability.
With separate Oracle homes, you can upgrade Automatic Storage Management and databases independently, and you can deinstall database software without impacting the Automatic Storage Management instance. Ensure that the Automatic Storage Management instance version is the same or later than the Oracle Database version.
If an Automatic Storage Management instance does not exist and you select the Oracle Universal Installer option to install and configure Automatic Storage Management only, Oracle Universal Installer installs Automatic Storage Management in its own Oracle home.
Each computer that has one or more Oracle Database instances that use Automatic Storage Management must have one ASM instance. For example, if a computer has two Oracle Database instances that use ASM, you only need one ASM instance for that computer, to manage the two database instances that use ASM.
When you install Automatic Storage Management, Oracle Database Configuration Assistant creates a separate server parameter file (SPFILE
) and password file for the Automatic Storage Management instance.
The following steps explain how to create an ASM instance and an ASM disk group for storing the Oracle database files. You can create multiple disk groups for the ASM instance to manage, if you want. If you plan to use ASM for backup and recovery operations, Oracle recommends that you create a separate disk group for this purpose.
To install an ASM instance and configure its disk groups:
Log on as a member of the Administrators group to the computer on which to install Oracle components.
If you are installing on a Primary Domain Controller (PDC) or a Backup Domain Controller (BDC), log on as a member of the Domain Administrators group.
Insert Oracle Database installation media and navigate to the database
directory. Alternatively, navigate to the directory where you downloaded or copied the installation files. Double-click setup.exe
to start Oracle Universal Installer.
Use the same installation media to install Oracle Database on all supported Windows platforms.
In the Welcome window, select Advanced Installation and click Next.
See Also:
Table 3-1 for a detailed description of the windows used in this procedureIn the Select Installation Type window, select either Enterprise Edition, Standard Edition, or Personal Edition, and then click Next.
In the Specify Home Details window, enter an Automatic Storage Management-specific name and directory location for the ASM instance.
For example, you could change OraDB10g_home1
to OraDB10g+asm
for the ASM home, and DRIVE_LETTER
:\oracle\product\10.2.0\db_1
to DRIVE_LETTER
:\oracle\product\10.2.0\asm
.
Click Next.
In the Product-Specific Prerequisite Checks window, check for and correct any errors that may have occurred when Oracle Universal Installer checked your system. Then click Next.
In the Select Configuration Option window, select Configure Automatic Storage Management (ASM) and then specify and confirm the ASM SYS password. Then click Next.
In the Configure Automatic Storage Management window, enter the following settings:
This window lets you create the disk groups to use with the ASM instance. You must have an available partition to create disk groups.
Disk Group Name: Enter a name for the disk group.
Redundancy: Select one of the following choices to set the redundancy level for the disks within the disk group. If you do not specify a redundancy level, the disk group defaults to normal redundancy.
High: With this option, the contents of the disk group are three-way mirrored by default. To create a disk group with high redundancy, you must specify at least three failure groups (a minimum of three devices).
Normal: In a normal redundancy level, by default the data files of the disk group are two-way mirrored and the control files are three-way mirrored. You can choose to create certain files that are three-way mirrored or not mirrored. To create a disk group with normal redundancy, you must specify at least two failure groups (a minimum of two devices) for two-way mirroring.
External: If you select this option, Automatic Storage Management does not mirror the contents of the disk group. Choose this redundancy level when the disk group contains devices, such as RAID devices, that provide their own data protection; or your use of the database does not require uninterrupted access to data, for example, in a development environment where you have a suitable backup strategy.
Add Disks: Click Stamp Disks to start the asmtoolg
GUI tool. In the asmtool
operation dialog box, select Add or change label, and then click Next. From the list, select the disks to use for the disk group. To select multiple disks, hold down the Control key and click to pick individual disks, or hold down the Shift key to select disks in a group. To use a specific prefix for this disk group, select Generate stamps with this prefix and enter a name. Click Next, and in the next window, click Finish.
After you click Finish, the Configure Automatic Storage Management window returns, with the disks you selected in the Add Disks list. From this list, select the disks you want to include in the disk group. To filter the display of disks, you can select Change Disk Discovery Path and enter a wildcard subset. For example, to list all disks ending with ORCLDISKDATA
from 0
to 3
, you enter \\.\ORCLDISKDATA[0–3]
.
Click Next.
In the Install window, check the installed contents, and then click Install.
To create another disk group for this instance, run Oracle Database Configuration Assistant and select the Configure Automatic Storage Management option.
At this stage, subsequent databases that you create are able to use Automatic Storage Management. If you have databases that were created before you installed ASM, you now can migrate them to ASM by using the Enterprise Manager Migrate Database wizard. This wizard is available in Enterprise Manager Grid Control or Database Control. Alternatively, you can use Oracle Database Recovery Manager (RMAN) to perform the migration.
See Also:
Enterprise Manager Migrate Database wizard online Help instructions on how to migrate an existing Oracle database to Automatic Storage Management
Oracle Database Backup and Recovery Advanced User's Guide for information about migrating an existing Oracle database to Automatic Storage Management using Oracle Database Recovery Manager.
After you have created the ASM instance and ASM disk groups, you are ready to create a database instance that can use Automatic Storage Management.
Log on as a member of the Administrators group to the computer on which to install Oracle components.
If you are installing on a Primary Domain Controller (PDC) or a Backup Domain Controller (BDC), log on as a member of the Domain Administrators group.
If you are installing Oracle Database on a computer with multiple home or multiple aliases, use System in the Control Panel to create the ORACLE_HOSTNAME
system environment variable. Set this variable to point to the host name of the computer on which you are installing Oracle Database.
Start Oracle Universal Installer.
In the Welcome window, select Advanced Installation and click Next.
See Also:
Table 3-1 for a detailed description of the windows used in this procedureIn the Select Installation Type window, select from the installation types (Enterprise Edition, Standard Edition, Personal Edition, or Custom), and then click Next.
In the Specify Home Details window, select a different Oracle home from the home used for Automatic Storage Management.
If you selected the Custom installation type, select from the products to install.
In the Product-Specific Prerequisite Checks window, check for and correct any errors that may have occurred when Oracle Universal Installer checked your system. Then, click Next.
In the Select Configuration Option window, select Create a Database.
In the Select Database Configuration window, select from the database types displayed and click Next.
In the Specify Database Configuration Options window, enter the following settings and then click Next.
Database Naming: Enter a name for the database.
Database Character Set: Select the database character set to use. The default offered is based on the character set that your operating system uses.
Database Examples: Select this option to create the EXAMPLE
tablespace, which contains sample schemas. (Optional, but recommended)
In the Select Database Management Option window, select either Use Grid Control for Database Management if you have Oracle Enterprise Manager installed, or if you do not have Enterprise Manager, select Use Database Control for Database Management. Optionally, select Enable Email Notifications and then enter the outgoing SMTP server and e-mail address. Then, click Next.
After you complete the installation, you can use either of these utilities to manage the Automatic Storage Management instance.
In the Specify Database Storage Option window, select Automatic Storage Management (ASM) and click Next.
In the Specify Backup and Recovery Options window, select the following:
Enable Automated Backups: Select this option, and then select Automatic Storage Management.
Backup Job Credentials: Enter the user name and password of the person responsible for managing backups.
Click Next.
In the Select ASM Disk Group window, select the ASM disk group that you created in "Step 2: Creating the ASM Instance and ASM Disk Groups" for recovery and backups.
If the ASM disks that you selected do not provide enough space, the Configure Storage Management window appears so that you can select additional disks as needed. As you select the disks, the Required Storage Space area adjusts the sizes displayed. Ideally, the Additional Space Needed value is a negative number.
Click Next.
In the Specify Database Schema Passwords window, enter and confirm passwords for the privileged database accounts, then click Next.
In the Summary window, check that the contents to be installed are correct, and then click Install.
To test the Automatic Storage Management installation, try logging on to the ASM instance by using SQL*Plus or iSQL*Plus.
Follow these steps:
In the Services Control Panel, ensure that the OracleASMService+ASM
service has started.
Open a Windows command prompt and temporarily set the ORACLE_HOME
and ORACLE_SID
to point to your ASM instance.
For example, if the ASM SID, which is named +ASM
, is located in the asm
directory under the ORACLE_BASE
directory, you would enter commands similar to the following:
SYSTEM_DRIVE:\> set ORACLE_SID = +ASM SYSTEM_DRIVE:\> set ORACLE_HOME = c:\oracle\product\10.2.0\asm
From the same Windows command prompt session, connect to the ASM instance as the SYS
user with SYSDBA
privilege and start the instance if necessary:
SYSTEM_DRIVE:\> sqlplus sys/SYS_password as sysdba SQL> STARTUP
Enter the following command to view the existing disk groups, their redundancy level, and the amount of free disk space in each one:
SQL> SELECT NAME,TYPE,TOTAL_MB,FREE_MB FROM V$ASM_DISKGROUP;
See Also:
Oracle Database Utilities for more information about the asmcmd
utility
"Managing Automatic Storage Management" for other tools that you can use to manage ASM
Oracle Database Administrator's Guide for a more detailed description of Automatic Storage Management
You can copy an existing Oracle home and then configure it for a new environment. This process is called cloning. If you are performing multiple Oracle Database installations, you may want to use this method to create each new Oracle home, because copying files from an existing Oracle Database installation takes less time than creating a new version of them. This method is also useful if the Oracle home that you are cloning has had patches applied to it. When you clone an Oracle home, the new Oracle home has the patch updates.
Note:
In addition to cloning an Oracle home, you can clone individual Oracle databases, by using Enterprise Manager Database Control. Oracle Database Administrator's Guide covers cloning Oracle databases in detail and cloning Oracle homes.To clone an Oracle home:
Ensure that the Oracle Database installation whose home you want to clone has been successful.
You can check the success of the installation by reviewing the installActions
date_time
.log
file for the installation session, which is normally located in the c:\Program Files\Oracle\Inventory\logs
directory.
If you have installed patches, you can check their status by running the following commands at a command prompt:
c:\ORACLE_BASE\ORACLE_HOME\OPatch> set ORACLE_HOME = ORACLE_HOME_using_patch c:\ORACLE_BASE\ORACLE_HOME\OPatch> opatch lsinventory
Stop the Oracle-related services on this computer.
You can stop Oracle services by using one of the following methods:
Oracle Administration Assistant for Windows: From the Start menu, select Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools, then Administrative Assistant for Windows.
Microsoft Windows Services utility: From the Start menu, select Programs, then Administrative Tools, then Services. Right-click any service that begins with Oracle, and then from the menu, select Stop.
Create a ZIP file with the Oracle home (but not Oracle base) directory, selecting the Save full path info option.
For example, if the source Oracle installation is in c:\oracle\product\10.2.0\db_1
, you would zip the db_1
directory, leaving out the admin
, flash_recovery_area
, and oradata
directories that are under 10.2.0
. These directories are created in the target installation later on when you create a new database there.
Copy the ZIP file to the root directory of the target computer.
Extract the ZIP file contents, selecting the Use folder names option.
Repeat Steps 4 and 5 for each computer where you want to clone the Oracle home, unless the Oracle home is on a shared storage device.
In the source Oracle home, restart the services that you stopped in Step 2.
On the target computer, cd
to the unzipped Oracle home directory, and perform the following steps:
Remove the *.ora
files that are present in unzipped ORACLE_BASE
\
ORACLE_HOME
\network\admin
directory, such as listener.ora
, sqlnet.ora
, and tnsnames.ora
.
From the oui\bin
directory, run Oracle Universal Installer in clone mode for the unzipped Oracle home. Use the following syntax:
c:\ORACLE_BASE\ORACLE_HOME\oui\bin> setup.exe -silent -clone ORACLE_HOME="target location" ORACLE_HOME_NAME="unique_name_on node" [-responseFile full_directory_path]
For example:
c:\ORACLE_BASE\ORACLE_HOME\oui\bin> setup.exe -silent -clone ORACLE_HOME="c:\oracle\product\10.2.0\db_1" ORACLE_HOME_NAME="db_1"
The -responseFile
parameter is optional. You can supply clone-time parameters on the command line or by using the response file named on the command line.
Oracle Universal Installer starts, and then records the cloning actions in the cloneActions
timestamp
.log
file. This log file is normally located in c:\Program Files\Oracle\Inventory\logs
.
To create a new database for the newly cloned Oracle home, run Oracle Database Configuration Assistant.
To start Oracle Database Configuration Assistant, select Start, then Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools, and then Database Configuration Assistant.
To configure connection information for the new database, run Net Configuration Assistant.
To start Net Configuration Assistant, select Start, then Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools, and then Net Configuration Assistant.
See Also:
Oracle Database Administrator's Guide for information about cloning Oracle homes and Oracle databases
Oracle Universal Installer and OPatch User's Guide for additional information about cloning an Oracle home