Oracle8(TM)
Getting Started for Windows NT Release 8.0.3 A54894-01 |
|
This chapter introduces you to Oracle8 for Windows NT.
Specific topics discussed are:
Oracle8 for Windows NT is a release 8.0.3 Oracle Object Relational Database Management System (ORDBMS). Oracle8 client and server software operates on a personal computer (PC), running one of the following operating systems:
Operating System | Oracle8 Server Software | Oracle8 Client Software |
---|---|---|
Windows NT Workstation Version 4.0 |
Yes |
Yes |
Windows NT Server Version 4.0 |
Yes |
Yes |
Windows 95 |
No |
Yes |
Note:
This guide describes only those features of Oracle8 that apply to the Windows NT and Windows 95 operating systems. |
Operating within the framework of Network Computing Architecture (NCA), Oracle8 for Windows NT provides:
This table describes the new features of Oracle8 release 8.0.3 specific to Windows NT.
Additional
Information:
See Appendix A, "Oracle8 Enhancements" of Oracle8 Server Migration for the list of new Oracle8 features applicable to all operating system platforms. |
New Features | Description | For More Information, See... |
---|---|---|
Multi-Threaded Server (MTS) Configuration on Windows NT |
Enables many client connection threads to share very few server threads. Without this functionality, one client connection thread requires its own dedicated server thread for the duration of the connection. |
|
Stopping OracleServiceSID |
Performs a SHUTDOWN IMMEDIATE of your database. |
|
Microsoft SMS (Systems Management Server) enabled |
Customer sites supporting Microsoft SMS for software distribution and asset management can now distribute Oracle8 for Windows NT client and server software. Predefined Oracle packages have been added to allow for simple distribution. |
|
Oracle Database Assistant |
A wizard that helps you create a database. When you install Oracle8, Oracle Installer detects if there is a database on your system. If not, you may choose to use this wizard at the end of the installation process to create a database. |
Oracle8 Installation for Windows NT CD-ROM Insert and Chapter 9, "Creating a Database" |
Oracle Data Migration Assistant |
A wizard that helps you migrate an Oracle7 Server database of release 7.1.3.3.6 or later to an Oracle8 database. When you install Oracle8, Oracle Installer detects if there is an Oracle7 database on your system. If so, you may choose to use this wizard at the end of the installation process to migrate your database. |
Oracle8 Installation for Windows NT CD-ROM Insert and Chapter 5, "Database Co-existence and Migration" |
Oracle INTYPE File Assistant |
A wizard that helps you create INTYPE files, which are used with the Object Type Translator (OTT). INTYPE File Assistant simplifies the creation of new INTYPE files, as well as the modification of existing ones. |
|
Oracle Web Publishing Assistant |
A wizard that helps you create HTML web pages based on data retrieved from an Oracle8 database. |
Oracle Web Publishing Assistant Getting Started for Windows NT |
Oracle Net8 Assistant |
A wizard that helps you configure Net8 client and server networking products. |
|
Oracle8 ConText Cartridge |
Enables text queries to be performed through SQL and PL/SQL from most Oracle interfaces. If you install this cartridge, Oracle8 ConText Filters, Demos, and Workbench are also installed. |
Chapter 14, "Oracle8 ConText Filters, Demos, and Workbench" and Oracle8 ConText Cartridge Administrator's Guide |
When you run Oracle Installer from the Oracle8 for Windows NT CD-ROM disc, a dialog box appears with various product installation options depending on the operating system you use. Each installation option contains a specific set of Oracle products.
Operating System | Installation Options |
---|---|
Windows NT |
Custom Installation |
Windows 95 |
Custom Installation |
The products in the following table are listed according to the product installation options available from the Oracle8 for Windows NT CD-ROM disc. All products listed in the Custom column are available on Windows NT and Windows 95 unless noted otherwise.
Products | Installation Options | ||
---|---|---|---|
Oracle8 | Oracle8 Client | Custom | |
A Graphical User Interface (GUI) application that lets you quickly install, update, and remove Oracle products. |
Yes |
Yes |
Yes |
Oracle Online Documentation 8.0 Available in HTML, viewable using a web browser. PDF is also available but is not installable with any installation option. You can find the PDF documentation on the CD-ROM disc in the \PDFDOC directory. The Adobe Acrobat Reader is located in the \ACROREAD directory. |
Yes |
Yes |
Yes |
The database component of Oracle8 for Windows NT software. |
Yes |
No |
NT only |
Required Support Files 7.3, 7.2, and 7.1 Required Support Files version 7.3, 7.2, and 7.1 can be installed on Windows NT and Windows 95 clients but are only available for installation through the Custom installation option. Oracle Corporation provides Required Support Files version 7.3, 7.2, and 7.1 for third party applications linked with them. |
No |
No |
Yes |
Required Support Files version 8.0 can be installed from each installation option. |
Yes |
Yes |
Yes |
Oracle Migration Assistant for Microsoft Access 8.0 Provides complete and easy migration of schema or data from your Microsoft Access database to an Oracle8 database. |
Yes |
Yes |
Yes |
Oracle Data Migration Assistant 8.0 Helps you migrate your existing Oracle7 for Windows NT database (release 7.1.3.3.6 or later) to an Oracle8 database. |
Yes |
No |
NT only |
Helps you create and delete a database. |
Yes |
No |
NT only |
Oracle Web Publishing Assistant 1.0 Enables you to query the database and publish the data retrieved to a web page at specified time intervals. |
Yes |
Yes |
Yes |
Oracle INTYPE File Assistant 1.0 Provides an easy and intuitive GUI to generate input files necessary for the OTT. This wizard is used in conjunction with Oracle development environments to build rapid object-oriented applications. |
Yes |
Yes |
Yes |
Provides fast and simple configuration of Net8 products. |
Yes |
Yes |
Yes |
Used to configure simple network configurations. |
Yes |
Yes |
Yes |
A suite of products used for database administration. Oracle8 Utilities include ORADIM80, Server Manager, Export Utility, Import Utility, SQL*Loader, Migration Utility, Recovery Manager, and the Password Utility. |
Yes |
Yes |
Yes |
Thin Client JDBC (Java Database Connectivity) Driver (Beta) Appropriate for use by Java applets that can be downloaded in a web browser. The JDBC Thin Client Driver provides a direct connection from the Web browser to the database by emulating SQL*Net or Net8 and TTC (the wire protocol used by Oracle Call Interface (OCI)) on top of Java sockets. This driver works for Oracle7 version 7.2 and later. |
Yes |
Yes |
Yes |
OCI (OCI7 and OCI8) JDBC Driver (Beta) The Oracle Call Interface (OCI) based drivers are appropriate for use by Java applications, which include the Oracle Web Application Server Java Cartridge, or any other Java middle tier. The OCI JDBC Drivers call OCI directly from Java to connect to the database. You need the OCI7 driver if you have an Oracle 7 installation or the OCI 8 driver if you have an Oracle 8 installation. |
Yes |
Yes |
Yes |
A set of files distributed by Sun that allows Java applications to run. It is required by many of the Oracle Assistants. |
Yes |
Yes |
Yes |
When you install this product these components are installed: JNLS Java native interface to Oracle National Language Support (NLS) runtime library. JHELP Java based online help included with Oracle Assistants. BALI A set of re-usable components that are built in Java including toolbars, tab panels, scrolling areas, spin boxes, status bars, table/grid controls and so on.
|
Yes |
Yes |
Yes |
Enables text queries to be performed through SQL and PL/SQL from most Oracle interfaces. By installing Oracle8 ConText Cartridge with an Oracle8 server, client tools such as SQL*Plus, Oracle Forms, and Pro*C are able to retrieve and manipulate text in an Oracle database. Oracle8 ConText Cartridge manages textual data in association with traditional datatypes in an Oracle database. When text is inserted, updated, or deleted, Oracle8 ConText Cartridge automatically manages the change. Although this product is automatically installed when you select the Oracle8 ConText Cartridge during installation, it requires a separate license. If you select Oracle8 ConText Cartridge, Oracle8 ConText Filters are also installed. Oracle8 ConText Filters 2.0 Utilizes the external filter feature in Oracle8 ConText Cartridge to extract plain (ASCII) text from formatted documents for the purpose of indexing, linguistic processing, and highlighting. Oracle8 ConText Cartridge Demos 2.0 A sample application illustrating the text querying and retrieval capabilities of Oracle8 ConText Cartridge and Oracle8.
|
Yes |
No |
Yes |
Oracle8 ConText Cartridge Workbench 2.0 A suite of products used in conjunction with Oracle8 ConText Cartridge to enhance viewing, storage, and manipulation of text data. If you select Oracle8 ConText Cartridge Workbench, the following components are installed. Oracle8 ConText Cartridge System Administration 2.0 A GUI application that can be used to perform system and text administration tasks. Oracle8 ConText Cartridge Viewer 2.0 A document viewer supplied as a custom control (OCX), which can be embedded in any application developed in an environment, such as Visual Basic, and Visual C++, that supports custom controls. Oracle8 ConText Cartridge I/O Utility 2.0 A stand-alone executable that can be used to load text to a database column, load text from a column into a file, execute SQL and PL/SQL code, and call other executables from the MS-DOS command prompt.
|
Yes |
Yes |
Yes |
Oracle8 Performance Utility 8.0 Enables Database Administrators to monitor local and remote database performance through the Windows NT Performance Monitor. |
Yes |
No |
Yes |
Oracle Open Database Connectivity Driver (ODBC) (32 bit) Driver 8.0 Provides support for ODBC connections from Windows NT and Windows 95 systems to Oracle8 databases. |
Yes |
Yes |
Yes |
An application programming interface (API) for accessing an Oracle database from a C or C++ program. You make calls directly to the OCI functions from within your C or C++ program to direct the execution of your SQL statements. |
Yes |
Yes |
Yes |
Oracle Objects for Object Linking and Embedding (OLE) 8.0 Provides a custom control (OCX or ActiveX) combined with an OLE in-process server that lets you plug native Oracle8 functionality into your Windows applications. |
Yes |
Yes |
Yes |
Enables you to use the SQL and PL/SQL database languages in the Windows NT environment. SQL*Plus has both a command line and graphical user interface. |
Yes |
Yes |
Yes |
Oracle Security Server Manager 2.0 Provides complete management of subjects, certificates, attributes, and applications. |
No |
No |
Yes |
Performs the most common web administrative tasks through web pages. Web administrative tasks include creating, modifying, deleting, PL/SQL Database Connection Descriptors (DCDs), the Web Listener, and the Web Request Broker. |
Yes |
Yes |
Yes |
Provides a GUI that enables a Database Administrator to display the Oracle Biometric Authentication Service database schema in two windows. Used in conjunction with the Oracle Advanced Networking Option and Identix secure authentication products. |
Yes |
Yes |
Yes |
Combines a graphical console, agent processes, and common services to provide an integrated, comprehensive systems management platform for managing distributed databases and networks. |
Yes |
Yes |
Yes |
Oracle Client Software Manager (OCSM) A 32-bit product that enables System Administrators to install and configure Oracle products on a server for access by multiple client workstations. Oracle Client Software Agent Used to bring the client workstation up-to-date with respect to the OCSM host. Oracle Client Configuration Manager Used to define client configurations.
|
Yes |
Yes |
Yes |
Oracle Administrator Toolbar 1.4 Enables you to execute commands and run applications in Oracle Enterprise Manager. |
Yes |
Yes |
Yes |
Oracle Enterprise Manager Software Development Kit (SDK) 1.4 Provides sample source files, libraries, and header files for integrating new applications into the Oracle Enterprise Manager Console. |
Yes |
Yes |
Yes |
Responds to, schedules, and executes database administration job requests initiated by the Oracle Enterprise Manager Console. |
Yes |
Yes |
Yes |
Net8 Products 8.0 Net8 establishes and maintains a connection between the client application and the server and exchanges messages between them. Net8 is a software layer that is required to communicate between Oracle clients and servers. It provides both client-server and server-server communications across any network. It enables client tools to access, modify, share, and store data on Oracle8 servers over a network. See Oracle Networking Products Getting Started for Windows Platforms for detailed information on each Net8 product. |
Yes |
No |
Yes |
Net8 Protocol Adapters 8.0 Oracle TCP/IP Protocol Adapter 8.0 Oracle SPX/IPX Protocol Adapter 8.0 Oracle Named Pipes Protocol Adapter 8.0 Oracle NDS Protocol Adapter 8.0 Oracle APPC/LU6.2 Protocol Adapter Net8 Protocol Adapters are responsible for mapping Transparent Network Substrate (TNS) functionality to industry-standard protocols used in the client/server connection. Each protocol adapter is responsible for mapping the equivalent functions between TNS and a specific protocol. See Oracle Networking Products Getting Started for Windows Platforms for detailed information on each protocol adapter. |
Yes |
Yes |
Yes |
Note:
Although the CD-ROM disc in your kit contain many Oracle products, you are only licensed to use those products for which you have purchased licenses. |
|
Copyright © 1997 Oracle Corporation. All Rights Reserved. |
|