-
oem is not free, in fact it's bloody expensive
-
Starting 9i, OEM is part of the oracle install. I remember in 8i, OEM change management pack, tuning pack etc., are all separate CD's. What other expenses?
The DBA resources to maintain OEM? It is part of the DBA's job.
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
-
well OEM has been in Oracle CDs since 8i, that does not mean it's free, it's not part of Enterprise license
one of our customer pay tons of $$$ to Oracle to use them, if I remember right they charge you per database or instance
-
I've been using OEM in a standalone mode (ie not using OMS)to 'monitor' our DBs. it came with the 9i disks so I've been using it.
I believe to monoitor the alert logs via OEM I need to use OMS (which I know nothing about). So, back to my original question ...
What key words should I look for? Yes, I agree I should look at them all (and I do - every day at the moment_ but what I'd like is to check for ORA errors, Shutdowns, fail to extend stuff etc on an hourly basis and be notified by email. Then at the end of every day visually check that days logs for anything else.
-
Check for world 'error'. 'ORA-600' is another one you need to watch out. 'Failed' of occurs with redo and archive log failures.
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
-
Originally posted by pando
well OEM has been in Oracle CDs since 8i, that does not mean it's free, it's not part of Enterprise license
one of our customer pay tons of $$$ to Oracle to use them, if I remember right they charge you per database or instance
Back when I looked at it (~3 years ago) it was per database user. You had to license for the same number of users as all your instances. The cost was too much for what OEM does.
Jeff Hunter
-
I have a script I use to monitor my alert log. I still check it manually, but this alerts me when there's a definite problem... specially during off hours.
We look for ORA- and Corrupt Block. We also skip any ORA-1109 since we get those when we are restarting the DB after a consistent backup (in mount mode)
I don't claim to be a fantastic shell scripter, so if anyone has any suggestions... please feel free to let me know!
Code:
#!/bin/ksh
. /home/oracle/.environment_ora
# Find all Sids and Oracle homes in the /etc/oratab file
grep oracle /etc/oratab |grep -v ^#|grep -v ^*|awk 'BEGIN { FS = ":" } {
instance=($1)
ohome=($2)
print instance " " ohome
}'|while read instance ohome rest
do
export ORACLE_SID=$instance
export ORACLE_HOME=$ohome
# Get the BDUMP location
alert_dir=`$ORACLE_HOME/bin/sqlplus -silent DBA_USER/$DBA_USERPASS @${SQL_SCRIPTS}/show_dump_dest`
# Define Name of logs
export ALERT_LOG=$alert_dir/alert_${ORACLE_SID}.log
export ERR_LOG=$alert_dir/alert_${ORACLE_SID}_`date +%m%d%y%H`.errors
export ALERT_LOG_COPY=$alert_dir/alert_${ORACLE_SID}_`date +%m%d%y%H`.log
# Look for ORA errors or Corrupt Block Errors.
cnt=`grep -E 'ORA-|^Corrupt block' $ALERT_LOG|grep -v ORA-1109|wc -l`
# If Errors, write them to a file and exit with return code 1
if [ $cnt -gt 0 ] ; then
echo "Oracle Errors Found on SID=" $ORACLE_SID > $ERR_LOG
echo "Alert Log Name is " $ALERT_LOG_COPY >> $ERR_LOG
echo " " >> $ERR_LOG
grep -nE 'ORA-|^Corrupt block' $ALERT_LOG|grep -v ORA-1109 >> $ERR_LOG
# Copy Error list to the $ERR_FILES directory
cp $ERR_LOG $ERR_FILES/alert_${ORACLE_SID}_`date +%m%d%y%H`.err
# Send Mail
# cat $ERR_LOG|mail -s "Oracle Errors on $ORACLE_SID alert log" $EMAIL_LIST
# Move Alert.log to a new file so that we don't get paged again for same error.
mv $ALERT_LOG $ALERT_LOG_COPY
touch $ALERT_LOG
exit 1
fi
done
-
Originally posted by kris109
[B]Starting 9i, OEM is part of the oracle install. I remember in 8i, OEM change management pack, tuning pack etc., are all separate CD's. What other expenses?
Hey, professor, pray to god that noone from Oracle is reading this. Or else in the next few weeks you may have a visit from them at your shop that manages over 100 databases with OEM, without licencing it.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
I am going to follow this up with my manager and our IT Director to find out what licensing arragements we have with oracle and that we use OEM with proper licence.
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|