iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.

 

 

 

 

 

 

 

Lesson 16

"When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us."

-Helen Keller (1880-1968)

How to start, trace 8i and 9i Data Collection Service 

(Data Gatherer and Intelligent Agent)?

In 9i, the Data Collection Service is integrated in the Intelligent Agent. You must trace the Intelligent Agent to trace the Data Collection Service.

 

In 8i, The Data Collection Service is a separate process, the Data Gatherer. You must trace the Data Gatherer process.

 

9i Data Collection Service on Unix

----------------------------------

1. Stop the Intelligent Agent if it is started

$> agentctl stop

2. Set the environment variable VP_DEBUG to 1

$> setenv VP_DE<BUG:1> or export VP_DEBUG=1

3. Start the Intelligent Agent

$> agentctl start

Data Collection Service debug information will be logged in the file dbsnmp.

nohup located in ORACLE_HOME/network/log (by default)

 

9i Data Collection Service on Windows

--------------------------------------

1. Stop the intelligent agent service if it is started

2. Open a dos command window

3. Set the environment variable VP_DEBUG

c:\oracle\product\ia\bin> set VP_DEBUG=1

4. Start the intelligent agent

c:\oracle\product\ia\bin> dbsnmp -agent_name <

Intelligent_agent_service_name>

 

for example : dbsnmp -agent_name Oracleora92Agent

Data Collection Service debug information will be logged at screen. To redirect debug information to file odg.log for example :

dbsnmp agent_name Oracleora901Agent > stdout.log 2> odg.log

 

Pre-9i Data Collection Service on Unix

--------------------------------------

1. Stop the Data Collection Service (Data Gatherer process) if it is started

$> vppcntl -stop (-status or -start)

2. Start the Data Collection Service with the following command

$> vppdc -debug > output.log 2> odg.log &

This will redirect Data Collection Service debug information in the file odg.log

 

Pre-9i Data Collection Service on Windows

-----------------------------------------

1. Stop the Data Collection Service (Data Gatherer service) if it is started

2. Open a dos command window

3. Start the Data Collection Service with the following command c:\oracle\product\ia\bin> vppdc -console -debug > stdout.txt 2> odg.log

 

This will redirect Data Collection Service debug information in the file odg.log which is located in ORACLE_HOME\odg\log