Oracle8(TM) Getting Started for Windows NT
Release 8.0.3
A53722-01

Library

Product

Contents

Index


Prev Next

6
Configuration Tasks

This chapter describes post-installation configuration tasks for Oracle8.

Specific topics discussed are:

What Must You Configure?

The Oracle8 ConText Cartridge configuration procedures described in this chapter are required only if you choose to add it to an already installed Oracle8 database. Review the table below to identify your configuration responsibilities.

Product   Automatic Configuration   Manual Configuration  

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.  

Oracle8 ConText Cartridge

 

The Oracle8 ConText Cartridge is automatically configured if you select it for installation:

  • When prompted during the Typical or Oracle Database Assistant database installation of Oracle8.
  • Along with Oracle8 during Custom installation in the Software Asset Manager window.

You can select the Oracle8 ConText Cartridge for installation in either of these two scenarios.  

See the section, "Configuring Oracle8 ConText Cartridge" in this chapter for manual configuration instructions.  

Configuring Net8

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:

Configuring Oracle Enterprise Manager

Oracle Enterprise Manager

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.

Attention:

Oracle Enterprise Manager uses an Oracle8 repository database to store its information. This repository database is an Oracle8 database installed on the Oracle Enterprise Manager console if it is a Windows NT machine, or on another Windows NT machine where a Windows 95 or Windows NT Oracle Enterprise Manager console can connect.

The database on the Oracle8 server must not also act as the Oracle8 repository database. If it does, you will not be able to perform many database administration tasks, such as starting or shutting down the database. The repository database must be on a separate machine whose sole responsibility is to act as the Oracle Enterprise Manager's storage resource.  

Oracle Intelligent Agent

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:

  • listens for and responds to job requests initiated by the Oracle Enterprise Manager console workstation
  • schedules job requests (requests can include detecting and correcting abnormal conditions, performing standard database administration procedures, and monitoring events)
  • executes the job request

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 for Windows NT machine:

  1. Step 1: Start Oracle Services
  2. Step 2: Create a Repository User Account
  3. Step 3: Create an NT User Account
  4. Step 4: Create Configuration Files
  5. Step 5: Create the Repository and Discover Services

Each of these tasks is described in the sections that follow.

Step 1: Start Oracle Services

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:

  1. Start the OracleServiceSID, OracleTNSListener80, and OracleAgent services on Oracle8 database:
    • From the MS-DOS command line, enter:
    • C:\>NET START SERVICE
      
    • From the Control Panel's Services window, select a service, and choose Start.
  2. Continue to "Step 2: Create a Repository User Account".

Step 2: Create a Repository User Account

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:

  1. Start Server Manager and connect to the Oracle8 repository database:
  2. C:\> SVRMGR30
    SVRMGR> CONNECT SYSTEM/MANAGER
    
  3. Create a special tablespace for the Oracle Enterprise Manager repository:
  4. 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.

  5. Create a user account where the user's default tablespace is the newly-created tablespace:
  6. SVRMGR> CREATE USER USERNAME IDENTIFIED BY PASSWORD
    2> DEFAULT TABLESPACE REPOSIT_TABLESPACE;
    
  7. Grant the SYSTEM privileges to this user account:
  8. SVRMGR> GRANT DBA TO USERNAME IDENTIFIED BY PASSWORD;
    
  9. When done, enter:
  10. SVRMGR> EXIT
    

    Exiting Server Manager closes the database connection.

  11. Follow Steps 1-5 for additional repository user accounts.

Step 3: Create an NT User Account

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 server.

To create a user account on the Oracle8 server:

  1. Choose Start>Programs>Administrative Tools (Common)>User Manager:
  2. The User Manager window appears:

  3. Choose New User from the User menu.
  4. The New User dialog box appears:

  5. Enter the appropriate information in the dialog box:
    1. Enter a user name that is the same as the one you entered in section "Step 2: Create a Repository User Account" in the Username field.
    2. Enter the same password you entered in section "Step 2: Create a Repository User Account" in both the Password and Confirm Password fields.
    3. Make sure the User Must Change Password at Next Logon check box is not checked and Password Never Expires check box is checked.
    4. Make the user a member of the Administrator's group by choosing Groups.
    5. The Group Memberships dialog box appears:

    6. Select Administrators from the Not member of list box and choose <- Add.
    7. Administrators is added to the Member of list box.

    8. Click OK to close the Group Memberships dialog box and return to the New User dialog box.
  6. Click OK in the New User dialog box.
  7. The user is added and the User Manager window re-appears.

  8. Select the newly-created user and choose User Rights from the Policies menu.
  9. The User Rights Policy dialog box appears:

  10. Click the Show Advanced User Rights check box and select Log on as a batch job from the Right drop-down list box.
  11. Select Users from the Grant To list box.
  12. If Users does not exist, create it:

    1. Click Add.
    2. The Add Users and Groups dialog box appears:

    3. Select the names of the local host machine from the List Names From drop-down list box.
    4. Select Users from the Names list box and click Add.
    5. Click OK.
    6. Users appears in the Grant To list box.

  13. Click OK in the User Rights Policy dialog box.
  14. The User Manager window re-appears.

  15. Choose Exit from the User menu.
  16. Repeat Steps 1-9 for any other repository user accounts you created.

