| Oracle® Application Server CDC Adapters for SQL Server User's Guide 10g Release 3 (10.1.3.4) Part Number E13836-01 |
|
|
View PDF |
This section describes how to install Oracle Connect and Oracle Studio.
Note:
In addition to the installation procedures described in this section, the J2CA 1.5 adapter must be installed with Oracle Application Server. Installing the J2CA 1.5 adapter is described in the Oracle Application Server Adapter Installation Guide.This section includes the following topics:
Before installing OracleAS Adapter for SQL Server, ensure that you have carried out the following:
Microsoft SQL Server 2000 or 2005 (Standard, Enterprise, or SBS editions). For MS SQL Server 2005 you must use Service Pack 1 or higher. You must install SQL Server where you install Oracle Connect.
This section describes the following requirements for installing Oracle Connect:
The following UNIX operating systems are supported:
Red Hat Linux
Linux SUSE
HP-UX
IBM AIX
Sun Solaris
For all of the operating systems, the required disk space is 48MB.
You must install Oracle connect on the Windows computer where you install Microsoft SQL Server and on any machine that you are using for a staging area for the CDC adapter. This can be the same computer or different computers.
This following sections explain how to install Oracle Connect on a Windows machine.
This section explains how to install Oracle Connect. Do the following to install Oracle Connect.
Note:
If you are upgrading from version 10.1.3.3, you must use the upgrade option in the installation wizard. Do not uninstall Version 10.1.3.3 and then install the newer version. If you do this, you will lose all data in theDef directory.Copy the following installation files into a folder on the Windows computer where you are installing Oracle Connect.
OCL_10134_windows.exe
brand.bin
Open the Windows command line interface.
Change to the directory where you installed the installation files.
Type the following at the command prompt to install Oracle Connect.
"OCL_10134_windows.exe" -a -bBRAND=".\brand.bin" -bSERVER
The install wizard opens. Follow the directions in the insallation wizard to complete the installation.
Note:
If you are installing Oracle Connect on a Windows XP computer, you cannot use a logical drive as the destination folder for the installation.You must install Oracle connect on any UNIX machine that you are using for a staging area for the CDC adapter. The following sections explain how to install Oracle Connect on a UNIX machine.
This section explains how to install Oracle Connect on a UNIX platform. This section includes the following:
Before starting the installation procedure, ensure that you have the following information is available:
The root directory where you want to install Oracle Connect.
Notes:
The root directory cannot be a system root directory,/var or /tmp.The account name where Oracle Connect will run.
Whether the installation source media is removable media or a disk archive file.
If you are installing from the removable media that is not a default device in the system, you need to know the media device name (such as /dev/rmt/0m). See the operating system manuals or ask the system administrator to find out the device name for the site.
If you are installing from the disk archive file, you need to know the name of the Oracle Connect disk archive file (such as /tmp/nav.2.0.tar).
The shell being used: C-shell Korn,-shell, or Bourne-shell. The installation creates a startup file according to the indicated shell.
When running the installation below, use the following as the <filename>:
For RedHat Linux: OCL10134-linuxrh.tar.Z
For Linux Suse: OCL10134-linuxsuse.tar.Z
For HP-UX: OCL10134-hpux.tar.Z
For IBM AIX: OCL10134-ibmaix.tar.Z
For Solaris Operating System (SPARC): OCL10134-sunsol2.8.tar.Z
Perform the following steps to install Oracle Connect:
Transver the tar.Z file to th esystem.
Decompress the file using the following command:
uncompress <filename>
Run the tar command, as shown in the following example:
tar xvf <filename> nav_install
The following message is displayed:
x nav_install, nnnn bytes, mmmm tape blocks
Note:
Ensure that the directory used to run the installation files hasWRITE privileges.Perform the following steps to install Oracle Connect:
Run the following command:
./nav_install
This command initiates the installation procedure. The installation procedure is displayed in a series of screen prompts and responses.
Enter the full path of the disk archive (.tar) file, and press Enter.
Enter the root directory name for the installation, and press Enter. You must have a WRITE permission for this directory. The default directory is the users home directory.
Notes:
The root directory cannot be a system root directory or /var or /tmp directory.
Oracle Connect is installed into a fixed directory named navroot.
Confirm the directory name in which Oracle Connect will be installed, and press Enter.
Enter the account name where you want Oracle Connect to run, and press Enter. This account name will be used for anonymous access to the server by clients. It can be changed after the installation is complete.
Confirm the account name, and press Enter.
Specify the required shell, under which Oracle Connect should run, and press Enter. The following options are displayed:
C-shell (/bin/csh).
Korn-shell (/bin/ksh)
Bourne-shell (/bin/sh)
Enter the account name for a user with administrative authorization. Optionally, press Enter to enable any user to administer Oracle Connect.
After installing Oracle Connect, perform the following post-installation tasks:
Configuring the Oracle Connect Environment
When Oracle Connect is installed on a UNIX platform, using FTP, copy the brand.bin file to the Oracle Connect computer, to NAVROOT/bin.
Where NAVROOT is the directory where Oracle Connect is installed.
Configuring the Oracle Connect Script
The program that manages Oracle Connect server processes (nav_server) is accessed by a symbolic link to a file for the C-shell, Bourne and Korn shells.
To set up nav_server, perform the following steps:
In the bin directory, under the directory where Oracle Connect is installed, delete the existing link to nav_server using the following command:
rm nav_server
In the bin directory, under the directory where Oracle Connect is installed, link to the required version of nav_server as follows:
C-shell: ln -s nav_server.csh nav_server
Bourne: ln -s nav_server.sh nav_server
Korn: ln -s nav_server.ksh nav_server
Note:
Instead of renaming files, use a symbolic link.The Oracle Connect nav_login procedure defines the default environment when Oracle Connect runs. If you want site-dependent variables to be included in the environment, create a file called site_nav_login and save this file in the bin directory under the Oracle Connect root directory. nav_login runs site_nav_login automatically.
nav_login must be invoked to run Oracle Connect. It can be invoked from the user login script.
The command line for invoking nav_login varies according to the shell the user is running. The following table lists the different options for invoking the command line:
| Shell | nav_login Command |
|---|---|
| CSH |
source root/bin/nav_login
|
| Bourne |
. root/bin/nav_login.sh |
| Korn |
. root/bin/nav_login.sh
|
In the nav_login command, root represents the root directory of the Oracle Connect installation. After running the login procedure, the environment variable NAVROOT points to this root directory.
Ensure that users have READ and EXECUTE permissions on the Server files. Use the chmod command to change the permissions.
Starting the Oracle Connect Daemon
The Oracle Connect daemon must run on a server for client/server access to Oracle Connect. To start the daemon with the system startup, add the following command invoking the daemon to the end of the /etc/inittab file:
nv:3:once:navroot/bin/irpcd -l ip:2551 start >/dev/console 2>&1
In this command, the symbol navroot should be replaced with the directory where Oracle Connect is installed and ip replaced by the ip address of the computer.
Note:
To allow automatic client/server access to Oracle Connect, start the daemon at system startup time from a super user account.This following sections explain how to install Oracle Studio.
Note:
If you have Oracle Studio version 10.1.3.4 or higher installed on your computer because you are using an OracleAS legacy adapter or OracleAS CDC adapter , you do not need to reinstall it. If you have an older version of Oracle Studio, you must install the newest version.The following are the hardware requirements for Oracle Studio:
Processor: Intel or 100% compatible computer, based on a Pentium processor
Memory: 256 MB
Disk space: 120 MB of free disk space
You can install Oracle Studio on the following operating systems:
Windows XP with Service Pack 2 or higher
Windows 2003
Windows Vista
Linux OS with GTK
Oracle Studio is installed with a standard install wizard. Do the following to install Oracle Studio.
Run the installation file, either using the Run option in the Windows Start menu or through Windows Explorer. Follow the instructions on the wizard screen.
The Oracle Studio installation on Linux can be caried out by one of the following:
You can install Oracle Studio by using the installation wizard. This allows you to easily carry out any standard or custom installation. Do the following for the Linux SH installation.
Install into a directory where you have permission.
Change the mode to execute mode. Type in:
Chmod +x <file name>
Enter the following:
./ <file name>
If you are not installing to the current directory, enter the full path.
You can use the Linux RPM method to install Oracle Studio. Do the following to carry out a silent installation on Linux.
Enter the following:
rpm -i <file name>
You can use RPM parameters to create a custom inslallation.