OEM requires the use of a "repository" in which it stores allit'sinformation. This repository is a group of database tables. Oraclesuggests that you keep this repository on a machine other than the machinethatyour production database(s) reside on. That way if either of the databasescrash you will still have access to database structure information byeitherre-creating the OEM repository if it crashed or looking up theinformation in the repository if the production database crashes.

After installing the OEM software, and before you start it up for thefirst time, create a new tablespace (ex OEMSPACE) to store the repositoryin. Next create a new database user (ex OEMUSER). Make sure to assign theOEMUSER a default tablespace of OEMSPACE and grant the OEMUSER the DBAprivilege.

Next, start up the OEM console and give the OEMUSER/password. Youwill then see a dialog box that asks if you want to create the repository.Hit the CREATE button and OEM will install the repository tables in theOEMUSERs schema.

The first thing you want to do once the repository is created is todiscover the Oracle services on other nodes. If the other nodes are runningversion 7.3.3 or higher of the Oracle Intelligent agent, you can discoverthese services automatically by selecting the following options from thetool bar:

Navigator/Service Discovery/Discover New Services

If you are not running the intelligent agent you can manually discoverservices by using the following option from the tool bar:

Navigator/Service Discovery/Manually Define Services

This will bring up a wiward that will let you supply node name (ipaddress) and databases to discover. The database portion is misleading, itisnot the name of the database, but the actual SQL*Net connect string thatyou would use to connect to the database. This connect string must existin the TNSNAMES.ORA file on the same machine that the OEM console isrunningon. For this reason you must configure each SQL*Net connection beforeattempting to discover the services in OEM.

Once your services are discovered you will be able to manage any ofthese databases from the OEM console.

The fall Wizard '98 seminar is soon approaching. We are looking forwardto anexciting event. A preliminary agenda has been sent out with such topicsasfirewalls, OpenVMS, Digital Unix, and deploying forms on the web to be covered.We have changed the layout of the conference to allow for more breakoutsessions for round-table discussions.

The seminar will be held at the former Four Points Hotel (currently aHolidayInn), Syracuse, NY, located directly across from Exit 37 of the NYS ThruwayonElectronics Parkway in Liverpool.

For Hotel reservations, please call (315) 457-1122. A block of rooms isbeingheld for Wizard participants so mention this when making reservations. Besureto bring your tax-exempt form.

The cost will be $15 for one day and $25 for both days, which is to be paidupon arrival at the Wizard registration desk. Checks should be made outto theSUNY Training Center.

We look forward to seeing everyone there to further strengthen and buildtheSUNY community. If you have any questions, or would like to see anagenda,please call the SUNY Training Center at (315) 464-4078.