Completed the Preinstallation Tasks module

Completed the Installing the Oracle9i Database module

Oracle Enterprise Manager Configuration Guide

Right-click on your desktop and create a shortcut. Enter a pathname of D:\oracle\ora92\bin\sqlplusw.exe or browse to that file, then click Next.

Specify a name for your shortcut and click Finish.

Right-click the new shortcut icon, open the Properties window, and click the Shortcut tab.

Enter /nolog after the target file, enter the SQL*Plus working directory D:\wkdir in the "Start in" field, and then click OK.

Select Start > Programs > Oracle - OraHome92 > Configuration and Migration Tools > Enterprise Manager Configuration Assistant.

At the Welcome window, click Next.

Click Next to accept the default choice (Configure local Oracle Management Server).

Make sure that Create a new repository is selected and click Next.

Because you want to specify the name of the repository instance that is created, click Custom and then Next.

Select In a new local database instance and click Change SID....

Enter oms for the Global Database Name and the SID and click OK.

Click Next.

Specify the username and password as oem and click Next.

Click Yes to create the user. This username must be unique across the environment.

Click Finish to create the database and the repository.

The Database Configuration Assistant will be invoked to create the database.

Enter a password for SYS and SYSTEM. In the examples oracle will be used as the password for both SYS and SYSTEM. After enter your passwords click OK.

Next, the repository will be created.

When the repository creation is complete, click Close.

Open Enterprise Manager Console running Standalone. Logon to the OMS database as sys/oracle as sysdba. Expand Instance, then select Configuration. Then click the Memory tab.

Change the following parameters as follows then click Apply:

Shared Pool: 24 MB
Buffer Cache: 8 MB
Large Pool: 8 MB
Java Pool: 16 MB
Aggregate PGA Target: 10 MB

You will need to stop and start the database for the changes to take effect. Click Yes.

Make sure that Immediate is selected and click OK:

After the shutdown is completed, click Close.

Click File > Exit.

Before you can connect to Enterprise Manager through the Oracle Management Server, you need to make sure that the OracleOraHome92Agent and OracleOraHome92ManagementServer services in your Control Panel Services are running. Note: When an OMS Repository is created, the services are started, but you may want to verify that they are indeed running before moving on to the next task.

Select Start > Programs > Oracle- OraHome92 > Enterprise Manager Console.

At the login window, select Login to the Oracle Management Server and specify sysman as the administrator and oem_temp as the password. The management server you just created is entered by default in the Management Server field. Click OK.

Specify the new password as sysman and click Change.

The Oracle Enterprise Manager Console will appear and the Discovery Wizard will appear automatically. Click Next.

Note: When running the OMS and Agent locally, the local node will automatically be discovered so the Discovery Wizard will not appear.

Enter your hostname as your node and click Next.

Your node will be discovered. When done, click Finish.

You will see your node in the console.

You will need to change the report user administrator password. From the Console, select the Configuration pulldown then select Manage Administrators. Select the REPORTS_USER and click Edit.

Change the default password (oem_temp) to reports_user and click OK. Then click Close.

Click Close.

Now you will need to configure the Web Server for Enterprise Manager Reporting. If you HTTP Server is not already started, you can start it by selecting Start -> Programs -> Oracle - OraHome92 -> Oracle HTTP Server -> Start Oracle HTTP Server powered by Apache.

Open a DOS Command prompt and enter the following command:

oemctl configure rws

Follow the instructions to configure the HTTP Server for Enterprise Manager Reporting by providing the following:

Webserver Name: your node name
Port Number: 3339
Oracle Management Server: your node name
Password for the REPORTS_USER Administrator: reports_user
Would you like to specify an alternate location for historical data [Y/N, default is N]: n
Enter Y to configure the Web Server

To see the Oracle Enterprise Manager Reporting Home Page, open a browser and enter the following URL:

http://<hostname>:3339/

Then click Access Reports.

You will examine this reporting capability in a later module.

Setting up NT Access Privileges

Setting up Windows 2000 Access Privileges

Select Start > Programs > Administration Tools > User Manager.

Select User > New User.

Enter a username of ntoem and a password of ntoem. Select Password Never Expires, deselect all the other options, and click the Groups button.

Select the Administrators and ORA_DBA groups and click Add. Then select the Users group and click Remove. Click OK twice.

Select Policies > User Rights and then click the Show Advanced User Rights check box.

Select Logon as a batch job from the drop down box and click Add.

Click Show Users.

Scroll down, select ntoem, and click Add.

The ntoem user has been added. Click OK twice.

Select User > Exit.

Reboot your system. Note: When your system is loaded, make sure you select your machine name as the domain.

Select Start > Settings > Control Panel.

Double clik Users and Passwords.

Click Add.

Type NTOEM for the User name. Click Next.

Enter a password. Example: NTOEM. Click Next.

Select Other, then Administrator from the drop down menu. Click Finish.

Click the Advanced tab.

Click the Advanced button.

Double click Users in the right hand pane.

Right click NTOEM and select Properties.

Click the Members Of tab.

Click Add.

Select ORA_DBA. Click Add.

Click OK. Click Apply. Click Close.

Close Local Users and Groups.

Click OK.

From Control Panel, double click Administrative Tools.

Double click Local Security Policy.

Double click Local Policies in the right hand pane.

Double click User Rights Assignments from the right hand pane.

Right click on Logon As Batch Job and select Security...

Click Add.

Select NTOEM. Click Add. Click OK. Click OK.

Close Local Security Settings.

Close Administrative Tools.

Unzip postinstall.zip into your working directory.

Open the SQL*Plus session you just created and execute the following commands:

connect / as sysdba
@unlock_users

SET TERMOUT OFF
SET NEWPAGE 0
SET PAGESIZE 0
SET LINESIZE 132
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF

SPOOL unlockusers.sql

SELECT 'ALTER USER '|| username ||' identified by '|| username ||' 
  ACCOUNT UNLOCK;'
  FROM dba_users
  WHERE account_status LIKE '%LOCKED%';

SPOOL OFF

@unlockusers.sql

SET PAGESIZE 14
SET NEWPAGE 1
SET HEADING ON
SET FEEDBACK ON
SET ECHO ON
SET TERMOUT ON

From your SQL*Plus session, execute the following statements:

@alter_temp

SET TERMOUT OFF
SET NEWPAGE 0
SET PAGESIZE 0
SET LINESIZE 132
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF

SPOOL altertemp.sql

SELECT 'ALTER DATABASE TEMPFILE '''|| a.name ||''' 
    AUTOEXTEND ON NEXT 5M MAXSIZE 200M;'
    FROM v$tempfile a, v$tablespace b
    WHERE b.name = 'TEMP'
    AND a.ts# = b.ts#;

SPOOL OFF

@altertemp.sql

SET PAGESIZE 14
SET NEWPAGE 1
SET HEADING ON
SET FEEDBACK ON
SET ECHO ON
SET TERMOUT ON