Download e-book for kindle: Oracle Intelligent Agent. User's Guide by

This handbook offers configuration details and solutions to the most important troubleshooting questions concerning the Oracle clever Agent The clever Agent User's advisor is directed in the direction of clients of Oracle firm supervisor VersionI and model 2. in addition to different supported approach administration frameworks that converse with the Oracle database during the clever Agent.This guide is meant for somebody 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 manner of configuration and upkeep. as a result, the Oracle clever Agent User's advisor will be used as a reference, instead of learn sequentially.

Show description

Read or Download Oracle Intelligent Agent. User's Guide PDF

Best databases books

The New Relational Database Dictionary: Terms, Concepts, and - download pdf or read online

It doesn't matter what DBMS you're using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can continually come up over the correct meanings of phrases, misunderstandings which may have a major impression at the luck of your database tasks. for instance, listed below are a few universal database phrases: characteristic, BCNF, consistency, denormalization, predicate, repeating crew, subscribe to dependency.

Extra info for Oracle Intelligent Agent. User's Guide

Sample text

EMP where job like :jobclass; end; } set idpass $argv if {[string length $idpass] == 0} { set idpass "scott/tiger" } set lda [oralogon $idpass] set cur1 [oraopen $lda] set cur2 [oraopen $lda] orasql $cur1 $find_jobs_sql set job [orafetch $cur1] while {$oramsg(rc) == 0} { set total_for_job [lindex [oraplexec $cur2 $monthly_pay_pl :monthly "" :jobclass "$job"] 0] puts stdout "Total monthly salary for job class $job = \$$total_for_job" set job [orafetch $cur1] } oraclose $cur1 oraclose $cur2 oralogoff $lda exit Job and Event Scripts 4-5 Server Message and Error Information Server Message and Error Information OraTcl creates and maintains a Tcl global array oramsg to provide feedback of Oracle server messages.

Ora file is not found, the database alias, _ , is assigned to a database service. The service will be known to the Agent by this alias, and it will be visible as such at the Oracle Enterprise Manager Console. ORA file, the Agent will use the one listed first. ORA file entries and restart the Agent. If a database or any other new service is installed on the node where the Agent resides, the Agent must be restarted to add the new service to the Agent configuration files. This procedure also applies to UNIX versions of the Intelligent Agent.

Syntax oracols logon-handle Parameters logon-handle See Common Parameters on page 4-14. Comments oracols raises a Tcl error if the logon-handle specified is not open. The oramsg array index collengths is set to a Tcl list corresponding to the lengths of the columns; index coltypes is set to a Tcl list corresponding to the types of the columns; index colprecs is set to a Tcl list corresponding to the precision of the numeric columns, other corresponding non-numeric columns are a null string (Version 7 only); index colscales is set to a Tcl list corresponding to the scale of the numeric columns, other corresponding non-numeric columns are a null string (Version 7 only).

Download PDF sample

Rated 4.19 of 5 – based on 46 votes