Page 175
Table 8.2. Operating system integration support.
Oracle7 Server 7.3 for | Windows NT | NetWare 4.1 HP-UX | Sun Solaris |
| | | |
Symmetric multiprocessing (SMP) | Yes | Yes | Yes |
NetWare Directory Services (NDS) | N/A | Yes | N/A |
Windows NT Services (Registry) | Yes | N/A | N/A |
In Oracle7 Server for NetWare, symmetric multiprocessing (SMP) support and NetWare Directory Services (NDS) support are available only with NetWare 4.1. Neither SMP nor NDS is available in NetWare 3.12. The SMP support enables the processes and logon threads to be distributed among the available CPUs to avoid high use on a single CPU. The Parallel Query option requires SMP support in NetWare 4.1.
Oracle7 Server 7.2 or higher for NetWare supports NDS, which enables you to have central access to your network resources, including NetWare servers, users, printers, and databases in a distributed environment. Using the NetWare NWADMIN for Windows utility, the NDS support enables you, as an Oracle database administrator, to create an Oracle database instance as a new object in the directory tree. If you want to allow the NetWare 4.1 users and groups to be able to connect to the Oracle database instance through a single database user account, you can map the NetWare 4.1 users and groups to a database user account by using NWADMIN. You also can allow an NDS group to inherit the privileges of a database role by mapping the NDS group to a database role.
NDS support has the following requirements:
Oracle7 Server is different from other Oracle packages in terms of its database options. Certain Oracle7 options are available for Oracle7 Server, but they are not available for other Oracle7 packages, such as the Advanced Replication option. Table 8.3 summarizes some of the Oracle7 features currently available for each Oracle package. Certain options require separate licenses and additional cost.
Page 176
Table 8.3. Oracle7 options available for the Oracle packages.
Oracle7 Options | Personal Oracle7 | Oracle7 Workgroup Server | Oracle7 Server |
Procedural option | Yes | Yes | Yes |
Distributed option | Yes | Yes | Yes |
Advanced Replication | N/A | N/A | Yes |
Updateable snapshots | Yes | N/A | Yes |
Parallel Query option | N/A | N/A | Yes |
Context option | N/A | N/A | Yes |
Advanced Networking | N/A | N/A | Yes |
Spatial Data option | N/A | N/A | Yes |
Parallel Server | N/A | N/A | Yes |
Choosing an Oracle package that meets your business needs and technical needs is not an easy task. You might need more than one Oracle package for your organization or business to develop and deploy your client/server applications. This section tells you whether using Oracle7 Server with the Oracle7 options is appropriate for meeting your business and technical needs. Three of the Oracle7 options that are available for the Oracle7 Server are listed here:
Page 177
This chapter compared Oracle7 Server with the Oracle7 universal data server, Personal Oracle7, and Oracle7 Workgroup Server. It also discussed the system requirements, database tools and utilities, and the major features of Oracle7 Server. Oracle7 Server Enterprise Edition supports OLTP systems, a data warehouse environment, and OLAP systems in a distributed, enterprise environment.
Page 178