Step 4: Create Configuration Files

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 Networking Products Getting Started for Windows Platforms and the Net8 Administrator's Guide for complete information about configuring your network.  

Step 5: Create the Repository and Discover Services

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:

  1. Choose Start>Programs>Oracle Enterprise Manager.
  2. The Oracle Enterprise Manager Repository Login Information dialog box appears:

  3. Enter the following appropriate information and choose OK:
    • Repository user name and password you created in "Step 2: Create a Repository User Account" in Username
    • Net8 service name (or database alias) of the repository database; only necessary to enter service name if you are connecting from a client console machine connecting to the Oracle8 repository database

    The Oracle Repository Manager window appears, prompting you to build the repository:

  4. Click OK.
  5. The repository is built.

    The Discover New Services Wizard appears:

  6. Follow the wizard to discover services.
  7. Services are discovered when you see the dialog box below with a status of Discovered:

  8. Click Close.
  9. The Oracle Enterprise Manager Console appears:

Configuring Oracle8 ConText Cartridge

If you are adding Oracle8 ConText Cartridge to an already installed Oracle8, you must follow these configuration procedures. If you installed Oracle8 ConText Cartridge during the same installation as Oracle8, you do not have to perform the procedures in this section; Oracle8 ConText Cartridge was automatically configured for you.

To configure Oracle8 ConText Cartridge:

  1. Create the Oracle8 ConText Cartridge dictionary and packages in the schema CTXSYS. About 5 MB of database space is needed for these objects. You can create these objects in an existing tablespace or preferably in a separate tablespace.
  2. To create objects in an existing tablespace:

    1. Extend the existing tablespace by at least 5 MB.
    2. Start Server Manager at the MS-DOS command prompt:
    3. C:\> SVRMGR30
      
    4. Connect to the database as SYSTEM:
    5. CONNECT SYSTEM/MANAGER
      
    6. Expand an existing tablespace by at least 5 MB.
    7. SVRMGR30> ALTER TABLESPACE EXISTING_TABLESPACE;
      SVRMGR30> ADD DATAFILE `%ORACLE_HOME%\DATABASE\SYS2ORCL.ORA' SIZE 5 M; 
      
    8. Exit Server Manager:
    9. SVRMGR30> EXIT 
      

    To create objects in a separate tablespace:

    1. Create a tablespace of at least 5 MB.
    2. Start Server Manager at the MS-DOS command prompt:
    3. C:\> SVRMGR30
      
    4. Connect to the database as SYSTEM:
    5. SVRMGR30> CONNECT SYSTEM/MANAGER
      
    6. Create a tablespace called DRSYS with a size of at least 5 MB.
    7. SVRMGR30> CREATE TABLESPACE DRSYS DATAFILE 
      '%ORACLE_HOME%\DATABASE\DR1ORCL.ORA' SIZE 5 M; 
      
    8. Exit Server Manager:
    9. SVRMGR30> EXIT 
      
  3. Go to the ORACLE_HOME\CTX80\ADMIN directory and execute the scripts DRCRSYST.SQL and DR0INST.SQL.
  4. To execute the DRCRSYST.SQL script:

    1. Start SQL*Plus:
    2. C:\> PLUS80W
      
    3. Enter the SYSTEM username and MANAGER password when prompted.
    4. Execute the DRCRSYST script:
    5. 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.

    6. Exit SQL*Plus:
    7. SQLPLUS> EXIT
      

    To execute the DR0INST.SQL script:

    1. Start SQL*Plus:
    2. C:\> PLUS80W
      
    3. Enter the CTXSYS username and password when prompted.
    4. Execute the DR0INST script:
    5. SQLPLUS> @DR0INST 
      
    6. Exit SQL*Plus
    7. SQLPLUS> EXIT
      
  5. Import the Oracle8 ConText Cartridge linguistics settings into the schema of user CTXSYS.
    1. Go to the directory ORACLE_HOME\CTX80\ADMIN.
    2. C:\> CD ORACLE_HOME\CTX80\ADMIN
      
    3. Execute the IMP80 command:
    4. C:\ORACLE_HOME\CTX80\ADMIN> IMP80 CTXSYS/PASSWORD_FOR_CTXSYS \ 
      FILE=CTXSET.DMP FULL=Y IGNORE=Y 
      
    5. Execute the DRSYS.SQL script. This creates a user called DRSYS for backward compatibility purposes.
    6. C:\ORACLE_HOME\CTX80\ADMIN> PLUS80W SYSTEM/PASSWORD_FOR_SYSTEM 
      SQLPLUS>@DRSYS 
      
    7. Exit SQL*Plus:
    8. SQLPLUS> EXIT
      
  6. Add or check for the following line in the INITSID.ORA file. This is required to issue one-step queries through the Oracle8 ConText Cartridge.
  7. TEXT_ENABLE = TRUE 
    
  8. Set the SHARED_POOL_SIZE initialization parameter in the INITSID.ORA file to at least 9 MB when using the Oracle8 ConText Cartridge.
  9. Restart the database.
  10. 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:

  1. Go to the ORACLE_HOME\CTX80\DEMO directory.
  2. Run SQL scripts in order to get these demos to work.

Running Server Processes on Windows NT

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.




Prev

Next
Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.

Library

Product

Contents

Index