This guide offers configuration details and solutions to the most important troubleshooting questions referring to the Oracle clever Agent The clever Agent User's consultant is directed in the direction of clients of Oracle firm supervisor VersionI and model 2. in addition to different supported method administration frameworks that speak with the Oracle database throughout the clever Agent.This handbook is meant for a person fitting, configuring, or troubleshooting the Oracle clever Agent on UNIX or home windows NT systems. less than so much conditions, the Agent calls for little within the approach of configuration and upkeep. for that reason, the Oracle clever Agent User's advisor might be used as a reference, instead of learn sequentially.
Read or Download Oracle Intelligent Agent. User's Guide PDF
Best databases books
This e-book brings the entire parts of database layout jointly in one quantity, saving the reader the time and fee of constructing a number of purchases. It consolidates either introductory and complicated themes, thereby protecting the gamut of database layout method ? from ER and UML concepts, to conceptual information modeling and desk transformation, to storing XML and querying relocating items databases.
Oracle Call Interface. Programmer's Guide
The Oracle name Interface (OCI) is an software programming interface (API) that enables functions written in С or C++ to have interaction with a number of Oracle database servers. OCI provides your courses the aptitude to accomplish the entire variety of database operations which are attainable with an Oracle database server, together with SQL assertion processing and item manipulation.
Oracle Warehouse Builder 11g: Getting Started
This easy-to-understand educational covers Oracle Warehouse Builder from the floor up, and faucets into the author's broad event as a software program and database engineer. Written in a peaceful type with step by step factors, plenty of screenshots are supplied during the booklet. there are many guidance and priceless tricks all through that aren't present in the unique documentation.
Additional info for Oracle Intelligent Agent. User's Guide
Sample text
There are several reasons why oradbsnmp should be used instead of fetching the values from V$ tables with SQL commands: ■ ■ ■ The Agent maintains a cache of MIB values fetched from the V$ tables to avoid burdening the RDBMS excessively. oradbsnmp is often faster than SQL and imposes less overhead on the system. When SGA access is implemented, it will be transparent to this function, for those MIB variables that are fetched directly from the SGA. In the case of getnext, the next object_id is the next object_id within the private and public RDBMS MIBs, and not one of another MIB.
Orainfo Purpose Syntax This function is used by jobs to get configuration information. orainfo destaddress Parameters destaddress See Common Parameters on page 4-14. Comments orainfo fetches Agent configuration information from the Agent at destaddress. If destaddress is not present, then it is fetched from the Agent on the local machine. The Agent configuration is a Tcl list, as follows: Job and Event Scripts 4-23 OraTcl Functions and Parameters ■ 4-24 A list of databases monitored by this Agent.
The list includes the database name, ORACLE_HOME, and SID for each database. ■ The Agent’s normal RPC address, a tnsnames (TNS) string. ■ The Agent’s file transfer address, a TNS string. Intelligent Agent User’s Guide OraTcl Functions and Parameters orajobstat Purpose This function is used by a job to send intermediate output back to the Console. Syntax orajobstat destaddress string Parameters destaddress See Common Parameters on page 4-14. string string can either be a quoted string of text or a string of the form: FAC-XXXXX where XXXXX is an Oracle message number for the given facility, such as VOC-99999.