iSelfSchooling.com - Copyright © 1999-2007 iSelfSchooling.com  References  Job Openings  |  Secure Login
    Home  | Search more...  |  FREE Online VIDEO Oracle Training  |  Gift Store  |  Bookstore

   Unlimited access!   

    Oracle  Syntax  | Suggestions Your Contribution  |  FREE Legal Forms

 

Email2aFriend Homepage us! |  Bookmark   -  Copyright & User Agreement

Products/Services

 Vision/Mission

 Community Sharing

 Services

  Products

 Biography

 Contact Us

 FAQ

 Current News

 Website Traffic

 Bookstore

 FREE Training

 SQL

 PL/SQL

 Forms 

 Reports

 Other TOOLS

 Fundamentals

 Performance

 OEM

 Application Server

 Grid Control

 Articles

 Prepare for OCP

Oracle SYNTAX

 Oracle Functions

 Oracle Syntax

 Oracle 10g Syntax

  PL/SQL Syntax

UNIX and more...

 UNIX for DBAs

 LINUX for DBAs

 DB using PHP

  A+ Certification

 Basics of JAVA  

 Tips of  SEO

Finance/Jobs

 Financial Aid

 Skilled

 Oracle

 Jobs

  Magazine

More Training

 Q & Answers

 SQL-PL/SQL

 DBA

 Developer

 Important Notes

 Case Studies

 9i New Features

 10g New Features

 10g Qs/As

 Grid Control

 OracleAS # I

 OracleAS # II

  LDAP and OID

  HTTP Server

 Instructor-Led

  Virtual Hosts

 Community Sharing

More to know...

Acknowledgement**

 FREE Legal Forms

 Who is who

 Market Place

 University Directory

 Advisory Articles

 Links...

 

 

How to clean my Intelligent Agent on Oracle 9i?

 

More Resources by Google:

By: John Kazerooni

To clean your intelligent agent on Oracle 9i, do the following steps:

 

1.        Make sure to remove all jobs and events registered against your server using OEM.

2.        Make sure your agent is shutdown. #agentctl stop

3.        Relink the agent. # $ORACLE_HOME/network/lib/make –f ins_oemagent.mk install 1>log.1 2>log.2

4.        Login to root and change the ownership and mode of the $ORACLE_HOME/bin/dbsnmp file.

a.       # su root

b.       # chown root $ORACLE_HOME/bin/dbsnmp

c.       # chmod 6751 $ORACLE_HOME/bin/dbsnmp

5.        Now, clean the agent:

a.       Go to the $ORACLE_HOME/network/agent directory and delete the following files:

                                                               i.      # {services.ora, *.q, *.inp, *.jou, and out*}

                                                             ii.      NOTE: DO NOT DELETE the SVPPCART.DAT file that exists with 9.0.1 and later Agents. This file is the definition file for the Agents Data Gatherer Cartridge and is not generated by the Agent.

b.       Go to the $ORACLE_HOME/network/admin directory and delete the following files:

                                                               i.      # {snmp_ro.ora, snmp_rw.ora

c.       Rename all the log files in the $ORACLE_HOME/network/log directory.

d.       Make sure that you don’t have any core dumps in the ORACLE_HOME/network/lib directory.

e.       Recreate the snmp_ro.ora file with the following line. (snmp.visibleservices = ())

6.        Start the agent (# agentctl start).  If the above didn’t work then activate the trace on the agent by the following statements and read the snmp.log file.

c.        dbsnmp.trace_level =16

d.        dbsnmp.trace_unique=true

 

SERVICES.ORA

This file contains all the services the agent has discovered. This file will be recreated the next time the agent starts.

 

*.q

These files are the binary representation of all registered and running jobs and events. The agent creates new fresh files on startup when they do not exist. Information about the host the agent is running on is stored in these files. If the name or the IP address of the agent machine changes, these files need to be recreated.

 

*.inp

These files are parameter files for registered jobs.

 

*.jou

These files are journal files with information the agent will use to execute jobs.

 

out*

These files are temporary output files. These files are generated when jobs are being executed and should be automatically removed by the agent after a job finishes.

 

tcl*

These files are TCL template scripts, including the specific commands specified in the job send to the agent. There are

*.tcl files in other directories DO NOT delete the other TCL files. They are scripts that ship with the Agent.

 

DBSNMP.VER

This file is a text file with the agent version information. This file will also be recreated when the agent starts again.

 

SNMP_RO.ORA

This file contains read-only information about the Agents discovered services on the machine. This file should never be manually edited! During startup, this file is read if it exists, and then recreated again with the new discovery information.

 

SNMP_RW.ORA

This file contains read-write information about the Agents discovered services on the machine. Some of the information in this file can be edited by an administrator to provide additional information like tracing / logging and hostname resolution, etc. During startup, this file is also read if it exists and new discovery information is appended to the file.

 

 

 
 
Google
 
Web web site