2
Standalone

Beginning with Release 9.0, the Enterprise Manager Console or various other Enterprise Manager applications can be started standalone or with a Management Server connection. When you start the Enterprise Manager Console or other applications standalone, the Console or other application is not connected to the middle tier Management Server.

Because it does not require a middle tier Management Server or Intelligent Agents on target machines, the Console started standalone enables a single administrator to perform simple database schema, instance, storage, security, and other database tasks by connecting directly to the target database or databases.

This chapter will describe the out-of-box requirements for running the Console standalone.

Choosing to Start the Console Standalone

Start the Console standalone when you want to connect directly to your managed target or targets to perform administration tasks. With Enterprise Manager Release 9.2.0, the standalone Console only supports connecting directly to database targets. No other target types are currently supported for direct connection from the Console.

Figure 2-1 Standalone Configuration

Text description of the illustration two_tier.gif

Starting standalone does not require a Management Server as a middle tier or Intelligent Agents on managed targets. Consequently, when you start the Console standalone, you do not have access to functionality typically available through the Management Server and Intelligent Agent, such as:

• Management of several different target types. The target types include database, HTTP server, application server, and applications
• Sharing of administrative data among multiple administrators
• Proactive notification of potential problems
• Automation of repetitive administrative tasks
• Backup and data management tools
• Customization, scheduling, and publishing of reports
• Running the client from within a web browser
• LogMiner Viewer

Starting the Standalone Console

On Windows-based platforms, start the Console from the Windows Start Menu.

On any supported platform, you can start the Console from the command line by entering the command:

oemapp console

On UNIX platforms, the oemapp part of the command is case-sensitive and must be entered with lowercase characters.

When the Oracle Enterprise Manager Console Login appears, select the Launch standalone option and click OK.

Figure 2-2 Oracle Enterprise Manager Console Login

Text description of the illustration login_st.gif

To bypass the Oracle Enterprise Manager Console Login, you can enter the following command at any supported operating system command line:

oemapp console oem.loginmode=standalone

By entering the command, you will immediately see the standalone Console.

Figure 2-3 Standalone Console

Text description of the illustration standalo.gif

If you are starting the standalone Console for the first time, the left panel of standalone Console is empty because you have not yet added the databases you want to manage. The Add Databases To Tree dialog appears automatically so that you can add them to the Navigator.

Adding Databases to the Tree in the Standalone Console

You can also access the Add Databases To Tree dialog from the Navigator menu.

Figure 2-4 Add Databases to Tree

Text description of the illustration add_db_t.gif

The Add Databases To Tree dialog enables you to manually enter the Net service names or add them from the local tnsnames.ora file.

Add a database manually

You can add databases to the standalone Console Navigator by filling in the following fields:

• SID: The database system identifier, usually the instance name, such as ORCL.
• Hostname: The machine or node name where the database is located.
• Port Number: The database listener port address, usually 1521 or 1526.
• Net Service Name: A name which uniquely identifies a database when connecting to a machine. It is usually the global database name.

  For example: ORCL.world.

.

Add selected databases from your local tnsnames.ora file

You can populate the standalone Console Navigator by reading the database service names from the local tnsnames.ora file located in your Oracle Enterprise Manager home. The Add Databases To Tree dialog displays a list of databases identified in your tnsnames.ora file from which you can select or clear. Click the column header to the left of Service Name to either select or clear all the database boxes. If you have cleared all the selected database boxes, you can select specific databases by clicking their boxes.

After adding databases to the Navigator, see the Oracle Enterprise Manager Administrator's Guide for details on how to use the standalone Console to perform administration tasks.

Standalone Repository

The standalone Console includes several integrated applications. Some of these integrated applications require a standalone repository in which to save information.

The standalone repository is different from the repository used by the Management Server since it is used for a single user while the Management repository is used for multiple users.

The applications which require a standalone repository include:

• Change Manager
• Oracle Expert
• Oracle SQL Analyze

The first time one of the above standalone applications is accessed, you will be prompted to create a database user who will own the standalone repository schema or you will be prompted to specify a username and password if you have already created the user.

Figure 2-5 Prompt to Create Database User

Text description of the illustration prompt.gif

Figure 2-6 Repository Login

Text description of the illustration replogin.gif

Because this database user must have certain roles and privileges, Oracle recommends creating a new database user to own the standalone repository schema. In addition, because certain tablespace attributes are required for the standalone repository, you should also create a new tablespace. Once the user and tablespace have been created, you can supply the user's username and password, and the standalone application will automatically create the standalone repository for you.

