0115-0118 | Oracle Development Unleashed (3rd Edition)

Previous Table of Contents Next

Page 115

TIP

If you log on to SCHEMA MANAGER as the owner of the repository or as a non-DBA role user and attempt to create tables or objects in other users' schema, you might receive an Oracle error ORA-902. Make sure the repository owner for the Oracle Enterprise Manager or the user connecting to SCHEMA MANAGER has the DBA privilege to create tables or objects in any schema.

TIP

When you select data export, import, or load from the Data Manager dialog box, a seven-page Data Manager Wizard helps you through the process step-by-step. However, it is not clear how to perform a from-user-to-user import. You can follow these steps to do a from-user-to-user import:

In Data Manager, expand the Users folder.

Right-click the user you plan to import to and select Import from the pop-up menu.

On Page 1 of the Data Manager Wizard, specify your export file and then choose Next.

On Page 2, in the Importable Objects window on the top, select the user you want to import from. In the Selected Objects window on the bottom, the user you want to import to should be highlighted.

Click the down-arrow icon between the Importable Objects window and the Selected Objects window. Figure 6.2 shows the Data Manager Wizard dialog box at this step.

Follow the rest of the five pages in the Data Manager Wizard to finish the from-user-to-user import.

Figure 6.2.
The Data Manager
Wizard dialog box
performing a from- user -
to- user import.

Page 116

Oracle Administrator Toolbar

The Oracle Administrator Toolbar provides fast access to the Oracle Enterprise Manager database administration tools and utilities without the Oracle Enterprise Manager console. You can access the Security Manager, Schema Manager, Storage Manager, SQL Worksheet, and Instance Manager directly from the Oracle Administrator Toolbar. You can also configure the toolbar to display specific DBA tools, provide access to tools from third-party vendors , and connect to a default username, password, and service name .

Oracle WebServer Manager

The Oracle WebServer Manager enables you to manage the available Web servers in your network. It is integrated within the Oracle Enterprise Manager. Unlike the other components of the Oracle Enterprise Manager, such as the Schema Manager, the Oracle WebServer Manager does not run as a separate application from the Oracle Enterprise Manager. To display the Web servers in your network, you need to select the Wizard option of the Navigator Discovery from the Oracle Enterprise Manager console to discover the Web servers automatically.

Oracle7 Performance Monitor for Windows NT

The Oracle7 Performance Monitor for Windows NT allows you to measure the performance of the local or remote servers on the network. You can view the behavior of the important system objects, such as processor, memory, and physical disk. You can also view the behavior of the Oracle objects, such as buffer cache, DBWR, free list, and library cache. For each object, you can select a counter to display the desired information about the object. For example, if you want to view the behavior of the Oracle buffer cache, you add the Oracle7 Buffer Cache object with the %phyreads/gets counter for this object to the chart. Figure 6.3 shows the Oracle7 Performance Monitor for Windows NT dialog box.

Oracle Intelligent Agent

The Oracle Intelligent Agent communicates with the Oracle Enterprise Manager console to manage and monitor services, such as databases, listeners, and parallel servers, on remote machines in your network. The agent is also responsible for accepting, running, and canceling jobs or events from the Oracle Enterprise Manager console or other third-party applications. You must install, configure, and start the agent on each node you want to manage. The Oracle Intelligent Agent is currently available for the Windows NT and UNIX platforms. For step-by-step installation and configuration of the Oracle Intelligent Agent, please refer to your Oracle Enterprise Manager Installation Guide.

To start or stop the agent on a UNIX machine, you can enter the following commands at the UNIX prompt:

 $ lsnrctl dbsnmp_start $ lsnrctl dbsnmp_stop

Page 117

Figure 6.3.
The Oracle7
Performance Monitor
for Windows NT dialog
box.

On Windows NT, you can start or stop the OracleAgent service listed in the Services window. To bring up the Service window, double-click the Services icon in Control Panel. You can also run the following commands at the DOS prompt to start, stop, or check the status of the agent:

 c:> net start oracleagent c:> net stop oracleagent c:> lsnrctl dbsnmp_status

TIP

When starting the Oracle Intelligent Agent version 7.3.3 for Windows NT, you might receive the following error:
 System error 7: Storage control blocks were destroyed. 
First, check your \orant\network\log\nmiconf.log. If the log contains the message unable to open registry key: system\currentcontrolset\services\tcpip\parameters, system cannot find the file specified, then you might not have installed or configured TCP/IP properly. If you verify that TCP/IP is installed and functioning correctly, make sure the SID for the local database is in the SID_LIST of the listener.ora file.

Once the Oracle Intelligent Agent (version 7.3.3 or later) is installed and running, you can use the Navigator Discovery feature in the Oracle Enterprise Manager console to auto-discover the network services and populate the Navigator tree. If you add new services to a node, you need to restart the agent on that node and then use the Navigator Discovery feature to discover

Page 118

the new services. The auto-discovery feature with the agent is dependent on the listener.ora and the tnsnames.ora files. For the agent to discover a database on your host, you must specify a valid alias in the tnsnames.ora file for that database. Otherwise, the database will not be discovered .

NOTE

The Oracle Intelligent Agent version 7.3.3 is not auto-discovering databases defined by Oracle Names as specified by the Oracle Enterprise Manager Installation Guide. This problem is fixed in version 8.0.3. A workaround is to copy the tnsnames.ora file on each node.

Network Manager for Windows

Before you start using SQL*Net version 2, you might need to create or modify several configuration files, such as the listener.ora and tnsnames.ora files. These files are not easy to create or modify manually because they need to follow certain syntax for different network protocols. The Network Manager for Windows is a graphical tool that enables you to create or modify these configuration files by entering the necessary information on the screen. Before the Network Manager generates the configuration files, it validates the information that you enter and warns you if it discovers any inconsistency. Figure 6.4 shows the Network Manager for Windows dialog box.

Figure 6.4.
The Oracle Network
Manager for Windows
dialog box.

Previous Table of Contents Next