| Personal
Oracle7 Installation Release 7.3.4 for Windows NT and Windows 95 |
|
|
|
Library |
|
This document describes how to install Personal
Oracle7. It includes the following topics:
Before You Install
Check System Requirements
Other Installation Issues
Review the Products Available for Installation
Personal Oracle7 for Windows 95 Known Issues
Install Personal Oracle7 on Windows NT and
Windows 95
Install Oracle7 Client on Windows 3.1x
Remove Oracle Products
Start Personal Oracle7
Before You Install
Before you install Personal Oracle7 for Windows
NT/Windows 95, perform the following tasks:
- Review the printed Release Notes, which can contain important
installation information
- Determine if you need to upgrade from an earlier version of the database
(see below).
Upgrading from an Earlier Version of the Database
If you currently have data stored in a Personal
Oracle7 for Windows NT or Windows 95 database, and you want to use this
data with Personal Oracle7 for Windows NT/Windows 95 Version 7.3.4, please
see the Personal Oracle7 Upgrade Guide for Windows Platforms, which
comes with this software, for instructions.
Before Installing SPX on Windows NT
An SPX connection works only if your machine has
Microsoft NWLINK transport installed with either the Client Services for
NetWare (if running Windows NT Workstation) or Gateway Service for NetWare
(if running Windows NT Server) before you install the Oracle SPX Protocol
Adapter. Microsoft NWLINK transport software is included on your Microsoft
Windows NT installation media.
Before Installing SPX on Windows 95
An SPX connection works only if your machine has
the production version of Client 32 from Novell or Client for NetWare Networks
installed. This software is included on the Windows 95 installation media.
Client 32 from Novell or Client for NetWare Networks software is included
on your Microsoft Windows NT installation media.
Check System Requirements
Before you install Personal Oracle7, check these
system requirements:
Hardware Requirements
Personal Oracle7 requires the following hardware:
- IBM, Compaq, or 100%-compatible 80486 or Pentium processor
- CD-ROM drive
- Windows NT or 95 compatible network interface card (NIC) (Optional
- Required only if you want to use the distributed features of Personal
Oracle7)
- 16 MB of RAM for standard starter database
- Hard Disk Space -- The amount of hard disk space required depends on
the installation and replication options that you select.
|
Note To find
out how much disk space a product requires, select the product in the
Software Asset Manager window and view the disk space requirements
in the information field. To access the Software Asset Manager window,
click Custom Installation during the installation process. If you do not
want to perform a Custom Installation after reviewing the disk space requirements
of products, click Exit to exit and begin the installation process again.
|
The following table defines the hard disk space
required for the installation and replication options
| Installation Option |
Hard Disk Space Required (MB) |
| Personal Oracle7 - All Products (Standard starter
database) |
93 |
| Personal Oracle7 - All Products (Replication
starter database)1 |
115 |
| Personal Oracle7 - Database Only (Standard starter
database) |
75 |
| Personal Oracle7 - Database Only (Replication
starter database)1 |
98 |
| Custom |
1162 |
- Use of symmetric replication (e.g., updatable snapshots) requires a
remote database configured for symmetric replication.
- The amount of hard disk space required for the Custom installation
varies according to which components you select.
|
:
Installing on a Windows 95 Compressed Drive
In general, the Personal Oracle7 RDBMS (relational
database management system) does not support use of disk compression software
with database files.
You can install Personal Oracle7 for Windows 95
to a compressed disk drive on Windows 95. However, the starter database
must be installed to a noncompressed disk drive. If you select either the
Application Developer or the Runtime installation options, the starter
database is installed.
If you choose to install the starter database
to a compressed drive, you are asked to install the starter database to
a noncompressed disk drive of your choice.
If all your disk drives are compressed, then you
must adjust the free space allocated between the compressed drive and the
noncompressed host drive. The disk compression utility has information
on this procedure.
If you need to resize a compressed drive, use
the utility provided with the disk compression software. Adjust the free
space allocated between the compressed drive and the noncompressed host
drive to gain enough noncompressed disk space on the host drive for the
starter database. Then, specify the host drive as the noncompressed disk
drive on which to install your starter database. Please refer to the disk
compression utility's online help for more information on how to adjust
free space.
You need 40 MB of noncompressed disk space, if
you want to install the starter database with support for symmetric replication.
Otherwise, you need 20 MB of noncompressed disk space.
|
Attention For
Windows NT, installation of Personal Oracle7 on an NTFS compressed drive
is not supported.
|
Additional Windows 95 Disk Space Requirements
Personal Oracle7 for Windows 95 requires 20 MB
of free disk space on the disk drive where the Windows 95 Virtual Memory
page file is located (usually the C: drive) for a successful installation.
This space is required in addition to the space needed for Personal Oracle7
program files. The amount of space required for the Personal Oracle7 program
files is dependent upon the installation option that is chosen.
Software Requirements
- One of the following operating systems:
- Windows NT Workstation 3.51
- Windows NT Workstation 4.0
- Windows NT Server 3.51
- Windows NT Server 4.0
- Windows 95
- If you want to use the distributed features of Personal Oracle7, you
need to install one of the following network transport protocols:
- TCP/IP
- SPX
- Named Pipes
- LU6.2 (for Personal Oracle7 on Windows NT only)
- DECnet (for Windows NT 3.51 only)
|
Note If you
are unfamiliar with network transport protocols, please contact your network
administrator.
|
- One of the following Web browsers to view Personal Oracle7 online documentation:
- Netscape Navigator Version 3.0. Visit: http://www.netscape.com
- Microsoft Internet Explorer Version 3.0. Visit: http://www.microsoft.com
Oracle Client Software Manager
If you intend to use Oracle Client Software Manager
(OCSM), you must have the required OCSM hardware and software in addition
to the hardware and software requirements of the products you intend to
install. OCSM requires the hardware and software listed below:
Client Hardware
- Minimum of 4 MB of RAM; 8 MB recommended.
- Minimum of 4 MB of free hard disk space.
- Compatible NIC, for networked operation.
- Connected CD-ROM drive, functioning as a logical drive (for the administrator).
Client Software
- One of the following operating system releases:
- Windows NT Workstation 4.0
- Windows NT Server 4.0
- Windows 95
- CD-ROM device driver (for the administrator).
- Installed and functioning network.
Other Installation Issues
Changing the Character Set of Your Starter Database
The default character set for your starter database
is WE8ISO859P1. If you require a different character set for the starter
database, you need to install Personal Oracle7 using the Custom installation
option and, when prompted, choose the appropriate character set for the
starter database.
Selection of multibyte character set languages
(such as Japanese or Chinese) for use on single-byte versions of Windows
NT or Windows 95 (such as the U.S. Edition) is not supported. Installation
fails if these languages are chosen. However, the internal database character
set that is chosen can be a multibyte character set. During a Custom installation,
any of the listed character sets can be chosen as the internal character
set for the Starter Database.
Incoming Connections -- Windows 95 only
At installation, Personal Oracle7 tries to configure
itself for an incoming connection to provide support for distributed features
such as two-phase commit. This is only done if you already have installed
Microsoft TCP/IP or Microsoft SPX networking protocol support. The Named
Pipes networking protocol is not supported for this incoming connection.
Configuration is done as follows:
| IF |
THEN |
| No Microsoft TCP/IP or Microsoft SPX networking
is installed |
When Personal Oracle7 is installed, the assumption
is made that this is a stand-alone PC and network access is not available.
|
| Microsoft TCP/IP or Microsoft SPX networking
is installed after Personal Oracle7 is installed |
- Rerun the Personal Oracle7 installation
- Choose a Custom installation
- Choose to install the SQL*Net Add-On software.
NOTE: This procedure must be done in order
to install the LISTENER.ORA file. This file is the incoming configuration
file and is located in the ORACLE_HOME\NETWORK\ADMIN directory.
|
| If Microsoft TCP/IP networking is installed when
Personal Oracle7 is installed |
Configuration is done for a TCP/IP incoming connection
|
| If both Microsoft TCP/IP networking and Microsoft
SPX networking are installed when Personal Oracle7 is installed |
Configuration is done for both TCP/IP and SPX,
but only TCP/IP is enabled, making TCP/IP the default. |
If support for an SPX incoming connection is also
desired, it is possible to enable the SPX configuration by removing the
comment marks "#" in the SPX section of the LISTENER.ORA file.
For this change to take effect, the database must be shut down and restarted.
Incoming connections are only supported for distributed
features such as two-phase commit. Other incoming connections are not supported
and may be rejected with the following error message returned:
ORA-12500: TNS:listener failed to start a dedicated server process
Configuration for incoming connections assumes
that the database instance name, or system identifier (SID), of the Personal
Oracle7 database is ORCL; this is the SID used for the Starter Database.
If you create your own database that uses a different SID, then you must
modify the incoming connection configuration information. Edit the configuration
file LISTENER.ORA, changing the "SID_NAME = ORCL" entry, located
toward the end of the file, to specify a SID other than ORCL.
|
Note SIDs
can only be four alphanumeric characters in length. For this change to
take effect, the database must be shut down and restarted.
|
Connecting 16-bit Applications -- Windows 95 only
To connect to Personal Oracle7, 16-bit Windows
applications require updated Oracle Required Support Files (RSFs). These
updated RSFs are necessary even if these applications can connect to Personal
Oracle7 for Windows 3.1x.
The 16-bit Windows applications previously required
"2:" as the database name when connecting to Personal Oracle7
products. The updated RSFs change this behavior so that applications based
on ORA71WIN.DLL, ORA72WIN.DLL, or ORA73WIN.DLL do not have to specify "2:"
(it is now the default).
A separate installation is provided with Personal
Oracle7 that detects currently installed 16-bit Windows 3.1x RSFs
and installs new ones. Run SETUP.EXE located in the \WINDOWS directory
of your CD-ROM.
Review the Products Available for Installation
When you run Oracle Installer, a dialog
box displays several product installation options. When you select an option
for installation, a group of products are automatically installed. The
options that display depend upon the operating system you are using.
| If Using... |
These Installation Options Are Available... |
| Windows NT |
Personal Oracle7 - All Products
Personal Oracle7 - Database Only
Custom Installation |
| Windows 95 |
Personal Oracle7 - All Products
Personal Oracle7 - Database Only
Custom Installation |
| Windows 3.1x |
Oracle7 Client
Custom Installation |
The following tables list the products available
with the Personal Oracle7 options. The Custom option enables you to selectively
install from a list of all products available for your operating
system.
Personal Oracle7- All Products
When you select the Personal Oracle7 - All Products
option for Windows NT or Windows 95, the products automatically installed
are listed in the table below
| Oracle Installer |
Oracle Objects for OLE |
Personal Oracle7
Oracle7 Database
Oracle7 Utilities |
Oracle7 ODBC Driver |
| Oracle7 Utilites |
Oracle7 Documentation |
| Oracle Navigator |
Personal Oracle7 Release Notes |
| SQL*Net Add-On |
Oracle Migration Assistant for Microsoft Access
|
| SQL*Net Client |
Required Support Files |
| SQL*Plus |
Online Help |
| Oracle Trace Collection Services |
Oracle Protocol Adapters1
|
| Oracle Call Interface |
|
- On Windows NT and Windows 95, the appropriate Oracle Protocol Adapters
are installed automatically for your system. However, if you want to install
DECnet or LU6.2 Protocol Adapters, you must do so manually by selecting
them using the Custom Installation Option.
Note that the LU6.2 Protocol Adapter and the DECnet Protocol Adapter are
only available on Windows NT 3.51 and Windows 3.1x.
|
|
Note Although
the CD-ROM disc in your kit contains many Oracle products, you are only
allowed to use those products for which you have purchased licenses.
|
Personal Oracle7 - Database Only
When you select the Personal Oracle7 - Database
Only option for Windows NT or Windows 95, the products automatically installed
are listed below:
| Oracle7 Utilities |
Personal Oracle7 Release Notes |
| Oracle7 Database |
Required Support Files |
| Oracle Trace Collection Services |
|
|
Note Although
the CD-ROM disc in your kit contains many Oracle products, you are only
allowed to use those products for which you have purchased licenses.
|
Personal Oracle7 for Windows 95 Known Issues
- The Universal Naming Convention (UNC) for file names and directory
paths is not supported. This has two implications:
- When providing a directory path or filename, use the standard DOS naming
convention. The directory path or filename must be no longer than eight
characters and the extension must be no longer than three characters.
- Use of the \\ notation to represent the start of a directory path is
not supported.
- If you mount the CD-ROM and are installing from a network location,
you cannot start the Oracle Installer from the Network Neighborhood icon
located on your Desktop or in the Run>Browse item of your Taskbar. You
must map the network drive to where the CD-ROM is located. This is done
by right-clicking the Network Neighborhood icon and choosing Map Network
Drive. Use the drive letter you assigned to the network location as your
path to the Oracle Installer. If the Oracle Installer is not run in this
manner, the following error message may be encountered:
A problem occurred with the Oracle Installer. Try reinstalling it from the distribution media.
You can also provide the following message to
Worldwide Support to debug the problem:
OS Failure: Unable to Set Current Working Directory
Install Personal Oracle7 on Windows NT and Windows 95
These installation steps assume that the CD-ROM
drive is mapped to the D:\> drive. If you click Cancel in any Oracle
Installer dialog boxes (except when you are performing a Custom Installation),
Oracle Installer exits.
To install Personal Oracle7 on Windows NT and
Windows 95:
- Start your operating system.
If you are running Windows NT, log on to your
Windows NT server as a member of the Administrators group.
- Stop all running Oracle applications.
If you are running Windows NT, stop all running
Oracle services. To stop Oracle services:
- a. On Windows NT 4.0: From the taskbar, choose Start>Settings>Control
Panel.
On Windows NT 3.51: Double-click Control Panel in the Main program
group.
- b. Select the Services icon.
- c. If any Oracle services exist and have the status Started,
select the service, and click Stop.
- d. Click Close to close the Services window.
- Insert the Personal Oracle7 CD-ROM disc into the mapped CD-ROM drive,
and start the Oracle Installer by using one of these methods:
| Operating System |
To Start Oracle Installer... |
| Windows NT 3.51 |
- Choose the File Manager icon from the Windows NT Program Manager.
- Select the drive to which the CD-ROM is connected.
- Double-click on SETUP.EXE.
|
| Windows NT 4.0 |
The operating system automatically detects your
Personal Oracle7 CD-ROM disc. The Personal Oracle7 for Windows NT
dialog box appears. Click Yes to launch Oracle Installer.
or
- Open My Computer.
- Select the drive to which the CD-ROM is connected.
- Double-click SETUP.EXE.
|
| Windows 95 |
The operating system automatically detects your
Personal Oracle7 CD-ROM disc. The Personal Oracle7 for Windows 95
dialog box appears. Click Yes to launch the Oracle Installer.
or
- Open My Computer.
- Select the drive to which the CD-ROM disc is mapped.
- Double-click SETUP.EXE
|
The Language dialog box appears.
- Select a language, or click OK to accept the default language detected
by the Oracle Installer..
|
Note When
you run Oracle Installer from the Personal Oracle7 CD-ROM disc, Oracle
Installer prompts you to enter the language. If you install and run Oracle
Installer from your computer's hard drive, you will not receive this prompt
again.
|
|
Note The
language you select when you install Personal Oracle7 should match the
language of the version of Windows 95 or Windows NT that you are using.
The version of Windows 95 or Windows NT for your language must be a production
version for the language to be supported by Personal Oracle7. To change
your language after installation, see the Online Help that accompanies
Personal Oracle7.
|
The Oracle Installation Settings dialog
box appears.
- Specify a company name and Oracle home directory in which to install
Oracle products, then click OK.
|
Note When
you run Oracle Installer from the Personal Oracle7 CD-ROM disc, Oracle
Installer prompts you to enter the company name. If you install and run
Oracle Installer from your computer's hard drive, you will not receive
this prompt again.
|
|
Note Oracle
Installer determines the hard drive partition on your computer with the
most available space. This hard drive partition becomes the default location
of Oracle home. For example, C:\ORANT. Oracle Corporation recommends that
you use this default setting.
|
The Personal Oracle7 dialog box appears.
- Select any of the following product installation options, then click
OK.
- Follow the installation instructions below based on the option you
selected in Step 6:
Personal Oracle7 - All Products
The Starter Database Installation Options
dialog box appears
- Select the type of database you want to install, then click OK:
| Database Type |
This Option... |
| Standard |
Installs a fully configured and ready-to-use
starter database with the following settings:
- Name of ORACLE
- System Identifier (SID) of ORCL
- INTERNAL password of ORACLE
|
| Replication |
Installs a fully configured and ready-to-use
starter database with replication support. This database has the following
settings:
- Name of ORACLE
- System Identifier (SID) of ORCL
- INTERNAL password of ORACLE.
|
| None |
Does not create a database. All other
server components are installed. The None option is only for DBAs familiar
with advanced database creation procedures. |
The Oracle7 Documentation dialog box appears.
- Choose to install Oracle7 HTML documentation on your hard drive or
leave it on your CD-ROM disc, then click OK.
Personal Oracle7 installation continues. A progress
bar appears, indicating the percentage completion of the installation.
- Click OK when prompted to exit Oracle Installer.
Personal Oracle7 - Database Only
The Starter Database Installation Options
dialog box appears.
- Select the type of database you want to install, then click OK:
| Database Type |
This Option... |
| Standard |
Installs a fully configured and ready-to-use
starter database with the following settings:
- Name of ORACLE
- System Identifier (SID) of ORCL
- INTERNAL password of ORACLE
|
| Replication |
Installs a fully configured and ready-to-use
starter database with replication support. This database has the following
settings:
- Name of ORACLE
- System Identifier (SID) of ORCL
- INTERNAL password of ORACLE.
|
| None |
Does not create a database. All other
server components are installed. The None option is only for DBAs familiar
with advanced database creation procedures. |
Personal Oracle7 installation continues. A progress
bar appears, indicating the percentage completion of the installation.
- Click OK when prompted to exit Oracle Installer.
Custom Installation
The Software Asset Manager window displays
all products available for installation:
- Select the products to install.
The products available to install are listed on
the left side of the window. The Oracle products you have already installed
appear on the right side of the window. To see a brief description of a
component, click on the name of that component.
To select multiple products for installation,
press the CTRL key as you make your selections.
- Click Install to install the product(s) you have selected.
- Provide appropriate responses to any dialog boxes that appear.
Custom Installation continues. A progress bar
appears, indicating the percentage completion of the installation.
- To exit Oracle Installer, click Exit from the Software Asset Manager
window, and then click Yes.
Install Oracle7 Client on Windows 3.1x
If you want to use a Windows 3.1x 16-bit
application with your Personal Oracle7 database, you need to install the
client as outlined below. If you want to develop 16-bit client applications,
in addition to installing the Oracle7 Client, you need to install Oracle7
ODBC and Oracle Objects for OLE using the Custom Installation option.
|
Note These
installation steps assume that the CD-ROM drive is mapped to the D:\>
drive.
|
To install Oracle7 Client on Windows 3.1x:
- Start Windows 3.1x.
- Stop all applications that are running.
- Insert the Personal Oracle7 CD-ROM disc into your CD-ROM drive.
- Start Oracle Installer:
- a. Open File Manager.
- b. Select the drive to which the CD-ROM disc is mapped.
- c. Double-click SETUP.EXE.
The Language dialog box appears.
- Select a language, or click OK to accept the default language, English.
|
Note The
default language, English, is installed with every installation of Personal
Oracle7, in addition to any other language you select. To change your language
after installation, see Online Help.
|
The Oracle Installation Settings dialog
box appears.
- Specify a company name and Oracle home directory in which to install
products, then click OK.
|
Note When
you run Oracle Installer from the Personal Oracle7 CD-ROM disc, Oracle
Installer prompts you to enter the company name. If you install and run
Oracle Installer from your computer's hard drive, you will not receive
this prompt again.
|
|
Note Oracle
Installer determines the hard drive partition on your computer with the
most available space. This hard drive partition becomes the default location
of Oracle home. For example, C:\ORAWIN. Oracle Corporation recommends that
you use this default setting.
|
The Oracle7 Client dialog box appears.
- Select one of the following client options, then click OK.
- Oracle7 Client
- Custom Installation
- If you selected the Oracle7 Client option, follow the installation
dialog boxes that appear. Installation begins, and a progress bar appears,
indicating the percentage completion of the installation. Click OK when
prompted to exit the Oracle Installer.
If you selected the Custom Installation option
follow the instructions below:
The Software Asset Manager window displays
all products available for installation:
- a. Select the products to install.
The products available to install are listed on
the left side of the window. The Oracle products you have already installed
appear on the right side of the window. To see a brief description of a
component, click on the name of that component.
- b. Click Install to install the product(s) you have selected.
- c. Provide appropriate responses to any dialog boxes that appear.
Custom Installation continues. A progress bar
appears, indicating the percentage completion of the installation.
- d. To exit Oracle Installer, click Exit from the Software Asset
Manager window, and then click Yes.
Remove Oracle Products
To remove Oracle products:
- Stop all Oracle services/close all Oracle applications.
- Start the Oracle Installer:
| Operating System |
To start Oracle Installer from your hard drive...
|
| Windows NT 4.0 and Windows 95 |
From the taskbar, choose Start>Programs>Oracle
for Windows NT (or 95)>Oracle Installer. |
| Windows NT 3.51 |
Open the Oracle for Windows NT Program Group,
and double-click on the Oracle Installer icon. |
| Windows 3.1x |
Open the Oracle for Windows Program Group, and
double-click on the Oracle Installer icon. |
- The Installed Products field displays in the right portion of the Software
Asset Manager window.
- Select the product(s) you want to remove from the Installed Products
field.
- Click Remove.
The Oracle Installer warns you of any product
dependencies that can cause problems if particular products are removed,
and prompts you to confirm the de-installation.
Start Personal Oracle7
Start Personal Oracle7 on Windows 95
After you have successfully installed Personal
Oracle7 on Windows 95, you must start the database before you can perform
database tasks such as setting up tables, defining users, etc.
To start the database, from the Windows 95 screen,
select Start>Programs>Personal Oracle7 for Windows 95>Start Database
Start Personal Oracle7 on Windows NT
For Personal Oracle7 on Windows NT, the database
is started automatically.
Library