When subsequent standalone applications which require a standalone repository are accessed, they will all use the same standalone repository. If you do not want to be prompted with the standalone Repository Login dialog every time you start your standalone application, select the Save password and automatically log into repository next time option to save the credentials for future use.

Database Requirements for Standalone Repository

The following database releases are supported for the standalone repository:

• Enterprise Edition or Standard Edition Release 9.2.x
• Enterprise Edition or Standard Edition Release 9.0.1.x
• Enterprise Edition or Standard Edition Release 8.1.7.x

You must ensure that the database in which the repository will be placed has object support. If it does not, repository creation will fail. Either select another database that has object support, or install and enable object support on the chosen database.

Create a Tablespace for Standalone Repository

Create a tablespace with the following attributes:

• Type: Permanent
• Storage attributes: for Extent Management, use Locally managed
• Datafile attributes:
  • Size:
    • For 2 Kb blocks: 16 MB
    • For 4 Kb blocks: 24 MB
    • For 8 Kb blocks: 32 MB
    • For sizes above 8 KB: 64 MB
  • Reuse Existing File: Yes
  • AUTOEXTEND: Yes
  • AUTOEXTEND increment: 5MB
  • AUTOEXTEND maximum: 2000MB

To create a tablespace for the standalone repository, first select the database in which you want to place the standalone repository, ensuring it meets the requirements outlined. Then, follow the procedure described in this section:

1. Start the standalone Console.

   On Windows:

   You can start the standalone Console from the Windows Start Menu.

   On UNIX:

   You can start the standalone Console from the command line using the command:

   oemapp console

   When the Oracle Enterprise Manager Console Login appears, select the Launch standalone option to connect directly to databases and click OK.

2. Click the + next to Databases to display the list of databases under the Databases.
3. Double-click the database node in the Navigator and connect to the database as a user with the NORMAL privilege.
4. Choose Create from the Object menu. The Create Object List dialog appears.
5. Expand the database node in the Create Object List dialog and select Tablespace. Then click Create. The Create Tablespace property sheet appears.
6. In the Create Tablespace Property Sheet's General page,
   1. Enter the name of the new tablespace, OEM_REPOSITORY.
   2. Specify that the tablespace will be used to hold permanent database objects.
7. In the Datafile section, enter the size of the new datafile. The File Name and File Directory columns should already contain default entries. The datafile is called OEM_REPOSITORY.dbf or OEM_REPOSITORY.ora depending on the version of the database.
8. Right-click the + next to OEM_REPOSITORY.dbf and choose Edit. The Create Datafile property sheet appears.
9. In the Create Datafile's General page, select the Reuse Existing File box.
10. In the Create Datafile's Storage page, fill the appropriate attributes
    1. Select the Automatically extend datafile when full (AUTOEXTEND) option so that the datafile will automatically increase in size when more space is needed in the database.
    2. Specify 5 MB as the Increment.
    3. Specify 2000 MB as the Maximum Size.
11. Click OK in the Create Datafile property sheet.
12. In the Create Tablespace Property Sheet's Storage page, select the Locally Managed option as the method of space management.
13. Click Create in the Create Tablespace Property Sheet.

Create a Database User for Standalone Repository

A standalone repository is owned by a database user. A database user, in other words, a repository schema user, who will own the repository must be created before the standalone repository can be created by Enterprise Manager.

To create a database user who will own the standalone repository, follow the procedure described in this section:

1. Start the standalone Console.
2. Click the + next to Databases to display the list of databases under the Databases.
3. Double-click the database node in the Navigator and connect to the database as a user with the NORMAL role.
4. Choose Create from the Object menu. The Create Object List dialog appears.
5. Expand the database node in the Create Object List dialog and select User. Then click Create. The Create User property sheet appears.
6. In the General page, provide the name of the user and its password and select OEM_REPOSITORY as the default tablespace and TEMP as the temporary tablespace.
7. In the Role page, grant the CONNECT and SELECT_CATALOG_ROLE roles to the repository user.
8. In the System Privileges page grant the CREATE TRIGGER, CREATE PROCEDURE, EXECUTE ANY PROCEDURE, CREATE TYPE, EXECUTE ANY TYPE, SELECT ANY TABLE, and (for 9i) SELECT ANY DICTIONARY privileges to the repository user.
9. In the Quota page, specify unlimited for OEM_REPOSITORY and TEMP.
10. Click Create in the Create User property sheet.

Once you have a tablespace and a repository user, start a standalone application which requires a standalone repository.

When the dialog appears informing you that certain features of Enterprise Manager require a standalone repository and you must create a new database user to own the standalone repository schema, click OK to close the dialog since you have already created the user.

Supply the user's username and password for the repository login and click OK. The standalone application will automatically create the standalone repository for you.