Displaying a view on a Windows™ workstation with an Oracle 11g schema
To display a view on a Windows™ workstation
with an Oracle 11g
schema installed, perform the following steps:
- Verify that the Oracle Enterprise
Manager Console is accessible from a client browser. This implies
that the dbconsole process is running on the server. This process
starts automatically after the installation. To verify that the dbconsole process
is running, and start it if it is not running, perform the following
steps:
- Select Start → Settings → Control Panel → Administrative Tools → Services. The Services (Local) window opens.
- Locate the OracleDBConsoleORACLE_SID service, where ORACLE_SID is
the name of the Oracle database
created on the workstation. The Status column shows the status
of the service.
- If the Status column is Started:
- The dbconsole process is running on the server.
- If the Status column is blank, the process is stopped. To start it, perform the following steps:
-
- Double-click the OracleDBConsoleORACLE_SID service row. The OracleDBConsoleORACLE_SID Properties (Local Computer) dialog displays.
- In the General page, ensure that the Startup type is either Automatic or Manual.
- In the Service status group, click Start.
- Select Start → Programs → Oracle-installation_name → DatabaseControl- database_name. The Oracle Enterprise Manager 11g Login to Database database_name web page displays.
- Type the following information and click Login:
- Username
- It can be:
- Oracle administrator user
- The database administrator user name, for example SYSTEM, required to authenticate to the Oracle database.
- HCL Workload Automation user
- The owner of the HCL Workload Automation schema.
- Password
- The password associated with the user specified in the Username field.
- In Related Links, select SQL Worksheet. The SQL Worksheet: database_instance_name web page displays.
- In the Enter SQL commands input area, enter the following
command:
where view_name is the name of the view from which you want to display the information. The view name has the following format:select * from view_name
where username is the name of the owner of the HCL Workload Automation schema. For example, if the user name is TWSuser, to extract information from the username.JOB_HISTORY_V view, enter the following command:username.JOB_HISTORY_V
select * from TWSuser.JOB_HISTORY_V
- Click Execute. The output area displays the results of the query.