Oracle8(TM)
Enterprise Edition Getting Started for Windows NT Release 8.0.3 A53722-01 |
|
This chapter describes post-installation configuration tasks for Oracle8 Enterprise Edition.
Specific topics discussed are:
Some of the configuration procedures described in this chapter are required only if you choose to add the following products/support to an already installed Oracle8 database. Depending on which type of database and products/support you selected for installation, most configuration tasks are automatically performed for you. Review the table below to identify your configuration responsibilities.
Product/Support | When Is Configuration Automatically Performed? | When Must Configuration Be Manually Performed? |
---|---|---|
Net8 networking software |
Configuration is never automatically performed for you. |
You must always manually configure your networking software. However, an easy-to-use network configuration tool, Oracle Net8 Assistant, enables you to configure your Windows NT and Windows 95 clients to access your Oracle8 database. See the section "Configuring Net8", in this chapter for information on how Net8 is installed and where to look for instructions on using Net8. |
Oracle Enterprise Manager |
Configuration is never automatically performed for you. |
You must always manually configure Oracle Enterprise Manager. See the section "Configuring Oracle Enterprise Manager" for configuration instructions. |
Oracle Cartridges:
|
A cartridge is automatically configured if you select it for installation:
You can select up to all three cartridges for installation in either of these two scenarios. |
If you decide to install a data cartridge after previously installing Oracle8 Enterprise Edition. See the following sections in this chapter for manual configuration instructions based upon the cartridges you install:
|
Advanced Replication Support |
Advanced Replication support is automatically configured if you select:
|
If you decide you want replication support after previously installing Oracle8 Enterprise Edition. See the section "Configuring Advanced Replication" in this chapter for configuration instructions. |
Net8 is the Oracle networking software that enables applications running on client workstations to access, modify, share, and store data on the Oracle8 database. To configure Net8 so that your client workstations and Oracle8 database can communicate, you must use Oracle Net8 Assistant to create and modify server and client configuration files. Oracle Net8 Assistant is automatically installed when you select the following:
Additional
Information:
See Oracle Network Products Getting Started for Windows Platforms and the Net8 Administrator's Guide for instructions on using Oracle Net8 Assistant to configure your client/server network. |
Oracle Enterprise Manager works with the Oracle Intelligent Agent (installed on the Oracle8 database server) to perform database administration from a single console. Oracle Enterprise Manager is installed on a console workstation, a Windows NT or Windows 95 client.
The Oracle Intelligent Agent is installed on the Oracle8 database. The Oracle Intelligent Agent is responsible for managing and completing tasks requested from the console workstation by the Oracle Enterprise Manager. Once installed, the Oracle Intelligent Agent:
Perform the following configuration tasks after installing the Oracle Enterprise Manager on a client Windows NT or Windows 95 console workstation and the Oracle Intelligent Agent on your Oracle8 Enterprise Edition for Windows NT machine:
Each of these tasks is described in the sections that follow.
Before configuring Oracle Enterprise Manager, ensure that the Oracle8 database services OracleServiceSID, OracleTNSListener80, and OracleAgent are started on the server. The Oracle Intelligent Agent automatically locates the services on the computer where it resides and passes this information to the Oracle Enterprise Manager console.
To start the Oracle Services:
C:\>NET START SERVICE
You need to have a user account with DBA (database administrator) privileges set up on the Oracle8 repository database. Oracle Enterprise Manager places its repository in the default tablespace of the user account to which you are connected when creating the repository. Because of this, Oracle Corporation recommends that you create a new user account so that the repository can be created in its own tablespace. It is also recommended that you create a new tablespace and the newly-created user be customized to use this tablespace as its default tablespace.
To create a repository user account on the Oracle8 repository database:
C:\> SVRMGR30 SVRMGR> CONNECT SYSTEM/MANAGER
SVRMGR> CREATE TABLESPACE REPOSIT_TABLESPACE DATAFILE 'path\DATAFILE' SIZE XM;
where X is the tablespace size in megabytes; 20 MB is a good starting place.
SVRMGR> CREATE USER USERNAME IDENTIFIED BY PASSWORD 2> DEFAULT TABLESPACE REPOSIT_TABLESPACE;
SVRMGR> GRANT DBA TO USERNAME IDENTIFIED BY PASSWORD;
SVRMGR> EXIT
Exiting Server Manager closes the database connection.
After a repository user account is created, an NT user account with the same user name as the repository user account must be created on the Oracle8 Enterprise Edition server.
To create a user account on the Oracle8 Enterprise Edition server:
The User Manager window appears:
The New User dialog box appears:
The Group Memberships dialog box appears:
Administrators is added to the Member of list box.
The user is added and the User Manager window re-appears.
The User Rights Policy dialog box appears:
If Users does not exist, create it:
The Add Users and Groups dialog box appears:
Users appears in the Grant To list box.
The User Manager window re-appears.
If Oracle Enterprise Manager is installed on a Windows 95 or Windows NT client console, you must configure the client machine so it can connect to the Oracle8 repository database. Use the Oracle Net8 Assistant to configure your network.
If Oracle Enterprise Manager is installed on the machine where the Oracle repository database is installed, you do not need to configure your network.
Additional
Information:
See Oracle Network Products Getting Started for Windows Platforms and the Net8 Administrator's Guide for complete information about configuring your network. |
Before you can use Oracle Enterprise Manager, you need a repository on the console workstation where Oracle Enterprise Manager will run. The repository is a set of base tables in a database that contains status and environment information for your managed databases. A separate repository must be created for each user wanting to use Oracle Enterprise Manager.
The Oracle Enterprise Manager console workstation must also discover network services, such as databases, listeners, and nodes, to populate the Oracle Enterprise Manager Navigator tree. In addition to discovery, the Oracle Enterprise Manager must also be able to manage these services for the Job Scheduling and Event Management systems. This can be achieved with the Discovery Wizard.
When the agent starts up and is explicitly requested by the Oracle Enterprise Manager with the Navigator Discovery feature, the agent passes information from the Oracle Enterprise Manager console to populate the Navigator tree.
To create a repository on the console workstation:
The Oracle Enterprise Manager Repository Login Information dialog box appears:
The Oracle Repository Manager window appears, prompting you to build the repository:
The repository is built.
The Discover New Services Wizard appears:
Services are discovered when you see the dialog box below with a status of Discovered:
The Oracle Enterprise Manager Console appears:
If you are adding Oracle8 Spatial Cartridge to an already installed Oracle8 Enterprise Edition, you must follow these configuration procedures. If you installed Oracle8 Spatial Cartridge during the same installation as Oracle8 Enterprise Edition, you do not have to perform the procedures in this section; Oracle8 Spatial Cartridge was automatically configured for you.
To configure Oracle8 Spatial Cartridge:
C:\> SVRMGR30
SVRMGR> CREATE USER MDSYS IDENTIFIED BY MANAGER;
SVRMGR> CONNECT SYSTEM/MANAGER
SVRMGR> GRANT ALL PRIVILEGES TO MDSYS IDENTIFIED BY MANAGER WITH ADMIN OPTION; SVRMGR> ALTER USER MDSYS QUOTA UNLIMITED ON SYSTEM;
C:\> PLUS80W
Note:
You cannot use Server Manager to run CATMD.SQL. |
SQL> @%ORACLE_HOME%\MD80\ADMIN\CATMD.SQL
This script creates the following:
Additional
Information:
See the Oracle8 Spatial Data Option User's Guide and Reference. |
Note:
In order to develop applications that work with the Oracle8 Spatial Cartridge, you must link with SDO80.LIB, which is found in the ORACLE_HOME\MD80 directory. |
If you are adding Oracle8 ConText Cartridge to an already installed Oracle8 Enterprise Edition, you must follow these configuration procedures. If you installed Oracle8 ConText Cartridge during the same installation as Oracle8 Enterprise Edition, you do not have to perform the procedures in this section; Oracle8 ConText Cartridge was automatically configured for you.
To configure Oracle8 ConText Cartridge:
To create objects in an existing tablespace:
C:\> SVRMGR30
CONNECT SYSTEM/MANAGER
SVRMGR30> ALTER TABLESPACE EXISTING_TABLESPACE; SVRMGR30> ADD DATAFILE `%ORACLE_HOME%\DATABASE\SYS2ORCL.ORA' SIZE 5 M;
SVRMGR30> EXIT
To create objects in a separate tablespace:
C:\> SVRMGR30
SVRMGR30> CONNECT SYSTEM/MANAGER
SVRMGR30> CREATE TABLESPACE DRSYS DATAFILE '%ORACLE_HOME%\DATABASE\DR1ORCL.ORA' SIZE 5 M;
SVRMGR30> EXIT
To execute the DRCRSYST.SQL script:
C:\> PLUS80W
SQLPLUS> @DRCRSYST CTXSYS PASSWORD EXISTING_TABLESPACE EXISTING_TABLESPACE
or
SQLPLUS> @DRCRSYST CTXSYS PASSWORD DRSYS DRSYS
The password supplied here becomes the password for the new CTXSYS user.
SQLPLUS> EXIT
To execute the DR0INST.SQL script:
C:\> PLUS80W
SQLPLUS> @DR0INST
SQLPLUS> EXIT
C:\> CD ORACLE_HOME\CTX80\ADMIN
C:\ORACLE_HOME\CTX80\ADMIN> IMP80 CTXSYS/PASSWORD_FOR_CTXSYS \ FILE=CTXSET.DMP FULL=Y IGNORE=Y
C:\ORACLE_HOME\CTX80\ADMIN> PLUS80W SYSTEM/PASSWORD_FOR_SYSTEM SQLPLUS>@DRSYS
SQLPLUS> EXIT
TEXT_ENABLE = TRUE
Additional
Information:
See Oracle ConText Cartridge QuickStart, Oracle ConText Cartridge Administrator's Guide, and Oracle ConText Application Developer's Guide. |
Another configuration step:
To run the CTXPLUS and CTXLING Demos as well as the Oracle Forms Demo on Workbench:
Oracle8 ConText Cartridge servers can be started from the MS-DOS command prompt or the Oracle8 ConText Cartridge control utility.
From the MS-DOS command prompt, enter:
C:\> START CTXSRV80 -USER CTXSYS/PASSWD_FOR_CTXSYS@CONN_STRING -PERSONALITY
From the Oracle8 ConText Cartridge control utility, enter:
C:\> CTXCTL80 COMMAND> START 1 [DML | DDL | LOAD | LING | QUERY]
Oracle8 ConText Cartridge server processes started from the MS-DOS command prompt are killed by Windows NT when a console user logs off the Windows NT console.
To help Oracle8 ConText Cartridge servers survive Windows NT console log off, use the Oracle8 ConText Cartridge control utility CTXCTL80.EXE to start, stop, and view the Oracle8 ConText Cartridge servers running on the Windows NT server/workstation.
The Oracle8 ConText Cartridge control utility interacts with a Windows NT service for Oracle8 ConText Cartridge. It is this service that manages the various Oracle8 ConText Cartridge server processes on that Windows NT server/workstation. The service is called OracleConTextService80 and must be started prior to using the Oracle8 ConText Cartridge control utility. By default the service starttype is AUTO.
The Oracle8 ConText Cartridge control utility cannot list or kill Oracle8 ConText Cartridge servers started directly by executing CTXSRV80.EXE or CTXSRX80.EXE. It can only manage Oracle8 ConText Cartridge servers through the OracleConTextService80 Windows NT service.
If you are adding Oracle8 Image Cartridge to an already installed Oracle8 Enterprise Edition, you must follow these configuration procedures. If you installed Oracle8 Image Cartridge during the same installation as Oracle8 Enterprise Edition, you do not have to perform the procedures in this section; Oracle8 Image Cartridge was automatically configured for you.
Oracle8 Image Cartridge is an extension of Oracle8 Enterprise Edition that provides image storage, retrieval, and format conversion capabilities through an object data type (ODT).
After Oracle8 Enterprise Edition installation, run the following SQL script to enable Oracle8 Image Cartridge:
C:\> SVRMGR30
SVRMGR> CONNECT INTERNAL/PASSWORD
SVRMGR> @%ORACLE_HOME%\ORD80\IMG\ADMIN\ORDIINST.SQL
SVRMGR> CONNECT INTERNAL/PASSWORD
SVRMGR> ALTER USER ORDSYS IDENTIFIED BY NEW_PASSWORD;
Once this has been completed, Oracle8 Image Cartridge is usable.
If you want to install Advanced Replication support after previously installing Oracle8 Enterprise Edition, you must follow the procedures described below:
See the Oracle8 Enterprise Edition for Windows NT Installation CD-ROM Insert for Advanced Replication installation requirements.
Additional
Information:
There are many configuration and usage possibilities with Advanced Replication. For more information about advanced replication, see:
|
These are the recommended tablespace requirements for Advanced Replication:
Certain default initialization parameter values must be set for the replication database. For a complete list of these parameters, see the section "Advanced Replication Initialization Parameters" in Appendix B, "Initialization Parameter Files" of this guide.
After setting up the INITSID.ORA file with the initialization parameters for Advanced Replication, perform the following steps:
To configure Advanced Replication:
C:\> SVRMGR30
SVRMGR> CONNECT INTERNAL/PASSWORD
SVRMGR> STARTUP
The script is found in the ORACLE_HOME\RDBMS80\ADMIN directory. It takes approximately one hour to run. A good idea is to spool output to a log file first before running CATREP.SQL:
SVRMGR> SPOOL
This creates a file called OUTPUT.LOG to which to output all onscreen activity while the SPOOL session is open.
Run CATREP.SQL:
SVRMGR> @%ORACLE_HOME%\RDBMS80\ADMIN\CATREP.SQL
SVRMGR> SPOOL OFF
OUTPUT.LOG is placed in your current directory.
SVRMGR> SELECT * FROM ALL_OBJECTS WHERE STATUS = 'INVALID';
If you find that any of the package bodies compiled incorrectly, recompile them manually. Here is the syntax for running them manually:
SVRMGR> ALTER PACKAGE <package name> COMPILE BODY;
If CATREP.SQL has run successfully, a number of replication tables are created in the SYSTEM subdirectory. The database is now set up for Advanced Replication.
The practical limit to the number of master sites an environment can have is 36. The processes SNP0 to SNP9 (total of 10) and SNPA to SNPZ (total of 26) each handle one destination master at a time.
If you use Advanced Replication and intend to set up a large number of replicated objects, monitor the following data dictionary tables with the SQL SELECT command:
|
|
|
|
|
|
|
|
|
|
If necessary, increase the storage parameters to accommodate the storage requirements of large numbers of replicated objects.
If you are upgrading from a previous version of the Oracle8 database and want to use Advanced Replication, you must first complete the migration (see the Chapter Chapter 5, "Database Co-existence and Migration" in this guide). After upgrading, Advanced Replication is automatically installed with the Oracle8 database during Release 8.0 installation (see Oracle8 Enterprise Edition for Windows NT Installation CD-ROM Insert).
Caution: Advanced Replication is an advanced feature. Please consult your Oracle8 Server Replication documentation for concepts and details before proceeding. For additional information, contact Oracle Education. |
|
Copyright © 1997 Oracle Corporation. All Rights Reserved. |
|