oracleoracle-enterprise-manager
I just installed Oracle Enterprise Manager 12 C Grid Control from a ready made image that Oracle provides and now I am trying to add targets to it (monitoring targets i mean).
It might be a stupid question but how can such a thing be done ? I don't seem to find any tutorials on this and the Oracle docs are not that clear.
Just guesswork, but do you select "Upgrade an existing database" early on:
and "advanced install" later on:
The docs do look as if they are referring to the 10g installer.
I might have found a couple of answers on my own. Posting them here in case others need to know:
Searching the forums at https://forums.oracle.com/ I found this thread: https://forums.oracle.com/forums/thread.jspa?messageID=9956411, which references http://www.morganslibrary.org/reference/dba_best_practices.html. Here is the code mentioned:
SELECT start_time, end_time, input_type, input_type, status
FROM v$rman_backup_job_details
ORDER BY 1;
and
SELECT vbd.file#, vrbjd.start_time, vrbjd.end_time, vbd.incremental_level, vrbjd.input_type, vrbjd.status
FROM v$rman_backup_job_details vrbjd, v$backup_datafile vbd
WHERE vbd.completion_time BETWEEN vrbjd.start_time AND vrbjd.end_time
AND vrbjd.input_type <> 'ARCHIVELOG'
ORDER BY 2,1;
As for why the query in Enterprise Manager picked older jobs I learned a nice trick from someone at work: You can read recent queries from the view v$sqlarea. Something like select sql_text from v$sqlarea order by last_active_time desc should do the trick.
Best Answer
Well this task i am afraid it can not be described here, i mean it could but is to much to write and i will not re-invent the wheel.:)
So i recommend you follow this article How to add a new target on OEM , i wrote this article with this purpose(help guys like you ! kkkkk ).
i might get a down vote for my short answer ! but for those intrested -- fell free to read the article !! And thare a lot's of them on Oracle Enterprise Manager 12 C .